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 |
|---|---|
| accounts | Ad accounts. |
| campaigns | Campaigns with status and budget. |
| ad_groups | Ad groups. |
| ads | Ads. |
| account_performance_report_daily | Spend, impressions, clicks and conversions by day and account; loaded incrementally. |
| ad_group_performance_report_daily | The same measures by day and ad group. |
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 | Client ID, Developer Token, Refresh Token |
| 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 |
|---|---|---|
| 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 |
| 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 |
Connect Bing Ads in 4 steps
- 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
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
Choose streams
Click Test connection, pick campaigns and the daily reports at account or ad group level.
- 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
Connect Bing Ads and get verified dashboards
Free plan with no time limit · No card required · Sample workspace ready in minutes