Leiste mit Community-Erfolgen erweitern.

GELÖST

How do I find out how many people recieve at least one email in a year

Avatar

Level 1

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?

Themen

Anhand von Themen werden Community-Inhalte kategorisiert und Sie können so relevanten Inhalt besser finden.

1 Akzeptierte Lösung

Avatar

Korrekte Antwort von
Community Advisor

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.

Lösung in ursprünglichem Beitrag anzeigen

2 Antworten

Avatar

Korrekte Antwort von
Community Advisor

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.

Avatar

Level 1

That worked, thanks so much!