Combine Shopify with Google Ads to see the blended ROAS of your search ads
Google Ads reports conversion value from its conversion tags and attribution model; Shopify holds the real orders, refunds and discounts. The two numbers rarely match. Combine them in DataxLand and Google Ads spend by day and campaign sits next to Shopify net revenue after discounts and refunds, giving you blended ROAS, the gap between what Google reports and the real figure, and profit after ads when cost of goods is available. You set Search, Shopping and Performance Max budgets based on the money that actually reaches your store.
Free plan with no time limit · No card required · Sample workspace ready in minutes
Why combine
- Google's attribution model and conversion window can count one order for several campaigns.
- Refunds and discounts only exist in Shopify; ROAS on the original order value is always higher than reality.
- With product cost from Shopify or a file, you see right away which campaigns lose money after ads.
Metrics you only get by combining
| Metric | How it is computed |
|---|---|
| Blended ROAS | Shopify net revenue ÷ Google Ads spend, same period |
| Platform-reported ROAS | Google Ads conversion value ÷ ad spend |
| Ad-reported vs actual revenue gap | Reported conversion value − net revenueIf a large gap persists, check your conversion tags. |
| Net profit after fees and ads | Contribution margin − allocated ad spendPayment fees come from Shopify transactions; cost of goods from Shopify or an added file. |
Standard metrics from the analytics packs
Once both sources map to the same model, these metrics run on the joined data with one definition.
| Metric | Definition | Unit |
|---|---|---|
| Net revenue | Line value after line discounts and allocated order vouchers, minus refunds to buyers. Refunds are deducted only here. | Currency |
| Ad spend | Total advertising cost by report date. Filtering by channel or platform uses the destination channel the ads drive traffic to. | Currency |
| Blended ROAS | Actual net revenue divided by ad spend for the same channel and period.= Net revenue / Ad spend | Number |
| Platform-reported ROAS | Ad-platform-reported revenue divided by ad spend.= ad_conversion_value / Ad spend | Number |
| Ad-reported vs actual revenue gap | Ad-platform-reported revenue minus actual net revenue for the same channel and period. Positive means the platform reports more than reality.= ad_conversion_value - Net revenue | Currency |
| Net profit after fees and ads | Net revenue received minus COGS, marketplace fees, payment fees, shipping, return costs and advertising.= Contribution margin - allocated_ad_spend | Currency |
Questions you can answer
| Question | Google Ads only | Shopify + Google Ads combined |
|---|---|---|
| Revenue from ads? | Conversion value from Google's model | Net revenue after discounts and refunds |
| What is my ROAS? | Reported ROAS | Blended ROAS and the gap |
| Does the campaign make money? | Cost and fees unknown | Net profit after fees and ads |
Steps
- 1
Connect Shopify
Enter your shop name and the access token of a custom app with read access to orders, products and customers.
- 2
Connect Google Ads
Enter your Google Ads credentials (developer token, client ID, client secret, refresh token) and customer ID; keys are encrypted when stored.
- 3
Review Si's mapping
Si proposes how spend joins your website channel by day, and by product if Shopping campaigns carry product codes; you approve.
- 4
Build and read the dashboards
The Ads dashboard shows reported ROAS next to blended ROAS by campaign; set an alert when the gap crosses a threshold.
Frequently asked questions
Are Performance Max campaigns read?
DataxLand reads the spend and conversions the Google Ads API returns for your account, including Performance Max at campaign level. Product-level detail depends on what the API provides.
Where do I get Google Ads credentials?
You need a developer token from a manager account, a Google Cloud OAuth client and a refresh token with read access. The Google Ads connector guide has the detailed steps; keys are encrypted when stored.
Which plan can combine two sources?
The Free plan accepts a single Excel file. Combining two or more sources needs the Starter plan (up to 3 sources) or above; see pricing for the number of sources and the refresh schedule of each plan.
Dashboard templates that use this source
Connect Shopify →Connect Google Ads →Ask Si about your Shopify data →Ask Si about your Google Ads data →
Other combinations
- Combine QuickBooks with Shopify to reconcile your books with channel revenue
- Combine Shopify with Facebook Ads to see profit after advertising
- Combine Shopify with Google Analytics 4 to connect traffic with real revenue
- Combine Zendesk with Shopify to measure support tickets per 100 orders
- Combine BigQuery with Google Ads to measure ROAS on your own warehouse data
- Combine HubSpot with Google Ads to see which keywords bring real customers
Combine Shopify and Google Ads in minutes
Free plan with no time limit · No card required · Sample workspace ready in minutes