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)

---

amp_revenue

Billed Revenue

Total amount paid to Mozilla in USD.

Data Source: admarketplace

Definition:

SUM(billed_revenue)

---

amp_valid_clicks

Total Valid Clicks

Total number of valid clicks recorded.

Data Source: admarketplace

Definition:

SUM(valid_clicks)

---

amp_valid_impressions

Total Valid Impressions

Total number of valid impressions recorded.

Data Source: admarketplace

Definition:

SUM(valid_impressions)

---

amp_rpm_rate

RPM Rate

Average revenue per thousand impressions (paid to Mozilla, in USD), calculated as RPM payout divided by valid impressions times 1000.

Data Source: admarketplace

Definition:

AVG(rpm_rate)

---

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(billed_revenue), SUM(valid_clicks))

---

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(billed_revenue), SUM(valid_impressions)) * 1000

---

amp_alternative_revenue

Alternative Revenue

Potential Revenue from the other report. Note that this is zero for all revenue coming from CPC since we don't get data for RPM for mobile tiles or instant suggestions.

Data Source: admarketplace

Definition:

SUM(alternative_revenue)

---