Ads

metric-hub

Pre-defined metrics for ads. These metrics are defined in metric-hub

amp_avg_cpc

Average Publisher CPC

Average cost per click (paid to Mozilla, in USD). Calculated as CPC payout divided by valid clicks.

Data Source: admarketplace

Definition:

AVG(avg_pub_cpc)

SQL with DataSource

SELECT
  AVG(avg_pub_cpc)
FROM (
  mozdata.ads.admarketplace
)

---

amp_revenue

Revenue

Total amount paid to Mozilla in USD.

Data Source: admarketplace

Definition:

SUM(revenue)

SQL with DataSource

SELECT
  SUM(revenue)
FROM (
  mozdata.ads.admarketplace
)

---

amp_valid_clicks

Total Valid Clicks

Total number of valid clicks recorded.

Data Source: admarketplace

Definition:

SUM(valid_clicks)

SQL with DataSource

SELECT
  SUM(valid_clicks)
FROM (
  mozdata.ads.admarketplace
)

---

amp_valid_impressions

Total Valid Impressions

Total number of valid impressions recorded.

Data Source: admarketplace

Definition:

SUM(valid_impressions)

SQL with DataSource

SELECT
  SUM(valid_impressions)
FROM (
  mozdata.ads.admarketplace
)

---

amp_cpc_rate

CPC Rate

Calculated as total payout divided by the number of valid clicks. Returns NULL if number of billed clicks is zero.

Data Source: admarketplace

Definition:

SAFE_DIVIDE(SUM(revenue), SUM(valid_clicks))

SQL with DataSource

SELECT
  SAFE_DIVIDE(SUM(revenue), SUM(valid_clicks))
FROM (
  mozdata.ads.admarketplace
)

---

amp_revenue_per_thousand_impressions

Revenue Per Thousand Impressions

RPM Payout divided by the number of valid impressions times 1000. Returns NULL if number of valid impressions is zero.

Data Source: admarketplace

Definition:

SAFE_DIVIDE(SUM(revenue), SUM(valid_impressions)) * 1000

SQL with DataSource

SELECT
  SAFE_DIVIDE(SUM(revenue), SUM(valid_impressions)) * 1000
FROM (
  mozdata.ads.admarketplace
)

---

ad_metrics_ad_impressions

Ad Impressions

Ad impressions

Data Source: ad_metrics_daily

Definition:

SUM(impressions)

SQL with DataSource

SELECT
  SUM(impressions)
FROM (
  mozdata.ads.ad_metrics_daily
)

---

ad_metrics_ad_clicks

Ad Clicks

Ad clicks

Data Source: ad_metrics_daily

Definition:

SUM(clicks)

SQL with DataSource

SELECT
  SUM(clicks)
FROM (
  mozdata.ads.ad_metrics_daily
)

---

revenue

Revenue

Ad revenue

Data Source: ad_metrics_daily

Definition:

SUM(revenue)

SQL with DataSource

SELECT
  SUM(revenue)
FROM (
  mozdata.ads.ad_metrics_daily
)

---

milli_impressions

Milli Impressions

Impressions in thousands

Data Source: ad_metrics_daily

Definition:

SUM(impressions)/1000

SQL with DataSource

SELECT
  SUM(impressions)/1000
FROM (
  mozdata.ads.ad_metrics_daily
)

---