Explore 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 .
Numeric IDs are used for line items, creatives, and other Ad Manager objects. Use match tables to correlate objects names with ID values.
Note that not all file types listed for a field show significant results. When files don't apply to a field, they return "Null," "0," or "False."
Refer to the Ad Manager API documentation for more details about each field.
ImpressionId
STRING
File types
ActiveViews + BackfillActiveViews
Clicks + BackfillClicks
Impressions + BackfillImpressions
CodeServes + BackfillCodeServes
Every code serve receives a unique
ImpressionId
string value. Use this value, along with the KeyPart
values, to match records in the code serves and impressions files. - If the
ImpressionId
record appears in theNetworkCodeServes
file, Ad Manager responded with (or, "served") a creative. - If the
ImpressionId
record appears in theNetworkImpressions
file, the returned creative was downloaded to be viewed by the user. Note that thisImpressionId
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
BackfillImpressions
BackfillCodeServes
BackfillRichMediaConversions
BackfillVideoConversions
Name of the advertiser that won the auction.
AdxAccountId
NUMBER
File types
BackfillActiveViews
BackfillBids
BackfillClicks
BackfillImpressions
BackfillCodeServes
BackfillRichMediaConversions
BackfillVideoConversionss
The ID of the Ad Exchange (AdX) account that served the ad query.
Anonymous
Deprecated
BOOLEAN
File types
BackfillActiveViews
BackfillClicks
BackfillRequests
BackfillImpressions
BackfillCodeServes
BackfillRichMediaConversions
BackfillVideoConversions
The concept of an anonymous impression no longer exists in Ad Manager.
BackfillKeyPart
STRING(20)
File types
ActiveViews
Clicks
Requests
Impressions
CodeServes
RichMediaConversions
VideoConversions
Unique query identifier (hashed key). This field can be used to uniquely identify a query or bid auction.
This field can be used to join Network events with NetworkBackfill events.
Buyer
STRING
File types
BackfillActiveViews
BackfillClicks
BackfillImpressions
BackfillCodeServes
BackfillRichMediaConversions
BackfillVideoConversions
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.
CustomSpotSubpodIds
Integer
File types
ActiveViews
Clicks
Requests
Impressions
CodeServes
VideoConversions
The ID associated with the custom spot that is used in the ad break template.
DealId
STRING
File types
ActiveViews + BackfillActiveViews
Clicks + BackfillClicks
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
ID of the Ad Exchange (AdX) or Ad Manager deal that applied for this impression. Blank if no deal applied.
In backfill files, this field only displays data for your primary Ad Exchange account.
DealType
STRING
File types
ActiveViews + BackfillActiveViews
Clicks + BackfillClicks
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
BackfillBidsJoinable
Type of deal (see also " DealId "). Possible values:
- "Private auction"
- "Preferred deal"
- "Programmatic Guaranteed"
- "EB auction package"
- Blank if no deal applied
In backfill files, this field only displays data for your primary Ad Exchange account. Reservation files only contain “Programmatic Guaranteed” and “Preferred deal” types.
EventKeyPart
STRING(20)
File types
ActiveViews + BackfillActiveViews
Clicks + BackfillClicks
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
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
Clicks + BackfillClicks
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
The Unix time (also known as epoch time) of an impression or other event in microseconds since 1970-01-01 00:00:00 UTC.
Indicates whether a request is associated with at least one code serve. Values are
TRUE
(at least one code serve) or FALSE
(none).The max number of ads served in an optimized pod per the ad request.
OptimizationType
STRING
File types
ActiveViews + BackfillActiveViews
BackfillBids
BackfillBidsJoinable
Clicks + BackfillClicks
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
The type of optimization applied when filling the request. Possible values:
- "Optimized Competition"
- "First Look"
- "Target CPM"
- Blank if no optimization type
The length in seconds of the total filled time in an optimized pod.
The length in seconds where an ad was not served in an optimized pod.
OrderId
INTEGER
File types
ActiveViews + BackfillActiveViews
BackfillBids
Clicks + BackfillClicks
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
BackfillBidsJoinable
The numeric ID for the Ad Manager order that contained the delivered line item and creative.
ProcessingDateAndHour
STRING(11)
File types
ActiveViews + BackfillActiveViews
BackfillBids
Clicks + BackfillClicks
MinimumBidToWin
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
BackfillBidsJoinable
The label of the data processing partition. Data Transfer publishes events 24 times per day, so each partition is uniquely labelled with the date and hour when the processing of the partition started. This label always matches date and hour in the filename suffix. Format: [YYYYMMDD]_[HH]. Timezone: PST. Hour is zero indexed.
Product
STRING
File types
ActiveViews + BackfillActiveViews
Clicks + BackfillClicks
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
Product nameThe product from which the event originated.
Possible values in Network files:
- Ad Server
Possible values in NetworkBackfill files:
- Ad Exchange
- AdSense
- Exchange Bidding
- First Look
- Header Bidding
- Mediation
- Protected Audience Seller
- SDK Bidding
Note that "Exchange Bidding" in Data Transfer equals "Open Bidding" in Reporting.
RefererURL
STRING
File types
ActiveViews + BackfillActiveViews
Clicks + BackfillClicks
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
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.
RequestedAdUnitSizes
STRING
File types
ActiveViews + BackfillActiveViews
Clicks + BackfillClicks
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
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".
SellerReservePrice
DOUBLE
File types
BackfillActiveViews
BackfillClicks
BackfillImpressions
BackfillCodeServes
BackfillRichMediaConversions
BackfillVideoConversions
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. This field will display a zero (0) for any non-guaranteed line items .
ServingRestriction
STRING
File types
ActiveViews + BackfillActiveViews
Clicks + BackfillClicks
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
Shows performance distributed by serving restriction.
- Limited ads: Traffic where only limited ads can serve. This matches ad calls that include either the parameter ltd=1, or a TC string which does not signal the purpose 1 consented while signaling legal bases for the purposes 2, 7, 9, and 10.
- Restricted data processing (RDP): Includes traffic where the publisher requested restricted data processing using the tagging parameter or the now-deprecated network control , or traffic where GPP strings triggered restricted data processing .
- Non-personalized ads (NPA): Includes traffic where the publisher requested non-personalized ads using the tagging parameter or the network control .
- Basic ads: Traffic where only IAB TCF v2.0 basic ads are eligible to serve. This matches users whose provided TC string includes consent for purpose 1 and legal bases for purposes 2, 7, 9, and 10, but no consent for purposes 3 or 4.
- Personalization disabled: Traffic where personalization was disabled by iOS users who opted in to Limited Ad Tracking, Android users who opted out of ad personalization, the absence of an available ID for personalization, or any other case where personalization wasn't feasible.
- No restriction: Traffic without any of the restrictions listed above.
TargetedCustomCriteria
STRING(512)
File types
ActiveViews + BackfillActiveViews
Clicks + BackfillClicks
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
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 displays keys that were negatively targeted by the line item. This value is truncated to 512 characters.
When multiple values in an OR relationship are matched in the same key, only the first one (alphabetically) displays. If multiple values were in an AND relationship, all pairs used to serve the line item appear in this field.
Due to YouTube policy, certain demographic data will be removed for YouTube inventory.
Time
STRING(19)
File types
ActiveViews + BackfillActiveViews
BackfillBids
Clicks + BackfillClicks
MinimumBidToWin
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
BackfillBidsJoinable
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
Clicks + BackfillClicks
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
Use
TimeUsec2
, instead.
TimeUsec2
NUMBER (xsd:long)
File types
ActiveViews + BackfillActiveViews
BackfillBids
BackfillBidsJoinable
Clicks + BackfillClicks
MinimumBidToWin
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
The Unix time (also known as epoch time) of a query in microseconds since 1970-01-01 00:00:00 UTC.
YieldGroupCompanyId
NUMBER (xsd:long)
File types
BackfillActiveViews
BackfillClicks
BackfillImpressions
BackfillCodeServes
BackfillRichMediaConversions
BackfillVideoConversions
ID of the yield partner in a yield group that won the Open Bidding or mediation for mobile apps auction. If Ad Exchange wins, this field is blank.
YieldGroupNames
STRING
File types
BackfillActiveViews
BackfillClicks
BackfillImpressions
BackfillCodeServes
BackfillRichMediaConversions
BackfillVideoConversions
In Open 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.
YieldPartnerTag
STRING
File types
ActiveViews + BackfillActiveViews
Clicks + BackfillClicks
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
Reports the Yield Partner Tag when mediation is the ad source. Includes the name of a yield partner in a yield group, the name of the yield group, and the "Ad source ID" value. Example: "MyYieldGroup-MyYieldPartner ID: 123456789." Only applies to Mediation , not Open Bidding or Ad Exchange. Field shows empty string (" ") when not applicable.
AdUnitId
INTEGER
File types
ActiveViews + BackfillActiveViews
BackfillBids
BackfillBidsJoinable
Clicks + BackfillClicks
MinimumBidToWin
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
The ID for the inventory ad unit where the creative delivered. Unapproved ad units do not have an
AdUnitId
, and do not appear here.
AdvertiserId
INTEGER
File types
ActiveViews + BackfillActiveViews
Clicks + BackfillClicks
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
The numeric ID for the Ad Manager advertiser company associated with the creative delivered.
CreativeId
INTEGER
File types
ActiveViews + BackfillActiveViews
Clicks + BackfillClicks
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
The numeric ID for the delivered Ad Manager creative.
CreativeSize
STRING(9)
File types
ActiveViews + BackfillActiveViews
Clicks + BackfillClicks
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
The size in pixels (width x height) of the delivered Ad Manager creative. For example, "300x250".
CreativeSizeDelivered
STRING(9)
File types
ActiveViews + BackfillActiveViews
Clicks + BackfillClicks
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
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
INTEGER
File types
ActiveViews + BackfillActiveViews
Clicks + BackfillClicks
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
A numeric version value associated with the delivered Ad Manager creative.
CustomTargeting
STRING More details
File types
ActiveViews + BackfillActiveViews
Clicks + BackfillClicks
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
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.
Due to YouTube policy, certain demographic data will be removed for YouTube inventory.
EstimatedBackfillRevenue
DECIMAL
File types
ActiveViews + BackfillActiveViews *
Clicks + BackfillClicks *
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions *
VideoConversions + BackfillVideoConversions
* AdSense only
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 Open 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 reports, 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.
- Reports Yield group estimated revenue when mediation is the ad source.
IsCompanion
BOOLEAN
File types
ActiveViews + BackfillActiveViews
Clicks + BackfillClicks
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
Indicates that the event was logged by a companion creative . Values are
TRUE
or FALSE
.
IsInterstitial
BOOLEAN
File types
ActiveViews + BackfillActiveViews
Clicks + BackfillClicks
MinimumBidToWin
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
Indicates if the event was logged by an out-of-page creative , also known as an "interstitial." Values are
TRUE
or FALSE
.
KeyPart
STRING(20)
File types
ActiveViews + BackfillActiveViews
BackfillBids
BackfillBidsJoinable
Clicks + BackfillClicks
MinimumBidToWin
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
Unique query identifier (hashed key). This field can be used to uniquely identify a query or bid auction.
The KeyPart
used in the Bids file to identify a unique bid auction doesn't match the KeyPart
in the other files, where it identifies a unique query.
NativeFormat
STRING
File types
ActiveViews + BackfillActiveViews
Clicks + BackfillClicks
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
Native ad formats define the variables that determine the content of your ads. For non-Native ads or ads with no Native format associated with it, this will be an empty string.
NativeStyle
STRING
File types
ActiveViews + BackfillActiveViews
Clicks + BackfillClicks
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
Native styles determine how your native creatives look for a segment of inventory. For non-Native ads or ads with no Native style associated with it, this will be an empty string.
LineItemId
INTEGER
File types
ActiveViews + BackfillActiveViews
BackfillBids
Clicks + BackfillClicks
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
The numeric ID for the delivered Ad Manager line item.
Event time from attributed conversion ad event.
Indicates whether the conversion was post-impression or post-click.
Identifies a unique advertiser-site conversion.
User-specified name associated with an Ad Manager activity ID.
The ord= parameter value from your Ad Manager Activity tag .
The qty= parameter value from your Ad Manager Activity tag .
The cost= parameter value from your Ad Manager Activity tag .
ActiveViewEligibleImpression Deprecated
STRING
File types
Impressions + BackfillImpressions
CodeServes + BackfillCodeServes
This field is deprecated. Indicates that the impression was eligible for Active View measurement.
-
Y
= Impression was eligible -
N
= Impression was not eligible
This field is deprecated. 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.
ActiveViewEligibleCount
NUMBER
File types
Impressions + BackfillImpressions
ActiveViews + BackfillActiveViews
Indicates that the impression was eligible for Active View measurement.
While this field is available in the Active View file, it only has a value of zero from August 30, 2022 forward. Since that date, eligibility can be found by looking at this field only in the Impression file.
Impressions:
- 1 = Impression was eligible
- 0 = Impression was not eligible
To find the total number of Active View Eligible impressions from August 30, 2022 forward, use the sample queries .
ActiveViewMeasurableCount
NUMBER
File types
Impressions + BackfillImpressions
ActiveViews + BackfillActiveViews
Indicates whether the impression was measurable by Active View.
The values differ slightly between Impressions and Active View. Use both Impression and Active View values to determine measurability.
Impressions
Display
- 1 = Impression is initially determined to be measurable
- 0 = Impression is not measurable
Video
- 0 = Impression is initially determined not to be measurable
Active View
Display
- -1 = Impression is determined not to be measurable
- 0 = No change in the measurability of the impression
Video
- 1 = Impression is determined to be measurable
- 0 = No change in the measurability of the impression
To find the total number of Active View Measurable Count, use the sample queries .
Indicates whether the impression was viewable according to the IAB standard.
-
1 = Impression was measurable and viewable
-
0 = Impression was not viewable
To find the total number of Active View Viewable Count, use the sample queries .
ActionDuration
FLOAT/DOUBLE
File types
ActiveViews + BackfillActiveViews
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
The duration of a conversion action in seconds.
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
ActiveViews + BackfillActiveViews
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
Name of the creative conversion. For example, "Play" or "Mute".
ActionType
STRING(8)
File types
ActiveViews + BackfillActiveViews
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
Type of the creative conversion. For example, "standard" or "custom".
ActionCount
NUMBER
File types
ActiveViews + BackfillActiveViews
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
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
The video content against which ads were served.
PodPosition
NUMBER
File types
ActiveViews + BackfillActiveViews
Clicks + BackfillClicks
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
VideoConversions + BackfillVideoConversions
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. Value is -1 if no reservation ads are eligible and programatic ads are unfilled.
VideoFallbackPosition
NUMBER
File types
ActiveViews + BackfillActiveViews
Clicks + BackfillClicks
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
VideoConversions + BackfillVideoConversions
The fallback position of the video ad or mobile ad.
- 0 = Non-fallback
- 1 = First fallback ad, 2 = second fallback ad, 3 = third fallback ad and so forth.
VideoPosition
NUMBER
File types
ActiveViews + BackfillActiveViews
Clicks + BackfillClicks
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
VideoConversions + BackfillVideoConversions
The position of the ad in the video stream.
- 0 = Position unknown
- 1 = Pre-roll
- 2 = Any mid-roll (Deprecated)
- 3 = Post-roll
- 4 = First mid-roll, 5 = second mid-roll, etc.
Indicates that an ad request was for a video fallback ad or mobile fallback ad (also referred to as "waterfall" ads). Values are
TRUE
or FALSE
.
CmsMetadata
STRING
File types
ActiveViews + BackfillActiveViews
Clicks + BackfillClicks
Requests + BackfillRequests
Impressions + BackfillImpressions
CodeServes + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions *
VideoConversions + BackfillVideoConversions
* Always null
CMS metadataA list of key-value pairs describing content metadata tied to the event.
Example: genre=comedy|duration=over_60_second|duration=under_2_min
AudienceSegmentIds
STRING
File types
ActiveViews + BackfillActiveViews
Clicks + BackfillClicks
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
A list of Audience Solutions segment ID values associated with a user separated by pipe delimiter (
|
). - Requests/Unfilled impressions:Audience segments in use.
- Other files/events:Only segments that were used in targeting this line item. These are segments that have been included or excluded in the targeting.
This field matches the "Audience segment (billable)" dimension in reporting. To understand which segment will be logged for each data transfer line, review How audience segment billing works .
Due to YouTube policy, this field is redacted for YouTube inventory.
This field may also be redacted on ad requests subject to a privacy restriction, such as limited ads or non-personalized ads.
Browser
STRING(39)
File types
ActiveViews + BackfillActiveViews
Clicks + BackfillClicks
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
The user's internet browser name, version, and subversion.
"In-app browser" is a browser embedded within an app.
Due to YouTube policy, this field is redacted for YouTube inventory.
BrowserId
NUMBER
File types
ActiveViews + BackfillActiveViews
Clicks + BackfillClicks
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
A numeric ID assigned to the user's browser which can be matched using the API .
Due to YouTube policy, this field is redacted for YouTube inventory.
BandwidthGroupId
NUMBER(1)
File types
ActiveViews + BackfillActiveViews
Clicks + BackfillClicks
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
A numeric ID assigned to the user's bandwidth, on a scale from 1 to 10, which can be matched using the API .
City
STRING(46)
File types
ActiveViews + BackfillActiveViews
Clicks + BackfillClicks
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
The name of the city associated with the IP address of the user.
Due to YouTube policy, this field is redacted for YouTube inventory.
CityId
NUMBER
File types
ActiveViews + BackfillActiveViews
Clicks + BackfillClicks
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
A numeric ID assigned to the user's city which can be matched using the API .
Due to YouTube policy, this field is redacted for YouTube inventory.
Country
STRING(44)
File types
ActiveViews + BackfillActiveViews
BackfillBids
Clicks + BackfillClicks
MinimumBidToWin
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
BackfillBidsJoinable
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
BackfillBids
BackfillBidsJoinable
Clicks + BackfillClicks
MinimumBidToWin
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
DeviceCategory
STRING
File types
ActiveViews + BackfillActiveViews
Clicks + BackfillClicks
MinimumBidToWin
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
A descriptive category of the user's device. Possible values are:
- Connected TV
- Desktop
- Feature phone
- Set-top box
- Smartphone
- Tablet
Metro
STRING(55)
File types
ActiveViews + BackfillActiveViews
Clicks + BackfillClicks
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
The name of the metro associated with the IP address of the user.
Due to YouTube policy, this field is redacted for YouTube inventory.
MetroId
NUMBER
File types
ActiveViews + BackfillActiveViews
Clicks + BackfillClicks
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
A numeric ID assigned to the user's metro which can be matched using the API .
Due to YouTube policy, this field is redacted for YouTube inventory.
MobileCapability
STRING(256)
File types
ActiveViews + BackfillActiveViews
Clicks + BackfillClicks
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
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
Clicks + BackfillClicks
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
The name of the user's mobile carrier.
MobileDevice
STRING(256)
File types
ActiveViews + BackfillActiveViews
Clicks + BackfillClicks
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
The name of the user's mobile device.
OS
STRING(33)
File types
ActiveViews + BackfillActiveViews
Clicks + BackfillClicks
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
The name of the operating system installed on the user's device.
OSId
NUMBER
File types
ActiveViews + BackfillActiveViews
Clicks + BackfillClicks
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
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
Clicks + BackfillClicks
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
The version of the operating system installed on the user's mobile device.
Due to YouTube policy, this field is redacted for YouTube inventory.
PostalCode
STRING(5)
File types
ActiveViews + BackfillActiveViews
Clicks + BackfillClicks
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
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.
Due to YouTube policy, this field is redacted for YouTube inventory.
PostalCodeId
NUMBER
File types
ActiveViews + BackfillActiveViews
Clicks + BackfillClicks
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
A numeric ID assigned to the user's postal code which can be matched using the API .
Due to YouTube policy, this field is redacted for YouTube inventory.
PublisherProvidedID
STRING(64)
File types
ActiveViews + BackfillActiveViews
Clicks + BackfillClicks
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
The Publisher Provided ID (PPID), encrypted.
Due to YouTube policy, this field is redacted for YouTube inventory.
Note that this field should not be used to determine PPID presence, such as, querying for PublisherProvidedID IS NOT NULL AND PublisherProvidedID !=""
. Please rely on the PpidPresence
field for this information.
If this field is populated, OriginalPublisherProvidedID
will be empty.
Learn more about the limitations of OriginalPublisherProvidedID
, UserId
, and
PublisherProvidedID
.
PublisherProvidedSignals
STRING
File types
ActiveViews + BackfillActiveViews
Clicks + BackfillClicks
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
The IAB and Google video defined taxonomies associated with ad requests. There can be multiple signals per row that are represented in the following format:
[Taxonomy];[External category ID];[Data Provider name]
Taxonomy and external category ID are always present, and data provider name is used if present. Individual values in a signal are separated by a semi-colon ( ; ).
If there are multiple signals, each signal is separated by a vertical pipe ( | ).
[Taxonomy 1];[External category ID 1];[Data Provider name 1] | [Taxonomy 2];[External category ID 2];[Data Provider name 2]
.
PublisherProvidedSignalsDelivered
STRING
File types
ActiveViews + BackfillActiveViews
Clicks + BackfillClicks
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
The IAB and Google video defined taxonomies associated with ad impressions. There can be multiple signals per row that are represented in the following format:
[Taxonomy];[External category ID]
Taxonomy and external category ID are always present. Individual values in a signal are separated by a semi-colon ( ; ).
If there are multiple signals, each signal is separated by a vertical pipe ( | ).
[Taxonomy 1];[External category ID 1] | [Taxonomy 2];[External category ID 2]
.
Region
STRING (47)
File types
ActiveViews + BackfillActiveViews
Clicks + BackfillClicks
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
The name of the region associated with the IP address of the user.
UserId
STRING(64)
File types
ActiveViews + BackfillActiveViews
Clicks + BackfillClicks
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
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.
Due to YouTube policy, this field is redacted for YouTube inventory.
This field may also be redacted on ad requests subject to a privacy restriction, such as limited ads or non-personalized ads.
If this field is populated, OriginalPublisherProvidedID
will be empty.
Learn more about the limitations of OriginalPublisherProvidedID
, UserId
, and
PublisherProvidedID
.
Bandwidth
STRING(17)
File types
ActiveViews + BackfillActiveViews
Clicks + BackfillClicks
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
Name of the user's bandwidth type. For example, "dsl" or "cable".
MobileAppId
STRING
File types
ActiveViews + BackfillActiveViews
BackfillBids
Clicks + BackfillClicks
MinimumBidToWin
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
BackfillBidsJoinable
* Always null
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
Clicks + BackfillClicks
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
Language code associated with the ad request. A two-letter ISO 639-1 Alpha 2 language code. May be optionally followed by a hyphen and a two-letter ISO 3166-1 Alpha 2 lowercase country code. For example, "pt" or "pt-br".
In most cases, the RequestLanguage
reported is the browser language. However, if the browser language ("Accept-Language" HTTP header) isn't available in the request, then the device or region language may be reported instead.
BandwidthId
NUMBER (xsd:long)
File types
ActiveViews + BackfillActiveViews
Clicks + BackfillClicks
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
A numeric ID assigned to the user's bandwidth, on a scale from 1 to 7, which can be matched using the API .
The device on which the event took place. Grouped by type of device. Possible values:
- Mobile
- Desktop
- Other
The group the operating system installed on the user's device belongs to. Possible values:
- Apple iOS
- Android
- Other
UserIdentifierStatus
STRING
File types
ActiveViews + BackfillActiveViews
Clicks + BackfillClicks
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
Indicates whether a valid user advertising identifier (a third-party cookie or device ID) was present on a given ad request. Possible values include:
- Active: A user identifier was present and active.
- Restricted: A user identifier was present, but its usage was restricted by how cookies may be used. For example, personalization is not allowed.
- Missing: A user identifier wasn't present.
PpidPresence
STRING
File types
ActiveViews + BackfillActiveViews
Clicks + BackfillClicks
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
Indicates whether a valid PPID (Publisher provided identifier) was present on a given ad request. Covers both reservation and programmatic traffic.
Note that PPID Presence corresponds to the existence of a value in the PublisherProvidedId
field.
Possible values include:
- Present: A valid PPID was present
- Missing: A PPID was not present or had an invalid form
- Redacted: PPID was valid, but appears as null in the Data Transfer files
AttConsentStatus
STRING
File types
ActiveViews + BackfillActiveViews
Clicks + BackfillClicks
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
Understand user consent status in relation to Apple’s App Tracking Transparency (ATT) setting and its impact on monetization. Values include:
- Authorized
- Denied
- Restricted
- Not determined
- (Not applicable)
ProtectedAudienceAPIDelivery
BOOLEAN
File types
Impressions + BackfillImpressions
Clicks + BackfillClicks
VideoConversions + BackfillVideoConversions
RichMediaConversions + BackfillRichMediaConversions
ActiveViews + BackfillActiveViews
Codeserves + BackfillCodeServes
Indicates whether an event is delivered by the Protected Audience API or not.
Note: When this field is included in a data transfer file, advertiser information is redacted for impressions delivered via the Protected Audience API.
The origin of a non-Google seller you partner with to get impressions through Protected Audience.
OriginalPublisherProvidedId
STRING(64)
File types
ActiveViews + BackfillActiveViews
Clicks + BackfillClicks
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
The Original Publisher Provided ID (PPID), without additional encryption. For example, this value will match the value you send us on the ad request.
The value "1" indicates an Open Bidding bid. The value “2” indicates a non-Open Bidding bid from an Authorized Buyer (including bids from Display & Video 360 and Google Ads).
Name of the advertiser.
Redacted for winning bids.
Reason the bid lost or did not participate in the auction. Possible values include:
- "Winner": The bid won because it wasn’t rejected for any reason.
- "Outbid": The bid lost to another candidate in the auction or competing ad server line item.
- "Floor": The bid lost because its CPM was below a publisher-specified floor.
- "Optimized pricing": The bid was below the floor price set by optimized pricing.
- "No consent": The bid lost because the associated GDPR ad technology provider didn't have user consent.
- "Unidentified vendor": The bid lost because the GDPR ad technology provider was unidentified.
- "Publisher blocked": The bid lost because it was blocked by the publisher’s settings. This rejection includes bids that were filtered because of existing settings (such as a protection), or bids that aren't explicitly allowed (such as when only First Look traffic is eligible, but the bid doesn't match any First Look rules).
- "Other": The bid lost for another reason, such as URL filtering, or because it was below the minimum auction reserve price ($0.05 bids).
Offered price for this bid after revenue sharing calculations, displayed in the Ad Manager network's default currency. In BackfillBids, rounded for winning bids.
ID of the deal that applied for this impression. Blank if no deal was applied.
Type of deal. "Private auction", "Preferred deal", "Programmatic guaranteed", or blank if no deal was applied.
Names of the Ad Manager yield groups that matched the request. Blank if not applicable. Redacted for winning bids.
ID of the yield partner in an Ad Manager yield group that submitted the bid. Blank for Ad Exchange or if not applicable. Redacted for winning bids.
The per-buyer floor price from unified pricing rules. Displayed in the Ad Manager network's default currency. In BackfillBids, redacted for winning bids.
Reports the minimum bid buyers needed to win the auction. Offered price for this bid after revenue sharing calculations. Displayed in the Ad Manager network's default currency.
The value "1" indicates an Open Bidding bid.
The value “2” indicates a non-Open Bidding bid from an Authorized Buyer, Display & Video 360, or Google Ads.
The value “3” indicates a Header Bidding bid.
Denotes whether a PA/OB PD deal is optimized.
Values:
- Y
- N
Advertiser domain for block list checking, such as "ford.com."
DeclaredAdvertiserDomain
is sourced from bid responses and the aDomain
field on the OpenRTB spec
. It may not align with other derived advertiser fields in reporting or data transfer, for example, Advertiser (Classified), Advertiser Domain, or BidAdvertiser
.
ChildNetworkCode
STRING
File types
ActiveViews + BackfillActiveViews
Clicks + BackfillClicks
Requests + BackfillRequests
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions
Child NetworkChild networks have given parent networks (or "channel partners") the ability to represent and manage inventory on their behalf through "Manage inventory" in Multiple Customer Management.
This field allows parent networks to see how their individual child publishers are performing. Available only for MCM Manage Inventory parent accounts.
InventoryShareAssignmentName
STRING
File types
Impressions + BackfillImpressions
VideoConversions + BackfillVideoConversions
Requests + BackfillRequests
CodeServes + BackfillCodeServes
Inventory Share Assignment Name (Beta) Shows the name for the inventory share assignment.