Google Ad Manager

Sample

https://connectors.windsor.ai/google_ad_manager?api_key=[your API
key]&date_preset=last_7d&fields=campaign,clicks,spend,impressions,date,source&_renderer=csv


Fields

IDTypeNameDescription
account_idTEXTAccount idBreaks down reporting data by advertising company Company.id. Can be used to filter by Company.id. Compatible with any of the following report types: Historical, Future sell-through, Reach, Ad speed.
account_nameTEXTAccount nameBreaks down reporting data by advertising company. Company.name and Company.id are automatically included as columns in the report. Can be used to filter by Company.name. Corresponds to "Advertiser" in the Ad Manager UI. Compatible with any of the following report types: Historical, Future sell-through, Reach, Ad speed.
ad_network_idTEXTAd network idThe network that provided the ad for SDK ad mediation. If selected for a report, that report will include only SDK mediation ads and will not contain non-SDK mediation ads. SDK mediation ads are ads for mobile devices. They have a list of ad networks which can provide ads to serve. Not every ad network will have an ad to serve so the device will try each network one-by-one until it finds an ad network with an ad to serve. The ad network that ends up serving the ad will appear here. Note that this id does not correlate to anything in the companies table and is not the same id as is served by ADVERTISER_ID. Compatible with any of the following report types: Historical, Reach.
ad_network_nameTEXTAd network nameName of the ad network.
ad_server_clicksNUMERICAd server clicksThe number of clicks delivered by the ad server.
ad_server_ctrPERCENTAd server CTRThe CTR for an ad delivered by the ad server.
ad_server_impressionsNUMERICAd server impressionsThe number of impressions delivered by the ad server.
ad_server_targeted_impressionsNUMERICAd server targeted impressionsThe number of impressions delivered by the ad server by explicit custom criteria targeting.
ad_unit_idTEXTAd unit idThe id of the ad unit.
ad_unit_nameTEXTAd unit nameThe name of the ad unit.
adsense_line_item_level_impressionsNUMERICAdSense impressionsThe number of impressions an AdSense ad delivered for line item-level dynamic allocation. Compatible with the "Historical" report type.
advertiserTEXTAdvertiserThe name of the advertiser company assigned to an order.
advertiser_idTEXTAdvertiser idThe id of the advertiser company assigned to an order.
campaignTEXTCampaignBreaks down reporting data by placement. Placement.name and Placement.id are automatically included as columns in the report. Can be used to filter by Placement.name. Corresponds to "Placement" in the Ad Manager UI. Compatible with any of the following report types: Historical, Future sell-through, Reach.
clicksNUMERICClicksThe number of clicks delivered by the ad server. Corresponds to "Ad server clicks" in the Ad Manager UI. Compatible with the "Historical" report type.
countryTEXTCountryCountry associated to IP address from ad slot request
creative_idTEXTCreativeThe name of the Creative that served to the ad slot request.
creative_sizeTEXTCreative sizeSize of creative that served to the ad slot request. Creative size does not represent the actual size of a creative being served.
creative_typeTEXTCreative typeType of creative that served to the ad slot request.
dateDATEDateBreaks down reporting data by date in the network time zone. Can be used to filter by date using ISO 8601's format 'YYYY-MM-DD'". Note: In v201802 and later, this dimension is compatible with the following time zone types: TimeZoneType.PUBLISHER TimeZoneType.PROPOSAL_LOCAL Corresponds to "Date" in the Ad Manager UI. Compatible with any of the following report types: Historical, Future sell-through, Reach, Ad speed.
impressionsNUMERICImpressionsThe number of impressions an AdSense ad delivered for line item-level dynamic allocation. Corresponds to "AdSense impressions" in the Ad Manager UI. Compatible with the "Historical" report type.
line_item_delivery_indicatorTEXTLine item Delivery IndicatorIndicates the progress made for the delivery of the line item.
line_item_delivery_pacingTEXTLine item Delivery pacingRepresents delivery rate type for the line item.
line_item_idTEXTLine item idThe id of the line item associated to the Creative that served to the ad slot request.
line_item_nameTEXTLine item nameThe name of the line item associated to the Creative that served to the ad slot request.
line_item_typeTEXTLine item typeType of line item associated to the Creative that served to the ad slot request.
month_and_yearTEXTMonth and yearBreaks down reporting data by month and year in the network time zone. Can be used to filter on month using ISO 4601 format 'YYYY-MM'. Note: In v201802 and later, this dimension is compatible with the following time zone types: TimeZoneType.PUBLISHER TimeZoneType.PROPOSAL_LOCAL Corresponds to "Month and year" in the Ad Manager UI. Compatible with any of the following report types: Historical, Future sell-through, Reach, Partner finance.
order_delivery_statusTEXTORDER_DELIVERY_STATUSDelivery status of the order. Not available as a dimension to report on, but exists as a dimension in order to filter on it using PQL. Valid values are 'STARTED', 'NOT_STARTED' and 'COMPLETED'. Compatible with any of the following report types: Historical, Reach.
order_idTEXTOrder idThe id of the Order associated to the line item linked to the Creative that served to the ad slot request.
order_nameTEXTOrder nameThe name of the Order associated to the line item linked to the Creative that served to the ad slot request.
placement_idTEXTPlacement idThe id of the placement that currently includes an ad unit associated with an impression, click, or other event.
placement_nameTEXTPlacement nameName of the placement that currently includes an ad unit associated with an impression, click, or other event.
regionTEXTRegionRegion associated with the IP address included in the ad slot request.
spendNUMERICSpendThe total CPM and CPC revenue generated by the ad servers including line item-level dynamic allocation. Corresponds to "Total CPM and CPC revenue" in the Ad Manager UI. Compatible with the "Historical" report type.
total_ad_requestsNUMERICTotal ad requestsThe total number of times that an ad request is sent to the ad server including dynamic allocation.
total_line_item_level_clicksNUMERICTotal clicksThe total number of clicks delivered including line item-level dynamic allocation.
total_line_item_level_ctrNUMERICTotal CTRThe ratio of total clicks on ads delivered by the ad servers to the total number of impressions delivered for an ad including line item-level dynamic allocation.
total_line_item_level_impressionsNUMERICTotal impressionsThe total number of impressions delivered including line item-level dynamic allocation.
totalcostNUMERICTotal costThe total CPM and CPC revenue generated by the ad servers including line item-level dynamic allocation. Corresponds to "Total CPM and CPC revenue" in the Ad Manager UI. Compatible with the "Historical" report type.
video_viewership_average_view_rateNUMERICVideo viewership Average view rateAverage percentage of the video watched by users.
video_viewership_average_view_timeNUMERICVideo viewership Average view timeAverage time(seconds) users watched the video.
video_viewership_completeNUMERICVideo viewership CompleteThe number of times the video played to completion.
video_viewership_completion_rateNUMERICVideo viewership Completion ratePercentage of times the video played to the end.
video_viewership_engaged_viewNUMERICVideo viewership Engaged viewThe number of engaged views i.e. ad is viewed to completion or for 30s, whichever comes first.
video_viewership_first_quartileNUMERICVideo viewership First quartileThe number of times the video played to 25% of its length.
video_viewership_midpointNUMERICVideo viewership midpointThe number of times the video reached its midpoint during play.
video_viewership_startNUMERICVideo viewership StartThe number of impressions where the video was played.
video_viewership_third_quartileNUMERICVideo viewership third quartileThe number of times the video played to 75% of its length.
video_viewership_video_lengthNUMERICVideo viewership Video lengthDuration of the video creative.
video_viewership_view_through_rateNUMERICVideo viewership View-through rateView-through rate represented as a percentage.