Search
Clear search
Close search
Google apps
Main menu
true

  Not available in DFP Small Business.

Data Transfer fields

Data Transfer files contain information about impressions, clicks, and other events transmitted through DoubleClick for Publishers. The table below describes each field in Data Transfer files. Learn more about Data Transfer

Use match tables to pair ID values with names
Numeric IDs are used for line items, creatives, and other DFP objects. Use match tables to correlate objects names with ID values.

Refer to the DoubleClick for Publishers API documentation for more details about each field. 

Field nameDescription

AdUnitId

STRING (xsd:string)

File types
ActiveViews + BackfillActiveViews
Activities
Clicks + BackfillClicks
Impressions + BackfillImpressions
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

DFP Ad unit ID
The ID for the inventory ad unit where the creative delivered.

AdvertiserId

NUMBER (xsd:long)

File types
ActiveViews + BackfillActiveViews
Activities
Clicks + BackfillClicks
Impressions + BackfillImpressions
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

DFP Advertiser ID
The numeric ID for the DFP advertiser company associated with the creative delivered.

LineItemId

NUMBER (xsd:long)

File types
ActiveViews + BackfillActiveViews
Activities
Clicks + BackfillClicks
Impressions + BackfillImpressions
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

DFP Line item ID
The numeric ID for the delivered DFP line item.

CreativeId

NUMBER (xsd:long)

File types
ActiveViews + BackfillActiveViews
Activities
Clicks + BackfillClicks
Impressions + BackfillImpressions
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

Creative ID
The numeric ID for the delivered DFP creative.

CreativeSize

STRING(9)

File types
ActiveViews + BackfillActiveViews
Activities
Clicks + BackfillClicks
Impressions + BackfillImpressions
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

Creative Size
The size in pixels (width x height) of the delivered DFP creative. For example, "300x250".

CreativeVersion

NUMBER

File types
ActiveViews + BackfillActiveViews
Activities
Clicks + BackfillClicks
Impressions + BackfillImpressions
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

Creative Version
A numeric version value associated with the delivered DFP creative.

CustomTargeting

STRING(255)

File types
ActiveViews + BackfillActiveViews
Activities
Clicks + BackfillClicks
Impressions + BackfillImpressions
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

Custom Targeting
Includes both targeted and non-targeted pairs, known as "key-values" in DFP. Key-value pairs are specified by the publisher and separated by semicolons (;).

Key-values reporting differs slightly between DFP reports and data that's delivered through Data Transfer. DFP reports only include key-values where both the key and the value are defined in DFP, while Data Transfer reports only require that the key be defined.

For example, if the key "articleID" is defined, but the value "123456" is not, this key-value would be included in Data Transfer reports, but not in DFP reports.

Domain

STRING

File types
ActiveViews + BackfillActiveViews
Activities
Clicks + BackfillClicks
Impressions + BackfillImpressions
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

Domain
The user domain that triggered the event.

IsCompanion

BOOLEAN

File types
ActiveViews + BackfillActiveViews
Activities
Clicks + BackfillClicks
Impressions + BackfillImpressions
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

Companion creative indicator
Indicates that the event was logged by a companion creative. Values are TRUE or FALSE.

IsInterstitial

BOOLEAN

File types
ActiveViews + BackfillActiveViews
Activities
Clicks + BackfillClicks
Impressions + BackfillImpressions
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

Out-of-page creative indicator
Indicates if the event was logged by an out-of-page creative, also known as an "interstitial." Values are TRUE or FALSE.

Keypart

STRING(9)

File types
ActiveViews + BackfillActiveViews
Activities
Clicks + BackfillClicks
Impressions + BackfillImpressions
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

Unique query identifier
Unique query identifier (hashed key). This field can be used in combination with TimeUsec2 to uniquely identify a query.

OrderId

NUMBER (xsd:long)

File types
ActiveViews + BackfillActiveViews
Activities
Clicks + BackfillClicks
Impressions + BackfillImpressions
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

DFP Order ID
The numeric ID for the DFP order which contained the delivered line item and creative.

Product

STRING

File types
ActiveViews + BackfillActiveViews
Clicks + BackfillClicks
Impressions + BackfillImpressions
VideoConversions + BackfillVideoConversions

DoubleClick product name
The DoubleClick product from which the event originated.
  • Ad Server
  • AdExchange
  • AdSense
  • Exchange Bidding
  • First Look
  • Mediation

RequestedAdUnitSizes

STRING

File types
ActiveViews + BackfillActiveViews
Activities
Clicks + BackfillClicks
Impressions + BackfillImpressions
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

Inventory sizes included in your request to DFP
The inventory size included in your tag or request to DFP. Values are displayed in pixels (width x height), separated by a pipe delimeter (|). For example, "300x250|300x600".

RefererURL

STRING

File types
ActiveViews + BackfillActiveViews
Activities
Clicks + BackfillClicks
Impressions + BackfillImpressions
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

Referer URL
The URL of the page that requested and that displayed the ad. Only HTTP and HTTPS URLs are included. Login components of URLs (user:password@) are omitted.

TargetedCustomCriteria

STRING(512)

File types
ActiveViews + BackfillActiveViews
Activities
Clicks + BackfillClicks
Impressions + BackfillImpressions
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

Targeted key-values
The key-values in your request to DFP that matched DFP line item targeting. This includes broad-matched keys, prefix-matched keys, or both. This field also displays keys which were negatively targeted by the line item. This value is truncated to 512 characters.

Time

STRING(19)

File types
ActiveViews + BackfillActiveViews
Activities
Clicks + BackfillClicks
Impressions + BackfillImpressions
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

Time of the event
The time of the event in your network's local timezone, displayed in 24-hour format (YYYY-MM-DD-HH:MI:SS).
  • For impressions, this value corresponds to the impression.
  • For clicks, this value corresponds to the underlying impression.
  • For Rich Media, video, conversions, and Active View, it corresponds to the actual event.

TimeUsec Deprecated

NUMBER

File types
ActiveViews + BackfillActiveViews
Activities
Clicks + BackfillClicks
Impressions + BackfillImpressions
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

This field is deprecated.
Use TimeUsec2, instead.

TimeUsec2

NUMBER

File types
ActiveViews + BackfillActiveViews
Activities
Clicks + BackfillClicks
Impressions + BackfillImpressions
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

Unix time of a query
The Unix time (also known as epoch time) of a query in microseconds since 1970-01-01 00:00:00 UTC. Use this value with the Keypart field value to uniquely identify a request.

EventKeyPart

STRING(9)

File types
ActiveViews + BackfillActiveViews
Activities
Clicks + BackfillClicks
Impressions + BackfillImpressions
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

Unique event identifier
Unique event identifier (hashed key). Each impression or other event from a single query has a unique value.

EventTimeUsec2

NUMBER

File types
ActiveViews + BackfillActiveViews
Activities
Clicks + BackfillClicks
Impressions + BackfillImpressions
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

Unix time of an event
The Unix time (also known as epoch time) of an impression or other event in microseconds since 1970-01-01 00:00:00 UTC.

ImpressionId

STRING

File types
Clicks + BackfillClicks
CodeServes + BackfillCodeServes
Impressions + BackfillImpressions

Unique impression ID (Beta)  
Every code serve receives a unique ImpressionId string value. Use this value, along with the KeyPart and TimeUsec2 values, to match records in the code serves and impressions files.
  • If the ImpressionId record appears in the NetworkCodeServes file, DFP responded with (or, "served") a creative.
  • If the ImpressionId record appears in the NetworkImpressions file, the returned creative was downloaded to be viewed by the user. Note that this ImpressionId record might appear in a different hour's file than the request and code serve.

All unfilled impressions are recorded in the NetworkRequests file.

EstimatedBackfillRevenue

DECIMAL

File types
ActiveViews + BackfillActiveViews *
Clicks + BackfillClicks *
Impressions + BackfillImpressions
RichMediaConversions + BackfillRichMediaConversions *

* AdSense only.

Estimated AdSense and Ad Exchange Revenue
Estimated backfill revenue per AdSense/Ad Exchange impression. This revenue calculation uses the publisher's network default currency. This field is reported as a net value.
  • The latest available exchange rate for the network's default currency is captured hourly and used for that hour's Data Transfer files.
  • Revenue from mobile ads served by AdWords may be 5% lower than what is shown in the DFP Query Tool, making this revenue value an approximation. Be aware that there may be other differences, such as filtration and rounding, that contribute to this estimation.
  • If this column is enabled, the values appear in the Backfill files. However, the column also appears in the corresponding network file, but those values will always report 0.
  • For Ad Exchange, all revenue is attributed to the Impressions file type. AdSense revenue is attributed across several file types.

GfpActivityAdEventTime

NUMBER

File types
Activities

Time of DFP activity event
Event time from attributed conversion ad event.

GfpActivityAdEventType

STRING(14)

File types
Activities

Type of DFP activity event
Indicates whether the conversion was post-impression or post-click.

GfpActivityId

NUMBER

File types
Activities

Unique DFP activity event ID
Identifies a unique advertiser-site conversion.

GfpActivityName

STRING(45)

File types
Activities

Name of DFP activity event
User-specified name associated with a DFP activity ID.

Ord

STRING

File types
Activities

Randomly-generated value from DFP Activity tags
The ord= parameter value from your DFP Activity tag.

Quantity

NUMBER

File types
Activities

Quantity value from DFP Activity tags
The qty= parameter value from your DFP Activity tag.

Revenue

STRING

File types
Activities

Cost value from DFP Activity tags
The cost= parameter value from your DFP Activity tag.

ActiveViewEligibleImpression

STRING

File types
Impressions + BackfillImpressions

Active View Eligible Impression
Indicates that the impression was eligible for Active View measurement.
  • Y = Impression was eligible
  • N = Impression was not eligible

MeasurableImpression

STRING

File types
ActiveViews + BackfillActiveViews

Active View Measurable Impression
Indicates whether the impression was measurable by Active View. Values include: Y = yes, N = no. The NetworkActiveViews file does not include impressions that were Measurable but not Viewable.
  • Y = Impression was measurable
  • N = Impression was not measurable

To find the total number of Measurable Impressions, subtract number of impressions where MeasurableImpressions=N in the NetworkActiveViews file from the number of impressions where ActiveViewEligibleImpression=Y in the NetworkImpressions file.

ViewableImpression

STRING

File types
ActiveViews + BackfillActiveViews

Active View Viewable Impression
Indicates whether the impression was viewable according to the IAB standard.
  • Y = Impression was measurable and viewable
  • NA = impression was not measurable

ActionDuration

NUMBER

File types
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

Action Duration
The duration of a conversion action in seconds.
Why ActionDuration might have a value when ActionCount is zero
After the ad is displayed, Studio code starts tracking interactions. The Studio code sends metrics to ad server at regular intervals. This is done in order to avoid the loss if user closes the browser.

For example, let's say that an expandable creative has a custom timer configured for the expandable state. When the user sees the the ad expansion for the first time, the Studio code records ActionCount as 1 and starts the custom timer, but this data is not yet reported to ad server. Around one second in expansion, metrics are sent back to the ad server (ActionCount = 1 and ActionDuration = 1), and then the metrics are reset to 0.

If the user continues to interact with the creative in an expanded state, metrics keep being sent to the ad server periodically. If they’re sent 10 seconds later, then ActionCount = 0 and ActionDuration = 10 is sent to the ad server.

ActionName

STRING

File types
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

Action Name
Name of the creative conversion. For example, "Play" or "Mute".

ActionType

STRING(8)

File types
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

Action Type
Type of the creative conversion. For example, "standard" or "custom".

ActionCount

NUMBER

File types
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

Action Count
The number of occurrences of a particular creative conversion.

GfpContentId

NUMBER

File types
ActiveViews + BackfillActiveViews
Clicks + BackfillClicks
Impressions + BackfillImpressions
VideoConversions + BackfillVideoConversions

Unique video content ID
The video content against which ads were served.

PodPosition

NUMBER

File types
ActiveViews + BackfillActiveViews
Clicks + BackfillClicks
Impressions + BackfillImpressions
VideoConversions + BackfillVideoConversions

Video pod position
The position of the ad within a video pod. For example, an ad in the second position displays "2". Value is 0 if position is unknown.

VideoFallbackPosition

NUMBER

File types
ActiveViews + BackfillActiveViews
Clicks + BackfillClicks
Impressions + BackfillImpressions
VideoConversions + BackfillVideoConversions

Video Fallback Position
The fallback position of the video ad.
  • 0 = Non-fallback
  • 1 = First fallback ad, 2 = second fallback ad, 3 = third fallback ad, etc.

VideoPosition

NUMBER

File types
ActiveViews + BackfillActiveViews
Clicks + BackfillClicks
Impressions + BackfillImpressions
VideoConversions + BackfillVideoConversions

Video Position
The position of the ad in the video stream.
  • 0 = Position unknown
  • 1 = Pre-roll
  • 3 = Post-roll
  • 4 = First Mid-roll, 5 = second Mid-roll, etc.

AudienceSegmentIds

STRING

File types
ActiveViews + BackfillActiveViews
Activities
Clicks + BackfillClicks
Impressions + BackfillImpressions
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

DFP Audience segment IDs
A list of DFP Audience segment ID values associated with a user separated by pipe delimiter (|), maximum of 35 segment IDs. Only segments that are targeted by at least one currently delivering DFP line item in the network will be shown.

Browser

STRING(39)

File types
ActiveViews + BackfillActiveViews
Activities
Clicks + BackfillClicks
Impressions + BackfillImpressions
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

Browser
The user's internet browser name, version, and subversion.

BrowserId

NUMBER

File types
ActiveViews + BackfillActiveViews
Activities
Clicks + BackfillClicks
Impressions + BackfillImpressions
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

Browser ID
A numeric ID assigned to the user's browser which can be matched using the API.

BandwidthGroupId

NUMBER(1)

File types
ActiveViews + BackfillActiveViews
Activities
Clicks + BackfillClicks
Impressions + BackfillImpressions
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

Bandwidth Group ID
A numeric ID assigned to the user's bandwidth, on a scale from 1 to 7, which can be matched using the API.

City

STRING(46)

File types
ActiveViews + BackfillActiveViews
Activities
Clicks + BackfillClicks
Impressions + BackfillImpressions
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

City
The name of the city associated with the IP address of the user.

CityId

NUMBER

File types
ActiveViews + BackfillActiveViews
Activities
Clicks + BackfillClicks
Impressions + BackfillImpressions
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

City ID
A numeric ID assigned to the user's city which can be matched using the API.

Country

STRING(44)

File types
ActiveViews + BackfillActiveViews
Activities
Clicks + BackfillClicks
Impressions + BackfillImpressions
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

Country
The name of the country associated with the IP address of the user. Note that some countries are not displayed in Data Transfer.

CountryId

NUMBER

File types
ActiveViews + BackfillActiveViews
Activities
Clicks + BackfillClicks
Impressions + BackfillImpressions
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

Country ID
A numeric ID assigned to a user's country which can be matched using the API.

DeviceCategory

STRING

File types
ActiveViews + BackfillActiveViews
Activities
Clicks + BackfillClicks
Impressions + BackfillImpressions
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

Device Category
A descriptive category of the user's device. Possible values are:
  • Desktop
  • Feature Phone
  • Smartphone
  • Tablet

Metro

STRING(55)

File types
ActiveViews + BackfillActiveViews
Activities
Clicks + BackfillClicks
Impressions + BackfillImpressions
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

Metro
The name of the metro associated with the IP address of the user.

MetroId

NUMBER

File types
ActiveViews + BackfillActiveViews
Activities
Clicks + BackfillClicks
Impressions + BackfillImpressions
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

Metro ID
A numeric ID assigned to the user's metro which can be matched using the API.

MobileCapability

STRING(256)

File types
ActiveViews + BackfillActiveViews
Activities
Clicks + BackfillClicks
Impressions + BackfillImpressions
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

Capability of the user's mobile device
If a user's mobile device can make calls, this displays "Phone calls". Otherwise, this value is null.

MobileCarrier

STRING(256)

File types
ActiveViews + BackfillActiveViews
Activities
Clicks + BackfillClicks
Impressions + BackfillImpressions
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

User's mobile carrier
The name of the user's mobile carrier.

MobileDevice

STRING(256)

File types
ActiveViews + BackfillActiveViews
Activities
Clicks + BackfillClicks
Impressions + BackfillImpressions
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

User's mobile device name
The name of the user's mobile device.

OS

STRING(33)

File types
ActiveViews + BackfillActiveViews
Activities
Clicks + BackfillClicks
Impressions + BackfillImpressions
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

Device operating system name
The name of the operating system installed on the user's device.

OSId

NUMBER

File types
ActiveViews + BackfillActiveViews
Activities
Clicks + BackfillClicks
Impressions + BackfillImpressions
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

Device operating system ID
A numeric ID assigned to the operating system installed on the user's device which can be matched using the API.

OSVersion

STRING(256)

File types
ActiveViews + BackfillActiveViews
Activities
Clicks + BackfillClicks
Impressions + BackfillImpressions
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

Device operating system version
The version of the operating system installed on the user's mobile device.

PostalCode

STRING(5)

File types
ActiveViews + BackfillActiveViews
Activities
Clicks + BackfillClicks
Impressions + BackfillImpressions
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

Postal Code
The postal code associated with the user's IP address. This information is only available for user's in the United States (US) and Canada.

PostalCodeId

NUMBER

File types
ActiveViews + BackfillActiveViews
Activities
Clicks + BackfillClicks
Impressions + BackfillImpressions
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

Postal code ID
A numeric ID assigned to the user's postal code which can be matched using the API.

PublisherProvidedID

STRING(64)

File types
ActiveViews + BackfillActiveViews
Activities
Clicks + BackfillClicks
Impressions + BackfillImpressions
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

Publisher Provided ID
The Publisher Provided ID (PPID), encrypted.

Region

STRING (47)

File types
ActiveViews + BackfillActiveViews
Activities
Clicks + BackfillClicks
Impressions + BackfillImpressions
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

Region
The name of the region associated with the IP address of the user.

RegionId

NUMBER

File types
ActiveViews + BackfillActiveViews
Activities
Clicks + BackfillClicks
Impressions + BackfillImpressions
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

Region ID
A numeric ID assigned to the user's region which can be matched using the API.

UserId

STRING(64)

File types
ActiveViews + BackfillActiveViews
Activities
Clicks + BackfillClicks
Impressions + BackfillImpressions
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

Encrypted DoubleClick cookie ID
The DoubleClick cookie ID associated with the user, encrypted. The expected value is 22 characters in length, but up to 64 characters can be displayed.
  • For iOS mobile apps, this is an encrypted version of Apple's Identifier for Advertising (IDFA).
  • For Android apps, this is an encrypted version of the Android Advertising Id (AdId).
  • If a user's browser does not accept cookies, this field is blank.

Bandwidth

STRING(17)

File types
ActiveViews + BackfillActiveViews
Activities
Clicks + BackfillClicks
Impressions + BackfillImpressions
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

Bandwidth
Name of the user's bandwidth type. For example, "dsl" or "cable".