CDS View - active & logged out subscribers per month

[lisa_w]

Hello everyone,

I would like to see an evaluation of the subscribers in the Marketing Cloud. I would like to see the total number of active and unsubscribed subscribers per communication category and month.

I think I can create a CDS view for this. But I only find the general number of subscribers. Apparently summed up after interactions. But I want the sum of the unique subscribers that are currently logged in. The numbers also differ from those in my segmentation.

Can anyone give me a tip on how I can visualize this?

Best regards,

Lisa

[Abd_Am_K]

Hi lisa_w,

I can imagine to create a solution like this:

1. Create a CDS view with Analytical Cube using Primary data source I_MKT_InteractionCube
2. Include the necessary fields: InteractionContactUUID, InteractionType, NumberOfInteractions
3. In the filter tab add the filter for NEWSLETTER_SUBCR
4. Save and Publish

Next you have to create a custom analytical query on your Published Cube:

1. In the display tab add a counter on the dimension InteractionContactUUID

Save and Preview.

You should now be able to see number of subscriptions along with the number of unique contacts.

Hope this helps,

Abdullah Amer