How to extract opt-out data (count/rate) beyond tracking data retention period

Forum|Forum|5 years ago
November 2, 2020
1 reply
2200 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by bisswang

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

B

bisswang

Accepted solution

Adobe Employee

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

M

Mikael-PAuthor

Level 2

@bisswang 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!

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded