Explore & custom fields

Explore is the query builder behind every SpendMix surface — the same query you preview here can be downloaded as CSV, pushed to a destination, scheduled, or served over the API.

• Source & level — pick a platform and a granularity (account, campaign, ad — varies per source).
• Fields — metrics and dimensions from the field catalog (GA4 alone exposes 300+, including your custom dimensions).
• Breakdowns — split rows by date, campaign, device, country and more.
• Date range — a preset (last_7d, last_30d, this_month…) or explicit start/end dates.
• Accounts — all selected accounts, a single one, or an account group (client).

Click + Add custom field to define a metric as a formula over existing fields. Formulas support arithmetic, parentheses and functions like if, coalesce and safe_divide; division by zero yields an empty cell rather than an error.

cpm_custom = spend / impressions * 1000
profit     = purchase_value - spend
true_cpa   = safe_divide(spend, conversions)

Custom fields flow with the query — into the results table, CSV downloads and the REST API (via the custom parameter).

Save stores the full query — source, level, fields, breakdowns, dates, accounts and custom fields — under a name. Saved queries power scheduled destination pushes, and the Saved dropdown restores one in a click.

• Blended view — the cross-channel page normalizes currencies and shows period-over-period deltas on every KPI.
• Partial-data warnings — if some accounts fail or a platform truncates a pull, an amber strip names exactly what is missing instead of silently showing a smaller total.