ads

GET /v1/ads/analytics/export

One analytics table as CSV or XLSX, every row (za-286).

All ads endpoints

All developer docs →

Zinn®, our Viking, hammering at his anvil beside an API endpoint sending events to several listeners.

Authentication

Send an API key as a bearer token. The key must carry the ads.view permission; a key without it is refused with 403, not 404.

Where your organisation id goes

This endpoint takes org_id as a query parameter. Leave it out and the call covers your whole tenancy subtree; send it to narrow the call to one organisation.

Your organisation id is on the API keys screen in your dashboard, beside the key itself. It is the same id in every call you make.

Try it

Replace anything in angle brackets with your own values, and the key placeholder with a key from your dashboard.

curl -X GET https://api.zinndigital.com/v1/ads/analytics/export \
  -H "Authorization: Bearer zdk_live_…"

Signed in? The API console in your dashboard fills in your real organisation id and your own key, and runs the request against the live API so you can see the actual response. Open this endpoint in the API console

Details

Gated on ads.view, over the same filters as the analytics reads. table: breakdown (the leaderboard, grouped by by), currencies, truth (network-reported vs measured conversions per account), impact_changes, impact_fraud, impact_waste or impact_refunds. EVERY row is written, streamed - the page's 25-row page and the panels' latest 20 are page sizes, not export sizes. Column names are in locale; each money column is written twice, formatted in locale and as an integer in MINOR units of the stated currency (... (minor units)); ratios are plain numbers (ROAS 3.25, CTR in per cent). CSV is UTF-8 with a byte-order mark and guards formula-like cells with a leading apostrophe; XLSX is right to left for Arabic and Hebrew. Throttled per caller (ads_analytics_export, 600 per hour). A bad table or file answers 422 exportTable.

Parameters

NameTypeRequiredWhat it is
org_id (query)stringNo—
table (query)string<breakdown, currencies, truth, impact_changes, impact_fraud, impact_waste, impact_refunds>No—
file (query)string<csv, xlsx>No—
by (query)string<network, connection, campaign, country, device, offering, client>No—
locale (query)stringNo—
range (query)string<7d, 30d, 90d, ytd, 12m, custom>NoThe period. custom takes from and to.
from (query)stringNo—
to (query)stringNo—
compare (query)string<previous, year, none>No—
grain (query)string<day, week, month>NoBucket size. Default day up to 92 days, week up to 366, month beyond.
network (query)stringNoComma-separated networks (google, microsoft, meta, linkedin, tiktok, x, pinterest, amazon).
connection (query)stringNoComma-separated ad-account connection ids.
campaign (query)stringNoComma-separated <connection_id>:<campaign_id> tokens.
country (query)stringNoComma-separated ISO 3166-1 alpha-2 codes. Reads the country-level figures.
device (query)stringNoComma-separated devices: mobile, desktop, tablet, tv, other (za-282). Reads the device-level figures (Google Ads accounts, campaign grain). No stored level is split by…
offering (query)stringNoComma-separated product/site ids (za-290), or unassigned.
client (query)stringNoza-287: comma-separated client organisation ids. The read narrows to each client and its own clients, so an agency sees the same screen for one client. A client the caller cannot…
currency (query)stringNoReporting currency (ISO 4217). Default the one currency in play, else the organisation's.

Errors this endpoint can return

401 · 403 · 404 · 422 · 429