Skip to main content
Skip table of contents

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

CODE 
{
'facebook ads': 'Date',
'google ads': 'Date',
}
CODE 
{
'facebook ads': 'date_start',
'google 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

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

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

CODE 
{
'facebook ads': 'Facebook Ads',
'google ads': 'Google Ads',
}

publisher_platform

The Publisher Platform on where the Campaign Delivered Ads

Dimensions

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

account_id

The Ad Account Identifier

Dimensions

CODE 
{
'facebook ads': 'Account ID',
'google ads': 'Account ID',
}
CODE 
{
'facebook ads': 'account_id',
'google ads': 'customer_id',
}

account_name

The Ad Account Name

Dimensions

CODE 
{
'facebook ads': 'Account Name',
'google ads': 'Account',
}
CODE 
{
'facebook ads': 'account_name',
'google ads': 'customer_name',
}

campaign_id

The Campaign Identifier

Dimensions

CODE 
{
'facebook ads': 'Campaign Id',
'google ads': 'Campaign ID',
}
CODE 
{
'facebook ads': 'campaign_id',
'google ads': 'campaign_id',
}

campaign_name

The Campaign Name

Dimensions

CODE 
{
'facebook ads': 'Campaign',
'google ads': 'Campaign',
}
CODE 
{
'facebook ads': 'campaign_name',
'google ads': 'campaign_name',
}

adgroup_id

The Adgroup Identifier

Dimensions

CODE 
{
'facebook ads': 'Ad set ID',
'google ads': 'Ad group ID',
}
CODE 
{
'facebook ads': 'adset_id',
'google ads': 'ad_group_id',
}

adgroup_name

The Adgroup Name

Dimensions

CODE 
{
'facebook ads': 'Ad Set Name',
'google ads': 'Ad group',
}
CODE 
{
'facebook ads': 'adset_name',
'google ads': 'ad_group_name',
}

ad_id

The Ad Identifier

Dimensions

CODE 
{
'facebook ads': 'Ad ID',
'google ads': 'Ad ID',
}
CODE 
{
'facebook ads': 'ad_id',
'google ads': 'ad_id',
}

ad_name

The Ad Name

Dimensions

CODE 
{
'facebook ads': 'Ad',
'google ads': 'Ad',
}
CODE 
{
'facebook ads': 'ad_name',
'google ads': 'ad_name',
}

product_merchant_id

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

Dimensions

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

product_id

Item ID of the product.

Dimensions

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

cost

Costs (Ad Spend)

Metrics

CODE 
{
'facebook ads': 'Amount Spend',
'google ads': 'Cost',
}
CODE 
{
'facebook ads': 'spend',
'google ads': 'cost',
}

impressions

Impressions

Metrics

CODE 
{
'facebook ads': 'Impressions',
'google ads': 'Impr.',
}
CODE 
{
'facebook ads': 'impressions',
'google ads': 'impressions',
}

clicks

Clicks

Metrics

CODE 
{
'facebook ads': 'Link clicks',
'google ads': 'Clicks',
}
CODE 
{
'facebook ads': 'inline_link_clicks',
'google ads': 'clicks',
}

total_conversions

The Total Number of Conversions

Metrics

CODE 
{
'facebook ads': 'Actions',
'google ads': 'All conv.',
}
CODE 
{
'facebook ads': 'actions',
'google ads': 'all_conversions',
}

total_conversions_value

The Value associated with the Total Number of Conversions

Metrics

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

conversions

The Number of Conversions

Metrics

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

conversions_value

The Value associated with Conversions

Metrics

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

cross_device_conversions

Metrics

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

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.

JavaScript errors detected

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

If this problem persists, please contact our support.

Contact Support Close