Bing Webmaster Data Export

Bing Webmaster is a free Microsoft service that improve your website’s reach & performance by making sure your website shows up in the Bing search engine result. It also provides multiple tools for analyzing and monitoring your website.

Step 1: Ensure you have following prerequisites to create a Bing Webmaster Connection in Electrik.AI

a. Bing Webmaster User Id and Password.

b. Access to Bing Webmaster account.

Step 2: Sign-in into your Electrik.AI account.

Step 3: Select IO in Electrik.AI dashboard.

Step 4: Select the Connections tab in the left most navigation bar & click on “Add” action button.

Step 5: The Source default tab is selected just click on “Bing Webmaster” connection.

Step 6: Provide your Bing Webmaster account User Id and Password.

Step 7: Allow Electrik.AI to access your Bing Webmaster account.

Step 8: Select the Site URL from the dropdown whose data you wish to export.

Step 9: Click on Save button on the top. 

Congratulations, you have successfully created a Bing Webmaster Connection in Electrik.AI

Electrik.AI supports the following databases to export Bing Webmaster. 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

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

Step 1: Ensure you have the following prerequisites.

1. Access to Bing Webmaster Account.

2. Bing Webmaster Account User Id and Password.

3. Access to a Database/Warehouse of your choice (PostgreSQL, MySQL, Azure SQL, BigQuery.)

4. Database Connection Details such as Host, Port, DB Name, DB User, DB Password.

Step 2: Sign-in into your Electrik.AI account.

Step 3: Select IO in Electrik.AI dashboard.

Step 4: Click on Add button to create a Bing Webmaster Flow.

Step 5: Select Bing Webmaster Connection present in the list of available sources.

Step 6: Select your existing Bing Webmaster connection in Electrik.AI.

To Configure a new connection, refer to this link.

Step 7: Click on a database/ warehouse of your choice from list of available destinations.
In this example we are choosing BigQuery.

Step 8: Select your existing BigQuery connection in Electrik.AI.
To Configure a new connection, refer to this link.

Step 9:
a. Electrik.AI now supports 2 reports, choose the desired type to get the appropriate data. In this example we are choosing Keyword Performance.

b. Review the Data Source, Data Destination, Database Schema, Provide Success Notification Email, Failure Notification Email. Click “Save and Proceed” to continue.
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 signed-in user’s Email Id.

Note: By Default, Electrik.AI chooses an existing Database Schema to load your Bing Webmaster Report. You can create a new schema in your database by selecting the “Create New Schema” radio button.

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

You have now successfully setup Bing Webmaster to BigQuery Data Warehouse flow in Electrik.AI

Your Bing Webmaster will start loading after 24 hours in your Data Warehouse.