Marketing and ads
Connect Facebook Marketing to DataxLand
The Facebook Ads connector (Meta Marketing API) reads campaigns, ad sets, ads and daily numbers - spend, impressions, clicks, conversions and the conversion value Meta reports - for the ad accounts you choose, including ads running on Instagram. What DataxLand adds is putting that spend next to real net revenue from marketplaces, your website or your database: you see both the ROAS Meta reports and the true ROAS, plus the gap between reported ad revenue and money actually received.
Free plan with no time limit · No card required · Sample workspace ready in minutes
What you can do with Facebook Marketing
- Know the true ROAS of Facebook ads that send buyers to Shopee, TikTok Shop or your website.
- See the gap between Meta-reported revenue and net revenue, from double attribution or returned orders.
- Track cost per lead of lead ads next to your CRM data.
- Get an alert when spend rises while true ROAS falls.
What data you get
Each stream lands as its own table in the workspace warehouse, as is; personal-data columns are hashed on load.
| Stream (table) | Contents |
|---|---|
| campaigns | Campaigns, objective, status, budget. |
| ad_sets | Ad sets, audiences, schedule, budget. |
| ads | Ads and status, tied to ad set and campaign. |
| ad_creatives | Creatives (headline, link, image) to see which ones run. |
| ads_insights | Daily numbers - spend, impressions, clicks, conversions and conversion value in Meta's attribution windows. |
Connection details
| Sign-in method | Connection details (API key, account), encrypted at rest |
|---|---|
| Sync modes | Full (reloaded each run) · Incremental (new or changed rows only) |
| Fields to fill in | Ad Account ID(s), Authentication |
| Developer | Airbyte (certified), run inside DataxLand |
| License | ELv2 |
| Technical docs | Connector documentation ↗ |
Passwords and keys are encrypted at rest. Personal-data columns are hashed on load.
Metrics computed from this source
Real definitions from the analytics packs; dashboards and Si share them.
| Metric | Definition | Unit |
|---|---|---|
| Ad spend | Total advertising cost by report date. Filtering by channel or platform uses the destination channel the ads drive traffic to. | Currency |
| Platform-reported ROAS | Ad-platform-reported revenue divided by ad spend.= ad_conversion_value / Ad spend | Number |
| 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 |
| Marketing spend | Total cost of marketing campaigns by spend date. | Currency |
| Impressions | Total impressions (or reach) of campaigns by day. | Count |
| Clicks | Total clicks (or engagements that drive traffic) of campaigns by day. | Count |
| Click-through rate (CTR) | Clicks divided by impressions.= Clicks / Impressions | Ratio (%) |
| Cost per lead (CPL) | Marketing spend divided by leads created in the period.= Marketing spend / Leads | Currency |
Connect Facebook Marketing in 4 steps
- 1
Get an access token
In Meta Business Manager, create a system user, assign the ad accounts and generate an access token with ads_read; note the ad account IDs.
- 2
Add the source
In the workspace choose Add source, find Facebook Marketing in the connector library, paste the token and ad account IDs, pick a start date, click Test connection.
- 3
Choose streams
Keep campaigns, ad sets, ads and ads_insights; numbers load incrementally by day.
- 4
Review Si's mapping
Si proposes how spend joins your sales channels and products; you check and approve.
Limits and caveats
- DataxLand does not run the Facebook sign-in for you; the form takes an access token (from a system user or your own app). Short-lived personal tokens expire, so use a system user token.
- Meta may restate conversions for recent days; the connector re-reads a recent window on each load (insights lookback window).
- True ROAS and the revenue gap need a sales source too (marketplace, website, database or Excel); Facebook Ads alone gives only Meta's numbers.
- This is an Airbyte connector (ELv2 license) run inside DataxLand; a paid plan is required.
Frequently asked questions
Do I need a pixel or special UTMs?
Not required. DataxLand puts spend next to net revenue by day and channel; UTMs per product make allocation to products more precise.
Are Meta's numbers changed?
No. Source data stays as is; DataxLand computes new metrics next to it, with definitions.
Can I manage several ad accounts?
Yes, enter several ad account IDs in one source.
Dashboard templates that use this source
Connect Facebook Marketing and get verified dashboards
Free plan with no time limit · No card required · Sample workspace ready in minutes