Skip to content
+

Combine WooCommerce with Facebook Ads for your self-run online store

A WordPress site running WooCommerce usually goes hand in hand with Facebook and Instagram ads. The pixel on the site reports purchase value the way Meta attributes it, while orders, statuses, refunds and discount codes live in WooCommerce. DataxLand reads both, puts daily Meta spend next to the site's net revenue, and computes blended ROAS, the gap to reported ROAS and profit after ads when cost of goods is available. You get one ads dashboard based on the real orders of your site instead of two reports that never match.

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

Why combine

  • Bank transfer or cash on delivery orders can be cancelled after the pixel has already recorded a purchase.
  • Discount codes and refunds only exist in WooCommerce.
  • Only combining the two shows ad cost per real order and profit after ads.

Metrics you only get by combining

MetricHow it is computed
Blended ROASWooCommerce net revenue ÷ Facebook Ads spend, same period
Ad-reported vs actual revenue gapPlatform-reported conversion value − net revenue
Cancellation rateCancelled orders ÷ total ordersA high cancellation rate makes reported ROAS look better than it is.
Net profit after fees and adsContribution margin − allocated ad spend

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
Cancellation rateCancelled orders divided by total orders.= cancelled_orders / all_ordersRatio (%)
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

QuestionFacebook Ads onlyWooCommerce + Facebook Ads combined
Are cancelled orders counted?PossiblyNo, removed by status
Blended ROAS?NoNet revenue ÷ spend
Profit after ads?NoYes, when cost of goods is available

Steps

  1. 1

    Connect WooCommerce

    Enter your store domain plus the consumer key and consumer secret of the WooCommerce REST API (read access).

  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 which order statuses count as valid, cancelled or refunded based on how your store uses WooCommerce, and how spend joins the website channel; you approve.

  4. 4

    Build and read the dashboards

    The Ads and P&L overview dashboards show blended ROAS and cancellation rate; set an alert when blended ROAS drops.

Frequently asked questions

Are custom WooCommerce order statuses understood?

Yes. Si reads the statuses in your data and proposes which are valid, cancelled or refunded; you adjust them during review. The status mapping is saved and used for every later build.

Do I need to install a plugin on my site?

No. DataxLand reads through the WooCommerce REST API with a read-only consumer key and secret that you create in the advanced settings of WooCommerce.

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 WooCommerce →Connect Facebook Marketing →Ask Si about your WooCommerce data →Ask Si about your Facebook Marketing data →

Other combinations

Combine WooCommerce and Facebook Marketing in minutes

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