This article will guide you through building a report for basic emailing metrics drilled down based on the consent categories. We will need a few more components apart from the individual report since the click and open campaign events don't have a consent category property tracked inside them.
We will need an event expression for the campaign event, and this will be individual for each consent category. So, if we have 3 consent categories, we will need 3 such expressions. We will insert all of those event expressions into one event segmentation, where each segment will represent the individual consent category.
Why such a complicated setup? It all comes from the fact that the click and opened statuses in campaign events don't have any consent_category property inside its events, so we cannot simply drill down by campaign --> consent_category as we would miss the results for those events. But those events have something in common: they all have a sent_timestamp property, which is a unique UNIX timestamp of when the campaign was sent with precision to 6 decimal places of one second, so all of those are unique values. The following setup can segment all of the campaign events to the individual consent segments based on this sent_timestamp and pair clicks and open events to their parent-enqueued event through the uniqueness of the sent_timestamp value.
For the demonstration of this setup, we have two consent categories called "legal" and "cs" which we will use in this article, but the logic will be the same even if you have 10 individual consent categories, you would just need to create more expressions as described below
First, we need the event expressions.
- Create an event expressions that contains a distinct value aggregate for campaign --> sent_timestamp with distinct values limit set to 1000 and consent_category = "legal" (pick any consent category you have in your project).
Repeat this process and create an event expression for each consent_category individually. For further building, include the name of each consent in the event expression name. - Create an event segmentation. You will need more segments. If you have 2 consents, you need 2 segments. If you have 5 consents, you need 5 segments. Each segment must be named after a particular consent category, as the name of the segments will be shown in the final report.
Inside each segment, we need to insert a campaign event and select an event expression we created in step 1.
For example, for the "legal" segment, we need to pick the event expression made for the consent_category = "legal"
Then we need to build a condition such as this one
Event expression --> Any item --> Equals --> Sent_timestamp (demonstrated on the screenshot below)
Repeat these steps for each individual segment until you cover all the consent categories - Create a report, you can insert a metric for counting all campaign events, into the row drilldown pick the campaign --> status, and into the columns drill down, pick the previously created event segmentation
After all, this will give you results for basic emailing numbers such as enqueued, delivered, opened, clicked, and so on... Divided each consent category by column
Congratulations! Now you have a report that can analyze emailing results for each consent category individually