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.

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.

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.

Field name Description

Field name	Description
`ImpressionId` _STRING _{File types ActiveViews + BackfillActiveViews Clicks + BackfillClicks Impressions + BackfillImpressions} _{CodeServes + BackfillCodeServes}	Unique impression ID 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 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 BackfillImpressions BackfillCodeServes BackfillRichMediaConversions BackfillVideoConversions}	Advertiser Name of the advertiser that won the auction.
`AdxAccountId` _NUMBER _{File types BackfillActiveViews BackfillBids BackfillClicks BackfillImpressions BackfillCodeServes BackfillRichMediaConversions BackfillVideoConversionss}	Ad Exchange account ID 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}	This field is deprecated. 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 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}	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.
`CustomSpotSubpodIds` _Integer _{File types ActiveViews} _{Clicks Requests Impressions CodeServes VideoConversions}	CustomSpotSubpodIds 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}	Ad Exchange deal ID 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}	Deal type 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 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}	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.
`IsFilledRequest` _BOOLEAN _{File types Requests + BackfillRequests}	Filled request indicator^(Beta) Indicates whether a request is associated with at least one code serve. Values are `TRUE` (at least one code serve) or `FALSE` (none).
`MaxAdsInOptimizedPod` _NUMBER _{File types Requests + BackfillRequests}	Maximum ads in optimized pod^(Beta) 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}	Optimization type The type of optimization applied when filling the request. Possible values: "Optimized Competition" "First Look" "Target CPM" Blank if no optimization type
`OptimizedPodsFilledDurationSeconds` _NUMBER _{File types Requests + BackfillRequests}	Optimized pods filled duration in seconds^(Beta) The length in seconds of the total filled time in an optimized pod.
`OptimizedPodsUnfilledDurationSeconds` _NUMBER _{File types Requests + BackfillRequests}	Optimized pods unfilled duration in seconds^(Beta) 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}	Order ID 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}	Processing date and hour 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 name The 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 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}	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.
`RequestedAdUnitSizes` _STRING _{File types ActiveViews + BackfillActiveViews 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".
`SellerReservePrice` _DOUBLE _{File types BackfillActiveViews BackfillClicks 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. 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}	Serving restriction^(Beta) 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 network control. 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}	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 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}	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 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 BackfillBids BackfillBidsJoinable Clicks + BackfillClicks MinimumBidToWin 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.
`YieldGroupCompanyId` _{NUMBER (xsd:long)} _{File types BackfillActiveViews BackfillClicks BackfillImpressions BackfillCodeServes BackfillRichMediaConversions BackfillVideoConversions}	DFP yield partner ID 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}	Ad Manager yield group names 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}	Yield Partner Tag 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}	DFP Ad unit ID 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}}	DFP Advertiser ID 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}	Creative ID 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}	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 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` _INTEGER _{File types ActiveViews + BackfillActiveViews 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 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. Due to YouTube policy, certain demographic data will be removed for YouTube inventory.
`Domain` _STRING _{File types ActiveViews + BackfillActiveViews 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 * VideoConversions + BackfillVideoConversions} _{* 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 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}	Companion creative indicator 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}	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(20) _{File types ActiveViews + BackfillActiveViews BackfillBids BackfillBidsJoinable Clicks + BackfillClicks MinimumBidToWin Requests + BackfillRequests Impressions + BackfillImpressions Codeserves + BackfillCodeServes RichMediaConversions + BackfillRichMediaConversions VideoConversions + BackfillVideoConversions}	Unique query identifier 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 format name^(Beta) 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 style name^(Beta) 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}	DFP Line item ID The numeric ID for the delivered Ad Manager line item.
`GfpActivityAdEventTime` _STRING _{File types ActiveViews + BackfillActiveViews}	Time of Ad Manager activity event Event time from attributed conversion ad event.
`GfpActivityAdEventType` _STRING(14) _{File types ActiveViews + BackfillActiveViews}	Type of Ad Manager activity event Indicates whether the conversion was post-impression or post-click.
`GfpActivityId` _INTEGER _{File types ActiveViews + BackfillActiveViews}	Unique Ad Manager activity event ID Identifies a unique advertiser-site conversion.
`GfpActivityName` _STRING(45) _{File types ActiveViews + BackfillActiveViews}	Name of Ad Manager activity event User-specified name associated with an Ad Manager activity ID.
`Ord` _STRING _{File types ActiveViews + BackfillActiveViews}	Randomly-generated value from Ad Manager Activity tags The ord= parameter value from your Ad Manager Activity tag.
`Quantity` _NUMBER _{File types ActiveViews + BackfillActiveViews}	Quantity value from Ad Manager Activity tags The qty= parameter value from your Ad Manager Activity tag.
`Revenue` _STRING _{File types ActiveViews + BackfillActiveViews}	Cost value from Ad Manager Activity tags The cost= parameter value from your Ad Manager Activity tag.
`ActiveViewEligibleImpression^Deprecated` _STRING _{File types Impressions + BackfillImpressions CodeServes + BackfillCodeServes}	Active View Eligible Impression This field is deprecated. Indicates that the impression was eligible for Active View measurement. `Y` = Impression was eligible `N` = Impression was not eligible
`MeasurableImpression^Deprecated` _STRING _{File types ActiveViews + BackfillActiveViews}	Active View Measurable Impression 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}	Active View Eligible Impression Count^(Beta) 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}	Active View Measurable Impression Count^(Beta) 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.
`ActiveViewViewableCount` _NUMBER _{File types ActiveViews + BackfillActiveViews}	Active View Viewable Impression Count 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}	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 ActiveViews + BackfillActiveViews RichMediaConversions + BackfillRichMediaConversions VideoConversions + BackfillVideoConversions}	Action Name Name of the creative conversion. For example, "Play" or "Mute". Video action names Rich Media action names
`ActionType` _STRING(8) _{File types ActiveViews + BackfillActiveViews RichMediaConversions + BackfillRichMediaConversions VideoConversions + BackfillVideoConversions}	Action Type Type of the creative conversion. For example, "standard" or "custom".
`ActionCount` _NUMBER _{File types ActiveViews + BackfillActiveViews 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. 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}	Fallback position 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}	Video Position 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.
`IsVideoFallbackRequest` _BOOLEAN _{File types Requests + BackfillRequests}	Fallback request indicator^(Beta) Indicates that an ad request was for a video fallback ador 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 metadata A 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}	Audience segment IDs 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}	Browser 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}	Browser ID 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}	Bandwidth Group ID 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}	City 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}	City ID 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}	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 BackfillBids BackfillBidsJoinable Clicks + BackfillClicks MinimumBidToWin 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 Clicks + BackfillClicks MinimumBidToWin Requests + BackfillRequests Impressions + BackfillImpressions Codeserves + BackfillCodeServes RichMediaConversions + BackfillRichMediaConversions VideoConversions + BackfillVideoConversions}	Device Category 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}	Metro 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}	Metro ID 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}	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 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 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 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 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 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. 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}	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. 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}	Postal code ID 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}	Publisher Provided ID The Publisher Provided ID (PPID), encrypted. 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. 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.
`PublisherProvidedSignals` _STRING _{File types ActiveViews + BackfillActiveViews Clicks + BackfillClicks Requests + BackfillRequests Impressions + BackfillImpressions Codeserves + BackfillCodeServes RichMediaConversions + BackfillRichMediaConversions VideoConversions + BackfillVideoConversions}	Publisher provided signals 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 bar of 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}	Publisher provided signals delivered 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 bar of 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}	Region The name of the region associated with the IP address of the user.
`RegionId` _NUMBER _{File types ActiveViews + BackfillActiveViews 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 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. 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.
`Bandwidth` _STRING(17) _{File types ActiveViews + BackfillActiveViews 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 BackfillBids Clicks + BackfillClicks MinimumBidToWin Requests + BackfillRequests Impressions + BackfillImpressions Codeserves + BackfillCodeServes RichMediaConversions + BackfillRichMediaConversions VideoConversions + BackfillVideoConversions BackfillBidsJoinable} _{* Always null}	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 Clicks + BackfillClicks Requests + BackfillRequests Impressions + BackfillImpressions Codeserves + BackfillCodeServes RichMediaConversions + BackfillRichMediaConversions VideoConversions + BackfillVideoConversions}	Requested language 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}	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.
`DeviceFamily` _STRING _{File types BackfillBids}	Device family The device on which the event took place. Grouped by type of device. Possible values: Mobile Desktop Other
`OSFamily` _STRING _{File types BackfillBids}	Operating system family 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}	User identifier status 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}	PPID presence Indicates whether a valid PPID (Publisher provided identifier) was present on a given ad request. Covers both reservation and programmatic traffic. 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}	ATT consent Status^(Beta) 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}	Protected Audience API delivery 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.
`ProtectedAudienceSeller` _STRING _{File types Impressions + BackfillImpressions}	Protected Audience Seller The origin of a non-Google seller you partner with to get impressions through Protected Audience.
`AuctionType` _NUMBER _{File types BackfillBids}	Auction type 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).
`BidAdvertiser` _STRING _{File types BackfillBids}	Bid advertiser Name of the advertiser. Redacted for winning bids.
`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 BackfillBidsJoinable}	Bid rejection reason 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).
`BidPrice` _FLOAT/DOUBLE _{File types BackfillBids BackfillBidsJoinable}	Bid price Offered price for this bid after revenue sharing calculations, displayed in the Ad Manager network's default currency. In BackfillBids, rounded for winning bids.
`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 BackfillBidsJoinable}	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. Redacted for winning bids.
`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. Redacted for winning bids.
`BidSellerReservePrice` _DOUBLE _{File types BackfillBids BackfillBidsJoinable}	Bid seller reserve price The per-buyer floor price from unified pricing rules. Displayed in the Ad Manager network's default currency. In BackfillBids, redacted for winning bids.
`MinimumBidToWinCPM` _DOUBLE _{File types MinimumBidToWin}	Minimum Bid To Win^(Beta) 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.
`BidSourceType` _INTEGER _{File types BackfillBidsJoinable}	Bid source type 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.
`IsOptimizedDeal` _STRING _{File types BackfillBidsJoinable}	Is Optimized Deal Denotes whether a PA/OB PD deal is optimized. Values: Y N
`ChildNetworkCode` _STRING _{File types ActiveViews + BackfillActiveViews Clicks + BackfillClicks Requests + BackfillRequests} _{Impressions + BackfillImpressions Codeserves + BackfillCodeServes RichMediaConversions + BackfillRichMediaConversions VideoConversions + BackfillVideoConversions}	Child Network Child 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.
`InventoryShareAssignmentId` _STRING _{File types Impressions + BackfillImpressions VideoConversions + BackfillVideoConversions Requests + BackfillRequests CodeServes + BackfillCodeServes}	Inventory Share Assignment ID^(Beta) Shows the ID for the inventory share assignment.
`InventoryShareOutcome` _STRING _{File types Impressions + BackfillImpressions VideoConversions + BackfillVideoConversions Requests + BackfillRequests CodeServes + BackfillCodeServes}	Inventory Share Outcome^(Beta) Shows who received a share. Either a host or a partner receives shares.
Try your keywords on Google Web Search.

`ImpressionId`

_STRING

_{File types

ActiveViews + BackfillActiveViews

Clicks + BackfillClicks

Impressions + BackfillImpressions}
_{CodeServes + BackfillCodeServes}

Unique impression ID
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 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

BackfillImpressions

BackfillCodeServes

BackfillRichMediaConversions

BackfillVideoConversions}

Advertiser
Name of the advertiser that won the auction.

`AdxAccountId`

_NUMBER

_{File types

BackfillActiveViews

BackfillBids

BackfillClicks

BackfillImpressions

BackfillCodeServes

BackfillRichMediaConversions

BackfillVideoConversionss}

Ad Exchange account ID
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}

This field is deprecated.
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
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}

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.

`CustomSpotSubpodIds`

_Integer

_{File types

ActiveViews}
_{Clicks

Requests

Impressions

CodeServes

VideoConversions}

CustomSpotSubpodIds
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}

Ad Exchange deal ID
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

Deal type
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)

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)}

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.

`IsFilledRequest`

_BOOLEAN

_{File types

Requests + BackfillRequests}

Filled request indicator^(Beta)
Indicates whether a request is associated with at least one code serve. Values are TRUE (at least one code serve) or FALSE (none).

`MaxAdsInOptimizedPod`

_NUMBER

_{File types

Requests + BackfillRequests}

Maximum ads in optimized pod^(Beta)
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}

Optimization type
The type of optimization applied when filling the request. Possible values:

"Optimized Competition"
"First Look"
"Target CPM"
Blank if no optimization type

`OptimizedPodsFilledDurationSeconds`

_NUMBER

_{File types

Requests + BackfillRequests}

Optimized pods filled duration in seconds^(Beta)
The length in seconds of the total filled time in an optimized pod.

`OptimizedPodsUnfilledDurationSeconds`

_NUMBER

_{File types

Requests + BackfillRequests}

Optimized pods unfilled duration in seconds^(Beta)
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}

Order ID
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}

Processing date and hour
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

Product name
The 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

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}

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.

`RequestedAdUnitSizes`

_STRING

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".

`SellerReservePrice`

_DOUBLE

_{File types

BackfillActiveViews

BackfillClicks

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. This field will display a zero (0) for any non-guaranteed line items.

`ServingRestriction`

_STRING

Serving restriction^(Beta)
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 network control.
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)

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

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

This field is deprecated.
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}

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.

`YieldGroupCompanyId`

_{NUMBER (xsd:long)}

_{File types

BackfillActiveViews

BackfillClicks

BackfillImpressions

BackfillCodeServes

BackfillRichMediaConversions

BackfillVideoConversions}

DFP yield partner ID
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}

Ad Manager yield group names
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

Yield Partner Tag
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

DFP Ad unit ID
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}}

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

`CreativeId`

_INTEGER

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

`CreativeSize`

_STRING(9)

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

`CreativeSizeDelivered`

_STRING(9)

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`

_INTEGER

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

`CustomTargeting`

_{STRING More details}

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.

Due to YouTube policy, certain demographic data will be removed for YouTube inventory.

`Domain`

_STRING

Domain
The user domain that triggered the event.

`EstimatedBackfillRevenue`

_DECIMAL

_{File types

ActiveViews + BackfillActiveViews *

Clicks + BackfillClicks *

Impressions + BackfillImpressions

Codeserves + BackfillCodeServes

RichMediaConversions + BackfillRichMediaConversions *

VideoConversions + BackfillVideoConversions}

_{* 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 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

Companion creative indicator
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}

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(20)

Unique query identifier
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

Native ad format name^(Beta)
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

Native style name^(Beta)
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

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

`GfpActivityAdEventTime`

_STRING

_{File types

ActiveViews + BackfillActiveViews}

Time of Ad Manager activity event
Event time from attributed conversion ad event.

`GfpActivityAdEventType`

_STRING(14)

_{File types

ActiveViews + BackfillActiveViews}

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

`GfpActivityId`

_INTEGER

_{File types

ActiveViews + BackfillActiveViews}

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

`GfpActivityName`

_STRING(45)

_{File types

ActiveViews + BackfillActiveViews}

Name of Ad Manager activity event
User-specified name associated with an Ad Manager activity ID.

`Ord`

_STRING

_{File types

ActiveViews + BackfillActiveViews}

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

`Quantity`

_NUMBER

_{File types

ActiveViews + BackfillActiveViews}

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

`Revenue`

_STRING

_{File types

ActiveViews + BackfillActiveViews}

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

`ActiveViewEligibleImpression^Deprecated`

_STRING

_{File types

Impressions + BackfillImpressions

CodeServes + BackfillCodeServes}

Active View Eligible Impression

This field is deprecated.
Indicates that the impression was eligible for Active View measurement.

Y = Impression was eligible
N = Impression was not eligible

`MeasurableImpression^Deprecated`

_STRING

_{File types

ActiveViews + BackfillActiveViews}

Active View Measurable Impression

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}

Active View Eligible Impression Count^(Beta)
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}

Active View Measurable Impression Count^(Beta)
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.

`ActiveViewViewableCount`

_NUMBER

_{File types

ActiveViews + BackfillActiveViews}

Active View Viewable Impression Count
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}

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

ActiveViews + BackfillActiveViews

RichMediaConversions + BackfillRichMediaConversions

VideoConversions + BackfillVideoConversions}

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

`ActionType`

_STRING(8)

_{File types

ActiveViews + BackfillActiveViews

RichMediaConversions + BackfillRichMediaConversions

VideoConversions + BackfillVideoConversions}

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

`ActionCount`

_NUMBER

_{File types

ActiveViews + BackfillActiveViews

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. 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}

Fallback position
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}

Video Position
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.

`IsVideoFallbackRequest`

_BOOLEAN

_{File types

Requests + BackfillRequests}

Fallback request indicator^(Beta)
Indicates that an ad request was for a video fallback ador 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 metadata
A 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

Audience segment IDs
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)

Browser
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

Browser ID
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)

Bandwidth Group ID
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)

City
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

City ID
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)

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

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

`DeviceCategory`

_STRING

Device Category
A descriptive category of the user's device. Possible values are:

Connected TV
Desktop
Feature phone
Set-top box
Smartphone
Tablet

`Metro`

_STRING(55)

Metro
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

Metro ID
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)

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)

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

`MobileDevice`

_STRING(256)

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

`OS`

_STRING(33)

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

`OSId`

_NUMBER

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)

Device operating system version
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)

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.

Due to YouTube policy, this field is redacted for YouTube inventory.

`PostalCodeId`

_NUMBER

Postal code ID
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)

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

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.

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.

`PublisherProvidedSignals`

_STRING

Publisher provided signals
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 bar of pipe ( | ).

[Taxonomy 1];[External category ID 1];[Data Provider name 1] | [Taxonomy 2];[External category ID 2];[Data Provider name 2].

`PublisherProvidedSignalsDelivered`

_STRING

Publisher provided signals delivered

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 bar of pipe ( | ).

[Taxonomy 1];[External category ID 1] | [Taxonomy 2];[External category ID 2].

`Region`

_{STRING (47)}

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

`RegionId`

_NUMBER

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

`UserId`

_STRING(64)

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.

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.

`Bandwidth`

_STRING(17)

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

`MobileAppId`

_STRING

_{* Always null}

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

Requested language
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)}

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.

`DeviceFamily`

_STRING

_{File types

BackfillBids}

Device family
The device on which the event took place. Grouped by type of device. Possible values:

Mobile
Desktop
Other

`OSFamily`

_STRING

_{File types

BackfillBids}

Operating system family
The group the operating system installed on the user's device belongs to. Possible values:

Apple iOS
Android
Other

`UserIdentifierStatus`

_STRING

User identifier status
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

PPID presence
Indicates whether a valid PPID (Publisher provided identifier) was present on a given ad request. Covers both reservation and programmatic traffic. 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

ATT consent Status^(Beta)
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}

Protected Audience API delivery
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.

`ProtectedAudienceSeller`

_STRING

_{File types

Impressions + BackfillImpressions}

Protected Audience Seller
The origin of a non-Google seller you partner with to get impressions through Protected Audience.

`AuctionType`

_NUMBER

_{File types

BackfillBids}

Auction type
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).

`BidAdvertiser`

_STRING

_{File types

BackfillBids}

Bid advertiser
Name of the advertiser.
Redacted for winning bids.

`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

BackfillBidsJoinable}

Bid rejection reason
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).

`BidPrice`

_FLOAT/DOUBLE

_{File types

BackfillBids

BackfillBidsJoinable}

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

`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

BackfillBidsJoinable}

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. Redacted for winning bids.

`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. Redacted for winning bids.

`BidSellerReservePrice`

_DOUBLE

_{File types

BackfillBids

BackfillBidsJoinable}

Bid seller reserve price
The per-buyer floor price from unified pricing rules. Displayed in the Ad Manager network's default currency. In BackfillBids, redacted for winning bids.

`MinimumBidToWinCPM`

_DOUBLE

_{File types

MinimumBidToWin}

Minimum Bid To Win^(Beta)
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.

`BidSourceType`

_INTEGER

_{File types

BackfillBidsJoinable}

Bid source type

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.

`IsOptimizedDeal`

_STRING

_{File types

BackfillBidsJoinable}

Is Optimized Deal

Denotes whether a PA/OB PD deal is optimized.

Values:

`ChildNetworkCode`

_STRING

_{File types

ActiveViews + BackfillActiveViews

Clicks + BackfillClicks

Requests + BackfillRequests}
_{Impressions + BackfillImpressions

Codeserves + BackfillCodeServes

RichMediaConversions + BackfillRichMediaConversions

VideoConversions + BackfillVideoConversions}

Child Network
Child 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.

`InventoryShareAssignmentId`

_STRING

_{File types

Impressions + BackfillImpressions

VideoConversions + BackfillVideoConversions

Requests + BackfillRequests

CodeServes + BackfillCodeServes}

Inventory Share Assignment ID^(Beta)
Shows the ID for the inventory share assignment.

`InventoryShareOutcome`

_STRING

_{File types

Impressions + BackfillImpressions

VideoConversions + BackfillVideoConversions

Requests + BackfillRequests

CodeServes + BackfillCodeServes}

Inventory Share Outcome^(Beta)
Shows who received a share. Either a host or a partner receives shares.

Try your keywords on Google Web Search.

Explore Data Transfer fields

ImpressionId

Advertiser

AdxAccountId

Anonymous Deprecated

BackfillKeyPart

Buyer

CustomSpotSubpodIds

DealId

DealType

EventKeyPart

EventTimeUsec2

IsFilledRequest

MaxAdsInOptimizedPod

OptimizationType

OptimizedPodsFilledDurationSeconds

OptimizedPodsUnfilledDurationSeconds

OrderId

ProcessingDateAndHour

Product

RefererURL

RequestedAdUnitSizes

SellerReservePrice

ServingRestriction

TargetedCustomCriteria

Time

TimeUsec Deprecated

TimeUsec2

YieldGroupCompanyId

YieldGroupNames

YieldPartnerTag

AdUnitId

AdvertiserId

CreativeId

CreativeSize

CreativeSizeDelivered

CreativeVersion

CustomTargeting

Domain

EstimatedBackfillRevenue

IsCompanion

IsInterstitial

KeyPart

NativeFormat

NativeStyle

LineItemId

GfpActivityAdEventTime

GfpActivityAdEventType

GfpActivityId

GfpActivityName

Ord

Quantity

Revenue

ActiveViewEligibleImpressionDeprecated

MeasurableImpressionDeprecated

ActiveViewEligibleCount

ActiveViewMeasurableCount

ActiveViewViewableCount

ActionDuration

ActionName

ActionType

ActionCount

GfpContentId

PodPosition

VideoFallbackPosition

VideoPosition

IsVideoFallbackRequest

CmsMetadata

AudienceSegmentIds

Browser

BrowserId

BandwidthGroupId

City

CityId

Country

CountryId

DeviceCategory

Metro

MetroId

MobileCapability

`ImpressionId`

`Advertiser`

`AdxAccountId`

`Anonymous` ^Deprecated

`BackfillKeyPart`

`Buyer`

`CustomSpotSubpodIds`

`DealId`

`DealType`

`EventKeyPart`

`EventTimeUsec2`

`IsFilledRequest`

`MaxAdsInOptimizedPod`

`OptimizationType`

`OptimizedPodsFilledDurationSeconds`

`OptimizedPodsUnfilledDurationSeconds`

`OrderId`

`ProcessingDateAndHour`

`Product`

`RefererURL`

`RequestedAdUnitSizes`

`SellerReservePrice`

`ServingRestriction`

`TargetedCustomCriteria`

`Time`

`TimeUsec` ^Deprecated

`TimeUsec2`

`YieldGroupCompanyId`

`YieldGroupNames`

`YieldPartnerTag`

`AdUnitId`

`AdvertiserId`

`CreativeId`

`CreativeSize`

`CreativeSizeDelivered`

`CreativeVersion`

`CustomTargeting`

`Domain`

`EstimatedBackfillRevenue`

`IsCompanion`

`IsInterstitial`

`KeyPart`

`NativeFormat`

`NativeStyle`

`LineItemId`

`GfpActivityAdEventTime`

`GfpActivityAdEventType`

`GfpActivityId`

`GfpActivityName`

`Ord`

`Quantity`

`Revenue`

`ActiveViewEligibleImpression^Deprecated`

`MeasurableImpression^Deprecated`

`ActiveViewEligibleCount`

`ActiveViewMeasurableCount`

`ActiveViewViewableCount`

`ActionDuration`

`ActionName`

`ActionType`

`ActionCount`

`GfpContentId`

`PodPosition`

`VideoFallbackPosition`

`VideoPosition`

`IsVideoFallbackRequest`

`CmsMetadata`

`AudienceSegmentIds`

`Browser`

`BrowserId`

`BandwidthGroupId`

`City`

`CityId`

`Country`

`CountryId`

`DeviceCategory`

`Metro`

`MetroId`

`MobileCapability`

`MobileCarrier`