Data Transfer v2.0: File Format

All Data Transfer Files are stored as comma separated values (CSV). Due to the customizable nature of Data Transfer, your files may not contain all fields below.

  • 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.
  • Missing values are left blank.
  • Rows are not sorted.
  • DBM fields will only populate if advertisers are linked between DCM<>DBM and permissions are granted. You must permission each advertiser. You can also permission the partner to enable every new advertiser by default. In Bid Manager, navigate to: Advertiser (or partner) > Basic Details > Dcm Configuration > then enable Include Bid Manager Data in DCM Data Transfer

File naming conventions

Filenames are a combination of dcm ID (like account, or floodlight), data transfer type (impression, click, activity, or rich_media), the date and hour of the processed file (YYYYMMDDHH), the day the report was generated (YYYYMMDD), the time the report was generated (HHMMSS), and the execution ID of the report separated by underscores.

For example, an account impression file might look like: dcm_account_XXXX_impression_2015122400_20151225_123000_2413119.csv.gz where XXXX represents the account ID and the file is hour 0 from 12/24/2015. The report was generated on 12/25 at 12:30 pm with an execution ID of 2413119.

Fields Type Impression Click Activity Rich Media Description
Referrer URL String Yes No No No Contains the URL on which the ad appeared, when possible. May also be empty, or return ad server URLs.
Impression ID String Yes Yes No Yes Unique ID used to join Impression, Click, and Rich Media, Data Transfer file data
Active View: Eligible Impressions Long Yes No No No Whether the impression was eligible to measure viewability. An impression is eligible if (a) the ad's creative has an Active View tag and (b) the tag successfully communicates with the DoubleClick servers at the time of the impression.

See the Active View Help for more information
Active View: Measurable Impressions Long Yes No No No Whether the impression was measurable with Active View
Active View: Viewable Impressions Long Yes No No No Whether the impression was viewable
Activity ID Long No No Yes No The ID of the Floodlight tag related to the conversion event
Event Time Long Yes Yes Yes Yes Time in microseconds since 1970-01-01 00:00:00 UTC
Event Type String Yes Yes Yes No Contains details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "CONVERSION" or blank for conversion events
Event Sub-Type String Yes Yes Yes No Contains further details related to the event - these are "VIEW" and "CLICK" for view and click events, but may be "POSTVIEW", "POSTCLICK" or blank for conversion events
User ID String Yes Yes Yes Yes The DoubleClick tracking ID (it is based on, but does not expose the user's browser cookie or mobile device ID). This field may be zeroed out for privacy reasons.
Advertiser ID Long Yes Yes Yes Yes Unique ID of the advertiser
Campaign ID Long Yes Yes Yes Yes Unique ID of the campaign
Ad ID Long Yes Yes Yes Yes Unique ID of the ad placement
Rendering ID Long Yes Yes Yes Yes Unique ID of the creative for Data Transfer. Does not correspond to the UI-Creative-ID
Creative Version Integer Yes Yes Yes Yes Creative version number
Site ID (DCM) Long Yes Yes Yes Yes Unique ID for the site where the ad ran
Placement ID Long Yes Yes Yes Yes Unique ID for the site page / placement where the ad ran
Country Code String char(2) Yes Yes Yes Yes 2-letter ISO 3166-1 country code
State/Region String Yes Yes Yes Yes ID for user's state or province (US/Canada)
Browser/Platform ID Long Yes Yes Yes Yes ID of the browser type
Browser/Platform Version String Yes Yes Yes Yes Browser version
Operating System ID Long Yes Yes Yes Yes ID of the operating system
Designated Market Area (DMA) ID Long Yes Yes No No Designated Market Area ID (US/Canada)
City ID Long Yes Yes No No City ID
ZIP/Postal Code String Yes Yes No No Postal-Code (US/Canada)
U Value String Yes Yes Yes No Site's user-supplied info. Data is passed using the "u=" key value. Natural search clicks recorded by DCM are also surfaced here with the format of: U=[searchterm]^^[property]^^[referring_url]^^
TRAN Value String No No Yes No The advertiser's transaction ID, if relevant for a given activity type. Should only be activated if client is using the "tran=" key-value pair in their Floodlight tags (generally used for storing the client's Order-ID)
Other Data String No No Yes No Stores key-value data from the activity string which is not otherwise labeled. (Any key-value that is NOT "src=", "type=", "cat=", "ord=", "u=", "cost=", "qty=", "tran=", "a=", or "b="). (Can be used for further product breakdown aka "Custom Floodlight Variables")
ORD Value String No No Yes No The advertiser's ordinal ID, if relevant for a given activity type. Passed in the "ord=" key-value (also used for storing the client's Order-ID in sales tags)
Interaction Time String No No Yes No The activity’s associated (aka "matched") click or impression time in microseconds since 1970-01-01 00:00:00 UTC
Conversion ID Integer No No Yes No Indicates whether an activity has been matched as a post-click (value of 1) or post-impression (value of 2), or unmatched (value of 0)
Segment Value 1 Long No Yes Yes No DoubleClick Search keyword id
Rich Media Event ID Long No No No Yes MET Event ID for the Rich Media ad.
Rich Media Event Type ID Long No No No Yes ID of Rich Media Event Type. See match tables section for match descriptions. You will need to create your own match table.
Total Conversions Integer No No Yes No Can contain additional values for type or category, for example, sales quantity. As passed using the "qty=" key-value
Total Revenue Double No No Yes No Can contain additional values for type or category, for example, sales amount in USD micros, you can multiply by 1,000,000 to see it as currency. As passed using the "cost=" key-value
Event Timers Double No No No Yes MET Timer Value (the etm= value), expressed in seconds
Event Counters Long No No No Yes MET Counter Value (the ecn= value)
Partner1 ID String Yes Yes Yes Yes Partner1 encrypted value
Partner2 ID String Yes Yes Yes Yes Partner2 encrypted value
DBM View State String Yes No No No When tag wrappers are used for 3rd party ad verification, view state indicates if DBM successfully won the impression, and if an ad served to that inventory. Value of “outer” means Bid Manager won the bid and returned the wrapped tag to be served on publisher site. Value of “inner” means an ad served because the inventory was considered brand safe. When both events occur, there will be two impression records. A single impression record with an “outer” value, and no corresponding record with “inner”, means the 3rd party verification service blocked the impression post-bid
DBM Auction ID String Yes Yes Yes No A string used to join events among view/click/conversion types, for example"ABCDEFGH_abcdefgh-0123456789". Do not assume any ordering, structure or meaning to the auction_id value
DBM Request Time Long Yes Yes Yes No A Unix timestamp in microseconds (1/1,000,000 second) for when we received the ad request, for example1330403779608570represents Tuesday February 28th 2012 04:36:19.608570. Although this value is consistent across the view, click and conversion even it is not guaranteed to be unique - please use auction_id to join events
DBM Advertiser ID Long Yes Yes Yes No The DoubleClick Bid Manager numerical ID for the advertiser related to the event, for example164332
DBM Insertion Order ID Long Yes Yes Yes No The DoubleClick Bid Manager numerical ID for the insertion order related to the event, for example1079941
DBM Line Item ID Long Yes Yes Yes No The DoubleClick Bid Manager numerical ID for the line item related to the event, for example1155785
DBM Creative ID Long Yes Yes Yes No The DoubleClick Bid Manager numerical ID for the creative related to the event, for example 367487
DBM Bid Price (USD) Long Yes Yes Yes No The bid price sent to the exchange, in USD nanos, you can divide by 1,000,000,000 to see it as USD. Note that although the bid is sent to exchanges as a CPM value, this is represented as a CPI value for consistency with the other metrics
DBM Bid Price (Partner Currency) Long Yes Yes Yes No The bid price sent to the exchange, in partner currency nanos, you can divide by 1,000,000,000 to see it as currency. Note that although the bid is sent to exchanges as a CPM value, this is represented as a CPI value for consistency with the other metrics
DBM Bid Price (Advertiser Currency) Long Yes Yes Yes No The bid price sent to the exchange, in advertiser currency nanos, you can divide by 1,000,000,000 to see it as currency. Note that although the bid is sent to exchanges as a CPM value, this is represented as a CPI value for consistency with the other metrics
DBM URL String Yes Yes Yes No The raw URL taken from the bid request received from the exchange, for example "http://www.example.com". As some exchanges mask the URL in their bid requests this value may be"source_url_hidden"
DBM Site ID Long Yes Yes Yes No The DoubleClick Bid Manager numerical ID for the most specific universal site that matches the url
DBM Language String Yes Yes Yes No The ISO-639-1 code or"zh_CN" (Chinese (simplified)), "zh_TW"(Chinese (traditional)) or"other" representing the language related to the view event
DBM Adx Page Categories String Yes Yes Yes No Contains the DoubleClick Ad Exchange page category IDs separated by a space, for example "65 189". The categories may not be mutually exclusive
DBM Matching Targeted Keywords String Yes Yes Yes No A comma separated string containing a list of targeted keywords matching the page related to the view event, for example "apple,orange,banana". Although the page related to the view event may match many keywords, only those which were targeted will be included; if the list of keywords is large we may impose a limit to the number of keywords returned
DBM Exchange ID Long Yes Yes Yes No The DoubleClick Bid Manager numerical ID for the exchange that requested the ad
DBM Attributed Inventory Source External ID String Yes Yes Yes No The external ID of the attributed inventory source that DoubleClick Bid Manager selected as the best match from those accessible to the advertiser related to the view event based on floor price and auction type
DBM Attributed Inventory Source Is Public Boolean Yes Yes Yes No True if inventory source is available to all buyers. False otherwise
DBM Ad Position Long Yes Yes Yes No Specifies the position of the ad on the page if known. 1 represents above the fold, 2 represents below the fold
DBM Country Code String Yes Yes Yes No 2-letter ISO 3166-1 country code identifying the best-guess country of the impression, for example "US"
DBM Designated Market Area (DMA) ID Long Yes Yes Yes No Designated Market Area code if known, for example 807
DBM ZIP/Postal Code String Yes Yes Yes No The postal code identifying the best-guess postal area of the impression if known, for example "98033". Do not assume uniqueness across different countries
DBM State/Region ID Long Yes Yes Yes No An integer matching the state/region integer available in reporting and targeting
DBM City ID Long Yes Yes Yes No The DoubleClick Bid Manager numerical ID identifying the best-guess city of the impression
DBM Operating System ID Long Yes Yes Yes No The DoubleClick Bid Manager numerical ID identifying the operating system related to this event
DBM Browser/Platform ID Long Yes Yes Yes No The DoubleClick Bid Manager numerical ID identifying the browser related to this event
DBM Browser Timezone Offset Minutes Long Yes Yes Yes No The difference in minutes between the active timezone on the user's browser and GMT-12, for example 1320 represents a browser timezone of GMT+10
DBM Net Speed Long Yes Yes Yes No The DoubleClick Bid Manager numerical ID representing the network speed related to the view event.
1=Dial-up
2=EDGE/2G
3=UMTS/3G
4=Basic DSL
5=HSDPA/3.5G
6=Broadband/4G
7=Unknown
DBM Matching Targeted Segments String Yes Yes Yes No The names of targeted user lists that match the visitor separated by a space, for example "-4 456". If the visitor is in a user list that is not targeted by the ad associated with this event it will not be included here
DBM ISP ID Long Yes Yes Yes No The DoubleClick Bid Manager numerical ID for the best-guess Internet Service Provider of the impression. This value may be missing
DBM Device Type Long Yes Yes Yes No The numerical value of the identified device type. 0 = COMPUTER 1 = OTHER 2 = SMARTPHONE 3 = TABLET 4 = SMARTTV
DBM Mobile Make ID Long Yes Yes Yes No The numerical ID for the mobile make. This value may be missing
DBM Mobile Model ID Long Yes Yes Yes No The numerical ID for the mobile model. This value may be missing
DBM Media Cost (USD) Long Yes Yes Yes No The amount paid for the impression in USD nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero
DBM Media Cost (Partner Currency) Long Yes Yes Yes No The amount paid for the impression in the partner currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero
DBM Media Cost (Advertiser Currency) Long Yes Yes Yes No The amount paid for the impression in advertiser currency nanos, you can divide by 1,000,000,000 to see it as currency. This value may be zero
DBM Revenue (USD) Long Yes Yes Yes No The total amount in USD nanos made by the partner account for the view event. This value may be zero
DBM Revenue (Partner Currency) Long Yes Yes Yes No The total amount in partner currency nanos made by the partner account for the view event. This value may be zero
DBM Revenue (Advertiser Currency) Long Yes Yes Yes No The total amount in advertiser currency nanos made by the partner account for the view event. This value may be zero
DBM Total Media Cost (USD) Long Yes Yes Yes No The total media cost in USD nanos for the view event. This value may be zero
DBM Total Media Cost (Partner Currency) Long Yes Yes Yes No The total media cost in partner currency nanos for the view event. This value may be zero
DBM Total Media Cost (Advertiser Currency) Long Yes Yes Yes No The total media cost in advertiser currency nanos for the view event. This value may be zero
DBM CPM Fee 1 (USD) Integer Yes Yes Yes No The CPM 1 fee in USD nanos. This value may be zero
DBM CPM Fee 1 (Partner Currency) Long Yes Yes Yes No The CPM 1 fee in partner currency nanos. This value may be zero
DBM CPM Fee 1 (Advertiser Currency) Long Yes Yes Yes No The CPM 1 fee in advertiser currency nanos. This value may be zero
DBM CPM Fee 2 (USD) Long Yes Yes Yes No The CPM 2 fee in USD nanos. This value may be zero
DBM CPM Fee 2 (Partner Currency) Long Yes Yes Yes No The CPM 2 fee in partner currency nanos. This value may be zero
DBM CPM Fee 2 (Advertiser Currency) Long Yes Yes Yes No The CPM 2 fee in advertiser currency nanos. This value may be zero
DBM CPM Fee 3 (USD) Long Yes Yes Yes No The CPM 3 fee in USD nanos. This value may be zero
DBM CPM Fee 3 (Partner Currency) Long Yes Yes Yes No The CPM 3 fee in partner currency nanos. This value may be zero
DBM CPM Fee 3 (Advertiser Currency) Long Yes Yes Yes No The CPM 3 fee in advertiser currency nanos. This value may be zero
DBM CPM Fee 4 (USD) Long Yes Yes Yes No The CPM 4 fee in USD nanos. This value may be zero
DBM CPM Fee 4 (Partner Currency) Long Yes Yes Yes No The CPM 4 fee in partner currency nanos. This value may be zero
DBM CPM Fee 4 (Advertiser Currency) Long Yes Yes Yes No The CPM 4 fee in advertiser currency nanos. This value may be zero
DBM CPM Fee 5 (USD) Long Yes Yes Yes No The CPM 5 fee in USD nanos. This value may be zero
DBM CPM Fee 5 (Partner Currency) Long Yes Yes Yes No The CPM 5 fee in partner currency nanos. This value may be zero
DBM CPM Fee 5 (Advertiser Currency) Long Yes Yes Yes No The CPM 5 fee in advertiser currency nanos. This value may be zero
DBM Media Fee 1 (USD) Long Yes Yes Yes No The Media Fee 1 in USD nanos. This value may be zero
DBM Media Fee 1 (Partner Currency) Long Yes Yes Yes No The Media Fee 1 in partner currency nanos. This value may be zero
DBM Media Fee 1 (Advertiser Currency) Long Yes Yes Yes No The Media Fee 1 in advertiser currency nanos. This value may be zero
DBM Media Fee 2 (USD) Long Yes Yes Yes No The Media Fee 2 in USD nanos. This value may be zero
DBM Media Fee 2 (Partner Currency) Long Yes Yes Yes No The Media Fee 2 in partner currency nanos. This value may be zero
DBM Media Fee 2 (Advertiser Currency) Long Yes Yes Yes No The Media Fee 2 in advertiser currency nanos. This value may be zero
DBM Media Fee 3 (USD) Long Yes Yes Yes No The Media Fee 3 in USD nanos. This value may be zero
DBM Media Fee 3 (Partner Currency) Long Yes Yes Yes No The Media Fee 3 in partner currency nanos. This value may be zero
DBM Media Fee 3 (Advertiser Currency) Long Yes Yes Yes No The Media Fee 3 in advertiser currency nanos. This value may be zero
DBM Media Fee 4 (USD) Long Yes Yes Yes No The Media Fee 4 in USD nanos. This value may be zero
DBM Media Fee 4 (Partner Currency) Long Yes Yes Yes No The Media Fee 4 in partner currency nanos. This value may be zero
DBM Media Fee 4 (Advertiser Currency) Long Yes Yes Yes No The Media Fee 4 in advertiser currency nanos. This value may be zero
DBM Media Fee 5 (USD) Long Yes Yes Yes No The Media Fee 5 in USD nanos. This value may be zero
DBM Media Fee 5 (Partner Currency) Long Yes Yes Yes No The Media Fee 5 in partner currency nanos. This value may be zero
DBM Media Fee 5 (Advertiser Currency) Long Yes Yes Yes No The Media Fee 5 in advertiser currency nanos. This value may be zero
DBM Data Fees (USD) Long Yes Yes Yes No The cost of any data that was used to target this impression, in USD nanos
DBM Data Fees (Partner Currency) Long Yes Yes Yes No The cost of any data that was used to target this impression, in partner currency nanos
DBM Data Fees (Advertiser Currency) Long Yes Yes Yes No The cost of any data that was used to target this impression, in advertiser currency nanos
DBM Billable Cost (USD) Long Yes Yes Yes No The total amount of money billed to the partner, including the media cost and partner costs, in USD nanos
DBM Billable Cost (Partner Currency) Long Yes Yes Yes No The total amount of money billed to the partner, including the media cost and partner costs, in partner currency nanos
DBM Billable Cost (Advertiser Currency) Long Yes Yes Yes No The total amount of money billed to the partner, including the media cost and partner costs, in advertiser currency nanos

Send feedback about...

DoubleClick Campaign Manager
DoubleClick Campaign Manager