Breadcrumbs

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:

  1. Meta

  2. Campaign Manager 360

  3. Snpachat

  4. 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.


qa image alli.png

  • 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.


Certified Datasources

Data Library Field Mapping - Creative Performance