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)
Ad Type
String
Type of ad. Possible values are: "Standard, Interstitial, Static Click, Dynamic Click,
Tracking, In-Steam Video, DART Search Ads 360, Affiliate, Paid Inclusion, Product feeds, Search Ads 360 Natural Search,
Default, Interstitial Default, InStream Default Ad, Brand-neutral"
Creative Pixel Size
String
Size of creative in pixels
Ad Comments
String
User defined ad level comments
ad_placement_assignments
Field
Type
Description
Match to
Ad ID
Long
Unique ID of Ad
Ad ID in Data Transfer files/ match tables
Placement ID
Long
Unique ID of placement
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
[{
"type": "thumb-down",
"id": "missingTheInformationINeed",
"label":"Missing the information I need"
},{
"type": "thumb-down",
"id": "tooComplicatedTooManySteps",
"label":"Too complicated / too many steps"
},{
"type": "thumb-down",
"id": "outOfDate",
"label":"Out of date"
},{
"type": "thumb-down",
"id": "samplesCodeIssue",
"label":"Samples / code issue"
},{
"type": "thumb-down",
"id": "otherDown",
"label":"Other"
}]
[{
"type": "thumb-up",
"id": "easyToUnderstand",
"label":"Easy to understand"
},{
"type": "thumb-up",
"id": "solvedMyProblem",
"label":"Solved my problem"
},{
"type": "thumb-up",
"id": "otherUp",
"label":"Other"
}]
{"lastModified": "Last updated 2024-09-19 UTC."}
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2024-09-19 UTC."]]
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.
Placement Cost Structure
String
Possible values are: "Impressions, Clicks, CPM, CPC, CPA,
Flat Rate - Impressions, Flat Rate - Clicks"
Placement Cap Cost Option
String
User entered cost capping amount.
Flighting Activated
Boolean
TRUE or FALSE indicating whether this is a flighted (billing) placement.
Activity ID
Long
If a CPA buy, indicates the Activity-ID of the corresponding
Floodlight tag.
placement_cost
Field
Type
Description
Placement ID
Long
Unique ID from DCM. Refers to a Placement.
Placement Start Date
Date
Start date of the flight in 'YYYYMMDD' format.
Placement End Date
Date
End date of the flight in 'YYYYMMDD' format.
Package/Roadblock Total Booked Units
Long
Purchased units, eg, 1000 (impressions) or 1000 (clicks).
Placement Rate
Float
Purchased rate expressed in nanos of the network's currency. 1 nano = 1 billionth. 1 nano
USD = $0.000000001
Placement Comments
String
User entered placement pricing comments.
sites
Field
Type
Description
Site ID (CM360)
Long
Unique ID from CM360. Refers to Site ID in DT.
Site (CM360)
String
Site ID (Site Directory)
Long
Unique ID from CM360. Global unique ID for this site.
Site (Site Directory)
String
Global unique name for this site.
states
Field
Type
Description
State/Region
String
Abbreviated state/province name.
State/Region Full Name
String
State/province full name, in English.
custom_floodlight_variables
Field
Type
Description
Floodlight Configuration
Long
Unique ID of Floodlight configuration
Floodlight Variable ID
String
Variable key 'u1' through 'u20' found in Floodlight
conversion tags.
Floodlight Variable
String
User entered name corresponding to variable key.
landing_page_url
Field
Type
Description
Match to
Landing Page URL ID
Long
Unique ID of the landing page URL.
Landing Page URL ID in click files.
Landing Page URL
String
The URL a user was sent to when they clicked on an ad.
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License , and code samples are licensed under the Apache 2.0 License . For details, see the Google Developers Site Policies . Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2024-09-19 UTC.
