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 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.
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.
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.