Combine connected sources into one Sheets, BigQuery, or Excel destination. Start from an ecommerce template for a fast store report, or build a custom blend.
Prerequisites
At least one connected data source (ads, analytics, or ecommerce)
A Google Sheets, BigQuery, or Excel destination already set up in SyncRange
Room under your plan’s exporter limit (each blend counts as one exporter)
Path A: Templates
From Exporters, click New Export, choose Data blend, then Templates. Two steps: setup, then review.
Setup — name, date range, template, accounts, destination, and schedule on one page.
Choose Build custom for a three-step builder (setup matches a normal data export, then tabs).
Step 1: Setup
Name and date range (max 90 days)
Sources — ecommerce, ads, and marketing accounts
Destination — Google Sheets, BigQuery, or Excel
Schedule — as allowed by your plan
Step 2: Tabs
Add custom tabs and pick sources and columns. Per tab you can set the name, append vs replace, and Combine by date. Pre-built templates are under the Templates path instead.
Step 3: Review and activate
Confirm everything, then activate. You can run immediately from the blend detail page.
What happens on each run
SyncRange resolves the date range from your preset (or custom dates).
For each active tab, it fetches daily data from that tab’s sources.
Missing days are filled with zeros so every source has a row for each day in range.
If Combine by date is on, sources for the same day are merged into one row.
All Stores tabs combine by date and currency so different currencies stay on separate rows.
Derived metrics (AOV, MER, Blended ROAS, CAC, and so on) are calculated.
Rows are written to the destination tab (replace or append).