Skip to content
+

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

MetricHow it is computed
Blended ROASShopify net revenue ÷ Google Ads spend, same period
Platform-reported ROASGoogle Ads conversion value ÷ ad spend
Ad-reported vs actual revenue gapReported conversion value − net revenueIf a large gap persists, check your conversion tags.
Net profit after fees and adsContribution 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.

MetricDefinitionUnit
Net revenueLine value after line discounts and allocated order vouchers, minus refunds to buyers. Refunds are deducted only here.Currency
Ad spendTotal advertising cost by report date. Filtering by channel or platform uses the destination channel the ads drive traffic to.Currency
Blended ROASActual net revenue divided by ad spend for the same channel and period.= Net revenue / Ad spendNumber
Platform-reported ROASAd-platform-reported revenue divided by ad spend.= ad_conversion_value / Ad spendNumber
Ad-reported vs actual revenue gapAd-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 revenueCurrency
Net profit after fees and adsNet revenue received minus COGS, marketplace fees, payment fees, shipping, return costs and advertising.= Contribution margin - allocated_ad_spendCurrency

Questions you can answer

QuestionGoogle Ads onlyShopify + Google Ads combined
Revenue from ads?Conversion value from Google's modelNet revenue after discounts and refunds
What is my ROAS?Reported ROASBlended ROAS and the gap
Does the campaign make money?Cost and fees unknownNet profit after fees and ads

Steps

  1. 1

    Connect Shopify

    Enter your shop name and the access token of a custom app with read access to orders, products and customers.

  2. 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. 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. 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 Shopify and Google Ads in minutes

Free plan with no time limit · No card required · Sample workspace ready in minutes