How to build a report for emailing metrics drilled down by consent categories

Standard report drill-downs miss some campaign events when breaking down email metrics by consent category, as opened and clicked events lack this attribute.

This article shows an alternative setup that captures complete results.

1. Create event expressions

Create one event expression for each consent category in your project. 

• Create an event expression with a distinct value aggregate for the campaign event attribute sent_timestamp
• Apply a limit to 1000 distinct values
• Filter by specific consent category

As an example, for a legal consent category,  you would create an expression using campaign > sent_timestamp with consent_category = legal. 

Repeat this for each consent category, naming each expression by its consent.

This event expression collects the distinct sent_timestamp values from the selected campaign events that match the chosen consent category.

2. Create an event segmentation

Create one event segmentation for each consent category in your project. 

For each segment:

• Insert a campaign event and choose the event expression created in step 1. 
• Use any item equals campaign.sent_timestamp condition.
• Name each event segmentation after its consent category, because these names appear in the final report.

For example, for the "legal" segment, you would select the previously created event expression where consent_category equals legal.

Repeat these steps for each segment until all consent categories are covered.

Purpose

Although not all campaign event statuses track consent categories, each sendout includes a unique sent_timestamp. This is a UNIX timestamp with six decimal places that identifies the exact time the campaign was sent.

By using the expression from the previous step to collect the distinct sent_timestamp values for the relevant consent category, this event segment can match clicks and opens back to their original sendout events and assign them to the correct consent segment.

3. Create a report

Create a report by adding a metric to count all campaign events in the Rows section. Under Drill down by, select campaign and status.

In the Columns section, under Drill down by, choose the event segmentation you created.

This provides basic email metrics like enqueued, delivered, opened, clicked, and more, with each consent category in its own column.

You now have a report that analyzes email results for each consent category separately.