Data Blends

What is a Data Blend?

A Data Blend pulls metrics from several sources (ads, analytics, and ecommerce), normalizes them into common fields (spend, revenue, sessions, and so on), and writes one or more tabs to Google Sheets, BigQuery, or Excel.

Unlike a single-platform exporter, a blend is designed for cross-channel reporting: one sheet can include Google Ads and Shopify side by side, or Meta and GA4 on the same date grain.

How blends differ from exporters

• Multiple sources — one blend can include ads, analytics, and store data together.
• Shared schema — all sources map into the same field names so columns line up.
• Tabs — each blend has one or more tabs (templates or custom) written to the destination.
• Combine by date — optional merge of all sources into one row per day.

Each active blend counts as one exporter toward your plan limit. Rows written count toward your monthly row cap, same as other exports.

Supported sources

Sources must already be connected in SyncRange before you can add them to a blend.

Destinations

• Google Sheets — one worksheet tab per blend tab
• Google BigQuery — tables written to your dataset
• Microsoft Excel — workbook tabs (via your Microsoft connection)

Guides in this section

• Create a Data Blend — step-by-step builder walkthrough
• Tabs and templates — pre-built and custom tabs
• Field reference — every column and what it means
• Blend settings — date range, combine by date, append, schedule
• Manage blends — edit, run, pause, and logs