CDS - Calculation column (Count Interactions)

[bhaskar_idp]

Hi,

Usecase: As a marketeer, i would like to know the performance of my Whatsapp campaign.

Problem statement: For whatsapp campaign we dont have standard report, hence deriving report based CDS views.

I have used i_mkt_interaction(cube), but it doesnt have the measure to expose as analytical cube for reporting. I am creating one calculation column by counting the No of failed but CDS not accepting for counting the interactions tat are failed.

Any idea's how to count the interaction belongs to a campaign? Kindly let me know.

Product: SMC
Extensibility: Custom CDS Views
Errors: Syntax error/COUNT(DISTINCT) missing/GROUP BY clause is missing

Regards,
Bhaskar

[former_member226]

Hello,

Why do u need to define a custom "count" when you can actually use a custom field with context "Marketing: Campaign Performance - Actual Measure" as well as "Marketing: Campaign Performance - Target Measure". Since they are little bit different than the general custom fields therefore pls check the standard documentation https://help.sap.com/viewer/13d84c47bb6749a188fd53915c256516/LATEST/en-US/4c21206824f44f9fbf729568b2... .

Once you publish the field then it should be available(provided you enabled them) in API, Campaign Performance Tab as well as in CDS view like I_MKT_AggrgdCmpgnSuccessCube.

Thank you!

[vervinckt_joyca]

Hi saurabhkabra2009

Interesting!

But this help page only describes how to make fields, which are empty boxes.

How do you "fill" these empty boxes with data?

I have a similar case as Bhashkar where I would like to count interactions that relate to a campaign. In my email campaign, I send an email with a link to a landing page. This landing page has a box that creates a (custom) interaction upon submit of the form. So I'd like a count on how many of those interactions were generated by this campaign.

With the help page you mentioned, I can create a field for a measure and a target for the count of interactions, but how do you then actually make it count the nr of a particular interaction type?

Thanks,

Joyca

[former_member226]

Hello Joyca,

You need to use API API_MKT_CMPGN_SUCCESS_IMPORT_SRV in order to fill the data for newly created metrics. Once data ins there in system then it will be sitting in CDS views like I_MKT_AggrgdCmpgnSuccessCube which you use to design your own query based on customer need.

[vervinckt_joyca]

That would be logical in case of an externally executed campaign, that the external campaign populates success metrics back to Marketing.

But it concerns a standard campaign here, for which the data to be counted is already present in the SMC system.

Hence a "count" function in the CDS like Bhaskar asked about initially, is a more logical approach.

Also for Bhaskar's case, I assume all of the "outbound message to whatsapp" interactions are already present in the SMC system, but the whatsapp campaign just lacks a counter that shows this total nr of outbound messages.

I wouldn't know how to make it populate through API otherwise. Then you'd need some externally developed system that somehow frequently first does a GET call to the SMC system to fetch all of the interactions related to a campaign, counts them together, and then writes the sum to that API_MKT_CMPGN_SUCCESS_IMPORT_SRV? It would be better if that counting can be done by SMC itself.

[former_member226]

Hmm..It totally makes sense that what you are saying i.e. we should not call a GET request to read the data and then again make a POST to put back the aggregated data. I gave a basic check into my system and based on that I see that we can actually use "case" statement to write a custom measure based on the requirement. A sample key figure will be as follow:

And then define aggregation for it as SUM.

[Abd_Am_K]

Hi bhaskar.pavuluru,

You can use the I_MKT_InteractionCube as your data source which has the NumberOfInteractions field and the Campaign ID field. Then adding the filter on the interaction type in the filter tab will do it for you.

Thanks,

Amer