# 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

<br />

### 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 > [!NOTE] > 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. |   |
| 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_ad_group

| Field | Type | Description | Match to |
|---|---|---|---|
| Advertiser ID | Long | Unique ID from DCM. |   |
| Floodlight Configuration | Long | Unique ID of floodlight configuration |   |
| Paid Search Ad Group | String | User defined keyword group. |   |
| Paid Search Ad Group ID | Long | Unique ID of the keyword group. | Sa360 Ad Group ID in click or activity files. |

### paid_search_campaign

| Field | Type | Description | Match to |
|---|---|---|---|
| Advertiser ID | Long | Unique ID from DCM. |   |
| Floodlight Configuration | Long | Unique ID of floodlight configuration |   |
| Paid Search Campaign | String | User defined name of campaign as entered into Search Ads 360. |   |
| Paid Search Campaign ID | Long | ID of the Search Ads 360 campaign. | Sa360 Campaign ID in click or activity files. |
| Paid Search Bid Strategy | String | User defined keyword bid strategy. Returns a value of "(not set)" if empty. |   |
| Paid Search Bid Strategy ID | Long | ID of the keyword bid strategy. | Segment Value 1 in click or activity files. |

### paid_search_keyword

| Field | Type | Description | Match to |
|---|---|---|---|
| Advertiser ID | Long | Unique ID from DCM. |   |
| Floodlight Configuration | Long | Unique ID of floodlight configuration |   |
| Paid Search Keyword | String | User defined keyword value as entered into Search Ads 360. |   |
| Paid Search Keyword ID | Long | Unique ID for Search Ads 360. Uses the "long" format. | Sa360 Keyword ID in click or activity files. |
| Paid Search Match Type | String | User selected, engine defined, keyword selection match type. |   |
| Paid Search Ad Group ID | Long | Unique ID of the keyword group. | Sa360 Ad Group ID in click or activity files. |

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

> [!NOTE]
> 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

> [!NOTE]
> 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 (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. |   |