Connect Bing Ads to Looker Studio with Windsor.ai
Directly connect your Bing Ads data, in minutes, and in an easy-to-use format.
All your marketing data in one place, just in a few clicks.
In just a few clicks, Windsor.ai integrates all of your marketing data. Simply select and authenticate the connectors you want to use. You don’t even need to write a single line of code to connect your data. You can blend and visualize your marketing data in your preferred reporting platform after a few minutes of setup.
Automate and save time.
No more using CSV dumps and spreadsheets to bring together data from different platforms. Windsor.ai automates collecting all marketing data and minimizes time spent on preparing and formatting, saving you a lot of time and boosting the quality of your reports.
Spend less time on manual data loading and spreadsheets. Focus on what matters: Growing your business!
Use all your data where and when you need it.
We make sure that all the data we integrate is fresh and accessible to marketers, whenever they want. You can push your data from Windsor.ai to a variety of data destinations, including cloud storage services (Google BigQuery, Amazon S3, Azure, Snowflake), data visualization tools (Google Data Studio, Power BI, Tableau), and spreadsheets (Excel, Google Sheets).
About Microsoft Advertising (Formerly Bing Ads)
Microsoft Advertising (formerly Bing Ads, Microsoft adCenter, and MSN adCenter) is an online advertising platform offered by Microsoft that provides pay-per-click advertising on Bing, Yahoo!, and DuckDuckGo search engines and AOL-owned and operated sites, as well as various partner sites. Using Bing Ads, advertisers can target users based on geographic, time-based as well as socio-demographic options which enables them to create more effective ads that resonate with their target audience. Businesses may use Bing Ads to attract customers, improve traffic, and boost sales.
Learn more about Bing Ads.
About Looker Studio
Looker Studio or formerly known as Google Data Studio is a data visualization platform that helps businesses convert data into customizable informative reports and dashboards. It provides a simple and intuitive interface for users to create interactive reports and visualizations with their data. Data analysis using Google Data Studio provides businesses with valuable information that they can use to make informed decisions about their operations.
Learn more about Looker Studio
Why integrate Bing Ads data with Looker Studio?
- You can gain a more comprehensive understanding of who is viewing your ads, how they are interacting with them, and what keywords are driving traffic to your website by integrating Bing Ads data with Looker Studio.
- The combination of these two tools can assist you in optimizing campaign performance and identifying areas for improvement. By automating your reports in Looker Studio, you will be able to save time tracking ad performance and metrics that are important to your business.
- Looker Studio allows you to filter and analyze your campaign data in great detail. You can quickly identify which ads are performing best and measure the effectiveness of your ads to improve your marketing strategy and make better use of your advertising budget.
- You can also use Looker Studio’s powerful reporting tool to get a high-level overview of your campaigns, allowing you to see how much money you’re spending on each ad campaign and make informed budget decisions.
About the Bing Ads - Looker Studio Connector
The Bing Ads/Microsoft Ads Looker Studio Connector pulls Metrics and Dimensions for Microsoft Bing Ads. The Insights are retrieved at the Campaign Level. Once the user successfully logs into the connector he can then choose the metrics and dimensions he is interested to create a report on.
Prerequisites
To set up the connector, the user should have:
- A valid Bing Ads account. (Visit our privacy policy and terms of use)
- Google account for Bing Ads Ads to Looker Studio integration.
- A Windsor account. Start your free trial now.
How to connect Bing Ads data to Google Data Studio?
You need to select Bing Ads as a Data Source and grant access to Windsor.ai.
Select the fields on the right to later use in your data source. For example, you can include metrics such as balance amount, transaction fee, or refund amount.
Go to “Select Destination” and choose Google Data Studio.
Once done, select “connect” and authorize access to your data source.
Windsor.ai: All your marketing data in one place
Power up your marketing performance with result-driven marketing solutions
- Connect all your marketing, CRM, and analytics data from 50+ platforms and stream it to any spreadsheet tool, BI platform, or data warehouse.
- The setup is done in minutes. No coding is required.
- Currently, we support more than 3000 dimensions and metrics.
- See the value and return on every marketing touchpoint.
- Our marketing attribution software platform provides marketers with a 15-44% increase in marketing ROI.
Looker Studio Templates for Bing Ads
Do you plan to connect and visualize your Bing Ads data in Looker Studio?
These free and customizable Looker Studio Bing Ads templates will assist you in visualizing your data for easy reporting and analysis.
Looker Studio Tutorials for Bing Ads
Would you like to take your Looker Studio Pinterest Ads dashboards to the next level?
Here are some of our favorite tutorials to help you:
Available Bing Ads Metrics and Dimensions
| name | type | description |
|---|---|---|
| Absolute Top Impression Rate Percent | TEXT | How often your ad was in the first position of all results, as a percentage of your total impressions. A higher number indicates your ad is frequently showing in the best ad position. |
| Account ID | TEXT | The account id |
| Account Name | TEXT | The account name |
| Account Number | TEXT | The Microsoft Advertising assigned number of an account. |
| Account Status | TEXT | The account status |
| Ad Distribution | TEXT | The network where you want your ads to show. This can be the entire Microsoft Advertising Network, Microsoft sites and select traffic, or only partner traffic. |
| Ad group ID | TEXT | The ID of the AdGroup. |
| Ad group | TEXT | The name of the AdGroup. |
| Ad ID | TEXT | The ad id |
| Ad Title | TEXT | The ad title |
| Title Part 1 | TEXT | The title part 1 attribute of an ad. |
| Title Part 2 | TEXT | The title part 2 attribute of an ad. |
| Title Part 3 | TEXT | The title part 3 attribute of an ad. |
| Ad Network Conversions | NUMERIC | The ad network reported conversions |
| Ad Network Revenue | NUMERIC | The ad network reported revenue |
| All Conversion Rate | NUMERIC | The conversion rate as a percentage. |
| All Conversions | NUMERIC | The number of conversions. |
| AllCostPerConversion | NUMERIC | The cost per conversion. |
| All Revenue | NUMERIC | The revenue optionally reported by the advertiser as a result of conversions. |
| All Revenue Per Conversion | NUMERIC | The revenue per conversion.The formula for calculating the revenue per conversion is (Revenue / Conversions). |
| AllReturnOnAdSpend | NUMERIC | The return on ad spend (ROAS).The formula for calculating the ROAS is (Revenue / Spend). |
| Average CPC | NUMERIC | The average cost per click (CPC). The total cost of all clicks on an ad divided by the number of clicks. This is the average amount you're actually charged each time your ad is clicked. |
| Average CPM | NUMERIC | The total advertising cost divided by the number of impressions (in thousands). |
| Bid Match Type | NUMERIC | The keyword bid match type. This can be different from the DeliveredMatchType column, for example if you bid on a broad match and the search term was an exact match. For more information, see Budget and Bid Strategies. The possible values are Broad, Exact, Phrase, and Unknown. |
| Campaign | TEXT | The campaign Name |
| Campaign ID | TEXT | The campaign ID |
| City | TEXT | The city where the user was physically located when they clicked the ad. |
| Clicks | NUMERIC | The number of clicks |
| Conversion Rate | PERCENT | The conversion rate as a percentage. |
| Conversions | NUMERIC | The number of conversions |
| CostPerConversion | NUMERIC | The cost per conversion. |
| Country | COUNTRY | The country where the user was physically located when they clicked the ad. |
| County | TEXT | The county where the user was physically located when they clicked the ad. |
| Ctr | PERCENT | The number of clicks your ad receives (Clicks) divided by the number of times your ad is shown (Impressions). |
| Currency | TEXT | The account currency type. |
| Currency Code | TEXT | The account currency type. |
| Daily Spend | NUMERIC | The average amount of campaign budget spent per day. |
| Date | DATE | The date |
| Delivered Match Type | NUMERIC | The match type used to deliver an ad. This can be different from the BidMatchType column, for example if you bid on a broad match and the search term was an exact match. For more information, see Budget and Bid Strategies. The possible values are Broad, Exact, Phrase, and Unknown. |
| Device Type | TEXT | Device type |
| Device OS | NUMERIC | The operating system of the device reported in the DeviceType column. The possible values include Android, Blackberry, iOS, Other, Unknown, and Windows. If the operating system of the device cannot be determined or is not one of the operating systems that you can target, the value in this column will be Unknown. |
| The Final URL of the keyword | TEXT | Only the first URL in the list is reported. If the URL contains dynamic text substitution parameters (for example, {param1}), the report will contain the URL before substitution. |
| Final Url Suffix | TEXT | A place in your final URL where you can add parameters that will be attached to the end of your landing page URL. |
| Goal | TEXT | The name of the goal you set for the conversions you want, meaning actions customers take after clicking your ad. |
| Goal Type | TEXT | The type of conversion goal. Possible values include AppInstall, Duration, Event, InStoreTransaction, OfflineConversion, PagesViewedPerVisit, and Url. |
| Impression Share Percent | TEXT | The estimated percentage of impressions, out of the total available impressions in the market you were targeting. |
| Impressions | NUMERIC | The number of impressions |
| Keyword | TEXT | The keyword. |
| The Keyword ID | NUMERIC | The keyword ID. |
| Language | TEXT | The language of the publisher where the ad was shown. The language display name will be provided in the report e.g. English. |
| Location Id | TEXT | The Microsoft Advertising identifier of the location where the user was physically located when they clicked the ad. For geographical location identifiers, see Geographical Location Codes. If the location ID is in the report but not found in the file downloaded via GetGeoLocationsFileUrl, it is not targetable. |
| Metro Area | TEXT | The metro area (Nielsen DMA in the United States) where the user was physically located when they clicked the ad. |
| Month to Date Budget Spend | NUMERIC | The amount of money spent to date for the month. |
| Monthly Budget | NUMERIC | The anticipated maximum monthly budget amount that was calculated on the date of the most recent budget change. |
| Neighborhood | TEXT | The neighborhood where an ad was physically served, or the neighborhood that your customer had shown interest in through searches or content they had viewed. This helps you find out how your ads are doing in different locations, which can help you decide where to focus more of your advertising efforts. |
| Postal Code | TEXT | The postal code where the user was physically located when they clicked the ad. |
| Proximity Target Location | TEXT | The radius target bid name. The name of the geographic radius where the user was physically located when they clicked the ad. The Radius attribute column contains the distance of the radius. |
| Query Intent City | TEXT | The name of a city if the user's geographical intent can be determined. The city is set if the user's intent is a city, and not necessarily if they are physically located in the city. |
| Query Intent Country | TEXT | The name of a country if the user's geographical intent can be determined. The country is set if the user's intent is related to a country, and not necessarily if they are physically located in the county. |
| Query Intent County | TEXT | The name of a county if the user's geographical intent can be determined. The county is set if the user's intent is related to a county, and not necessarily if they are physically located in the county. |
| Query Intent DMA | TEXT | The name of a metro area (Nielsen DMA in the United States) if the user's geographical intent can be determined. The metro area is set if the user's intent is a metro area or city within the metro area, and not necessarily if they are physically located in the metro area. |
| Query Intent Location Id | TEXT | The location identifier if the user's geographical intent can be determined. |
| Query Intent Neighborhood | TEXT | The name of a neighborhood if the user's geographical intent can be determined. The neighborhood is set if the user's intent is related to a neighborhood, and not necessarily if they are physically located in the neighborhood. For example, the user's search query was rental cars in Encino. |
| Query Intent Postal Code | TEXT | The name of a postal code if the user's geographical intent can be determined. The postal code is set if the user's intent is a postal code, and not necessarily if they are physically located in the postal code. |
| Query Intent State | TEXT | The name of a state if the user's geographical intent can be determined. The state is set if the user's intent is a state or sub geography of the state, and not necessarily if they are physically located in the state. |
| Radius | NUMERIC | The radius of a radius target bid. The geographic radius where the user was physically located when they clicked the ad. The ProximityTargetLocation attribute column contains the address or landmark name of the radius. |
| Revenue | NUMERIC | The amount of revenue |
| Spend | NUMERIC | The media spend |
| State | TEXT | The state where the user was physically located when they clicked the ad. |
| Top Impression Rate Percent | TEXT | The percentage of times your ad showed in the mainline, the top placement where ads appear above the search results, out of your total impressions. |
| Top vs Other | TEXT | Indicates whether the ad impression appeared in a top position or elsewhere. The possible values include AOL search - Top, AOL search - Other, Audience network, Bing and Yahoo! search - Top, Bing and Yahoo! search - Other, Syndicated search partners - Top, Syndicated search partners - Other, Content network, and Unknown.of your total impressions. |
| Total Cost | NUMERIC | The media spend (Duplicate) |
| Transaction Revenue | NUMERIC | The amount of revenue |
| View Through Revenue | NUMERIC | The revenue optionally reported by the advertiser as a result of view-through conversions. |