Skip to Content

Reporting campaigns that resulted in interactions

Dear experts,

I need to create a report in SMC that connects email campaign performance with the interactions (such as clicking a link in an email) that resulted from those email-campaigns.

When I want to display interactions through a report. the columns are always empty:

2020-07-06-17-20-01-window.png

The campaign resulted in interactions, though:

2020-07-06-17-21-02-window.png

Can anybody please point me towards the mistake I'm apparently doing?

Thanks in advance,

BR

Nils

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    Posted on Jul 14, 2020 at 12:32 PM

    Hi Nils Walter. Thank you for the explanation. From your screenshot I see you need multiple views of the same data.

    Some comments:

    1. To see all the metrics you mentioned related to "Sending process" and "Measures", you just have to filter by the campaign id in the filter section and see all the aggregated metrics.
    2. You're not able to see the content details in the same view because it requires different level of aggregation. That's not possible with one view in the Design Studio (Analytics and Report Gallery).
    3. You could have a second view for the content metrics. You need to add the attribute Link Alias to the rows.

    Regarding to SAP Analytics Cloud, I'm not very familiar with that, but you could build a Custom CDS View to consume the data from SAC and build your custom reports there. Here you have the documentation of "Create the Live Data Connection to SAP Marketing Cloud".

    Let me know if you need more help :) Regards,

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 06, 2020 at 04:59 PM

    Hi Nils Walter! Which report are you using? I recommend you to use the "Campaign Success for Messages" operational report from the Analytics and Report Gallery app. There you can drag and drop the interaction type and use it as rows for the "group by" operation in the pivot table.

    Here you have a screenshot that can help you:

    Let me know if you need more help. Regards,


    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 10, 2020 at 09:31 AM

    Hi Nils Walter,

    Was Bruno Gonzalez's help sufficient. Were you able to get to your result? If not Can you please explain how you created your data source?

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 10, 2020 at 01:28 PM

    Hi Nils Walter. If I understand what you meant correctly, yes, it always shows you the aggregated values. Maybe you want to see those values by interaction type. For that, I recommend you to take the row of "Kampagnen-ID" out of the filters.

    Let me know if that helped :)

    Add a comment
    10|10000 characters needed characters exceeded