Skip to content
+

Combine Shopify with Facebook Ads to see profit after advertising

For Shopify stores, Facebook and Instagram Ads are often the biggest spending channel. The pixel and Conversions API report purchase value on Meta's attribution window, while real orders, refunds and discounts live in Shopify. DataxLand combines the two sources to put daily Meta spend next to Shopify net revenue, and computes blended ROAS, the gap to reported ROAS and profit after cost of goods, payment fees and ads. When you also connect Google Ads, total ad spend and store-wide blended ROAS are computed on the same definition.

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

Why combine

  • Meta may credit the same order that another channel also claims; only Shopify knows the real total.
  • Refunds and discount codes pull net revenue below the purchase value Meta reports.
  • Profit after ads is the number that decides whether to raise or cut the budget.

Metrics you only get by combining

MetricHow it is computed
Blended ROASShopify net revenue ÷ Facebook Ads spend, same period
Ad-reported vs actual revenue gapPlatform-reported conversion value − net revenue
Net profit after fees and adsContribution margin − allocated ad spend
Net marginNet profit after fees and ads ÷ net revenueTrack it by week to see the trend instead of daily noise.

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
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
Net marginProfit after fees and advertising divided by net revenue.= Net profit after fees and ads / Net revenueRatio (%)

Questions you can answer

QuestionFacebook Ads onlyShopify + Facebook Ads combined
How much real money comes from ads?Purchase value from the pixelShopify net revenue
Do the ads make money?Cost unknownNet profit after fees and ads
How far off is the reported figure?Not visibleAd-reported vs actual revenue gap

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 Facebook Ads

    Paste an access token with ads read permission and your ad account ID; DataxLand reads campaigns, ad sets, ads and daily metrics.

  3. 3

    Review Si's mapping

    Si proposes how Meta spend joins your website channel by day, and by product if campaigns carry a product code; you approve.

  4. 4

    Build and read the dashboards

    The Ads and P&L overview dashboards show blended ROAS and net margin; get a weekly report on Slack or Telegram.

Frequently asked questions

Does Shopify have cost of goods?

Shopify has a cost field on each product variant if you have filled it in. If not, add a cost file; COGS coverage shows how much of your revenue already has a cost.

Where do I get a Facebook access token?

Create a token with ads read permission (ads_read) from your Meta app or a system user in Business Manager, then paste it together with your ad account ID. The token is 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 Facebook Marketing →Ask Si about your Shopify data →Ask Si about your Facebook Marketing data →

Other combinations

Combine Shopify and Facebook Marketing in minutes

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