bigquery.microsoft_ads
Microsoft Ads data into BigQuery
Every Datanable plan includes a managed BigQuery warehouse: partitioned tables, incremental loads, and schema tracked over time. Or point it at your own project and keep the same pipeline.
Microsoft AdsBigQuery
The pipeline behind every Microsoft Ads table
1ExtractPull Microsoft Ads data via the official API on a schedule
2ValidateRun quality checks: nulls, duplicates, schema drift
3LoadWrite to partitioned, incremental BigQuery tables
4ModelTransform into clean, ready-to-query tables
Managed BigQuery, or your own project
Managed by DatanableYour own project
SetupNothing to configureGrant a service account access
Storage costIncluded in your planBilled on your GCP project
Data residencyEUWhatever your project uses
RetentionAs long as the connection is activeAs long as you keep the tables
Query it from anywhere
Instant integrations
Microsoft Ads to BigQuery: FAQ
What does the managed BigQuery warehouse cost?
It's included in every Datanable plan, storage and compute for your synced tables are not billed separately.
Can I point Datanable at my own BigQuery project instead?
Yes, on the Enterprise plan. Grant the Datanable service account write access and we load into your project using the same pipeline, partitioning included.
Are loads incremental or full refresh?
Incremental by partition. Only new or changed days are reprocessed, so daily syncs stay fast even on large accounts.
Which regions are supported?
EU on the managed warehouse; any region your project uses when you bring your own BigQuery project.
What is Microsoft Ads?
Microsoft Ads is an advertising platform that allows businesses to create and display ads on Bing, Yahoo, and other Microsoft-owned properties, helping them reach a broad audience through search ads and display ads.
Do I have to pay for a Data Warehouse?
No, we provide you with a Managed Data Warehouse that enables ultra-fast dashboards at no additional cost.
Can I use my own Data Warehouse?
Yes, with the Enterprise Plan. Please reach out to us through the contact form.
Do I need a Data Engineer or a Data Analyst to use Datanable?
No, Datanable is a no-code platform, offering powerful Data Engineering capabilities to everyone.
Where is Datanable based?
Datanable is based in France.
See it running on your own accounts.
Seven days free, no credit card required. Connect your first source in a few minutes.