I need to write a query or run a report that shows me how many people my company emails at least once in a calendar year. Any tips?
Solved! Go to Solution.
Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
Hi @TylerCPrice ,
In Query, have targeting dimension as recipient and filtering dimension as Delivery logs (broadLogRcp)
Filtering condition:
status equal to sent
AND
Delivery's channel equal to Email
Note: By default setting of Adobe campaign, broadLogRcp schema will store 6 months of Data only. So by using query you can able to get result of all receipts who had received email atleast once in last 6 months.
Hi @TylerCPrice ,
In Query, have targeting dimension as recipient and filtering dimension as Delivery logs (broadLogRcp)
Filtering condition:
status equal to sent
AND
Delivery's channel equal to Email
Note: By default setting of Adobe campaign, broadLogRcp schema will store 6 months of Data only. So by using query you can able to get result of all receipts who had received email atleast once in last 6 months.
That worked, thanks so much!
Views
Replies
Total Likes