Breadcrumbs

Data Library Field Mapping - Product Feed Performance

The product_feed datasource built by the Structured Data team to pull in product settings to join with performance data is currently being created across all client instances so it might not be available for your client at this time. This section will be updated when it has been deployed across all clients successfully.

Overview

This document describes how the columns from all the ad platforms are mapped to the productfeed_performance Alli Data Library Report.

Platforms include:

  • Google Ads

  • Facebook Ads

To understand which Alli Data Datasources are used within the ad_performance report, see the following link: Report Diagrams | productfeed_performance.


The value N/A identifies that the platform does not have a mapping for the corresponding column.

The value TBD identifies that the platform mapping is still being identified and will be updated once confirmed in the UI.

Column

Description

Dimensions / Metrics / Categorization

Platform UI Name Mapping

Platform API Mapping

id

The Internal Alli Id of the Record

N/A

N/A

N/A

source

The Source Table of Row

N/A

N/A

N/A

date

The Date of Performance Data

Dimensions

 
{
'facebook ads': 'Date',
'google ads': 'Date',
'Pinterest ads': 'Date',
}

{
'facebook ads': 'date_start',
'google ads': 'date',
'Pinterest ads': 'Date',
}

core_media_channel

The channel that the platform is a part of

Categorization

N/A

N/A

ad_format

The Format of the Ad

Categorization

N/A

N/A

audience_strategy

The Strategy Towards the Audience

Categorization

N/A

N/A

audience_type

The Type of the Audience

Categorization

N/A

N/A

marketing_objective

The Objective of the Marketing Tactic

Categorization

N/A

N/A

geo

The Geographic Info

Categorization

N/A

N/A

query_type

Query Type

Categorization

N/A

N/A

funnel

Marketing Funnel

Categorization

N/A

N/A

social_asc

Whether Campaign contains ASC or Advantage

Categorization

N/A

N/A

channel

The Default Alli Data Library Channel (Hard Coded Value)

 

Dimensions

N/A

 
{
'facebook ads': 'SOCIAL',
'google ads': 'SEARCH',
'Pinterest ads': 'SOCIAL',
}

core_media_channel

The channel that the platform is a part of

Categorization

N/A

N/A

platform

The Platform the Campaign belongs to. (Hard Coded)

Dimensions

N/A

 
{
'facebook ads': 'Facebook Ads',
'google ads': 'Google Ads',
'pinterest ads': 'Pinterest Ads'
}

publisher_platform

The Publisher Platform on where the Campaign Delivered Ads

Dimensions

 
{
'facebook ads': 'N/A',
'google ads': 'Networks',
'pinterest ads': 'N/A',
}

{
'facebook ads': 'N/A',
'google ads': 'ad_network_type',
'pinterest ads': 'N/A',
}

account_id

The Ad Account Identifier

Dimensions

 
{
'facebook ads': 'Account ID',
'google ads': 'Account ID',
'pinterest ads': 'Account ID',
}

{
'facebook ads': 'account_id',
'google ads': 'customer_id',
'pinterest ads': 'advertiser_id'
}

account_name

The Ad Account Name

Dimensions

 
{
'facebook ads': 'Account Name',
'google ads': 'Account',
'pinterest ads': 'Account'
}

{
'facebook ads': 'account_name',
'google ads': 'customer_name',
'pinterest ads': 'account_name'
}

campaign_id

The Campaign Identifier

Dimensions

 
{
'facebook ads': 'Campaign Id',
'google ads': 'Campaign ID',
'pinterest ads': 'Campaign ID',
}

{
'facebook ads': 'campaign_id',
'google ads': 'campaign_id',
'pinterest ads': 'campaign_id',
}

campaign_name

The Campaign Name

Dimensions

 
{
'facebook ads': 'Campaign',
'google ads': 'Campaign',
'pinterest ads': 'Campaign name',
}

{
'facebook ads': 'campaign_name',
'google ads': 'campaign_name',
'pinterest ads': 'campaign_name'
}

adgroup_id

The Adgroup Identifier

Dimensions

 
{
'facebook ads': 'Ad set ID',
'google ads': 'Ad group ID',
'pinterest ads': 'Ad group ID',
}

{
'facebook ads': 'adset_id',
'google ads': 'ad_group_id',
'pinterest ads': 'ad_group_id',
}

adgroup_name

The Adgroup Name

Dimensions

 
{
'facebook ads': 'Ad Set Name',
'google ads': 'Ad group',
'pinterest ads': 'Ad group name',
}

{
'facebook ads': 'adset_name',
'google ads': 'ad_group_name',
'pinterest ads': 'ad_group_name',
}

ad_id

The Ad Identifier

Dimensions

 
{
'facebook ads': 'Ad ID',
'google ads': 'Ad ID',
'pinterest ads': 'N/A',
}

{
'facebook ads': 'ad_id',
'google ads': 'ad_id',
'pinterest ads': 'N/A',
}

ad_name

The Ad Name

Dimensions

 
{
'facebook ads': 'Ad',
'google ads': 'Ad',
'pinterest ads': 'N/A',
}

{
'facebook ads': 'ad_name',
'google ads': 'ad_name',
'pinterest ads': 'N/A',
}

product_merchant_id

The Merchant Center ID of the account that contains the products to advertise.

Dimensions

 
{
'facebook ads': 'N/A',
'google ads': 'Merchant ID',
'pinterest ads': 'N/A',
}

{
'facebook ads': 'N/A',
'google ads': 'product_merchant_id',
'pinterest ads': 'N/A',
}

product_id

Item ID of the product.

Dimensions

 
{
'facebook ads': 'Product ID',
'google ads': 'Product Item ID',
'pinterest ads': 'product_item_id',
}

{
'facebook ads': 'product_id',
'google ads': 'product_item_id',
'pinterest ads': 'product_item_id',
}

cost

Costs (Ad Spend)

Metrics

 
{
'facebook ads': 'Amount Spend',
'google ads': 'Cost',
'pinterest ads': 'Spend'
}         

{
'facebook ads': 'spend',
'google ads': 'cost',
'pinterest ads': 'spend_in_dollar',
}

impressions

Impressions

Metrics

 
{
'facebook ads': 'Impressions',
'google ads': 'Impr.',
'pinterest ads': 'Impr.',
}         

{
'facebook ads': 'impressions',
'google ads': 'impressions',
'pinterest ads': 'impressions_1 + impressions_2',
}

clicks

Clicks

Metrics

 
{
'facebook ads': 'Link clicks',
'google ads': 'Clicks',
'pinterest ads': 'Result: Clicks',
}         

{
'facebook ads': 'inline_link_clicks',
'google ads': 'clicks',
'pinterest ads': 'clickthrough_1 + clickthrough_2',
}

total_conversions

The Total Number of Conversions

Metrics

 
{
'facebook ads': 'Actions',
'google ads': 'All conv.',
'pinterest ads': 'Conv'
}         

{
'facebook ads': 'actions',
'google ads': 'all_conversions',
'pinterest ads': 'total_conversions',
}

total_conversions_value

The Value associated with the Total Number of Conversions

Metrics

 
{
'facebook ads': 'N/A',
'google ads': 'All conv. value',
'pinterest ads': 'N/A'
}         

{
'facebook ads': 'N/A',
'google ads': 'all_conversions_value',
'pinterest ads': 'N/A'
}

conversions

The Number of Conversions

Metrics

 
{
'facebook ads': 'N/A',
'google ads': 'Conversions',
'pinterest ads': 'N/A'
}         

{
'facebook ads': 'N/A',
'google ads': 'conversions',
'pinterest ads': 'N/A'
}

conversions_value

The Value associated with Conversions

Metrics

 
{
'facebook ads': 'N/A',
'google ads': 'Conv. value',
'pinterest ads': 'N/A'
}         

{
'facebook ads': 'N/A',
'google ads': 'conversions_value',
'pinterest ads': 'N/A'
}

cross_device_conversions


Metrics

 
{
'facebook ads': 'N/A',
'google ads': '',
'pinterest ads': 'N/A'
}         

{
'facebook ads': 'N/A',
'google ads': 'cross_device_conversions',
'pinterest ads': 'N/A'
}

The other columns in this report are from the product_feed datasource which is created by our PMG product team. The data from that datasource is joined to the performance data on product_id. Below is a list of the columns. More information on them can be found here.

  • is_active

  • feed_region

  • feed_language

  • item_group_id

  • family_id

  • gtin

  • mpn

  • title

  • structured_title

  • description

  • structured_description

  • link

  • mobile_link

  • availability

  • availability_date

  • inventory

  • price

  • sale_price

  • currency

  • unit_pricing_measure

  • unit_pricing_base_measure

  • image_link

  • additional_image_link

  • video_link

  • product_type

  • category_one

  • category_two

  • category_three

  • category_four

  • category_five

  • client_category

  • google_product_category

  • brand

  • condition

  • age_group

  • color

  • standard_color

  • gender

  • material

  • pattern

  • size

  • size_type

  • size_system

  • multipack

  • bundle

  • loyalty_program

  • cost_of_goods_sold

  • price_comp

  • price_comp_label

See descriptions for each column in the datasource here.