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.

If you want to implement a Cross Channel datasource, you can view this doc.

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