Data Transfer fields

Data Transfer files contain information about impressions, clicks, and other events transmitted through Google Ad Manager. 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 Ad Manager 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
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
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
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

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

LineItemId

NUMBER (xsd:long)

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

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

CreativeId

NUMBER (xsd:long)

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

Creative ID
The numeric ID for the delivered Ad Manager creative.

CreativeSize

STRING(9)

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

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

CreativeSizeDelivered

STRING(9)

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

Creative Size (delivered)(Beta)
The actual size of the creative served from Ad Manager or Ad Exchange, which also matches the creative size reported in Ad Exchange. The size is displayed in the format "widthxheight" without spaces (for example, 300x250).

CreativeVersion

NUMBER

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

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

CustomTargeting

STRING  More details

File types
ActiveViews + BackfillActiveViews
Activities
Clicks + BackfillClicks
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

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

Key-values reporting differs slightly between Ad Manager reports and data that's delivered through Data Transfer. Ad Manager reports only include key-values where both the key and the value are defined in Ad Manager, 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 Ad Manager reports.

Domain

STRING

File types
ActiveViews + BackfillActiveViews
Activities
Clicks + BackfillClicks
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

Domain
The user domain that triggered the event.

EstimatedBackfillRevenue

DECIMAL

File types
ActiveViews + BackfillActiveViews *
Clicks + BackfillClicks *
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
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.

If you use Exchange Bidding, this value also includes estimated revenue for third-party exchanges.

  • 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 Ad Manager 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.

IsCompanion

BOOLEAN

File types
ActiveViews + BackfillActiveViews
Activities
Clicks + BackfillClicks
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
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
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
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
BackfillBids
Clicks + BackfillClicks
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
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 or bid auction.

OrderId

NUMBER (xsd:long)

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

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

Product

STRING

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

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

RequestedAdUnitSizes

STRING

File types
ActiveViews + BackfillActiveViews
Activities
Clicks + BackfillClicks
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

Inventory sizes included in your request to Ad Manager
The inventory size included in your tag or request to Ad Manager. 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
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
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
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

Targeted key-values
The key-values in your request to Ad Manager that matched Ad Manager 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
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
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
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

This field is deprecated.
Use TimeUsec2, instead.

TimeUsec2

NUMBER (xsd:long)

File types
ActiveViews + BackfillActiveViews
Activities
BackfillBids
Clicks + BackfillClicks
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
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 or bid auction.

EventKeyPart

STRING(9)

File types
ActiveViews + BackfillActiveViews
Activities
Clicks + BackfillClicks
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
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 (xsd:long)

File types
ActiveViews + BackfillActiveViews
Activities
Clicks + BackfillClicks
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
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
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, Ad Manager 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.

Advertiser

STRING

File types
BackfillActiveViews
BackfillClicks
BackfillRequests
BackfillImpressions
BackfillCodeServes
BackfillRichMediaConversions
BackfillVideoConversions

Advertiser
Name of the advertiser that won the auction.

AdxAccountId

NUMBER

File types
BackfillActiveViews
BackfillClicks
BackfillRequests
BackfillImpressions
BackfillCodeServes
BackfillRichMediaConversions
BackfillVideoConversionss

Ad Exchange account ID
The ID of the Ad Exchange (AdX) account that served the ad query.

Anonymous

BOOLEAN

File types
BackfillActiveViews
BackfillClicks
BackfillRequests
BackfillImpressions
BackfillCodeServes
BackfillRichMediaConversions
BackfillVideoConversions

Anonymous branding
Whether this was an anonymous impression. "True" if anonymous, "false" if semi-transparent or branded. This field contains null values if you're not an Ad Exchange (AdX) publisher.

Buyer

STRING

File types
BackfillActiveViews
BackfillClicks
BackfillRequests
BackfillImpressions
BackfillCodeServes
BackfillRichMediaConversions
BackfillVideoConversions

Buyer
Name of the buyer that won the Ad Exchange (AdX) auction. For video pods, this is a list of winning buyers, separated by the pipe (|) character.

DealId

STRING

File types
BackfillActiveViews
BackfillClicks
BackfillRequests
BackfillImpressions
BackfillCodeServes
BackfillRichMediaConversions
BackfillVideoConversions

Ad Exchange deal ID
ID of the Ad Exchange (AdX) deal that applied for this impression. Blank if no deal was defined.

This field only displays data for your primary Ad Exchange account.

DealType

STRING

File types
BackfillActiveViews
BackfillClicks
BackfillRequests
BackfillImpressions
BackfillCodeServes
BackfillRichMediaConversions
BackfillVideoConversions

Deal type
Type of Ad Exchange or Exchange Bidding deal. Possible values:
  • "Private auction"
  • "Preferred deal"
  • "Programmatic Guaranteed"
  • "EB auction package"
  • Blank if no deal was defined 

This field only displays data for your primary Ad Exchange account.

SellerReservePrice

DOUBLE

File types
BackfillActiveViews
BackfillClicks
BackfillRequests
BackfillImpressions
BackfillCodeServes
BackfillRichMediaConversions
BackfillVideoConversions

Seller Reserve Price
Bid floor set by the seller publisher, after the revenue share. For example, "1.58" or "3.216667".

This field only displays data for your primary Ad Exchange (AdX) account.

YieldGroupNames

STRING

File types
BackfillActiveViews
BackfillClicks
BackfillRequests
BackfillImpressions
BackfillCodeServes
BackfillRichMediaConversions
BackfillVideoConversions

DFP yield group names
In Exchange Bidding and mediation for mobile apps, where Ad Exchange doesn't win, this field displays the yield group name of the winner. If Ad Exchange wins, this field displays all competing yield group names, separated by pipe (|) characters.

YieldGroupCompanyId

NUMBER (xsd:long)

File types
BackfillActiveViews
BackfillClicks
BackfillRequests
BackfillImpressions
BackfillCodeServes
BackfillRichMediaConversions
BackfillVideoConversions

DFP yield partner ID
ID of the yield partner in a yield group that won the Exchange Bidding or mediation for mobile apps auction. If Ad Exchange wins, this field is blank.

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 an Ad Manager activity ID.

Ord

STRING

File types
Activities

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

Quantity

NUMBER

File types
Activities

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

Revenue

STRING

File types
Activities

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

ActiveViewEligibleImpression

STRING

File types
Impressions + BackfillImpressions
CodeServes + BackfillCodeServes

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
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
VideoConversions + BackfillVideoConversions

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

PodPosition

NUMBER

File types
ActiveViews + BackfillActiveViews
Clicks + BackfillClicks
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
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
Codeserves + BackfillCodeServes
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
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
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
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

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

Browser

STRING(39)

File types
ActiveViews + BackfillActiveViews
Activities
Clicks + BackfillClicks
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

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

BrowserId

NUMBER

File types
ActiveViews + BackfillActiveViews
Activities
Clicks + BackfillClicks
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
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
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
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
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
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
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
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
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
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
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
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
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
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
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
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
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
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
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
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
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
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
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
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
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
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
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
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
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
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
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
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
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
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
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

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

Region

STRING (47)

File types
ActiveViews + BackfillActiveViews
Activities
Clicks + BackfillClicks
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
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
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
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
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
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
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

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

MobileAppId

STRING

File types
ActiveViews + BackfillActiveViews
Activities
Clicks + BackfillClicks
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

Mobile app ID
Mobile application ID that requested the ad.
  • For Android, this is the package name.
  • For iOS, this is an integer.

RequestLanguage

STRING

File types
ActiveViews + BackfillActiveViews
Activities
Clicks + BackfillClicks
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

Requested language
Language code association with the ad request. A two-letter ISO 639-1 Alpha 2 language code optionally followed by a hyphen and a two-letter ISO 3166-1 Alpha 2 lowercase country code. For example, "pt" or "pt-br".

BandwidthId

NUMBER (xsd:long)

File types
ActiveViews + BackfillActiveViews
Activities
Clicks + BackfillClicks
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

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

AuctionType

NUMBER

File types
BackfillBids

Auction type
The value 1 indicates an Exchange Bidding auction.

BidAdvertiser

STRING

File types
BackfillBids

Bid advertiser
Name of the advertiser.

BidBidder

STRING

File types
BackfillBids

Bid bidder
Name of the bidder's account.

BidBuyer

STRING

File types
BackfillBids

Bid buyer
Name of the buyer's network.

BidRejectionReason

STRING

File types
BackfillBids

Bid rejection reason
Reason the bid lost or did not participate in the auction.
  • "Floor" indicates that the bid's CPM was below the seller's reserve
  • "Outbid" indicates that the bid lost to another candidate.
  • "Other" indicates that the bid lost for another reason, such as URL filtering.
  • "(Winner)" indicates that the bid was not rejected for any reason.

BidPrice

NUMBER

File types
BackfillBids

Bid price
Offered price for this bid after revenue sharing calculations, displayed in the Ad Manager network's default currency.

BidDealId

STRING

File types
BackfillBids

Bid deal ID
ID of the deal that applied for this impression. Blank if no deal was applied.

BidDealType

STRING

File types
BackfillBids

Bid deal type
Type of deal. "Private auction", "Preferred deal", "Programmatic guaranteed", or blank if no deal was applied.

BidYieldGroupNames

STRING

File types
BackfillBids

Bid yield group names
Names of the Ad Manager Yield groups that matched the request. Blank if not applicable.

BidYieldGroupCompanyId

STRING

File types
BackfillBids

Bid yield group company ID
ID of the yield partner in an Ad Manager yield group that submitted the bid. Blank for Ad Exchange or if not applicable.