Publisher Trends
Overview
The publisher_trends_quick_stats dataset contains data that is collected from other modules, that is stored in a performant, time-series table. The data that is included in the publisher_trends_quick_stats table is not unique - it can be found (often at a more granular level) in other tables within the application, such as the Wrappers or Audience Providers datasets.
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
Each publisher has a new publisher_trends_quick_stats object created daily, usually around 2230 EST.
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 found on the publisher. |
| ess_providers | array | Google Encrypted Signal partners found on the publisher’s domain |
| js_apis | array | JavaScript APIs or functionalities associated with the publisher. |
| auth_providers | array | Authorization or authentication providers found on the publisher. |
| absorption_rate | float | The rate at which identifiers are absorbed by SSPs into the bid stream. |
| consent_score | float | A score related to user consent, which determines overall Consent and privacy efficacy of the publisher. |
| 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 ads.txt resellers associated with the publisher. |
| ad_unit_refresh_timing | integer | Timing or frequency of ad unit refresh. |
| pub_controlled_traffic | integer | Traffic that is controlled or initiated by the publisher. |
| avg_ad_ratio | float | The average ads to content ratio (A2CR) |
| affiliate_providers | array | Providers of affiliate services or platforms associated with the publisher. |
| gpids_in_prebid | array | Google Publisher IDs in Prebid. |
| ad_unit_codes_in_prebid | array | Ad unit codes associated with Prebid, used by the publisher. |
| 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 was purchased by the publisher. |
| ad_slots_with_refresh | integer | Count of ad slots that have a refresh capability or feature. |