Breadcrumbs

Data Library Field Mapping - Google Ads Performance Max

Overview

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


To understand which Alli Data Datasources are used within the creative_performance report, see the following link: https://agencypmg.atlassian.net/wiki/spaces/PTD/whiteboard/3164110849


Platforms include:

  • Google Ads


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

Column

Description

Dimensions / Metrics / Categorizations

Platform UI Name Mapping

Platform Mapping

id

The Internal Alli Id of the Record

N/A

N/A

N/A

date

The Date of Performance Data

Dimensions

 
{
'google ads': 'Date'
}

{
'google ads': 'TimePeriod'
}

account_id

The Ad Account Identifier

Dimensions

 
{
'google ads': 'Customer ID',

}

{
'google ads': 'account_id'
}

account_name

The Ad Account Name

Dimensions

 
{
'google ads': 'Account Nname'
}

{
'google ads': 'account_name'
}

campaign_id

The Campaign Identifier

Dimensions

 
{
'google ads': 'Campaign Id'
}

{
'google ads': 'campaign_id'
}

campaign_name

The Campaign Name

Dimensions

 
{
'google ads': 'Campaign'
}

{
'google ads': 'campaign_name'
}

query_type

Query Type

Categorization

N/A

N/A

all_impressions

All Impressions for the Campaign

Metrics

 
{
'google ads': 'Impressions'
}

{
'google ads': 'all_impressions'
}

shopping_impressions

Shopping Impressions for the Campaign (sourced from googleads_insights_shopping)

Metrics

 
{
'google ads': 'Impressions'
}

{
'google ads': 'shopping_impressions'
}

video_impressions

Video Impressions for the Campaign (sources from googleads_insights_campaign_interactiontarget Where the Asset Type is like VIDEO

Metrics

 
{
'google ads': 'Impressions'
}

{
'google ads': 'video_impressions'
}

display_impressions

Video Impressions for the Campaign (sources from googleads_insights_campaign_interactiontarget Where the Asset Type is like IMAGE

Metrics

 
{
'google ads': 'Impressions'
}

{
'google ads': 'display_impressions'
}

all_clicks

All Clicks for the Campaign

Metrics

 
{
'google ads': 'Clicks'
}

{
'google ads': 'all_clicks'
}

shopping_clicks

Shopping Clicks for the Campaign (sourced from googleads_insights_shopping)

Metrics

 
{
'google ads': 'Clicks'
}

{
'google ads': 'shopping_clicks'
}

video_clicks

Video Clicks for the Campaign (sources from googleads_insights_campaign_interactiontarget Where the Asset Type is like VIDEO

Metrics

 
{
'google ads': 'Clicks'
}

{
'google ads': 'video_clicks'
}

display_clicks

Video Clicks for the Campaign (sources from googleads_insights_campaign_interactiontarget Where the Asset Type is like IMAGE

Metrics

 
{
'google ads': 'Clicks'
}

{
'google ads': 'display_clicks'
}

all_cost

All Clicks for the Campaign

Metrics

 
{
'google ads': 'Cost'
}

{
'google ads': 'all_cost'
}

shopping_cost

Shopping Cost for the Campaign (sourced from googleads_insights_shopping)

Metrics

 
{
'google ads': 'Cost'
}

{
'google ads': 'shopping_cost'
}

video_cost

Video Cost for the Campaign (sources from googleads_insights_campaign_interactiontarget Where the Asset Type is like VIDEO

Metrics

 
{
'google ads': 'Cost'
}

{
'google ads': 'video_cost'
}

display_cost

Video Cost for the Campaign (sources from googleads_insights_campaign_interactiontarget Where the Asset Type is like IMAGE

Metrics

 
{
'google ads': 'Cost'
}

{
'google ads': 'display_cost'
}