Use case: do you want to see your Salesforce Commerce Cloud (SFCC) sales, or any data from your back office, or internal reports, next to your media, analytics and measurement data? Here is how to bring it into spyne with a Google Sheet and cross it with your other sources in the same report.
1. Prepare your Google Sheet
Export the SFCC data you want to follow into a Google Sheet, at the granularity you need:
Date | Country | Channel | Orders | Revenue |
2026-11-01 | France | Paid Search | 120 | 9 800 |
2026-11-01 | Germany | Paid Social | 85 | 6 400 |
Date is always required (per day, per week…).
Add the breakdown columns you want to analyze: country, channel, campaign, product category…
Add one column per metric: orders, revenue, visits…
💡 Share the sheet as Viewer with [email protected].
2. Connect and map the sheet
Add the Google Sheet as a data source in spyne (see Google Sheet Import), then map the columns:
Sheet column | spyne field |
Date | Date |
Breakdown (country, channel, campaign…) | A spyne level such as Campaign Name |
Metrics (orders…) | Conversions. |
Map your breakdown columns to spyne levels that can be used in your Custom Dimensions: this is what lets you cross the data with your other sources in step 4.
⚠️ Map your SFCC metrics as conversions, not to native media metrics (Spend, Impressions, Clicks…), so they stay separate from your media data.
Your data shows in reports from the day after the source is created.
3. Create your Custom Conversions
Create a Custom Conversion on the Google Sheet source for each metric you want to use, with an explicit name, e.g. SFCC Orders and SFCC Revenue.
For the detailed setup, see Custom Conversions.
4. Add the source to your dimensions
In your Custom Dimensions (Country, Channel…), add a rule for the Google Sheet source, with the same output values as your other sources. Your SFCC data then falls into the right "bucket" of each dimension, next to your media data.
5. Cross everything in your reports
Once your dimensions are blended, use them in your reports to see your SFCC data side by side with your media data. If the same dimensions are also blended on your Analytics, Ad Server or Measurement sources, you can cross all of them in one view (see Data Blending).
You can then create the KPIs you need with Custom Calculated Metrics, for example:
Cost of Sale (COS) = Spend / SFCC Revenue
Average Order Value = SFCC Revenue / SFCC Orders
Conversion rate = SFCC Orders / Sessions
Need help setting this up? Contact us at [email protected].