Skip to content
+

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

MetricHow it is computed
Blended ROASNet revenue in the file ÷ Facebook Ads spend, same period
Ad cost per orderAd spend ÷ valid ordersComputed by day; cancelled orders are not counted.
Net profit after fees and adsContribution margin − allocated ad spendNeeds a cost column or a cost sheet in the file.
Average order valueOrder 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.

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
Valid ordersOrders that were not cancelled (standard status other than cancelled).Count
Net profit after fees and adsNet revenue received minus COGS, marketplace fees, payment fees, shipping, return costs and advertising.= Contribution margin - allocated_ad_spendCurrency
Average order valueLine revenue after discounts divided by valid orders.= line_net_total / Valid ordersCurrency

Questions you can answer

QuestionFacebook Ads onlyExcel + Facebook Ads combined
Are orders closed in the inbox counted?NoYes, if they are in the file
What is the blended ROAS?Only reported ROASNet revenue ÷ spend
How much do I spend per order?Meta's cost per resultSpend ÷ real orders

Steps

  1. 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. 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 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. 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 Excel and Facebook Marketing in minutes

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