Connect Bing Ads to Google Sheets: Tutorial and templates (2026)

Oct 1, 2026

5 min read

Connect Bing Ads to Google Sheets using Two Minute Reports

Summarize this blog post with:

Are you struggling to track, analyze and report your Bing Ads data into Google Sheets? If yes, it might be due to the following reasons:

You have a growing client base, so manually tracking performance feels extremely time-consuming.
You manage multiple campaigns across different time zones and need real-time updates.
Native Bing Ads analytics feels complex, especially when you need customized client reports.

This is where you can use Two Minute Reports’ Bing Ads reporting tool. It lets you connect Bing Ads directly to your Google Sheets, so you can streamline and automate performance tracking without manual effort.

Let’s get started.

How to Connect Bing Ads to Google Sheets?

You can import your Bing Ads data to Google Sheets via two methods:

Method 1: Connecting Bing Ads data to Google Sheets using the Two Minute Reports Hub.

Method 2: Connecting Bing Ads data to Google Sheets using pre-built templates.

Method 1: Connect Bing Ads to Google Sheets using Two Minute Reports Hub

The Two Minute Reports Hub is your dedicated workspace for managing all your Bing Ads accounts and clients in one place. Here’s how to get started.

Step 1: Creating a Connection

1. Go to hub.twominutereports.com and click Connections → Create Connection.

create a connection to connect Bing Ads data with Two Minute Reports

2. Inside the dialog box, complete these three steps

Select the Bing Ads connector from the list of options.

Authenticate your Bing Ads account by specifying your login credentials.
Once done, enable the Bing Ads accounts you want to track and analyze performance. Please note that you can’t query disabled accounts.

3. Once done, navigate back to the Hub homepage and click Google Sheets → New Google Sheets report.

Click Google Sheets to launch TMR add-on in your spreadsheet

4. Click Use Template and follow the on-screen instructions to launch the Two Minute Reports add-on in your spreadsheet.

Step 2: Configure and Run Your Query

1. Once you’ve installed the add-on, navigate to Menu → Data Queries and click Add.

2. Select the Bing Ads accounts you want to include in the sidebar.

3. If you’re managing multiple clients, go to Clients → Manage Clients (in the sidebar), map your Bing Ads accounts to the relevant clients and click Save & Close.

4. Next, choose relevant Bing Ads metrics and dimensions you want to track and select your date range.

5. Click Run Query to pull your data into the chosen sheet and cell. You can now see the insights populated in your Google Sheets dashboard.

The next step is to automate your query. In this way, you can set up predefined schedules so your clients will receive updated insights at defined intervals.

You can either click ‘Save & Automate’ or navigate to Menu → Schedule Refresh. Either way, the steps remain the same. For now, let’s click ‘Save & Automate’. Then, follow the steps below:

First, enter your schedule name.
Next, select the queries to include in this schedule. You can choose multiple queries if you want them to refresh on the same schedule.
Then, choose how often you want to refresh: hourly, daily, weekly and monthly.
Specify the exact time and timezone for the refreshes to occur.

Once you are done with the above steps, you can set up your Microsoft Ads (Bing) reports to be delivered via email. Here’s how you can:

To enable email delivery, move the toggle to ‘Email’.
Next, select the Sheet to report.
Enter the email addresses of your recipients – your clients, team members or stakeholders.
Select whether you need to attach the report as a PDF, Excel/CSV or both.
Write a customized email subject and body message to include with each report.

And that’s it. Your schedule is now saved. From here on, your clients will receive the latest campaign performance insights delivered to their inbox automatically.

Method 2: Connect Bing Ads to Google Sheets using pre-built templates

With Two Minute Reports’ pre-built Bing Ads Google Sheets templates, you can create custom Bing Ads reports and dashboards within minutes. Here’s how you can:

1. In the template gallery, select the Microsoft/Bing Ads template for Google Sheets.

2. Next, click ‘Get Template for Free’ to open the Google Sheets template.

3. Then, click Use Template. You’ll land on the Google Sheets dashboard.

4. Click Use to launch the Two Minute Reports sidebar in your spreadsheet.

5. 5. Finish importing your Bing Ads template by selecting the required Bing Ads accounts from the dropdown. Once done, click Submit to create your report.

6. Click Run Query to fill this template with the necessary data.

7. And that’s it. Your Bing Ads campaign data is populated across relevant sections, helping you give a detailed overview of what’s happening and what needs to be improved.

Click the template link below to get started.

Microsoft/Bing Ads - Campaign and Ad Analysis Report

View Template

Which metrics from Bing Ads Analytics should you track?

Once you understand your audience and campaign objectives, the next step is to decide which Bing Ads metrics to monitor. The right metrics will help you understand how much visibility your ads receive, how efficiently you spend your budget and whether those interactions lead to conversions. Here’s how they help:

Metric	What it tells you	Why you need it?
Impressions	The number of times your ads were shown to users.	Helps you understand your ads' visibility and reach
Amount Spent	The total amount spent on your ad campaign.	Helps you monitor campaign spending and understand how your budget is being used.
CTR	The percentage of impressions that result in clicks.	Helps you understand how effectively your ads encourage users to click.
Expected CTR	The expected likelihood of users clicking your ad.	Helps you evaluate potential click performance and identify areas where your ads need improvement.
Ad Relevance	How relevant your ad is to the user’s search query	Helps you determine whether your ad messaging aligns with the searches triggering your ads.
Benchmark CTR	The benchmark CTR for similar products in shopping campaigns.	Helps you put your shopping campaigns’ CTR into context against similar products.
Benchmark Bid	The benchmark bid associated with similar products in shopping campaigns.	Helps you understand the competitive bidding environment for your products.
All Conversions	The total number of conversions attributed to your campaigns.	Helps you measure the actions generated from your advertising activity.
CPC	The average cost associated with generating a conversion.	Helps you evaluate how efficiently your advertising spend is generating conversions.
All Conversion Rate	The percentage of interactions that resulted in conversions.	Helps you understand how effectively your campaigns turn ad interactions into conversions.
Revenue per All Conversions	The revenue generated per conversion.	Helps you understand the value generated from the conversions attributed to your campaigns.

Ready to connect Bing Ads to Google Sheets?

With Two Minute Reports, you can bring your Bing Ads data directly into Google Sheets and build reports around the metrics that matter to your search and shopping campaigns. Track impressions, clicks, ad spend, CTR, conversions, ROAS, and other key metrics across your campaigns in one place. Create customized reports to monitor campaign performance, compare results, and quickly identify areas that need attention.

Try Two Minute Reports free for 14 days and simplify your Bing Ads reporting with automated, up-to-date data in Google Sheets.

Set up your data pipeline

PROCEED

Frequently Asked Questions

Install the Two Minute Reports add-on from the Google Workspace Marketplace. Next, open your spreadsheet, launch the sidebar, connect your Microsoft/Bing Ads accounts and visualize actionable campaign performance insights within minutes without juggling spreadsheets.

With Two Minute Reports, you can set up custom refresh schedules – daily, hourly, weekly or monthly and ensure your campaign reports reflect the latest Bing Ads campaign insights. This ensures you always stay on top of what’s happening and implement proactive strategies to optimize your client’s ROI.

You can access our free, ready-to-share Microsoft Ads Google Sheets templates to streamline campaign tracking. Once you click “Use Template”, you can launch the Two Minute Reports add-on, import your client’s Bing ad accounts, run queries and auto-populate the dashboard with meaningful insights.

With data blending, you can compare Bing Ads with other advertising platforms, such as Meta, Google Ads, etc, into a single dashboard and unlock cross-channel ROI. No need to toggle between platforms or copy-paste KPIs manually.

You can select your client’s Bing Ads accounts from the Two Minute Reports sidebar and consolidate key KPIs in one place. Alternatively, you can also reuse the existing reports across multiple clients, ensuring you focus more on strategy and accomplish your campaign goals.

Meet the Author

Shalini Murugan

Shalini is driven by ideas that create a tangible impact. At Two Minute Reports, she specializes in content that helps marketers optimize their reporting workflows. When she's not transforming complex data into meaningful insights, you might find her lost in a book, jotting down ideas in her notebook, or connecting the dots others overlook.

Connect Microsoft/Bing Ads in Google Sheets

Try for Free