Docs

Microsoft Bing Ads Keyword Planner Extractor

Why Export Data from Microsoft Bing Ads Keyword Planner?

Microsoft Advertising platform provides a Keyword Planner Tool that facilitates advertisers to discover relevant keywords for their advertising campaigns. Based on the targeting, search options, and date range you select, the tool will provide you with the most sought-after keywords, and its search volume trends, competition level, and suggested bids advertisers can use this information to identify and select the most appropriate keywords for their targeting and bidding strategies.

Keyword Planner helps you research keywords for your Search campaigns. You can use this free tool to get widespread and accurate keyword suggestions to automate your keyword research process. In addition to the new keyword ideas, also get important KPI related to these keywords like average monthly searches, average cpc micros, the competition level (High, Low, Medium), monthly searches volume, etc.

How to add a Microsoft Bing Ads Keyword Planner Connection in Electrik.AI?

Follow these steps to connect your Microsoft Bing Ads Keyword Planner to Electrik.AI

Step 1: Ensure you have the following prerequisites to create a Microsoft Bing Ads Keyword Planner Connection in Electrik.AI:

a. Access to Microsoft Ads.

b. Microsoft Ads Account User Id and Password.

Step 2:  Sign-in to your Electrik.AI account. If you don’t have one, sign up for free using this link.
Step 3: Select IO – Data Pipelines on Electrik.AI’s dashboard.

Select IO in ElectrikAI Dashboard - ElectrikAI

Step 4: Select the Connections Icon on the navigation panel to the left, then click the “Add” button on top.

Select the Connections tab in the left most panel Conn - ElectrikAI

Step 5: In the “Source” tab choose “Microsoft Bing Ads Keyword Planner” connector.

Conn-Step 5 The Source default tab is selected just click on “Microsoft Bing Ads Keyword Planner” connection - ElectrikAI

Step 6: To use Microsoft Bing Ads Keyword Planner Connection, you first need to create Microsoft Bing Ads Connection. How to Create Google Ads Connection?

Conn-Step 6 To use Microsoft Bing Ads Keyword Planner Connection, you first need to create Microsoft Bing Ads Connection - ElectrikAI

Step 7: Select an existing Microsoft Bing Ads connection from the list.

Conn-Step 7 Select existing Microsoft Bing Ads connection from the list - ElectrikAI

Step 8: Click the “Save” button on the top right corner of the screen.

Conn-Step 8 Click on Save button on the top right corner of the screen - ElectrikAI

Congratulations! You have successfully created a Microsoft Ads Keyword Ideas connection in Electrik.AI.

Conn-Congratulations, you have successfully created a “Microsoft Ads Keyword Ideas ” Connection - ElectrikAI

What are the supported Data Destinations?

Electrik.AI supports the following databases and Data Warehouse to export Microsoft Analytics Data. It is important to note that Electrik.AI itself is not a destination. A destination is required to export data from various marketing data sources using Electrik.AI

PostgreSQL Data Destination-Eletrik.AI
MySQL Data Destination-Electrik.AI
AzureSQL Data Destination-Eletrik.AI
Google Big Query Data Destination-Elecrik.AI

How to export Microsoft Analytics Data?

Electrik.AI creates a data flow (or ETL process) that exports Microsoft Analytics data to a target database or data warehouse or cloud storage. This process runs daily at scheduled time and exports data for the previous day.

Follow these steps to create a Data Flow from Microsoft Ads Keyword Planner to Google BigQuery

Step 1: Ensure you have the following prerequisites:

  1. Access to Microsoft Ads.
  2. Microsoft Ads Account User Id and Passwords.
  3. Access to a Database of your choice (PostgreSQL, MySQL, Azure SQL).
  4. Database Connection Details such as Host, Port, DB Name, DB User.

Step 2: Sign-in to your Electrik.AI account.
Step 3: Select IO – Data Pipelines on Electrik.AI’s dashboard.

Select IO in ElectrikAI Dashboard - ElectrikAI

Step 4: Select the Flows Icon on the navigation panel to the left, then click the “Add” button on top.

Select the Connection icon from right most panel - Electrik AI

Step 5: Select Microsoft Ads Keyword Planner Connection from the the list of available sources.

Flow-Step 5 Select Microsoft Ads Keyword Planner Connection present in the list of available sources - ElectrikAI

Step 6: Select your existing Microsoft Ads Keyword Planner connection in Electrik.AI.

Flow-Step 6 Select your existing Microsoft Ads Keyword Planner connection - ElectrikAI

To Configure a new connection, refer to this link.

Step 7: Click on a destination of your choice from the list of available destinations.
In this example, we are choosing BigQuery.

Flow Click on a destination of your choice from list of available destinations - ElectrikAI

Step 8: Click on a destination of your choice from the list of available destinations.

Flow-Step 8 Click on a destination of your choice from list of available destinations - ElectrikAI

Step 9: This step can be used to get keyword ideas that are most relevant to your campaigns. Best practices for finding new keywords.

a. Search for new keywords using either phrase, website, or category.

b. Based on your selection made in step ‘a’, input potential keywords, URLs, or choose a category.

c. Select targeting locations. Currently only United States, United Kingdom, Canada, Australia, France, and Germany are supported.

d. Choose the Search Network, either of the following:
The entire Microsoft Advertising Network. (Ads can appear above or below search results on Google Search. They can appear besides, above, or below search results on Google Play, the Shopping tab, Google Images, Google Maps, and the Maps app.)

or

Google Search + Search partners. (Search partners include hundreds of non-Google websites as well as YouTube and other Google sites. Ads can appear on search partner sites that display and link to products for sale.)

e. Review the Data Source, Data Destination, Database Schema, Provide Success Notification Email, Failure Notification Email. Click “Save and Proceed” to continue.

Flow-Step 9 - Microsoft Ads Keywords ElectrikAI

Step 10: Review the Data Source, Data Destination, Database Schema, Provide Success Notification Email, Failure Notification Email. Click “Save and Proceed” to continue.

Flow Step 10 Microsoft Bing Ads Keyword Planner - ElectrikAI

Success Notification Email: Enter a valid Email ID to receive the Flow Success Email Notification.
Failure Notification Email: Enter a valid Email ID to receive the Flow Failure Email Notification.
Note: By default, Electrik.AI uses the Email ID of the user currently signed in.

Congratulations! Your Flow has been created successfully. You may need to wait until you are redirected to the Flow Details Screen.

Congratulations, Flow is created. Please wait while you are redirected to Flow Details Screen - ElectrikAI

You have now successfully setup Microsoft Bing Ads Keyword Planner to Google BigQuery flow on Electrik.AI.

flow-You have now successfully setup Microsoft Bing Ads Keyword Planner to Google BigQuery flow - ElectrikAI

Your Microsoft Analytics data will start loading after 24 hours in your Google BigQuery Dataset.

Your Microsoft Analytics data will start loading after 24 hours in your Microsoft BigQuery Dataset - ElectrikAI