How does data flow into Creative Insights?

This document will give a brief overview on how Creative Insights data is populated and how to troubleshoot metrics if they don’t match the respective platform data.

Creative Performance brief

The Creative Insights tool is powered by the creative_performance datasource present in the {client}_core schema. This datasource is a one-stop shop for creative-level dimensions and metrics across the four platforms currently supported by Creative Insights:

Meta
Campaign Manager 360
Snpachat
TikTok

Creative Performance column mapping to Creative Insights

creative_performance contains all the standard set of metrics and dimensions you can visualize in the Alli tool, the primary ones being:

Ad Name
Creative Type
Date
Spend
Impressions
Revenue
Clicks
Conversions

The table below summarizes how each dimension and metric in Creative Insights is mapped from the respective column in creative_performance by platform.

Creative Insights dimension/metric	Facebook column in creative_performance	Snapchat column in creative_performance	TikTok column in creative_performance	CM360 column in creative_performance
`Ad Name`	`ad_name`	`ad_name`	`ad_name`	`creative_name`
`Creative Type`	`ad_type`	`ad_type`	`ad_type`	`ad_type`
`Date`	`date`	`date`	`date`	`date`
`Spend`	`cost`	`cost`	`cost`	`cm_cost`
`Impressions`	`impressions`	`impressions`	`impressions`	`cm_impressions`
`Revenue`	`purchase_conversions_value`	`purchase_conversions_value`	`purchase_conversions_value`	`cm_total_conversions_value`
`Clicks`	`clicks`	`clicks`	`clicks`	`cm_clicks`
`Conversions`	`conversions`	`conversions`	`conversions`	`cm_conversions`

Troubleshooting Creative Insights with Creative Performance

As an example, let’s say that we find a Madewell Revenue mismatch issue between the Creative Insights tool and the Meta platform UI for a particular ad and date range. We can troubleshoot this mismatch by querying the creative_performance datasource using Alli Data Explorer.

If the Revenue from the Meta UI and the purchase_conversions_value from the creative_performance model do not match, then it is most likely an issue with the creative_performance datasource. Submit a support ticket here and select Data Library under the Feature dropdown.
If the Revenue from the Meta UI and the purchase_conversions_value from the creative_performance model do match, then it is most likely an issue with the Creative Insights tool. Submit a ticket here and select Creative Insights under the Feature dropdown.

Creative Performance brief

Creative Performance column mapping to Creative Insights

Troubleshooting Creative Insights with Creative Performance

Related Articles