Google Ad Manager
Google · DisponívelConsultar via API
GET https://askaner.askan.com.br/api/v1/data/google_ad_manager?fields=date,account_id&date_preset=last_30d Authorization: Bearer ik_...
Campos (62 métricas, 79 dimensões)
| ID | Tipo | Natureza | Descrição |
|---|---|---|---|
account_id | TEXT | Dimensão | Breaks 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_name | TEXT | Dimensão | Breaks 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_exchange_cpc | NUMERIC | Métrica | The cost-per-click generated by mapped Ad Exchange properties. Corresponds to "CPC" in the Ad Manager UI. Compatible with the "Ad Exchange historical" report type. |
ad_exchange_line_item_average_ecpm | PERCENT | Métrica | The average estimated cost-per-thousand-impressions earned from the delivery of Ad Exchange ads for line item-level dynamic allocation. Compatible with the 'Historical' report type. |
ad_exchange_line_item_clicks | NUMERIC | Métrica | The number of clicks an Ad Exchange ad delivered for line item-level dynamic allocation. Compatible with the 'Historical' report type. |
ad_exchange_line_item_clicks_percent | PERCENT | Métrica | The ratio of the number of clicks delivered to the total clicks delivered by Ad Exchange for line item-level dynamic allocation. Represented as a percentage. Compatible with the 'Historical' report type. |
ad_exchange_line_item_ctr | NUMERIC | Métrica | The ratio of clicks an Ad Exchange ad delivered to the number of impressions it delivered for line item-level dynamic allocation. Compatible with the 'Historical' report type. |
ad_exchange_line_item_impressions_percent | PERCENT | Métrica | The ratio of the number of impressions delivered to the total impressions delivered by Ad Exchange for line item-level dynamic allocation. Represented as a percentage. Compatible with the 'Historical' report type. |
ad_exchange_line_item_revenue | NUMERIC | Métrica | Revenue generated from Ad Exchange ads delivered for line item-level dynamic allocation. Represented in publisher currency and time zone. Compatible with the 'Historical' report type. |
ad_exchange_line_item_revenue_percent | PERCENT | Métrica | The ratio of revenue generated by Ad Exchange to the total revenue earned by CPM and CPC ads delivered for line item-level dynamic allocation. Represented as a percentage. Compatible with the 'Historical' report type. |
ad_exchange_line_item_revenue_percent_cpd | PERCENT | Métrica | The ratio of revenue generated by Ad Exchange to the total revenue earned by CPM, CPC and CPD ads delivered for line item-level dynamic allocation. Represented as a percentage.Compatible with the 'Historical' report type. |
ad_exchange_line_item_targeted_clicks | NUMERIC | Métrica | The number of clicks an Ad Exchange ad delivered for line item-level dynamic allocation by explicit custom criteria targeting. Compatible with the 'Historical' report type. |
ad_exchange_line_item_targeted_impressions | NUMERIC | Métrica | The number of impressions an Ad Exchange ad delivered for line item-level dynamic allocation by explicit custom criteria targeting. Compatible with the 'Historical' report type. |
ad_network_id | TEXT | Dimensão | The 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_name | TEXT | Dimensão | Name of the ad network. |
ad_server_all_revenue | NUMERIC | Métrica | The CPM, CPC and CPD revenue earned, calculated in publisher currency, for the ads delivered by the ad server. Can correspond to any of the following in the Ad Manager UI: Ad server CPM, CPC, CPD, and vCPM revenue, Ad server CPM, CPC and CPD revenue. Compatible with the "Historical" report type. |
ad_server_average_viewable_seconds | NUMERIC | Métrica | Active View ad server average time in seconds that specific impressions are reported as being viewable. Corresponds to "Ad Server Active View Average Viewable Time (seconds)" in the Ad Manager UI. Compatible with the 'Historical' report type. |
ad_server_clicks | NUMERIC | Métrica | The number of clicks delivered by the ad server. |
ad_server_ctr | PERCENT | Métrica | The CTR for an ad delivered by the ad server. |
ad_server_eligible_impressions | NUMERIC | Métrica | Total number of impressions delivered by the ad server that were eligible to measure viewability. Corresponds to "Ad server Active View eligible impressions" in the Ad Manager UI. Compatible with the 'Historical' report type. |
ad_server_impressions | NUMERIC | Métrica | The number of impressions delivered by the ad server. |
ad_server_measurable_impressions | NUMERIC | Métrica | The number of impressions delivered by the ad server that were sampled, and measurable by active view. Corresponds to "Ad server Active View measurable impressions" in the Ad Manager UI. Compatible with the 'Historical' report type. |
ad_server_measurable_impressions_rate | NUMERIC | Métrica | The percentage of impressions delivered by the ad server that were measurable by active view (out of all the ad server impressions sampled for active view). Corresponds to "Ad server Active View % measurable impressions" in the Ad Manager UI. Compatible with the 'Historical' report type. |
ad_server_targeted_impressions | NUMERIC | Métrica | The number of impressions delivered by the ad server by explicit custom criteria targeting. |
ad_server_viewable_impressions | NUMERIC | Métrica | The number of impressions delivered by the ad server viewed on the user's screen. Corresponds to "Ad server Active View viewable impressions" in the Ad Manager UI. Compatible with the 'Historical' report type. |
ad_server_viewable_impressions_rate | NUMERIC | Métrica | The percentage of impressions delivered by the ad server viewed on the user's screen (out of the ad server impressions measurable by active view). Corresponds to "Ad server Active View % viewable impressions" in the Ad Manager UI. Compatible with the 'Historical' report type. |
ad_unit_id | TEXT | Dimensão | The id of the ad unit. |
ad_unit_name | TEXT | Dimensão | The name of the ad unit. |
adsense_line_item_level_impressions | NUMERIC | Métrica | The number of impressions an AdSense ad delivered for line item-level dynamic allocation. Compatible with the "Historical" report type. |
advertiser | TEXT | Dimensão | The name of the advertiser company assigned to an order. |
advertiser_id | TEXT | Dimensão | The id of the advertiser company assigned to an order. |
campaign | TEXT | Dimensão | Breaks 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. |
city | CITY | Dimensão | City associated with the IP address included in the ad slot request. |
clicks | NUMERIC | Métrica | The number of clicks delivered by the ad server. Corresponds to "Ad server clicks" in the Ad Manager UI. Compatible with the "Historical" report type. |
country | COUNTRY | Dimensão | Country associated to IP address from ad slot request |
creative_click_through_url | TEXT | Dimensão | Represents the click-through URL for Dimension.CREATIVE_NAME. Corresponds to "Click-through URL" in the Ad Manager UI. Compatible with the "Historical" report type. |
creative_id | TEXT | Dimensão | The ID of the Creative that served to the ad slot request. |
creative_image_url | IMAGE | Dimensão | Direct URL of the creative's primary image asset, fetched from CreativeService. Only populated for image creatives; null for creatives without an image asset (e.g. third-party, video or snippet creatives). |
creative_name | TEXT | Dimensão | The name of the Creative that served to the ad slot request. |
creative_preview_url | TEXT | Dimensão | URL of the creative's preview page in Ad Manager, fetched from CreativeService. Populated for all creative types. |
creative_size | TEXT | Dimensão | Size of creative that served to the ad slot request. Creative size does not represent the actual size of a creative being served. |
creative_type | TEXT | Dimensão | Type of creative that served to the ad slot request. |
custom_criteria | TEXT | Dimensão | Breaks down reporting data by custom criteria. Cannot be used for filtering; When using this Dimension, metrics for freeform key values are only reported on when they are registered with CustomTargetingService. Corresponds to 'Key-values' in the Ad Manager UI. Compatible with any of the following report types: Historical, Reach. |
data_fetched_at | TIMESTAMP | Dimensão | UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed. |
datasource | TEXT | Dimensão | The name of the Windsor connector returning the row |
date | DATE | Dimensão | Breaks 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. |
day_of_month | TEXT | Dimensão | Day of the month |
device_category_id | TEXT | Dimensão | The ID of the device category to which an ad is being targeted. Compatible with any of the following report types: Historical, Reach, Ad speed. |
device_category_name | TEXT | Dimensão | The category of device (smartphone, feature phone, tablet, or desktop) to which an ad is being targeted. Corresponds to "Device category" in the Ad Manager UI. Compatible with any of the following report types: Historical, Reach, Ad speed. |
domain | TEXT | Dimensão | Breaks down reporting data by top private domain. Corresponds to "Domain" in the Ad Manager UI. Compatible with any of the following report types: Historical, Reach. |
impressions | NUMERIC | Métrica | The 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_average_number_of_viewers | TEXT | Dimensão | Corresponds to 'Nielsen Average Number Of Viewers' in the Ad Manager UI. Compatible with any of the following report types: Historical, Reach. |
line_item_contracted_quantity | TEXT | Dimensão | Represents the LineItem.contractedUnitsBought quantity for Dimension.LINE_ITEM_NAME. |
line_item_cost_per_unit | NUMERIC | Métrica | Represents Line Item cost per unit for Line item name. Corresponds to 'Rate' in the Ad Manager UI |
line_item_cost_type | TEXT | Dimensão | Represents LineItem.costType for Dimension.LINE_ITEM_NAME. Can be used for filtering. |
line_item_creative_end_date | DATE | Dimensão | Represents a LineItemCreativeAssociation.endDateTime for a Dimension.LINE_ITEM_NAME and a Dimension.CREATIVE_NAME. Includes the date without the time. |
line_item_creative_start_date | DATE | Dimensão | Represents a LineItemCreativeAssociation.startDateTime for a Dimension.LINE_ITEM_NAME and a Dimension.CREATIVE_NAME. Includes the date without the time. |
line_item_currency_code | TEXT | Dimensão | Represents the 3 letter currency code for Dimension.LINE_ITEM_NAME. |
line_item_delivery_indicator | TEXT | Dimensão | Indicates the progress made for the delivery of the line item. |
line_item_delivery_pacing | TEXT | Dimensão | Represents delivery rate type for the line item. |
line_item_discount | TEXT | Dimensão | Represents the LineItem.discount for Dimension.LINE_ITEM_NAME. The number is either a percentage or an absolute value depending on LineItem.discountType. |
line_item_end_date_time | DATE | Dimensão | Represents the end date (in YYYY-MM-DD format) for Dimension.LINE_ITEM_NAME. Can be used for filtering. |
line_item_external_id | TEXT | Dimensão | Represents LineItem.externalId for Dimension.LINE_ITEM_NAME. Can be used for filtering. |
line_item_frequency_cap | TEXT | Dimensão | Represents LineItem.frequencyCaps as a comma separated list of 'FrequencyCap.maxImpressions impressions per/every FrequencyCap.numTimeUnits FrequencyCap.timeUnit' (e.g. '10 impressions every day,500 impressions per lifetime') for Dimension.LINE_ITEM_NAME. |
line_item_goal_quantity | TEXT | Dimensão | The total number of impressions, clicks or days that is reserved for Line item name. |
line_item_id | TEXT | Dimensão | The id of the line item associated to the Creative that served to the ad slot request. |
line_item_label_ids | TEXT | Dimensão | Represents LineItem.effectiveAppliedLabels as a comma separated list of Label.id for Dimension.LINE_ITEM_NAME. |
line_item_labels | TEXT | Dimensão | Represents LineItem.effectiveAppliedLabels as a comma separated list of Label.name for Dimension.LINE_ITEM_NAME. |
line_item_last_reconciliation_date_time | TEXT | Dimensão | Represents the monthly last reconciliation date time of the line item for Dimension.LINE_ITEM_NAME and Dimension.MONTH_YEAR. |
line_item_lifetime_clicks | TEXT | Dimensão | The total number of clicks delivered over the lifetime of a Dimension.LINE_ITEM_NAME. |
line_item_lifetime_impressions | TEXT | Dimensão | The total number of impressions delivered over the lifetime of a Dimension.LINE_ITEM_NAME. |
line_item_name | TEXT | Dimensão | The name of the line item associated to the Creative that served to the ad slot request. |
line_item_non_cpd_booked_revenue | NUMERIC | Métrica | The cost of booking for a non-CPD Line item name. |
line_item_optimizable | TEXT | Dimensão | Generated as true for Dimension.LINE_ITEM_NAME which is eligible for optimization, false otherwise. Can be used for filtering. |
line_item_priority | TEXT | Dimensão | Represents Line item priority for Line item name as a valuebetween 1 and 16. Can be used for filtering. |
line_item_reconciliation_status | TEXT | Dimensão | Represents the monthly reconciliation status of the line item for Dimension.LINE_ITEM_NAME and Dimension.MONTH_YEAR. |
line_item_sponsorship_goal_percentage | PERCENT | Métrica | The ratio between the goal quantity for Dimension.LINE_ITEM_NAME of LineItemType.SPONSORSHIP and the LINE_ITEM_GOAL_QUANTITY. Represented as a number between 0..100. |
line_item_start_date_time | DATE | Dimensão | Represents the start date (in YYYY-MM-DD format) for Dimension.LINE_ITEM_NAME. Can be used for filtering. |
line_item_type | TEXT | Dimensão | Type of line item associated to the Creative that served to the ad slot request. |
metro | TEXT | Dimensão | Metro (DMA) area associated with the IP address included in the ad slot request. |
mobile_device_name | TEXT | Dimensão | Breaks down reporting data by device name. Corresponds to "Devices" in the Ad Manager UI. Compatible with any of the following report types: Historical, Reach. |
month | TEXT | Dimensão | Number of the month |
month_and_year | TEXT | Dimensão | Breaks 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. |
now | TIMESTAMP | Dimensão | Current timestamp |
order_delivery_status | TEXT | Dimensão | Delivery 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_end_date | DATE | Dimensão | Represents the end date (in YYYY-MM-DD format) for Dimension.ORDER_NAME. Corresponds to "Order end date" in the Ad Manager UI. Compatible with any of the following report types: Historical, Future sell-through, Reach, Ad speed. |
order_id | TEXT | Dimensão | The id of the Order associated to the line item linked to the Creative that served to the ad slot request. |
order_name | TEXT | Dimensão | The name of the Order associated to the line item linked to the Creative that served to the ad slot request. |
order_start_date | DATE | Dimensão | Represents the start date (in YYYY-MM-DD format) for Dimension.ORDER_NAME. Corresponds to "Order start date" in the Ad Manager UI. Compatible with any of the following report types: Historical, Future sell-through, Reach, Ad speed. |
placement_id | TEXT | Dimensão | The id of the placement that currently includes an ad unit associated with an impression, click, or other event. |
placement_name | TEXT | Dimensão | Name of the placement that currently includes an ad unit associated with an impression, click, or other event. |
postal_code | TEXT | Dimensão | Postal code associated with the IP address included in the ad slot request. |
programmatic_match_rate | PERCENT | Métrica | The number of programmatic responses served divided by the number of requests eligible for programmatic. Includes Ad Exchange, Open Bidding, and Preferred Deals. Compatible with the 'Historical' report type. |
region | REGION | Dimensão | Region associated with the IP address included in the ad slot request. |
sell_through_available_impressions | NUMERIC | Métrica | The number of available impressions for future sell-through reports. This metric is available for the next 90 days with a daily break down and for the next 12 months with a monthly break down. Compatible with the "Future sell-through" report type. |
sell_through_forecasted_impressions | NUMERIC | Métrica | The number of forecasted impressions for future sell-through reports. This metric is available for the next 90 days with a daily break down and for the next 12 months with a monthly break down. Compatible with the "Future sell-through" report type. |
sell_through_rate | PERCENT | Métrica | The sell-through rate for impressions for future sell-through reports. This metric is available for the next 90 days with a daily break down and for the next 12 months with a monthly break down. Compatible with the "Future sell-through" report type. |
sell_through_reserved_impressions | NUMERIC | Métrica | The number of reserved impressions for future sell-through reports. This metric is available for the next 90 days with a daily break down and for the next 12 months with a monthly break down. Compatible with the "Future sell-through" report type. |
source | TEXT | Dimensão | The name of the Windsor connector returning the row |
spend | NUMERIC | Métrica | The 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. |
today | DATE | Dimensão | Today's date |
total_ad_requests | NUMERIC | Métrica | The total number of times that an ad request is sent to the ad server including dynamic allocation. |
total_average_viewable_seconds | NUMERIC | Métrica | Active View total average time in seconds that specific impressions are reported as being viewable. Corresponds to "Total Active View Average Viewable Time (seconds)" in the Ad Manager UI. Compatible with the 'Historical' report type. |
total_eligible_impressions | NUMERIC | Métrica | Total number of impressions that were eligible to measure viewability. Corresponds to "Total Active View eligible impressions" in the Ad Manager UI. Compatible with the 'Historical' report type. |
total_line_item_level_all_revenue | NUMERIC | Métrica | The total CPM, CPC and CPD revenue generated by the ad servers including line item-level dynamic allocation. Can correspond to any of the following in the Ad Manager UI: Total CPM, CPC, CPD, and vCPM revenue, Total CPM, CPC and CPD revenue. Compatible with the "Historical" report type. |
total_line_item_level_clicks | NUMERIC | Métrica | The total number of clicks delivered including line item-level dynamic allocation. |
total_line_item_level_cpm_and_cpc_revenue | NUMERIC | Métrica | The 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_line_item_level_ctr | NUMERIC | Métrica | The 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_impressions | NUMERIC | Métrica | The total number of impressions delivered including line item-level dynamic allocation. |
total_line_item_level_targeted_clicks | NUMERIC | Métrica | The total number of clicks delivered including line item-level dynamic allocation by explicit custom criteria targeting Corresponds to 'Total targeted clicks' in the Ad Manager UI. Compatible with the 'Historical' report type. |
total_line_item_level_targeted_impressions | NUMERIC | Métrica | The total number of impressions delivered including line item-level dynamic allocation by explicit custom criteria targeting. Corresponds to 'Total targeted impressions' in the Ad Manager UI. Compatible with the 'Historical' report type. |
total_line_item_level_with_cpd_average_ecpm | NUMERIC | Métrica | Estimated cost-per-thousand-impressions (eCPM) of CPM, CPC and CPD ads delivered by the ad servers including line item-level dynamic allocation. |
total_line_item_level_without_cpd_average_ecpm | NUMERIC | Métrica | Estimated cost-per-thousand-impressions (eCPM) of CPM and CPC ads delivered by the ad servers including line item-level dynamic allocation. Corresponds to 'Total average eCPM' in the Ad Manager UI. Compatible with the 'Historical' report type. |
total_measurable_impressions | NUMERIC | Métrica | The total number of impressions that were sampled and measured by active view. Corresponds to "Total Active View measurable impressions" in the Ad Manager UI. Compatible with the 'Historical' report type. |
total_measurable_impressions_rate | NUMERIC | Métrica | The percentage of total impressions that were measurable by active view (out of all the total impressions sampled for active view). Corresponds to "Total Active View % measurable impressions" in the Ad Manager UI. Compatible with the 'Historical' report type. |
total_viewable_impressions | NUMERIC | Métrica | The total number of impressions viewed on the user's screen. Corresponds to "Total Active View viewable impressions" in the Ad Manager UI. Compatible with the 'Historical' report type. |
total_viewable_impressions_rate | NUMERIC | Métrica | The percentage of total impressions viewed on the user's screen (out of the total impressions measurable by active view). Compatible with the 'Historical' report type. |
totalcost | NUMERIC | Métrica | The 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. |
url_name | TEXT | Dimensão | Breaks down reporting data by URL name (the URL where the ad served). Corresponds to "URL" in the Ad Manager UI. Compatible with the "Historical" report type. |
video_viewership_average_view_rate | NUMERIC | Métrica | Average percentage of the video watched by users. |
video_viewership_average_view_time | NUMERIC | Métrica | Average time(seconds) users watched the video. |
video_viewership_complete | NUMERIC | Métrica | The number of times the video played to completion. |
video_viewership_completion_rate | NUMERIC | Métrica | Percentage of times the video played to the end. |
video_viewership_engaged_view | NUMERIC | Métrica | The number of engaged views i.e. ad is viewed to completion or for 30s, whichever comes first. |
video_viewership_first_quartile | NUMERIC | Métrica | The number of times the video played to 25% of its length. |
video_viewership_midpoint | NUMERIC | Métrica | The number of times the video reached its midpoint during play. |
video_viewership_start | NUMERIC | Métrica | The number of impressions where the video was played. |
video_viewership_third_quartile | NUMERIC | Métrica | The number of times the video played to 75% of its length. |
video_viewership_video_length | NUMERIC | Métrica | Duration of the video creative. |
video_viewership_view_through_rate | NUMERIC | Métrica | View-through rate represented as a percentage. |
week | TEXT | Dimensão | Week (Sun-Sat). |
week_day | TEXT | Dimensão | Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday. |
week_day_iso | TEXT | Dimensão | Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7 |
week_iso | TEXT | Dimensão | Week, ISO format (Mon-Sun). |
year | TEXT | Dimensão | Year |
year_month | TEXT | Dimensão | Year and month, e.g. 2024|3 |
year_month_name | TEXT | Dimensão | Year and month with the month name written out, e.g. "Jan 2025". |
year_of_week | TEXT | Dimensão | The year that contains first day of the week (Sun-Sat). |
year_of_week_iso | TEXT | Dimensão | The year that contains first day of the ISO week (Mon-Sun). |
year_week | TEXT | Dimensão | Year and week for US weeks (Sun-Sat), e.g. 2024|15 |
year_week_iso | TEXT | Dimensão | Year and week for ISO weeks (Mon-Sun), e.g. 2024|20 |