CX Works

CX Works brings the most relevant leading practices to you.
It is a single portal of curated, field-tested and SAP-verified expertise for SAP Customer Experience solutions

External Campaigns in SAP Marketing Cloud Using Khoros (4/4)

5 min read

A how-to on executing external campaigns in SAP Marketing Cloud using Khoros | Part 4: Functional Testing

This is the last article of this series to explain how external campaign can be created in SAP Marketing Cloud for the social media management platform - Khoros. In this article, steps to test end-to-end use case are explained. To better understand the external campaign use case using SAP Marketing Cloud and Khoros, please visit Part 1 of this series. 

Table of Contents

Functional Testing

After maintaining all the configurations in SAP Marketing Cloud, SAP Integration Suite, and Khoros, to create a campaign with the campaign category Khoros Campaign - Test, you will need to log on to the SAP Marketing Cloud tenant using the Marketing_Expert business role.

Go to the Campaigns tile in the SAP Marketing Cloud tenant.

Create a campaign with the campaign category Khoros Campaign - Test.

Result: An external campaign is created.

Once the action has been selected, the initiatives are read from Khoros and populates the drop down for Advertiser in SAP Marketing Cloud. From here, one of the initiative needs to be chosen in SAP Marketing Cloud as an advertiser.

Once the advertiser is chosen and the value help of campaign ID is clicked, all the plans corresponding to the selected initiative are read from Khoros and a pop-up will open to select a plan.

After selecting a Khoros plan, a corresponding plan ID and plan name will be assigned to the SAP Marketing Cloud external campaign ID and campaign name fields.

After creating this external campaign of type Khoros Campaign - Test, the campaign can be started. Once started, the status of the SAP Marketing Cloud campaign will change to Released. If the Marketing Calendar App in SAP Marketing Cloud is opened thereafter, the newly created external campaign with category Khoros Campaign - Test will display in the calendar.

A standard batch job SAP_CUAN_CPG_GET_EXT_DATA exists and is scheduled in SAP Marketing Cloud to read the campaign success data. This batch job will execute every four hours to read the campaign success data that will trigger the iFlow configured as a part of the communication arrangement ‘Marketing-External Campaign Execution-Integration’. Once this batch job is executed for the first time after creating the campaign, it will fetch the ReportID from the Khoros system and will store it in SAP Marketing Cloud. On next execution of this batch job, it will try to fetch actual campaign success data corresponding to the ReportID generated by the previous execution. Finally, the aggregated campaign success data will be populated in the Performance tab of the campaign.

If you access the chart view, you can see the different KPIs (Key Performance Indicators) based on the different communication mediums.

Current Challenges

Currently, there is no Khoros API available that provides filtered campaign success data based on the Khoros Plan. Therefore, you need to read all the campaign success data for a given time frame from Khoros and then filter the data based on the SAP Marketing Cloud campaign in the SAP Integration Suite middleware. From a performance perspective, this could be a bottleneck when dealing with a large amount of campaign success data.

Additionally, the Plan name is returned by Khoros as a part of the campaign success data rather than sending a Plan ID. This means that you need to filter success data based on the campaign name and not on the campaign ID. Using text to filter data rather than using code or an ID is not a recommended approach. 


In this series, you learned how you can assign a Khoros Plan in the SAP Marketing Cloud external campaign. These articles provided a detailed step to build the use case between Khoros and SAP Marketing Cloud. Keep in mind that this use case needs a marketing user to create and assign marketing campaigns using the SAP Marketing Cloud solution. Since SAP Marketing Cloud communicates with Khoros using SAP Cloud Integration, SAP Integration Suite will take care of the Khoros user authentication based on oAuth2. This means that it is not required to have a Khoros login user for every SAP Marketing Cloud user who wants to assign a Khoros Plan to the SAP Marketing Cloud campaign. If you need to create the SAP Marketing Cloud campaign by using a batch job without any effort from marketing users for a Khoros Plan, this integration scenario needs to be carried out differently, which is explained in this article.