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)

---

ad_metrics_ad_impressions

Ad Impressions

Ad impressions

Data Source: ad_metrics_daily

Definition:

SUM(impressions)

---

ad_metrics_ad_clicks

Ad Clicks

Ad clicks

Data Source: ad_metrics_daily

Definition:

SUM(clicks)

---

ad_metrics_ad_reports

Ads Reported

Number of time ad was reported

Data Source: ad_metrics_daily

Definition:

SUM(reports)

---

revenue

Revenue

Ad revenue

Data Source: ad_metrics_daily

Definition:

SUM(revenue)

---

milli_impressions

Milli Impressions

Impressions in thousands

Data Source: ad_metrics_daily

Definition:

SUM(impressions)/1000

---