Only available in Google Ad Manager 360.

आपने जिस पेज का अनुरोध किया है वह फ़िलहाल आपकी भाषा में उपलब्ध नहीं है. पेज के निचले हिस्से से कोई दूसरी भाषा चुनी जा सकती है. इसके अलावा, किसी भी वेबपेज का अपनी पसंदीदा भाषा में झटपट अनुवाद भी किया जा सकता है. इसके लिए, आपको Google Chrome की पहले से मौजूद अनुवाद करने की सुविधा का इस्तेमाल करना होगा.

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 nameDescription

ImpressionId

STRING

File types
ActiveViews + BackfillActiveViews
Clicks + BackfillClicks
CodeServes + BackfillCodeServes
Impressions + BackfillImpressions

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

All unfilled impressions are recorded in the NetworkRequests file.

Advertiser

STRING

File types
Activities
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.

Buyer

STRING

File types
Activities
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
Impression
Click
Video Conversion
Active view
Request
Code Serve

CustomSpotSubpodIds
The ID associated with the custom spot that is used in the ad break template.

 

DealId

STRING

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

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

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

Unique event identifier
Unique event identifier (hashed key). Each impression or other event from a single query has a unique value.
Note: 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

EventTimeUsec2

NUMBER (xsd:long)

File types
ActiveViews + BackfillActiveViews
Activities
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
Indicates whether a request is associated with at least one code serve. Values are TRUE (at least one code serve) or FALSE (none).

OptimizationType

STRING

File types
ActiveViews + BackfillActiveViews
Activities
BackfillBids
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

OrderId

INTEGER

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

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
Activities
BackfillBids
Clicks + BackfillClicks
MinimumBidToWin
Requests + BackfillRequests

Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

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
Activities
Clicks + BackfillClicks
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

Product name
The product from which the event originated.
  • Ad Exchange
  • AdSense
  • Ad Server
  • First Look
  • Mediation
  • Open Bidding
  • Header Bidding

Note that "Ad Exchange" in Data Transfer equals "Open Bidding" in Reporting.

RefererURL

STRING

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

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

RequestedAdUnitSizes

STRING

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

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

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
Activities
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
Activities
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 also displays keys which were negatively targeted by the line item. This value is truncated to 512 characters.

When multiple values matched in the same key, only the first one (alphabetically) will be displayed.

Time

STRING(19)

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

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

TimeUsec Deprecated

NUMBER

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

This field is deprecated.
Use TimeUsec2, instead.

TimeUsec2

NUMBER (xsd:long)

File types
ActiveViews + BackfillActiveViews
Activities
BackfillBids
Clicks + BackfillClicks
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. Use this value with the Keypart field value to uniquely identify a request or bid auction.

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.

AdUnitId

INTEGER

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

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

CreativeId

INTEGER

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

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

CreativeSize

STRING(9)

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

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

CreativeSizeDelivered

STRING(9)

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

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

CreativeVersion

INTEGER

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

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

CustomTargeting

STRING  More details

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

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

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

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

Domain

STRING

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

Domain
The user domain that triggered the event.

EstimatedBackfillRevenue

DECIMAL

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

IsCompanion

BOOLEAN

File types
ActiveViews + BackfillActiveViews
Activities
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
Activities
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(9)

File types
ActiveViews + BackfillActiveViews
Activities
BackfillBids
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 in combination with TimeUsec2 to uniquely identify a query or bid auction.

NativeFormat

STRING

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

Native ad format name
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
Activities
Clicks + BackfillClicks
Impressions + BackfillImpressions
Codeserves + BackfillCodeServes
RichMediaConversions + BackfillRichMediaConversions
VideoConversions + BackfillVideoConversions

Native style name
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
Activities
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
Activities

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

GfpActivityAdEventType

STRING(14)

File types
ActiveViews + BackfillActiveViews
Activities

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

GfpActivityId

INTEGER

File types
ActiveViews + BackfillActiveViews
Activities

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

GfpActivityName

STRING(45)

File types
ActiveViews + BackfillActiveViews
Activities

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

Ord

STRING

File types
ActiveViews + BackfillActiveViews
Activities

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

Quantity

NUMBER

File types
ActiveViews + BackfillActiveViews
Activities

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

Revenue

STRING

File types
ActiveViews + BackfillActiveViews
Activities

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

ActiveViewEligibleImpressionDeprecated

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

MeasurableImpressionDeprecated

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.

ViewableImpressionDeprecated

STRING

File types
ActiveViews + BackfillActiveViews

Active View Viewable Impression

This field is deprecated.
Indicates whether the impression was viewable according to the IAB standard.

  • Y = Impression was measurable and viewable
  • NA = impression was not measurable

ActiveViewEligibleCount

NUMBER

File types
Impressions + BackfillImpressions
ActiveViews + BackfillActiveViews

Active View Eligible Impression Count
Indicates that the impression was eligible for Active View measurement.

The values differ slightly between Impressions and Active View. Use both Impression and Active View values to determine eligibility.

Impressions:

  • 1 = Impression was eligible
  • 0 = Impression eligibility was not determined

Active View:

  • 1 = Impression was eligible
  • 0 = Impression was not eligible, or impression eligibility was unchanged

To find the total number of Active View Eligible Count:

SUM(Eligible) FROM (
SELECT SUM(ActiveViewEligibleCount) AS
Eligible FROM Impressions
UNION ALL
SELECT SUM (ActiveViewEligibleCount) AS
Eligible FROM ActiveViews

)

ActiveViewMeasurableCount

NUMBER

File types
Impressions + BackfillImpressions
ActiveViews + BackfillActiveViews

Active View Measurable Impression Count
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:

SUM(measurable) FROM (
SELECT SUM(ActiveViewMeasurableCount)
AS measurable FROM Impressions 
  UNION ALL 
  SELECT SUM(ActiveViewMeasurableCount)
AS measurable FROM ActiveViews)

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:

SUM(ActiveViewViewable) FROM ActiveViews

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

Video Fallback Position
The fallback position of the video ad.
  • 0 = Non-fallback
  • 1 = First fallback ad, 2 = second fallback ad, 3 = third fallback ad 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

Video fallback request indicator
Indicates that an ad request was for a video fallback ad (also referred to as "waterfall" ads). Values are TRUE or FALSE.

CmsMetadata

STRING

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

* 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
Activities
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 (|), maximum of 35 segment IDs.
  • Requests: All audience segment IDs that the user belonged to.
  • Other files: Only segments that were used in targeting this line item. These are segments that have been included or excluded in the targeting.

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

Browser

STRING(39)

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

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

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

BrowserId

NUMBER

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

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

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

BandwidthGroupId

NUMBER(1)

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

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

City

STRING(46)

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

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

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

CityId

NUMBER

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

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

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

Country

STRING(44)

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

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

CountryId

NUMBER

File types
ActiveViews + BackfillActiveViews
Activities
BackfillBids
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
Activities
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:
  • Desktop
  • Feature Phone
  • Smartphone
  • Tablet

Metro

STRING(55)

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

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

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

MetroId

NUMBER

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

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

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

MobileCapability

STRING(256)

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

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

MobileCarrier

STRING(256)

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

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

MobileDevice

STRING(256)

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

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

OS

STRING(33)

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

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

OSId

NUMBER

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

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

OSVersion

STRING(256)

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

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

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

PostalCode

STRING(5)

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

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

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

PostalCodeId

NUMBER

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

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

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

PublisherProvidedID

STRING(64)

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

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

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.

Region

STRING (47)

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

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

RegionId

NUMBER

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

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

UserId

STRING(64)

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

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

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

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

MobileAppId

STRING

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

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

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

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

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

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

Bid price
Offered price for this bid after revenue sharing calculations, displayed in the Ad Manager network's default currency. 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

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

Bid seller reserve price
The per-buyer floor price from unified pricing rules. Displayed in the Ad Manager network's default currency. 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. 

ChildNetworkCode

STRING

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

Search
Clear search
Close search
Google apps
Main menu
Search Help Center
true
148
false