Combine Excel orders with Facebook Ads for shops that sell through a fan page
Shops that sell through a Facebook fan page, Zalo or a self-built website often keep orders in Excel or export them from their sales software, while ad spend sits in Facebook Ads. The pixel only sees part of the orders, because customers message or call before they buy. Upload your order file and connect Facebook Ads: DataxLand puts daily spend next to the net revenue in the file and computes blended ROAS, ad cost per order and, if the file has cost of goods, profit after ads. It is the simplest way to know whether your fan page ads really make money.
Free plan with no time limit · No card required · Sample workspace ready in minutes
Why combine
- Orders closed in the inbox or by phone never pass through the pixel, so the revenue Meta reports is too low or wrong.
- Your order file is the real number; joined with spend it gives a ROAS that Meta cannot compute.
- With cost of goods in the file you see profit after ads, not just revenue.
Metrics you only get by combining
| Metric | How it is computed |
|---|---|
| Blended ROAS | Net revenue in the file ÷ Facebook Ads spend, same period |
| Ad cost per order | Ad spend ÷ valid ordersComputed by day; cancelled orders are not counted. |
| Net profit after fees and ads | Contribution margin − allocated ad spendNeeds a cost column or a cost sheet in the file. |
| Average order value | Order line revenue ÷ valid orders |
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 |
| Valid orders | Orders that were not cancelled (standard status other than cancelled). | Count |
| 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 |
| Average order value | Line revenue after discounts divided by valid orders.= line_net_total / Valid orders | Currency |
Questions you can answer
| Question | Facebook Ads only | Excel + Facebook Ads combined |
|---|---|---|
| Are orders closed in the inbox counted? | No | Yes, if they are in the file |
| What is the blended ROAS? | Only reported ROAS | Net revenue ÷ spend |
| How much do I spend per order? | Meta's cost per result | Spend ÷ real orders |
Steps
- 1
Upload the Excel file
Upload an .xlsx file: one sheet per table, column names in the first row, plus a data_dictionary sheet describing each column.
- 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 reads the order sheet and data_dictionary and proposes the date, channel, amount and status columns; phone number and customer name columns are hashed; you approve.
- 4
Build and read the dashboards
The Ads and P&L overview dashboards show blended ROAS by day; upload a new file each week to keep them current.
Frequently asked questions
Does the Excel file need a fixed template?
No fixed template. One sheet per table with column names in the first row; a data_dictionary sheet describing the columns helps Si understand quickly. Si asks about unclear columns during review.
Is customer information in the file safe?
Columns marked as personal data are hashed on load and masked before they reach Si. Dashboards, the API and MCP never return customer names or phone numbers.
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 Excel →Connect Facebook Marketing →Ask Si about your Excel data →Ask Si about your Facebook Marketing data →
Other combinations
- Combine an Excel cost file with Shopee to see real profit per product
- 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 TikTok Shop with Facebook Ads when Meta ads send buyers to TikTok
Combine Excel and Facebook Marketing in minutes
Free plan with no time limit · No card required · Sample workspace ready in minutes