Data Model Structure

Because Ad Revenue Insights is a product delivered through Workspaces, your key reporting needs should be satisfied through the boards detailed above. However, as you get more familiar with the tool, you have the option to leverage the data model underlying this reporting.

Most commonly, you will want to inject particular properties or metrics into existing tiles while in full-screen mode in order to provide additional granularity and insights. The documentation below details the Ad Revenue Insights data model so you are able to perform such operations.

Ad Revenue Insights data, like all Piano Analytics data, is classified in three categories:

Events: Events are the primary data points ingested into Piano Analytics. A pageview or an ad impression firing or a conversion are examples of events (an event, by nature, is a data point associated with a timestamp).

Properties: An event can have hundreds of pieces of metadata attached to it (for example, think of all the rich device, referrer, and geography data a pageview contains). Each piece of event metadata is a property.

Metrics: Piano uses the combination of events, properties, other metrics, and computational formulas (division, addition, multiplication, etc) to calculate out-of-the-box metrics. Examples of metrics include conversion rate and CPM.

Events

The following events are critical to Ad Revenue Insights:

Event	Description
Page.display	Event indicating a page has been displayed on-site or on a mobile/App screen. This event is essential to measure traffic correctly and is the origin of the "Page views" metric and associated properties.
Ad.impression	Event capturing all ad impressions on a given page, which is the key ad event in order to properly calculate advertising revenue and compute all associated metrics.

Properties

The following properties are implemented as part of the Ad Revenue Insights dataset. Properties should be seen as metadata that provide contextual information on your events.

Property Name	Property Key	Format	Description
Ad revenue	ad_revenue	DECIMAL	The revenue attributed to a specific impression.
Ad slot code	ad_slot_code	STRING	Ad container identifier as defined in your SSP.
Ad slot ID	ad_slot_id	STRING	Unique ad container identifier automatically attributed by the SSP.
Advertiser name	ad_advertiser_name	STRING	The advertiser shown on the ad.
Line item ID	ad_line_item_id	STRING	Line item identifier automatically attributed by the SSP to the campaign.
Line item name	ad_ line_item_name	STRING	User-defined line item label.
Line item type	ad_ line_item_type	STRING	Line item information defining how inventory will be sold and prioritized for the given campaign.
Creative ID	ad_creative_id	STRING	Creative identifier automatically attributed by the SSP to the creative.
Creative name	ad_creative_name	STRING	User-defined creative name.
Creative size	ad_creative_size	STRING	Dimensions of the creative displayed.
Creative type	ad_creative_type	STRING	Technical category of the displayed creative (Third-Party, Image, Custom Template...).
Header bidding	header_bidding	BOOLEAN	Information (yes/no) to know whether an ad impression was sold using header bidding.
Order name	ad_order_name	STRING	User-defined order label containing high level information about an ad campaign.
Pricing model	pricing_model	STRING	The unit of measurement of the transaction used for a specific campaign between an advertiser and publisher.
Page title	page_title_html	string	HTML title tag of the measured page.
User ID	user_id	string	Identifier of the visitor who has logged on to your site (user). This ID can be numeric or alphanumeric. Information within "visit" scope (only 1 value per visit)
Pageview ID	pageview_id	string	Identifier of page view. Information within the “event” scope (several possible values per visit).
Content author	content_authors	array string	Person who wrote the article.
Content publication date	content_publication_date	date	Article publication date.
Content section	content_section	string	Section is a collection of pages defined on the publisher structure under the content of the article.
Tags	tags_array	array string	Freely definable tags for the page, as provided by the publisher.
Page content type	page_content_type	string	Information on the measured page’s content. The main values are “article”, “website”, “video” taken from the HTML “og:type” tag within the page.

MetricsHere is a list of metrics included in the current Ad Revenue Insights analyses.

Source	Name	Key	Description	Calculation	Formula
Ad Revenue Insights	Ad revenue	m_ad_revenue	Revenue generated by on-site ads.	Sum of ad revenue.	SUM(ad_revenue where event=ad.impression AND pricing_model=CPM) + SUM(ad_revenue where event=ad.click)
Ad Revenue Insights	Ad impressions	m_ad_impressions	Number of ad impressions.	Count of the number of ad.impression events.	COUNT(CASE WHEN event_name = 'ad.impression')
	Pageview IDs	m_pageview_ids	Number of pageview IDs.	Distinct pageview IDs	count distinct pageview_id
Ad Revenue Insights	Ad impressions / pageview IDs	m_ad_impressions_per_pageviewid	Number of ad impressions per pageview IDs.	Ad impressions / distinct pageview IDs	(m_ad_impressions / m_pageview_ids )
Ad Revenue Insights	CPM	m_cpm	Revenue per 1000 ad impressions.	Ad revenue / ad impressions * 1000	(m_ad_revenue / m_ad_impressions) *1000
Ad Revenue Insights	RPM	m_rpm	Revenue per 1000 pageview IDs.	Ad revenue / distinct pageview IDs * 1000	(m_ad_revenue / m_pageview_ids )*1000
Ad Revenue Insights	RPS	m_rps	Revenue per 1000 visits.	Ad revenue / visits * 1000	(m_ad_revenue / m_visits )*1000
Ad Revenue Insights	Ad and new subscription revenue	m_ad_new_subscription_revenue	Revenue from ads and new subscriptions.	Ad revenue + new VX turnover	m_ad_revenue + m_vx_turnover_new
vx	VX payments	m_vx_payments	Visits with VX paid conversion(s).	Count of visits where goal type = “Payment Term Converted”.	count distinct visit_ID WHERE Goal Type = “Payment Term Converted”
vx	VX payment rate	m_vx_payment_rate	Proportion of visits with VX paid conversion(s).	VX payments / visits	(m_vx_payments / m_visits )
Ad Revenue Insights	Subscription RPM	m_subscription_rpm	New subscription revenue per 1000 pageview IDs.	New VX turnover / distinct pageview IDs * 1000	(m_vx_turnover_new / m_pageview_ids) *1000
Ad Revenue Insights	Articles	m_articles	Number of pages where page content type is “article”.	Distinct pages where page_content_type = “article”.	Count distinct page WHERE page_content_type = “article”.
Ad Revenue Insights	Page views / article	m_pageviews_per_article	Number of pageview IDs per article.	Distinct pageview IDs / articles	(m_pageview_ids / m_articles )
Ad Revenue Insights	Ad revenue / article	m_ad_revenue_per_article	Revenue from ads per article.	Ad revenue / articles	(m_ad_revenue / m_articles)
Ad Revenue Insights	New subscription revenue / article	m_new_subscription_revenue_per_article	Revenue from new subscriptions per article.	New VX turnover / articles	(m_vx_turnover_new / m_articles)
Ad Revenue Insights	VX payments / article	m_vx_payment_per_article	Visits with VX paid conversion(s) per article.	VX payments / articles	(m_vx_payments / m_articles)