CJA- email opens across multiple emails

Question

Hello- I have a list of 12 campaigns that a marketer is looking to get some metrics for within CJA. Looking across all 12 campaigns:

People who didn’t open any email the selected campaigns
People who opened only 1 email during the past 12 months
People who had 2 or more opens during the past 12 months

We have a unique email open metric that de-dupes at the person level and we keep the first instance based on the delivery label. How do I look across multiple campaigns to see if someone only opened one or two?

AmitVishwakarma · Accepted Answer

Hi ​@adgerman25In CJA you do this with person‑scoped segments that use a metric condition on your unique open metric (filtered to those 12 campaigns), then count People.1. Filter the email opens to just those 12 campaignsIf you have a dimension like Campaign name or Delivery label:Create a filter/segment "Selected campaigns – opens" (Event scope):Event container:Condition 1: Email open event existsCondition 2: Campaign/Delivery label equals any of your 12 campaignsYou'll reuse this in the next step.2. Create 3 person‑level segmentsUse Person scope and your unique email open metric, with the filter above applied.People with 0 opens (none)Segment scope: PersonDefinition: Exclude people whereUnique email opens (filtered by "Selected campaigns – opens") is greater than 0People with exactly 1 openSegment scope: PersonDefinition: Include people whereUnique email opens (filtered) is greater than or equal to 1AND Unique email opens (filtered) is less than or equal to 1People with 2+ opensSegment scope: PersonDefinition: Include people whereUnique email opens (filtered) is greater than or equal to 23. Report in Workspace (last 12 months)In a CJA project, set panel date range to Last 12 months.Freeform table:Rows: the 3 segments aboveMetric: PeopleYou'll get counts for:People with 0 opens in the selected campaignsPeople with 1 openPeople with 2+ opens

MandyGeorge · Answer

There might be more than one way to do this, since you have CJA. There’s probably a way to make a derived field, but I have limited CJA experience so I’m not certain.

What I do know is that you should definitely be able to do this with a calculated metric. There’s a function for distinct count. In that function put the variable that has your campaign IDs. This will give you a count of how many different campaign values they interacted with. Put this metric against a visitor identifier, and it will show you how many campaigns each visitor/person interacted with in your time frame.

Sign up

Login with SSO

Login to the community

Login with SSO