→

Bing Ads for Looker Studio: sync to Sheets & BigQuery

Bing Ads Looker Studio integration works best when data lives in Google Sheets or BigQuery. SyncRange writes scheduled Microsoft Advertising exports there for native Looker Studio connectors.

Google Sheets Microsoft Excel BigQuery Looker Studio Power BI

Start free Watch demo

Free plan · No credit card · From $19/mo

Overview: all destinations for Microsoft Advertising (Bing Ads)

How it works

Connect, choose data, open the report

Connect Microsoft Advertising (Bing Ads) securely with OAuth so SyncRange can read only the access your team approves.
Pick the fields your model needs and map them to Looker Studio, including deep store data basic extractors skip when available.
Open the report in a destination on the schedule you set, from daily to as often as every 15 minutes by plan.

Looker Studio dashboards read from connectors such as Google Sheets and BigQuery. SyncRange focuses on keeping Microsoft Advertising (Bing Ads) accurate inside those destinations. Think of us as the sync layer, not a charting substitute.

After data lands on a schedule, you build Looker Studio charts and blended data sources the same way you would for any other business data. Looker Studio stays fast because the heavy lifting happens in Sheets or BigQuery.

Looker Studio and your data warehouse

Looker Studio connects natively to BigQuery and Google Sheets. SyncRange does not paint charts inside Looker Studio. We keep Microsoft Advertising (Bing Ads) synchronized into those destinations so your blended reports and filters stay fast and auditable.

Read how Looker Studio fits with BigQuery and Sheets

Export schema

What we can export, and how it lands

Each row is a field you can include or omit in the app before export. Column headers match the labels below; SyncRange writes them as the first row in your destination(worksheets in Google Sheets or Excel, or BigQuery columns) when you choose Looker Studio.

Campaign Performance

Microsoft Advertising (Bing) export tab using report type 'campaign'. Dimensions depend on the report; metrics are selected per tab from the shared metric library.

Columns
Date
Device
Device OS
Network
Account ID
Account Name
Campaign ID
Campaign Name
Campaign Status
Campaign Type

Ad Group Performance

Microsoft Advertising (Bing) export tab using report type 'ad_group'. Dimensions depend on the report; metrics are selected per tab from the shared metric library.

Columns
Date
Device
Device OS
Network
Account ID
Account Name
Campaign ID
Campaign Name
Ad Group ID
Ad Group Name
Ad Group Status

Keyword Performance

Microsoft Advertising (Bing) export tab using report type 'keyword'. Dimensions depend on the report; metrics are selected per tab from the shared metric library.

Columns
Date
Device
Device OS
Network
Campaign ID
Campaign Name
Ad Group ID
Ad Group Name
Keyword ID
Keyword
Keyword Status
Bid Match Type
Delivered Match Type

Ad Performance

Microsoft Advertising (Bing) export tab using report type 'ad'. Dimensions depend on the report; metrics are selected per tab from the shared metric library.

Columns
Date
Device
Device OS
Network
Campaign ID
Campaign Name
Ad Group ID
Ad Group Name
Ad ID
Ad Title
Ad Type
Ad Status
Final URL
Display URL

Search Query Performance

Microsoft Advertising (Bing) export tab using report type 'search_query'. Dimensions depend on the report; metrics are selected per tab from the shared metric library.

Columns
Date
Device
Device OS
Network
Campaign ID
Campaign Name
Ad Group ID
Ad Group Name
Search Query
Keyword
Keyword ID
Keyword Status

Geographic Performance

Microsoft Advertising (Bing) export tab using report type 'geographic'. Dimensions depend on the report; metrics are selected per tab from the shared metric library.

Columns
Date
Device
Device OS
Network
Country
State
Metro Area
City
County
Postal Code
Neighborhood

Product Dimension Performance

Microsoft Advertising (Bing) export tab using report type 'product_dimension'. Dimensions depend on the report; metrics are selected per tab from the shared metric library.

Columns
Date
Device
Device OS
Network
Product ID
Product Title
Condition
Brand
Product Type (Level 1)
Product Type (Level 2)
Product Type (Level 3)
Product Category (Level 1)
Product Category (Level 2)
Custom Label 0
Custom Label 1
Custom Label 2

Metrics (all Bing Ads report types)

Metrics available to add to export tabs (subject to compatibility with the dimensions you choose).

Columns
Impressions
Clicks
Spend
Conversions
Revenue
CTR
Average CPC
Average CPM
Average Position
Conversion Rate
Cost per Conversion
Return on Ad Spend
Revenue per Conversion
All Conversions
All Revenue
All Conversion Rate
All Cost per Conversion
All Return on Ad Spend
All Revenue per Conversion
View-Through Conversions
View-Through Revenue
Date Exported

Built for ecommerce teams and multi-brand operators

See how teams export clean ecommerce and marketing data to BigQuery, Google Sheets, or Excel without manual work.

SML Cakes

Shopify Store and Food delivery

★★★★★

Super easy to use and has been extremely useful in getting the real time data we need from our Shopify store. Ryan was super helpful in getting started, and responded to questions within minutes. Highly recommend.

Emma L.

Multi-brand Shopify Plus Operator

★★★★★

We run multiple Shopify stores and needed brand-level exports into BigQuery without custom pipeline maintenance. SyncRange gave us reliable scheduled exports and removed hours of manual QA.

UPlay

Large marketplace

★★★★★

We struggled to find a Shopify extraction tool that went beyond basic product, order, and customer data until we found SyncRange. It effortlessly pulls everything we require, including metaobjects and custom fields. SyncRange's hands-on guidance has given us complete confidence.

Hydro Power

Large Shopify Store

★★★★★

SyncRange was very helpful setting up Report Automation for my store. Highly recommend, Ryan made it as simple as possible and was very easy to work with. I recommend.