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
| Metric | How it is computed |
|---|---|
| Blended ROAS | WooCommerce net revenue ÷ Facebook Ads spend, same period |
| Ad-reported vs actual revenue gap | Platform-reported conversion value − net revenue |
| Cancellation rate | Cancelled orders ÷ total ordersA high cancellation rate makes reported ROAS look better than it is. |
| Net profit after fees and ads | Contribution 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.
| 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 |
| 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 |
| Cancellation rate | Cancelled orders divided by total orders.= cancelled_orders / all_orders | Ratio (%) |
| 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 | Facebook Ads only | WooCommerce + Facebook Ads combined |
|---|---|---|
| Are cancelled orders counted? | Possibly | No, removed by status |
| Blended ROAS? | No | Net revenue ÷ spend |
| Profit after ads? | No | Yes, when cost of goods is available |
Steps
- 1
Connect WooCommerce
Enter your store domain plus the consumer key and consumer secret of the WooCommerce REST API (read access).
- 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
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
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 with PayPal to get the real payment fee on every order
- Combine Excel orders with Facebook Ads for shops that sell through a fan page
- Combine HubSpot with Facebook Ads to get real CPL and CAC
- Combine your PostgreSQL order database with Facebook Ads
- Combine Shopee with Facebook Ads to see your blended ROAS
- Combine Shopify with Facebook Ads to see profit after advertising
Combine WooCommerce and Facebook Marketing in minutes
Free plan with no time limit · No card required · Sample workspace ready in minutes