Data Transfer v2.0: Match Tables

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 Type 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
Click-through URL	String	Click through 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 Note: This is different from DT V1, where the Creative ID did not align to the UI Creative ID, but rather an ID for Data Transfer In DT V2, Rendering ID is the match for Data Transfer and Creative ID is the match to the ID in the 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.
Click-through URL	String	Clickthrough 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. This might differ for keywords developed prior to or post DS3 migration	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

Because matches for null user ID reason categories don't change, they are not included in a match table file. Use the matches below to create your own. Multiple reasons are "or" (less specific) denoted by a "|"

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

Because IDs for RM standard events and event types don't change, they are not included in a match table file. Use the IDs / names below to create your own.

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.
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	Long	Unique ID from DCM. Refers to Site ID in DT.
Site	String
Site ID (Site Directory)	Long	Unique ID from DCM. Global unique ID for this site.
Site (Site Directory)	String	Global unique name for this site.

states

Field	Type	Description
State/Region Abbreviation	String	Abbreviated state/province name.
State/Region	String	State/province name, in English.

custom_floodlight_variables

Field	Type	Description
Floodlight Configuration	Long	Unique ID of Floodlight configuration
Custom Floodlight Variable ID	String	Variable key 'u1' through 'u20' found in Floodlight conversion tags.
Custom 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.