Bing Webmaster Data Export

What is Bing Webmaster?

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.

How to add Bing Webmaster Source in Electrik.AI?

Follow these steps to connect your Bing Webmaster to Electrik.AI

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.

Select IO in Electrik.AI dashboard

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

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.

The Source default tab is selected just click on “Bing Webmaster” connection

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

Provide your Bing Webmaster account User Id and Password
Provide your Bing Webmaster account User Id and Password

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

Allow Electrik.AI to access your Bing Webmaster account

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

Select the Site URL from the dropdown whose data you wish to export

Step 9: Click on Save button on the top. 

Click on Save button on the top

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

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

What are the supported Data Destinations?

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

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 Bing Webmaster Data?

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.

Follow these steps to create a Data Flow from Bing Webmaster to Database/Data Warehouse

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.

Select IO in Electrik.AI dashboard

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

Click on Add button to create a Flow

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

Select Bing Webmaster Connection present in the list of available sources

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

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.

Click on a database-warehouse of your choice from list of available destinations

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

Flow Step 8 Select your existing BigQuery connection in Electrik.AI

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.

9a

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.

Step 9b

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.

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

You have now successfully setup Bing Webmaster to BigQuery Data Warehouse flow in ElectrikAI

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

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

Bing Webmaster Data Schema

IndexCategoryElectrik.AI Column NameDescriptionSample Value
1DimensionpagePage URLhttps://mypd.com/resources
2Dimensionsnapshot_dtSnapshot Date2020-11-06T00:00:00Z
3MetricavgclickpositionAvg Click Position0
4MetricavgimpressionpositionAvg Impression Position44
5MetricclicksThe number of instances where searchers clicked the selected page in Bing search results for any query.0
6Metricimpressions The number of instances when the selected page was displayed in the search results to searchers for any query. When a page appears multiple times in one search result, each link counts as an impression.25
7Dimensionsite_urlSite URLhttps://mypd.com/
8Electrik.AIsha_idHashed Primary Key4d7a30ffb7e178 09271acabafbb50c269 4c14878f352013ca5b0c 997a777b454
9Electrik.AIetl_orgOrganization IdORG000097
10Electrik.AIetl_projectProject IdPR000154
11Electrik.AIetl_create_utc_dttmRecord loaded/created Timestamp in UTC2021-06-13 12:45:42 UTC
12Electrik.AIetl_update_utc_dttmRecord Update Timestamp in UTC2021-06-13 12:45:42 UTC
13Electrik.AIetl_start_utc_dttmEAI Flow Start Timestamp in UTC2021-06-13 12:45:42 UTC
14Electrik.AIetl_flow_nmEAI Flow CodeFL001282
15Electrik.AIetl_flow_instance_idEAI Flow Execution Instance IdFL00AD-20190910144445424196
IndexCategoryElectrik.AI Column NameDescriptionSample Value
1DimensionaccountidAccount Id149039804
2DimensionaccountnameAccount NameGajSys
3DimensionaccountnumberAccount NumberH11844PD
4DimensionaccountstatusAccount StatusActive
5DimensionaddistributionAd DistributionSearch
6DimensionadgroupidAd Groupid1260040999272000
7DimensionadgroupnameAd Group NameETL 1st adGrp
8DimensionadgroupstatusAd Group StatusActive
9DimensionadidAd Id78752663168000
10MetricadrelevanceAd Relevance3
11DimensionadtypeAd TypeExpanded text ad
12MetricallconversionrateAll Conversion Rate
13MetricallconversionsAll Conversions0
14MetricallcostperconversionAll Cost Per Conversion
15MetricallreturnonadspendAll Return On Ad Spend
16MetricallrevenueAll Revenue0
17MetricallrevenueperconversionAll Revenue Per Conversion
18MetricassistsAssists0
19MetricaveragecpcAverage Cost Per Click0
20Metricaverageposition This represents the average of the different positions on which any page of your website appeared for the selected keyword.0
21DimensionbasecampaignidBase Campaign Id405600000
22DimensionbidmatchtypeBid Match TypeExact
23DimensionbidstrategytypeBid Strategy TypeMaximize clicks
24DimensioncampaignidCampaign Id405600189
25DimensioncampaignnameCampaign NameEG tools and auto ETL Tst US/CA
26DimensioncampaignstatusCampaign StatusActive
27MetricclicksThe number of instances when the user searched for the selected keyword and clicked on the any page of your website.0
28MetricconversionrateConversion Rate
29MetricconversionsConversions0
30MetriccostperassistCost Per Assist
31MetriccostperconversionCost Per Conversion
32Metricctr For each keyword, this represents the percentage of impressions that resulted in user clicking on any page of your website.(Click Through Rate)0
33DimensioncurrencycodeCurrency CodeUSD
34MetriccurrentmaxcpcCurrent Max Cost Per Click10
35DimensioncustomparametersCustom Parameters
36DimensiondeliveredmatchtypeDelivered Match TypeExact
37DimensiondestinationurlDestination URL
38DimensiondeviceosDevice OSWindows
39DimensiondevicetypeDevice TypeComputer
40MetricexpectedctrExpected Click Through Rate2
41DimensionfinalappurlFinal App URL
42DimensionfinalmobileurlFinal Mobile URL
43DimensionfinalurlFinal URLhttps://mypd.com/etl-test-automation
44DimensionfinalurlsuffixFinal URL Suffix
FMetricfirstpagebidFirst Page Bid
46MetricgoalGoal
47DimensiongoaltypeGoal Type
48MetrichistoricaladrelevanceHistorical Ad Relevance
49MetrichistoricalexpectedctrHistorical Expected Click Through Rate
50MetrichistoricallandingpageexperienceHistorical Landing Page Experience
51MetrichistoricalqualityscoreHistorical Quality Score
52MetricimpressionsThe number of times any page on your website was shown when the user searched for the selected keyword. When multiple pages of your website appear in one search result, each page counts as an impression.2
53DimensionkeywordKeywordetl testing automation tools
54Dimensionkeywordidkeyword Id78752942596000
55DimensionkeywordlabelsKeyword Labels
56DimensionkeywordstatusKeyword StatusActive
57MetriclandingpageexperienceLanding Page Experience3
58DimensionlanguageLanguageEnglish
59Metricmainline1bidMainline1 Bid
60MetricmainlinebidMainline Bid
61DimensionnetworkNetworkBing and Yahoo! search
62MetricqualityimpactQuality Impact0
63MetricqualityscoreQquality Score8
64MetricreturnonadspendRreturn On Ad Spend
65MetricrevenueRevenue0
66MetricrevenueperassistRevenue Per Assist
67MetricrevenueperconversionRevenue Per Conversion
68Dimensionsnapshot_dtSnapshot Date9/16/2021
69MetricspendSpend0
70MetrictopvsotherTop Other Bing WebmasterBing and Yahoo! search - Top
71MetrictrackingtemplateTracking Template
72MetricviewthroughconversionsView Through Conversions0
73Electrik.AIsha_idHashed Primary Key4d7a30ffb7e178 09271acabafbb50c269 4c14878f352013ca5b0c 997a777b454
74Electrik.AIetl_orgOrganization Id2021-11-30T09:45:08Z
75Electrik.AIetl_projectProject IdFL005290-20211130094352920856
76Electrik.AIetl_create_utc_dttmRecord loaded/created Timestamp in UTCFL005290
77Electrik.AIetl_update_utc_dttmRecord Update Timestamp in UTCORG000943
78Electrik.AIetl_start_utc_dttmEAI Flow Start Timestamp in UTCPR000880
79Electrik.AIetl_flow_nmEAI Flow Code2021-11-30T09:43:58.658Z
80Electrik.AIetl_flow_instance_idEAI Flow Execution Instance Id2021-11-30T09:45:08Z