Skip to content

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
campaignsCampaigns, objective, status, budget.
ad_setsAd sets, audiences, schedule, budget.
adsAds and status, tied to ad set and campaign.
ad_creativesCreatives (headline, link, image) to see which ones run.
ads_insightsDaily numbers - spend, impressions, clicks, conversions and conversion value in Meta's attribution windows.

Connection details

Sign-in methodConnection details (API key, account), encrypted at rest
Sync modesFull (reloaded each run) · Incremental (new or changed rows only)
Fields to fill inAd Account ID(s), Authentication
DeveloperAirbyte (certified), run inside DataxLand
LicenseELv2
Technical docsConnector 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.

MetricDefinitionUnit
Ad spendTotal advertising cost by report date. Filtering by channel or platform uses the destination channel the ads drive traffic to.Currency
Platform-reported ROASAd-platform-reported revenue divided by ad spend.= ad_conversion_value / Ad spendNumber
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
Marketing spendTotal cost of marketing campaigns by spend date.Currency
ImpressionsTotal impressions (or reach) of campaigns by day.Count
ClicksTotal clicks (or engagements that drive traffic) of campaigns by day.Count
Click-through rate (CTR)Clicks divided by impressions.= Clicks / ImpressionsRatio (%)
Cost per lead (CPL)Marketing spend divided by leads created in the period.= Marketing spend / LeadsCurrency

Connect Facebook Marketing in 4 steps

  1. 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. 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. 3

    Choose streams

    Keep campaigns, ad sets, ads and ads_insights; numbers load incrementally by day.

  4. 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

Ask Si about your Facebook Marketing data →Facebook Marketing + Excel →Facebook Marketing + HubSpot →Facebook Marketing + PostgreSQL →Facebook Marketing + Shopee →Facebook Marketing + Shopify →Facebook Marketing + TikTok Shop →Facebook Marketing + WooCommerce →All data sources →

Connect Facebook Marketing and get verified dashboards

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