Customise the Sheet export
Each destination is its own shape. Pick dimensions and metrics, choose a time grain, filter to specific accounts or campaigns, and your Sheet rewrites on the next push.
What you can customise
A destination’s export config has four moving parts:
- Group by— Day, Week, Month, or Year. Controls the time grain of each row when the Date dimension is included
- Dimensions— which columns identify each row (Date, Platform, Account, Campaign). Excluded dimensions cause the rows to collapse across that axis
- Metrics— which value columns appear (built-ins plus any custom metrics you’ve defined)
- Filters— restrict to specific accounts and/or campaigns. Empty means “all”
The mode (REPLACE / APPEND), date range, and platform filter stay on the destination card itself — they were always there. Customise export adds the four above.
Where to find it
- Open /app/connections/google-sheets
- Find the destination card you want to customise
- Click Customise export— lands you on a dedicated page for that destination
The card itself shows a summary chip with the current shape (e.g. Group by: month · Dimensions: date, platform · Metrics: 5 columns) so you can see at a glance what each destination is configured to push.
Group by
Pick the time grain for each row in the Sheet:
- Day— one row per date. Default; matches the original Crowflow behaviour
- Week— one row per ISO week (Mon-start, ISO-numbered). e.g.
2026-W23 - Month — one row per calendar month. e.g.
2026-06 - Year— one row per calendar year
Group by only matters when the Date dimension is included. If you uncheck Date, the time axis is collapsed entirely and Group by has no effect on the output.
Dimensions
The four dimensions tell Crowflow what makes each row unique. Tick the ones you want as columns. The order in the header is canonical (Date, Platform, Account, Campaign) regardless of the order you tick them.
Excluding a dimension collapses the rows across that axis. For example:
- Date + Platform + Campaign— one row per (date, platform, campaign). Account-level detail is summed in
- Date + Platform only— one row per (date, platform). All campaigns and accounts within that (date, platform) are summed into one row
- Platform only— one row per platform. Spend / clicks / impressions are summed across the whole date window. Useful for headline numbers on one tab
- No dimensions— one grand-total row per currency. Niche but works
Metrics
Two groups in the picker:
- Built-in: Impressions, Clicks, Conversions, Spend, CTR, CR, CPC, CPA
- Custom: any metric you’ve defined in Custom metrics. The list updates live — define a new metric and it appears here on the next page load
Tick the ones you want as columns. Like dimensions, the order in the header is canonical (built-ins in their listed order, then custom metrics in alphabetical order) regardless of tick order.
A + New custom metric shortcut in the section header jumps you to /app/settings/metrics if you want to define something on the fly.
Filters
Two multi-select pickers, both with search:
- Accounts— restrict to specific ad accounts. Each entry shows the platform underneath (Google Ads, Microsoft Ads, Meta Ads) so you don’t pick the wrong one
- Campaigns— restrict to specific campaigns. Each entry shows its parent account underneath
Empty filter = no restriction (include all). Clear / Pick all shortcuts are in the dropdown header.
Column preview
At the bottom of the page, a live preview shows the exact header that’ll be written to your Sheet. Dimension columns appear first (in Ink), then metric columns (charcoal), then Currency at the very end (mist).
The preview updates as you toggle dimensions and metrics, so you can confirm the shape before saving.
The Currency column
Crowflow always appends a Currency column at the end of every export. It’s neither a dimension nor a metric — it’s row-level context for the spend-related numbers.
You can ignore it if you don’t need it. It exists because:
- We don’t prefix Spend, CPC, CPA, or currency-formatted custom metrics with a symbol in the export — those are written as plain numbers so your Sheet formulas work
- Mixed-currency workspaces need to know which currency each row is in. Currency on every row lets you write Sheet formulas that filter or convert
APPEND mode & the Date dimension
APPEND mode requires the Date dimension. Crowflow uses a composite key per row to detect “have I already pushed this row?” — the key is built from the included dimensions. Without Date, every push would write what it thinks is the same aggregate, and dedup would silently lose data.
The customise UI shows the Date checkbox as locked-on when mode is APPEND. If you switch from REPLACE to APPEND with Date unchecked, the save action force-adds Date back so you don’t accidentally break dedup.
Worked examples
Three common shapes and how to configure them.
Monthly platform summary
One row per (month, platform). Five number columns. Good for a client-facing one-page tab.
- Group by: Month
- Dimensions: Date, Platform
- Metrics: Impressions, Clicks, Conversions, Spend, CTR, CR
- Filters: leave empty (include all)
- Mode: REPLACE (each push gives a fresh month-by-month view)
Daily campaign detail, one client, one platform
One row per (date, campaign) for a specific Google Ads account. The shape that lets a client dig into day-by-day campaign performance.
- Group by: Day
- Dimensions: Date, Campaign
- Metrics: Impressions, Clicks, Conversions, Spend, CTR, CR, CPC, CPA (and any relevant custom ones)
- Filters: pick the one Google Ads account under Accounts. Leave Campaigns empty to include them all
- Platforms filter (on the card): Google Ads only
- Mode: APPEND if archival, REPLACE if rolling
Yearly ROAS by campaign
One row per (year, campaign). Custom ROAS metric front-and- centre. Useful for an annual review.
- Group by: Year
- Dimensions: Date, Campaign
- Metrics: Spend, Conversions, ROAS (a custom metric defined as
conversions / spend) - Filters: leave empty
- Mode: REPLACE