Join our Community in its new Home - The Datorama Trailblazer Community Group!

It's been an amazing 3 years coming together in this forum to collaborate, innovate, support, and inspire each other about our shared usage of Datorama. While this is not quite a goodbye, we are excited to announce that we are getting a fresh start in our new home within the Salesforce Trailblazer Community. We have a ton of fun new content planned and you may even see the revival of some of our most popular posts from the past few years.

We’ll be keeping this group around for a bit for you to peruse, but as of November 15, we will no longer be allowing new posts or comments. Be sure to join our new group at https://www.salesforce.com/success-datorama to keep the conversation going.

We can’t wait to see you there!

Advanced Exam

Comments

  • MarissbcMarissbc New YorkSYS_ADMIN IMG42
    Hi @smoore

    I am sharing the mapping for this file below which I uploaded as a TotalConnect (ads) data stream:

    Mapping:



    A couple of things to note in the mapping above to get the rows to populated on separate lines.

    1.  A campaign key is needed, so notice that is a concat of the Conference Code and Conference Name in the mapping above! 

    2. Map all the dimensions and measurements as campaign custom attributes (conference code and conference name) and a delivery custom attribute (number of attendees)

    Output Pivot:



    I hope this is helpful!

    Thank you!!
    Marisssa


  • MarissbcMarissbc New YorkSYS_ADMIN IMG42
    Hi @smoore

    You are very welcome! I am so glad I could help!
    Marissa

Sign In or Register to comment.