Ad Ratios

Overview

This dataset reflects metadata related to several ad viewability stats (i.e. min and max ad units in view). This data can be joined to the publishers dataset to derive ad density aggregations by publisher integration. This is also aggregated with time-series trends in the publisher_trends_quick_stats dataset.

Dataset

Field	Type	Description
id	integer	Unique identifier that applies to the ad ratio instance.
resolution_id	integer	Unique identifier for the given resolution of the publisher’s page.
scroll_depth	integer	Details the depth that was scrolled on the Sincera scan.
avg_ads_to_content_ratio	float	Average number of ads in relation to content (A2CR) within a given publisher page.
avg_ads_units_in_view	float	Average number of units seen in the viewport.
max_ads_units_in_view	integer	Max number of units seen in the viewport.
created_at	datetime	Date when the scan was first generated by the Sincera platform.
updated_at	datetime	Date when the scan was last updated by the Sincera platform.
last_detected	datetime	The last time the page was scanned by the Sincera platform.
detailed_results	jsonb	Provides detailed metadata on the ad ratio metrics (i.e. `avg_ads_to_content_ratio`) for each ad slot and ad unit detected on the page.
publisher_id	integer	Maps to the `publisher_id` primary key in the publishers dataset.
max_ads_to_content_ratio	float	Provides max value of A2CR seen when scrolling the page.
min_ads_to_content_ratio	float	Provides min value of A2CR seen when scrolling the page.
is_homepage	boolean	Detects whether the page being scanned is a publisher’s home page.