Stay organized with collections
Save and categorize content based on your preferences.
All match table files are stored as comma delimited text files on Google
Cloud Storage and are compressed using gzip.
The first row of the file is always a header row containing the
column names.
For fields containing special characters, the contents of the field are
wrapped in quotation marks.
Rows are not sorted.
Files are in CSV format and support UTF-8 character encoding
fields without values are exposed as empty, unless specified otherwise
activity_cats
Field
Type
Description
Match to
Floodlight Configuration
Long
Unique ID of floodlight configuration
Floodlight configuration in advertisers match table
Activity Group ID
Long
The ID associated with an activity group and included in the type= parameter of Floodlight
tags
Activity Type
String
User defined string corresponding to type= value from
Floodlight tag
Activity ID
Long
Unique ID of activity
Activity ID in Data Transfer activity file
Activity Sub-Type
String
User defined string corresponding to cat= value from
floodlight tag
Activity
String
User defined category report interface name for
floodlight tags
Tag Counting Method ID
Long
User defined type - describing Floodlight tag type. Key: 1 -
standard, 2 - unique, 3 - custom, 4 - integer of transactions - for sales
tags only, 5 - integer of items sold - for sales tags only
activity_types
Field
Type
Description
Match to
Floodlight Configuration
Long
Unique ID of floodlight configuration
Floodlight Configuration in advertisers match table
Activity Group ID
Long
ID for this activity group
Activity Type
String
User defined string corresponding to type= value from
Floodlight tag
Activity Group
String
Name for this activity group
ads
Field
Type
Description
Match to
Advertiser ID
Long
Unique ID of Advertiser
Advertiser ID in Data Transfer files / match tables
Campaign ID
Long
Unique ID of Campaign
Campaign ID in Data Transfer files / match tables
Ad ID
Long
Unique ID of Ad
Ad ID in Data Transfer files / match tables
Ad
String
User defined ad name
Ad Click URL
String
Ad Click URL of Click Ad type creatives only (aka Click
Commands)
Placement ID in Data Transfer files / match tables
advertisers
Field
Type
Description
Match to
Floodlight Configuration
Long
Unique ID of floodlight configuration
activity_cats, activity_types match tables
Advertiser ID
Long
Unique ID of advertiser
Advertiser ID in Data Transfer files / match tables
Advertiser
String
User entered name of advertiser
Advertiser Group ID
Long
Group ID to which this advertiser belongs. An advertiser may be a
member of only one group
Advertiser Group
String
User specified group to which this advertiser belongs. An
advertiser may be a member of only one group
assets
Field
Type
Description
Match to
Asset
String
The name of the asset.
Asset ID
Long
The unique ID of the asset.
Asset ID in Data Transfer files.
Asset Category
String
The category of the asset. 1 = flash, 2 = video, 3 = static image, 4 = HTML5, 5 = other, 6 = audio
Asset Orientation
String
The screen orientation of the asset: portrait, landscape, or square.
browsers
Field
Type
Description
Match to
Browser/Platform ID
Long
Unique ID of Browser/Platform
Browser/Platform ID in Data Transfer files
Browser/Platform
String
Browser name
campaigns
Field
Type
Description
Match to
Advertiser ID
Long
Unique ID of advertiser
Advertiser ID in Data Transfer files / match tables
Campaign ID
Long
Unique ID of Campaign
Campaign ID in Data Transfer files / match tables
Campaign
String
User entered campaign name
Campaign Start Date
date
Campaign start date as YYYYMMDD.
Campaign End Date
date
Campaign end date as YYYYMMDD.
Billing Invoice Code
String
User entered string.
cities
Field
Type
Description
Match to
City ID
Long
Unique ID of City.
City ID in Data Transfer impression, click files
City
String
City name, in English.
creatives
Field
Type
Description
Match to
Advertiser ID
Long
Unique ID of Advertiser
Advertiser ID in Data Transfer files / match tables
Creative ID
Long
Matches the Creative ID in DCM UI
Rendering ID
Long
Unique ID of the creative for Data Transfer.
Rendering ID in Data Transfer files
Creative
String
Creative Name as entered into the DCM interface.
Creative Last Modified Date
Long
Last Modified date and time in milliseconds since 1970-01-01 00:00:00 UTC.
Creative Type
String
Image, HTML, Redirect, etc.
Creative Pixel Size
String
Width x height creative size string. Empty size represented by "0X0".
Creative Image URL
String
Location of creative image (Does not apply to rich media).
Creative Version
Integer
Used for change management to capture
different versions, such as when traffickers swap creatives. Part of
the primary key.
creative_ad_assignments
Field
Type
Description
Match to
Ad ID
Long
Unique ID from DCM.
Ad ID in Data Transfer files / match tables
Creative ID
Long
This is not rendering ID. It is the Creative ID used in the creatives match table.
Creative ID in creatives match table
Creative Start Date
Long
Rotation start date and time in milliseconds since 1970-01-01 00:00:00 UTC.
Creative End Date
Long
Rotation end date and time in milliseconds since 1970-01-01 00:00:00 UTC.
Creative Rotation Type
String
Rotation type.
Creative Groups 1
String
User defined value from creative group 1.
Creative Groups 2
String
User defined value from creative group 2.
Ad Click URL
String
Ad Click URL of creative.
custom_creative_fields
Field
Type
Description
Match to
Advertiser ID
Long
Unique ID of advertiser.
Advertiser ID in Data Transfer files / match tables
Creative ID
Long
This is not rendering ID. It is the Creative ID used in the creatives match table.
Creative ID in creatives match table
Creative Custom Field Number
Long
Slot ID assigned to this custom creative field (typically IDs from
1-20).
Creative Custom Field Name
string
User defined name associated to a particular custom creative field.
Creative Custom Field Value
string
User defined value as available option to named field.
paid_search
Field
Type
Description
Match to
Ad ID
Long
Unique ID from DCM.
Advertiser ID
Long
Unique ID from DCM.
Campaign ID
Long
Paid Search Ad ID
Long
Unique ID associated with a Search Ads 360 ad.
Paid Search Keyword ID
Long
Unique ID from Search Ads 360. Uses the “long” format, a 17 digit number starting with 43*
Paid Search Legacy Keyword ID
Long
Unique ID from Search Ads 360. Uses the "short" format in which the leading 43* is removed.
Segment Value 1 in click or activity files.
Paid Search Campaign
String
User defined name of campaign as entered into Search Ads 360.
Paid Search Ad Group
String
User defined keyword group.
Paid Search Bid Strategy
String
User defined keyword bid strategy. Returns a value of "(not set)" if empty.
Paid Search Landing Page URL
String
User defined landing page URL as entered into Search Ads 360.
Paid Search Keyword
String
User defined keyword value as entered into Search Ads 360.
Paid Search Match Type
String
User selected, engine defined, keyword selection match type.
designated_market_areas
Field
Type
Description
Match to
Designated Market Area (DMA) ID
Long
Unique ID of the DMA.
Designated Market Area (DMA) ID in Data Transfer files
Designated Market Area
String
DMA text name, in English.
keyword_value
Field
Type
Description
Match to
Ad ID
Long
Unique ID of the ad.
Ad ID in Data Transfer files / match tables
Keyword
String
Targeted key/value pair.
Null user ID reason categories
ID
Reason category
0
No Reasons
1
Google
2
Partner Policy
3
Google | Partner Policy
4
Privacy
5
Google | Privacy
6
Partner Policy | Privacy
7
Google | Partner Policy | Privacy
Rich Media standard event and event type IDs
Event ID
Event type ID
Name
1
3
Prefetch
2
1
Display Time
3
1
Interactivity Time
4
3
Interactivity Impressions
5
3
Full Screen Video Plays
6
3
Full Screen Video Completes
7
1
Full Screen Average View Time
8
3
Motif Manual Closes
9
3
Motif Backup Image
10
1
Motif Expansions
11
3
Video Plays
12
1
Video View Time
13
3
Video Complete Plays
14
3
Video Interactions
15
3
Video Pauses
16
3
Video Mutes
17
3
Video Replays
18
3
Video Midpoints
19
3
Video Full Screen
20
3
Video Stops
22
3
Video Abandons
149645
3
Video Unmutes
200034
3
TrueView Views
286263
3
Full Screen Impressions
536393
3
Dynamic Ad Impressions
871060
3
HTML5 Impressions
960584
3
Video First Quartile Completions
960585
3
Video Third Quartile Completions
1095941
3
In-stream Companion Clicks
1208655
3
Video Skips
1208656
3
Video Views
200017
3
Audio Plays
200018
1
Audio Play Time
200019
3
Audio Complete Plays
200020
3
Audio Interactions
200021
3
Audio Pauses
200022
3
Audio Mutes
200023
3
Audio Replays
200024
3
Audio Midpoints
200025
3
Audio Stops
200026
3
Audio Abandons
200031
3
Audio Unmutes
custom_rich_media
Field
Type
Description
Advertiser ID
Long
Rich Media Event ID
Long
Rich Media Event
string
Rich Media Event Type ID
Long
Rich Media Event Type
string
Describes the type of rich media event. Possible values are: "Timer, Exit, Counter"
operating_systems
Field
Type
Description
Match to
Operating System ID
Long
Unique ID of OS for Data Transfer.
Operating System IDs in DT files that are greater than 22 have a direct match in this table.
For DT file Operating System IDs less than 23, you must raise 2 to the power of the Operating System ID in the Data Transfer
file to find its corresponding match in this table. Match Table Operating System ID = 2 ^ DT file operating system ID.
For example 2 ^ 12 = 8192 (Linux).
Operating System
string
Operating system name.
placements
Field
Type
Description
Campaign ID
Long
Unique ID from DCM.
Site ID
Long
Unique ID from DCM.
Placement ID
Long
Unique ID from DCM.
Site keyname
String
User defined site key as expressed in the DCM ad tag.
Placement
String
User defined name of placement.
Content Category
String
User defined content category.
Placement Strategy
String
User defined strategy.
Placement Start Date
Date
Placement start date as YYYYMMDD.
Placement End Date
Date
Placement end date as YYYYMMDD.
Placement Group Type
String
User defined type of placement group. Roadblock for instance.
Package/Roadblock ID
Long
Page-ID of the parent placement if this placement is a child
placement type.
