Tabs and templates

Each blend writes one or more tabs to your destination. Tabs can use a pre-built template or a fully custom column set.

Ecommerce templates (quick start)

When you create a new blend you can start from an ecommerce template. SyncRange pre-selects matching stores and ad accounts. You only need a destination and schedule, then review.

  • This store — Daily sales for one store
  • This store + ads — Daily Performance (spend vs net sales) plus platform Campaigns
  • All my stores — By Store and All Stores rollups
  • All my stores + ads — Multi-store tabs plus company-level Daily Performance

Templates you cannot use yet stay visible with a short reason (for example, All my stores needs two or more connected stores). Etsy and Amazon stores are included alongside Shopify.

Ecommerce Daily columns

Used by This store and the By Store / All Stores tabs.

Columns: Date, Store, Currency, Gross Sales, Discounts, Refunds, Net Sales, Shipping, Taxes, Total Sales, Orders, AOV, Units, New Customer Orders, Returning Customer Orders

By Store also includes Store ID. All Stores drops Store / Store ID and keeps Currency so mixed-currency stores are not summed together.

Metric definitions

  • Gross Sales / Discounts / Shipping / Taxes / Total Sales — From the store order on the order date (Shopify).
  • Refunds — Attributed to the refund date, matching Shopify Admin sales reports.
  • Net Sales — Gross Sales − Discounts − Refunds (for that day).
  • AOV — Net Sales ÷ Orders. Blank when Orders is zero.
  • New / Returning Customer Orders — Based on the customer’s order count on Shopify (1 = new).
  • MER / Blended ROAS — Net Sales ÷ Ad Spend. Same formula. Blank when spend is zero.
  • Blended CAC — Ad Spend ÷ New Customer Orders. Blank when new customer orders is zero.
  • Platform ROAS — Platform conversion value ÷ spend. Campaign rows are platform-reported and are not joined to store orders.

Etsy and Amazon contribute revenue/orders (and net sales mirrored from revenue) where available. Shopify-only columns stay blank for those sources.

Currency on All Stores

When every selected store uses the same currency, daily totals are summed. If currencies differ, SyncRange writes one row per date per currency. There is no automatic FX conversion.

More templates

These live under New Blend → Templates → More templates (not in the custom Tabs step). Existing blends that already use them keep their saved column lists.

Cross-Channel Ads

Daily paid media performance across ad platforms.

Sources: Meta Ads, Google Ads, TikTok Ads, LinkedIn Ads, Bing Ads

Columns: Date, Source, Campaign, Spend, Impressions, Clicks, CPC, CPM, CTR, Conversions, Conversion Value, ROAS

Social Media

Social ad delivery and spend.

Sources: Meta Ads, LinkedIn Ads, TikTok Ads

Columns: Date, Source, Impressions, Clicks, Spend, Followers

Ecommerce Overview

Store sales by day (classic columns).

Sources: Shopify, Etsy, Amazon Seller

Columns: Date, Source, Revenue, Orders

Ecommerce ROI

Ad spend alongside store revenue for ROI-style reporting (classic columns).

Sources: Meta Ads, Google Ads, TikTok Ads, LinkedIn Ads, Bing Ads, Shopify, Etsy, Amazon Seller

Columns: Date, Source, Spend, Revenue, Orders, ROAS, CAC

GA4 + Ads Funnel

Analytics sessions and users with ad spend and conversions.

Sources: GA4, Meta Ads, Google Ads, TikTok Ads, LinkedIn Ads, Bing Ads

Columns: Date, Source, Sessions, Users, Spend, Conversions, Conversion Rate, CAC

Channel Comparison

Monthly rollup by channel (not daily).

Sources: Meta Ads, Google Ads, TikTok Ads, LinkedIn Ads, Bing Ads

Columns: Month, Source, Spend, Impressions, Clicks, Conversions, ROAS

Custom tabs

Custom tabs let you choose:

  • Sources for this tab — any subset of the blend’s sources
  • Columns — only fields available from the selected sources appear in the picker
  • Tab name — the worksheet or table name in the destination
  • Append data and Combine by date — same options as templates

Row layout

Default (combine off): one row per source per day. Example: Google Ads and Shopify for 30 days → 60 rows.

Combine by date on: one row per day, with sources listed comma-separated in the Source cell and metrics summed. Example: same blend → 30 rows.

Quiet days still get a row (metrics as zero) so the date series is complete for every source.

Something missing on this page? Email [email protected]

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