on ‎2020 Jul 08 4:14 PM
Hello Experts,
we generally run campaigns on targe groups, based on interactions (in this case contracts that are created as interactions). Now we would like to evaluate these campaigns and be able to access the data of the target group interactions. For the evaluations, we build CDS views and queries, which we then use in SAP Analytics Cloud.
At this point it is not entirely clear to us how we can get from the campaign success cube to the interactions from the target group.
The interaction contact data is not enough.
Thanks in advance.
BR,
Caro
Request clarification before answering.
Hi carostoe,
Please use the view browser app to check for the released views and the fields that you can use to access data from these released views.
For example I searched for Target Group and set a filter on the status to give me released views and I found the view "I_MKT_TgtGrpIntactnCntct". After looking at the fields, I can see that I can use this view to join with interactions, campaigns and create my use-cases.
Best Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi carostoe. I'm back again with another questions and ideas.
First of all, I don't understand how you use "contracts that are created as interactions". If you are trying to do something with contacts, it's always better to use the contacts entity.
Regarding to your campaigns and the performance, I don't understand how you are using the interactions for campaigns because it's not possible to use a target group of "All Interactions" segmentation profile to launch campaigns. Can you explain how you do that?
If you are using the interaction target group as a live target group to filter some trigger campaign, why do you need to access those interactions?
I'm not understanding the scenario clearly, but there are some questions and ideas that could clarify that for both 🙂
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi carostoe. If you want to access target group data from the Custom CDS View, you need to add an associated data source in the "Data Sources" tab while you are creating the Custom CDS View.
You can use the _I_MKT_TargetGroup data source and the join condition with the field TargetGroupUUID (present in both data sources). Here's an example of the join condition:

Let me know if that helped or you need to implement a different scenario.
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.