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, Affiliate, Paid Inclusion, Product feeds, 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

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.
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 DoubleClick Search ad.
Paid Search Keyword ID Long Unique ID from DoubleClick Search. Uses the “long” format, a 17 digit number starting with 43*
Paid Search Legacy Keyword ID Long Unique ID from DoubleClick Search. 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 DoubleClick Search.
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 DoubleClick Search.
Paid Search Keyword String User defined keyword value as entered into DoubleClick Search.
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
149645 3 Video Unmutes
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

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 Sytem ID Long Unique ID of OS for Data Transfer. Operating System ID in Data Transfer files
Operating Sytem 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.

Send feedback about...

DoubleClick Campaign Manager
DoubleClick Campaign Manager