Skip to main content
Skip table of contents

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:

  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.

Alli Data Library 2.0

Data Library Field Mapping - Creative Performance

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.