Exporting Report Data
How to download your site's revenue data as CSV — file format, column definitions for the daily series and demand source breakdown, and known limitations.
The revenue report for each site includes a CSV export button that downloads all data for the selected date range as a spreadsheet-compatible file. This article describes the export format, how to use the data, and any limitations.
How to export
- Open a site's reporting page (Dashboard → [site name] → Reporting).
- Set your desired date range using the preset buttons or the custom date picker.
- Click the Export CSV button in the top-right corner of the report.
The file downloads immediately — there is no email or delayed job. The filename is formatted as {domain}-advlume-report-{from}-to-{to}.csv.
File format
The CSV is UTF-8 encoded with standard comma delimiters. It contains two sections separated by an empty row.
Section 1: Daily series
| Column | Description |
|---|---|
date | Calendar date (YYYY-MM-DD) |
impressions | Total ad impressions on that day |
revenue_usd | Gross revenue in USD (6 decimal places) |
ecpm_usd | Effective CPM for that day, or blank if zero impressions |
Every calendar day in the selected range appears as a row, including days with zero impressions.
Section 2: Demand sources
After an empty row and a # demand_sources comment line:
| Column | Description |
|---|---|
channel_key | Internal channel identifier (e.g. google_ad_manager, magnite) |
label | Human-readable channel name |
revenue_usd | Total revenue for this channel in the period |
impressions | Total impressions for this channel |
share_of_revenue_pct | Percentage of total revenue attributable to this channel |
ecpm_usd | Effective CPM for this channel, or blank if zero impressions |
Channels are sorted by revenue descending.
Limitations
- Today's data is an estimate. Any rows for today contain Prebid intraday estimates, not finalised GAM figures. These are updated the next morning.
- One site at a time. The export covers a single site for the selected range. To combine data across multiple sites, download each separately and merge in your spreadsheet tool.
- Channel data may be incomplete for old dates. Channel-level breakdown data is sourced from the edge database, which retains Prebid win history. Very old periods may show zero channel data even if total revenue is non-zero.
Further reading
- Reading Your Revenue Report — the full reporting interface guide
- Key Metrics Explained — definitions of every column in the export
- How Revenue is Calculated — why today's revenue figures update overnight
Last updated 2 months ago