Ads to Content Ratio (A2CR)
Overview
The ad_ratios dataset contains data about the different Ads to Content Ratio (A2CR) values of a publisher, alongside the in view data. The data that is copied over to the publisher_trends_quick_stats for ease of use and trend data across the entire publisher.
The publisher_trends_quick_stats table is intended to be used for quick, high-level analysis of Publisher trends, and is not intended to be used for detailed analysis.
Frequency
Created or updated with each visit of a Synthetic User to a given domain / publisher.
Dataset
| Field | Type | Description |
|---|---|---|
| id | integer | unique identifier that applies to specific publisher trend row. |
| publisher_id | integer | foreign key of the publisher that trend counts belong to. |
| date | date | The date associated with the record. |
| identifiers | array | Array of strings, using the friendly name of identifiers found on the publisher in the last 90 days, across Header Bidding Wrappers and Direct Publisher Integrations |
| audience_providers | array | String array of the different Audience Providers found on the publisher’s environment. |
| wrappers | array | Array of strings of the unique Header Bidding Wrappers found on the publisher’s environment in the last 90 days. |
| created_at | datetime | Date the record was created. |
| updated_at | datetime | The last time the record was updated |
| ssp_adapters | array | Supply-Side Platform adapters associated with the record. |
| ess_providers | array | Providers associated with an ESS (Exact Service Selector) or a similar service. |
| js_apis | array | JavaScript APIs or functionalities associated with the record. |
| auth_providers | array | Authorization or authentication providers related to the record. |
| absorption_rate | float | The rate at which something (like an ad) is absorbed or viewed by users. |
| consent_score | float | A score related to user consent. |
| percentage_of_ad_slots_with_refresh | float | The percentage of ad slots that have a refresh capability or feature. |
| average_refresh_rate | float | The average rate at which ad slots are refreshed. |
| total_supply_paths | integer | The total number of paths or routes through which ads can be supplied. |
| reseller_count | integer | The number of resellers associated with the record. |
| ad_unit_refresh_timing | integer | Timing or frequency of ad unit refresh. |
| pub_controlled_traffic | integer | Traffic that is controlled or managed by the publisher. |
| avg_ad_ratio | float | The average ratio of ads. |
| affiliate_providers | array | Providers of affiliate services or platforms associated with the record. |
| gpids_in_prebid | array | Google Publisher IDs in Prebid. |
| ad_unit_codes_in_prebid | array | Ad unit codes associated with Prebid. |
| ad_unit_paths_in_aps | array | Paths or identifiers for the ad unit in Amazon Publisher Services (APS). |
| ad_element_ids_in_aps | array | Identifiers for ad elements in Amazon Publisher Services (APS). |
| ad_unit_path_in_gam | array | Path or identifier for the ad unit in Google Ad Manager (GAM). |
| ad_element_ids_in_gam | array | Identifiers for ad elements in Google Ad Manager (GAM). |
| paid_traffic_sources | array | Sources from which paid traffic is derived. |
| ad_slots_with_refresh | integer | Number of ad slots that have a refresh capability or feature. |