Skip to content

Marketing and ads

Connect Bing Ads to DataxLand

The Bing Ads (Microsoft Advertising) connector reads accounts, campaigns, ad groups, ads and daily performance reports. Si maps the reports into daily marketing spend by campaign, giving you spend, impressions, clicks and CTR next to Google Ads and Facebook Ads. With orders from a marketplace or website, Microsoft Ads spend joins total ad spend to compute true ROAS on net revenue.

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

What you can do with Bing Ads

  • Combine Microsoft Advertising spend with your other ad channels in one marketing dashboard.
  • Compute true ROAS on net revenue instead of the revenue the platform reports.
  • Get an alert when daily spend spikes unexpectedly.

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
accountsAd accounts.
campaignsCampaigns with status and budget.
ad_groupsAd groups.
adsAds.
account_performance_report_dailySpend, impressions, clicks and conversions by day and account; loaded incrementally.
ad_group_performance_report_dailyThe same measures by day and ad group.

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 inClient ID, Developer Token, Refresh Token
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
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
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

Connect Bing Ads in 4 steps

  1. 1

    Gather credentials

    Get a Developer Token in Microsoft Advertising, create a Microsoft app for a Client ID (and Client Secret if any), then generate a Refresh Token with ad read access.

  2. 2

    Add the Bing Ads source

    In the workspace choose Add source, find Bing Ads, enter the Developer Token, Client ID, Refresh Token and report start date; keys are encrypted when saved.

  3. 3

    Choose streams

    Click Test connection, pick campaigns and the daily reports at account or ad group level.

  4. 4

    Review and build

    Si proposes a mapping into daily marketing spend; you approve, then build.

Limits and caveats

  • Setup needs some technical know-how (developer token, refresh token) because DataxLand does not run the Microsoft sign-in for this connector.
  • True ROAS needs an order source (marketplace, website, Excel) in the same workspace.
  • Requires the Starter plan or above. This is an Airbyte connector (ELv2) run inside DataxLand.

Frequently asked questions

Do I need hourly reports?

No. Daily reports are enough for dashboards and alerts; hourly reports only make the tables bigger.

Are Microsoft-reported conversions treated as revenue?

No. Real revenue comes from orders; platform-reported numbers are for comparison only.

What if the refresh token expires?

The next refresh shows a connection error on the source card; generate a new token and update it in the source settings.

Dashboard templates that use this source

All data sources →

Connect Bing Ads and get verified dashboards

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