Campaign metrics breakdown
Per-day metrics broken down by country. One row per
(report_date, campaign_id, country_code). Can be large, so results
are paginated.
Row schema: campaign_country_daily v1.0 — the same schema used
in JSONL bulk exports. Rows are idempotent on the primary key
(provider, account_id, report_date, campaign_id, country_code);
re-ingesting is safe.
Mutability window: rows for a given report_date can be revised
for up to 7 days after the date closes due to delayed events from
Meta and Spotify. Re-fetch or re-ingest accordingly.
Maps to the Countries tab in the Soundlink Insights UI. Use for daily warehouse loads.
Requires the metrics:read scope. Accepts API key or OAuth Bearer.