How do I find out how many people recieve at least one email in a year | Community
Skip to main content
T
TylerCPrice
December 9, 2023
Solved

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

  • December 9, 2023
  • 1 reply
  • 679 views

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?

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 ParthaSarathy

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.

1 reply

ParthaSarathy
Community Advisor
ParthaSarathyCommunity AdvisorAccepted solution
Community Advisor
December 9, 2023

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.

~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
    T
    TylerCPriceAuthor
    December 11, 2023

    That worked, thanks so much!

    Terms & ConditionsAccessibility statement

    Loading footer...