Create a Data Blend

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.

  1. Setup — name, date range, template, accounts, destination, and schedule on one page.
  2. Review and activate.

Tab layouts and metric definitions are in Tabs and templates.

Path B: Build custom

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

  1. SyncRange resolves the date range from your preset (or custom dates).
  2. For each active tab, it fetches daily data from that tab’s sources.
  3. Missing days are filled with zeros so every source has a row for each day in range.
  4. If Combine by date is on, sources for the same day are merged into one row.
  5. All Stores tabs combine by date and currency so different currencies stay on separate rows.
  6. Derived metrics (AOV, MER, Blended ROAS, CAC, and so on) are calculated.
  7. Rows are written to the destination tab (replace or append).

Something missing on this page? Email [email protected]

Start syncing your ecommerce data in minutes Start free today. No credit card required.