Microsoft Advertising provides a unique opportunity to reach potential customers beyond Google. While the targeting options are not as extensive, you can capitalize on the smaller audience to consistently generate profits for your clients. However, achieving success with Microsoft advertising is not simple. The reporting tools for Bing ad are not very comprehensive and are not very user-friendly for customization. These requirements become crucial when highlighting specific key results from multiple Bing ad campaigns for your clients.
That’s where Two Minute Reports’ Microsoft (Bing) Ads connector comes in. By connecting your Bing ad account to Google Sheets, TMR will automatically fetch real-time ad metrics and enable you to create custom reports for your clients. Our setup prioritizes data security through encryption and stores data in your private Google Sheet. Let me walk you through the steps to connect your Microsoft Ads data via Two Minute Reports in Google Sheets.
Step 1: Install and Launch Two Minute Reports
Install Two Minute Reports if you have not done so already.
Sign in to your Google Sheets with the associated Gmail ID.
Go to Extensions > Add-ons > Get add-ons.
Search for Two Minute Reports and select Install.
Review and accept the permissions necessary to run Two Minute Reports. Once you’ve accepted the terms and conditions, click Allow for Two Minute Reports to manage and access your data.
Note: Allow access is mandatory for TMR to function and efficiently analyze your data.
Next, open your Google Sheets and go to Extensions > Two Minute Reports > Launch.
Once your TMR sidebar opens, you can connect your data sources and run queries.
Step 2: Connect Microsoft Ads to Google Sheets
Click Menu at the top left of the sidebar to navigate to the Data Sources section. If you see an onboarding popup, please proceed with it or minimize it by clicking the inverted arrow.
Click Add, name your data source, and select your data source type as Microsoft Ads from the Advertising dropdown.
Once you click Microsoft Ads, you’ll have to log in with your Microsoft ad account. After connecting your Microsoft account, click Yes to authenticate your login successfully.
Note: If you get an error message check whether you have signed in with the correct Microsoft Ads account.
Step 3: Getting Microsoft Ads data in Google Sheets
To pull Microsoft Ads performance data, you must first create a new query by navigating to the Data Queries section.
Click Add and choose the Microsoft Ads account to analyze its campaign data. You can manage multiple client’s Microsoft ad accounts under one roof. Simply select one or more ad accounts to analyze performance.
Alternatively, you can navigate to the Clients section. Add your client and map their corresponding Microsoft Ad account.
Click on “Manage Clients” and enter the necessary account details. Once done, click “Save & Close” to save your client’s details for future reference.
Note: You can add multiple clients and map their respective ad accounts. Doing so saves you tons of wasted hours from manually juggling numerous data sets. You can get a unified view of your client campaigns and track key metrics in a centralized dashboard. For further information, please read our guide – How to Create Queries Using Clients?
Next, add the Microsoft ad metrics and dimensions you want to analyze. You can choose from the list of metrics and dimensions to assess your Microsoft Ad campaign performance. Refer to the screenshot below for better understanding.
Next, you have to configure your data reporting by choosing how to customize it.
It would be best to customize your data reporting by selecting the relevant fields and choosing whether to sort them in ascending or descending order. You can also apply custom filters to display only the necessary information.
Note: You can sort and filter multiple fields based on your data reporting preferences.
You can also select Data Options to decide how you want to represent your data output. For instance, the “Replace blank metrics with zeros” option will replace all the blank metric values as “0”.
Likewise, choosing “No header row” will not add the header row at the top of the result, and “Merge new data with the old” removes duplicate data and retains the latest data fetched from the API.
Lastly, you can specify in which sheet and cell you want to save your queries.
Once you have completed the above steps, click Run Query to visualize the final output.
Now, you can use different Google Sheet features such as pivot table and VLOOKUP(), to extract advanced insights and build charts to amplify your data visualization.
Pro TMR Tip: Run all your queries directly from the Extensions menu on your Google Sheets. Go to Extensions > Two Minute Reports > choose your desired quick action.
Step 4: (Optional) Get automatic data updates via Schedule Refresh
Once you create a report in Google Sheets, you can schedule automatic updates to get updated data. This feature is convenient for sending emails or refreshing your spreadsheets with live data and using them as a dashboard.
Under the email section, you can enter the recipient(s)’s email ID and save the new schedule.
You can also choose to specify the reporting format. You can insert the sheet content in the email body, attach the selected sheet as a PDF or Excel, or attach the spreadsheet as an Excel file.
Two Minute Reports’ schedule refresh or data refresh feature has other capabilities. For more information, please read our guide, “How to Refresh Data Automatically in Google Sheets.”
We hope you found this guide helpful. Please contact our support team via chat button or support@twominutereports.com if you have any questions.