Advertising
Microsoft Advertising schema
SightShark syncs Microsoft Advertising into a data warehouse you own. It creates 1 table holding 9 fields, refreshed daily. Campaign performance from the Bing Ads reporting API.
1 table / 9 fields / Provisional
Provisional
The table names below follow this site’s naming convention rather than a production sync, and the field names follow the documented Microsoft Advertising schema. Confirm both against your own dataset before you rely on them.
Tables and fields
Every table this connector creates, and every field in it, named as you will query it.
microsoft_ads_campaign_performance
9 fields
- account_id
- campaign_id
- campaign_name
- date
- spend
- impressions
- clicks
- conversions
- conversion_value
Where it lands
Into a warehouse you already own, in a region you pick. The modelling runs inside that project, so nothing leaves your cloud to be transformed and we keep no copy of your history.
- Google BigQuery
- Snowflake
- Databricks
- AWS Redshift
- Azure Synapse
Every ad platform names the same number differently and reports it in its own currency and its own time zone. Put two of them in one report without reconciling that and the totals disagree.
Questions people ask
What tables does SightShark create from Microsoft Advertising?
1 table, including microsoft_ads_campaign_performance. microsoft_ads_campaign_performance is one row per campaign, per day. Every one is listed on this page, with its fields.
Which Microsoft Advertising fields can I get?
The columns on this page are the ones most reports use. Microsoft Advertising exposes more, and a sync can be extended to any of it.
How often does Microsoft Advertising data refresh?
Daily. A sync adds to the tables rather than replacing them, so when a platform restates a figure for a day that has already closed, both the original number and the correction stay on record.
Can I join Microsoft Advertising data to my other platforms?
Yes. Every metric is modelled to one name, one type, one grain and one currency, so a query across Microsoft Advertising and another source needs no reconciling of field names first.
Related connectors
Reporting on this data
- 6 min read
Budget pacing: the formula, and the report.
Spend against plan, while there is still time to do something about it.
Read it - 5 min read
How often marketing data should refresh.
Almost always daily. Here is why more often is usually worse, not better.
Read it - 7 min read
Reporting across currencies and time zones.
Both are the same failure. A number that means something different depending on where it was read, and no error either way.
Read it
Get started
Want Microsoft Advertising in your own warehouse?
A call with someone who can answer the schema questions.