CJA- email opens across multiple emails | Community
Skip to main content
A
adgerman25
March 18, 2026
Solved

CJA- email opens across multiple emails

  • March 18, 2026
  • 2 replies
  • 37 views

 

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: 

  1. People who didn’t open any email the selected campaigns 
  2. People who opened only 1 email during the past 12 months
  3. 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? 

Best answer by AmitVishwakarma

Hi ​@adgerman25 

In 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 campaigns

If 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 exists
      • Condition 2: Campaign/Delivery label equals any of your 12 campaigns

You'll reuse this in the next step.

2. Create 3 person‑level segments

Use Person scope and your unique email open metric, with the filter above applied.

  1. People with 0 opens (none)
    • Segment scope: Person
    • Definition: Exclude people where
      • Unique email opens (filtered by "Selected campaigns – opens") is greater than 0
  2. People with exactly 1 open
    • Segment scope: Person
    • Definition: Include people where
      • Unique email opens (filtered) is greater than or equal to 1
      • AND Unique email opens (filtered) is less than or equal to 1
  3. People with 2+ opens
    • Segment scope: Person
    • Definition: Include people where
      • Unique email opens (filtered) is greater than or equal to 2

3. Report in Workspace (last 12 months)

  • In a CJA project, set panel date range to Last 12 months.
  • Freeform table:
    • Rows: the 3 segments above
    • Metric: People
  • You'll get counts for:
    • People with 0 opens in the selected campaigns
    • People with 1 open
    • People with 2+ opens

2 replies

MandyGeorge
Community Advisor and Adobe Champion
MandyGeorgeCommunity Advisor and Adobe Champion
Community Advisor and Adobe Champion
March 18, 2026

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. 

    AmitVishwakarma
    Community Advisor
    AmitVishwakarmaCommunity AdvisorAccepted solution
    Community Advisor
    March 19, 2026

    Hi ​@adgerman25 

    In 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 campaigns

    If 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 exists
        • Condition 2: Campaign/Delivery label equals any of your 12 campaigns

    You'll reuse this in the next step.

    2. Create 3 person‑level segments

    Use Person scope and your unique email open metric, with the filter above applied.

    1. People with 0 opens (none)
      • Segment scope: Person
      • Definition: Exclude people where
        • Unique email opens (filtered by "Selected campaigns – opens") is greater than 0
    2. People with exactly 1 open
      • Segment scope: Person
      • Definition: Include people where
        • Unique email opens (filtered) is greater than or equal to 1
        • AND Unique email opens (filtered) is less than or equal to 1
    3. People with 2+ opens
      • Segment scope: Person
      • Definition: Include people where
        • Unique email opens (filtered) is greater than or equal to 2

    3. Report in Workspace (last 12 months)

    • In a CJA project, set panel date range to Last 12 months.
    • Freeform table:
      • Rows: the 3 segments above
      • Metric: People
    • You'll get counts for:
      • People with 0 opens in the selected campaigns
      • People with 1 open
      • People with 2+ opens
    Amit Vishwakarma - Adobe Commerce Champion 2025 | 16x Adobe certified | 4x Adobe SME
      A
      adgerman25Author
      March 19, 2026

      Thank you!! 

        Terms & ConditionsAccessibility statement

        Loading footer...