SAP Marketing Cloud - Campaign Success Cube

[former_member600860]

Hello Experts,

I have the following requirement. Our customer wants to evaluate campaigns in a certain category. That means they want to know at the campaign level how many clicks a campaign has or how often a campaign has clicked. They also want to know how many people were in the target group of a campaign.

I have already found the campaign evaluation cubes. However, they always have the interactions as the key. But I would need everything based on the campaign. Does anyone have an idea or a starting point how to start?

Best Regards,

Caro

[Abd_Am_K]

Hi carostoe ,

Alternative to Bruno's solution, if you are working with custom CDS views and creating your custom Cubes, you can set the fields which you want to set to key fields in your primary CDS views. Then when you create your secondary views, you can select the fields as key fields for your joins.

This way you can join I_Mkt_Interaction to I_Mkt_Contact and I_Mkt_Initiative to combine interactions, contact master data and campaigns data.

Best Regards

[former_member600860]

Hello abdullah.amerk ,

thanks for your answer.

But what is when i want for each campaign the amount of the target member group. The Problem ist, when i use the field "targetmembergroup" from the dimension "campaign execution run" then it calculates every interaction with the target group members. And so the number of the target group members is wrong.

For example my campaign has a target group of 10 people and i have 2 interactions. Then the field shows 10*2 = 20 target group memebers.

Is it not possible that the system calculates it on a campaign basis?

thanks in advange,

br caro

[Abd_Am_K]

Hi carostoe ,

1) I would recommend to take the I_Mkt_Initiative view (Campaign View) and join it with I_MKT_TargetGroup to get the number of per campaign members. This way you should get the right number of members.

2) For you current case you need to set the aggregated column on the target group members. Currently it seems that it is set on the interactions.

[Former Member]

Hi carostoe! I suppose that you're talking about email campaigns. If that's the case, you can create a Program under "Programs" app, and then assign the program to the campaign.

You can then use the standard filter of that Program in the Campaign Success for Messages cube available in the default reports like this:

More information about Marketing Programs: https://help.sap.com/viewer/b88f770e4b7c4ecead5477e7a6c7b8f7/2005.500/en-US/d13a20562d06c34ee1000000...

If you want to do a specific tracking for several links across campaigns, you can use Item of Interest. Item of interest are like "tags" you assign to a link. It's available in the Content Studio (not Lite version for Email).

Regarding to the target group people count, you can use the metrics "Delivered Messages" to see how many people you reached.

Let me know if you need more help 🙂 Regards,