Hi Keerti J, I guess I am stuck in thinking in different ways than you
describe this, because I can’t get my head around how I would find that
query audience data to my WKF. So currently I am using Deliveries as
resource for my query. By doing this I can add all KPIs as additional
data I need. I then further have used enrichment to get the
unsubscriptions to the final table. What the query does is it looks at
all deliveries with main date in the last 2 years and not looking at
specific labels as...
Hi Keerti J, thanks for the reply! So what you describe is more looking
at specific query audiences and the performance of those. Which is
helpful as well. But what if you would have a table report where each
row represents a delivery label. Is there a way to enrich the WKF so
that one column would be "audience". So the audience that was targeted
for a specific delivery?
Hi, We are exporting delivery reports with basic KPIs, such as open
rate, delivered, clicks etc. So each row indicates a delivery, and in
the WKF we've added KPIs and enrich that with tracking logs as well,
which we then export into a table sheet report as a csv. I was wondering
if there is a possibility to add or enrich this delivery data with
"audience". This would be a really great thing to have, and give us a
possibility to later on analyze the performance of audiences. Thanks
already in adv...
@ramon_bisswange 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!
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