How to extract opt-out data (count/rate) beyond track...

[Mikael-P]

Hi,

I would want to extract opt-out data for deliveries past the 6 months data retention period (count and/or rate). Data for deliveries (indicators) are collected, but for some reason the opt-out/unsubscriptions are not in the indicators (kpis). If I look at dynamic reports from +6 months ago, the unsubscription data for deliveries are shown, so it must be stored somewhere. Where is this stored so I can enrich it in to the delivery data?

Thanks!

BR,

Mikael

[ramon_bisswanger · Accepted solution]

The reporting data is not stored in the ACS database but in a separate reporting store.

Unfortunately this cannot be addressed in workflows.

If you need that frequently, best would be to enhance the delivery schema and aggregate data yourself before retention takes place

[Mikael-P]

Thanks a lot for a quick reply! As a follow-up, is the domain level reporting data (gmail.com, hotmail.com etc.) also stored in reporting only or is that possible to work on in the workflows? Thanks!

[Sukrity_Wadhwa]

Hi @ramon_bisswanger,

Can you please help @Mikael-P further?

Thanks!

[ramon_bisswanger]

Domain level reporting is also only available in aggregated form inside reporting.

But you could also calculate that inside a workflow but only during the retention period before the logs are cleaned up

[Mikael-P]

Thanks @ramon_bisswanger! Where is the domain level reporting stored would I for instance want to work with domain level open rate and CTR in a workflow (and extract it)? Could you help me out on that?

[ramon_bisswanger]

It is not stored in the system. You would have to calculate it using the delivery + Tracking logs. (using rownumber function and deduplication activity)

[Mikael-P]

@ramon_bisswanger Is it possible that you could give an example (screenshot or text) for how to do this "It is not stored in the system. You would have to calculate it using the delivery + Tracking logs. (using rownumber function and deduplication activity)"? Let's say I would have Delivery label as dimension, then added data would be for instance gmail.com delivered | gmail.com-unique opens | gmail.com-unique clicks. Could you show how I can get those calculated? Thanks!