Microsoft Ads Performance Data Export

What is Microsoft Ads?

Microsoft Ads previously known as Bing Ads is an online advertising platform developed by Microsoft, where advertisers pay to display ads based on the keywords used in a user’s search query.

Microsoft Ads report give you post-click performance metrics for users who clicked on your Microsoft Ads and then came to your website, or installed and started using your mobile app.

How to add a Microsoft Ads Source in Electrik.AI?

Follow these steps to connect your Microsoft Ads account to Electrik.AI

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

a. Microsoft Ads Account User Id and Password.

b. Access to Microsoft Ads.

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

Step 3: Select IO in Electrik.AI dashboard

Select IO in Electrik.AI dashboard-ElectrikAI

Step 4: Select the Connections tab in the left most panel.

Step 4 Select the Connections Icon in the left most panel-ElectrikAI

Step 5: Click on “Add” action button.

Step 5 Click on “Add” button the top-ElectrikAI

Step 6: The Source default tab is selected just click on “Microsoft Bing Ads” connection.

Step 6 select Source and Click on “Microsoft Ads”-ElectrikAI

Step 7:  Provide your Microsoft Bing Ads User Id and Password.

Step 7 Bing Sign In-ElectrikAI
Step 7 Bing Password-ElectrikAI

Step 8: Allow Electrik.AI to access your Microsoft Ads account.

Step 8 Allow BingAds-ElectrikAI

Step 9: Select the Microsoft Ads Account from the dropdown whose data you wish to export.

Step 9 Select the Microsoft Ads Account-ElectrikAI

Step 10: Click on Save button on the top.

Step 10 Click on Save button on the top-ElectrikAI

Congratulations, you have successfully created a Microsoft Ads Connection in Electrik.AI

Microsoft BingAds Congratulations-ElectrikAI

What are the supported Data Destinations?

Electrik.AI supports the following databases to export Microsoft Ads 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 Ads Data ?

Electrik.AI creates a data flow (or ETL process) that exports Microsoft Ads Performance reports of your choice 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 Microsoft Ads.
2. Microsoft Ads Account User Id and Password.
3. Access to a Database 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-ElectrikAI

Step 4: Click on Add button to create a Microsoft Ads Performance Data Extractor Flow

Step 4 Flow Add Button-ElectrikAI

Step 5: Select Microsoft Ads Connection present in the list of available sources

Step 5 Flow Select Microsoft Ads Connection-ElectrikAI

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

Step 6 Select your existing Microsoft Ads con-ElectrikAI

To Configure a new connection, refer to this link.

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

Step 7 Select destination mysql-ElectrikAI

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

Step 8 Select existing mysql-ElectrikAI

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

Step 9 a-Flow BingAds Choose REport-ElectrikAI

b. Review the Data Source, Data Destination, Database Schema, Report Name, Provide Success Notification Email, Failure Notification Email
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.
c. Click “Save and Proceed” to continue.

Step 9 b-Review BingAds-ElectrikAI

Note: By Default, Electrik.AI chooses an existing Database Schema to load your Microsoft Ads Report. You can create a new schema in your database by selecting the “Create New Schema” radio button.
Step 10: Congratulations, Flow is created. Please wait while you are redirected to Flow Details Screen.

Step 10 Congratulations Flow is created. Please wait while you are redirected-ElectrikAI

You have now successfully setup Microsoft Ads Performance Report to MySQL Database flow in Electrik.AI

Step 10 Congratulations,Flow BingAds to MYSQL-ElectrikAI

Your Microsoft Ads data will start loading after 24 hours in your Database.

Microsoft Ads data will start loading after 24 hours-ElectrikAI

Microsoft Ads Data Schema

The Ad Performance report includes all statistics aggregated at the ad level.

IndexCategoryElectrik.AI Column Name Description        Sample Value
1DimensionaccountidThe Microsoft Advertising assigned identifier of an account149039804
2DimensionaccountnameThe account nameTorana Inc.
3DimensionaccountnumberThe Microsoft Advertising assigned number of an accountF11844RA
4DimensionaccountstatusThe account statusActive
5DimensionaddescriptionThe first ad description that appears below the path in your adAutomate Data Migration Testing of Hadoop & Other Big Data Platforms With iCEDQ
6Dimensionaddescription2The second ad description that appears below the path in your ad. Ad description 2 might not appear in your ad
7DimensionaddistributionThe network where you want your ads to showSearch
8DimensionadgroupidThe Microsoft Advertising assigned identifier of an ad group1.26114E+15
9DimensionadgroupnameThe ad group nameDatabase Migration
10DimensionadgroupstatusThe ad statusActive
11DimensionadidThe Microsoft Advertising assigned identifier of an ad7.88214E+13
12DimensionadlabelsThe labels applied to the ad
13DimensionadstatusThe ad statusPaused
14DimensionadtitleThe ad title
15DimensionadtypeDifferent Microsoft Advertising ad types are Expanded Text Ads; Dynamic search ads; Product ads; Microsoft Audience Ads; Microsoft Advertising in Bing Smart Search; App Install Ads; Responsive search adsExpanded text ad
16MetricallconversionrateThe conversion rate as a percentage. (Conversions / Clicks) x 100
17MetricallconversionsThe number of conversions0
18MetricallcostperconversionThe cost per conversion
19MetricallreturnonadspendThe return on ad spend (ROAS). ROAS is (Revenue / Spend)
20MetricallrevenueThe revenue optionally reported by the advertiser as a result of conversions.Available for accounts that are setup to use analytics with Microsoft Advertising Universal Event Tracking0
21Metricallrevenueper conversionThe revenue per conversion. (Revenue / Conversions)
22MetricassistsThe number of conversions from other ads within the same account that were preceded by one or more clicks from this ad0
23MetricaveragecpcThe 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 are charged each time your ad is clicked. (Spend /Clicks)0
24MetricaveragepositionThe average position of the ad on a webpage1
25DimensionbasecampaignidThe Microsoft Advertising assigned identifier of an experiment campaign.This will be the same value as the CampaignId if the campaign is not an experiment389316750
26DimensionbidmatchtypeDefines the bid match type values that you can use to filter the report data.The report will contain keywords that set a bid value for the broad match type/Exact match type/Phrase match typeBroad
27DimensionbusinessnameThis column only applies to Audience campaigns.Your business's name may appear in your ad depending on your responsive ad's placement
28DimensioncampaignidThe Microsoft Advertising assigned identifier of a campaign389316750
29DimensioncampaignnameThe campaign nameData Migration Testing
30DimensioncampaignstatusThe campaign statusActive
31DimensioncampaigntypeThe campaign is an Audience campaign/Dynamic Search Ads campaign/Search campaign/Shopping/campaignSearch & content
32MetricclicksClicks are what you pay for. Clicks typically include a customer clicking an ad on a search results page or on a website on the search network. Clicks can also come from other sources (for example,spiders, robots, and test servers)0
33MetricconversionrateThe conversion rate as a percentage. The formula for calculating the conversion rate is (Conversions / Clicks) x 100
34MetricconversionsThe number of conversions. Conversions are measured by adding a small bit of code to your website pages so that a visitor's progress through your site can be tracked0
35MetriccostperassistThe cost per assist
36MetriccostperconversionThe cost per conversion. The formula for calculating the cost per conversion is (Spend / Conversions). Only ads in campaigns that enable conversion tracking contribute to the conversion number, so unless all campaigns in the account enable conversion tracking, the number will not be accurate
37MetricctrThe click-through rate (CTR) is the number of times an ad was clicked, divided by the number of times the ad was shown (impressions).The formula for calculating CTR is (Clicks / Impressions) x 1000
38DimensioncurrencycodeThe account currency typeUSD
39DimensioncustomeridThe Microsoft Advertising assigned identifier of a customer162436566
40DimensioncustomernameThe customer nameTorana Inc.
41DimensioncustomparametersThe match type used to deliver an ad. Identifies the delivered match type (exact, phrase, or broad) to  the user's query
42DimensiondeliveredmatchtypeThe match type used to deliver an ad. Identifies the delivered match type (exact, phrase, or broad)to the user's queryExact
43DimensiondestinationurlThe destination URL attribute of the ad, keyword, or ad group criterion
44DimensiondeviceosThe operating system of the device reported in the DeviceType column. The possible values include Android, Blackberry, iOS, Other, Unknown, and WindowsAndroid
45DimensiondevicetypeThe type of device which showed ads. The possible values include Computer,Smartphone, Tablet, and UnknownSmartphone
46DimensiondisplayurlThe ad display URLicedq.com
47DimensionfinalappurlReserved for future use
48DimensionfinalmobileurlThe Final Mobile URL of the ad, keyword, or criterion
49DimensionfinalurlThe Final URL of the ad, keyword, or criterionhttp://icedq.com/ data-migration-testing-tool
50DimensionfinalurlsuffixA place in your final URL where you can add parameters that will be attached to the end of your landing page URL
51DimensiongoalThe name of the goal you set for the conversions you want, meaning actions customers take after clicking your ad
52DimensiongoaltypeThe type of conversion goal.Possible values include AppInstall, Duration, Event, InStoreTransaction, OfflineConversion, PagesViewedPerVisit, and Url.
53DimensionheadlineThe shorter of two possible responsive ad headlines for Audience campaigns
54MetricimpressionsThe number of times an ad has been displayed on search results pages. Without impressions there are no clicks or conversions.1/1/1900 0:00
55DimensionlanguageThe language of the country the ad is served inEnglish
56DimensionlongheadlineThe longer of two possible responsive ad headlines for Audience campaigns
57DimensionnetworkThe combined search advertising marketplace made up of Bing, AOL, Yahoo, and partner sites. Use this data to make the best decision on network selection for your ad groupsBing and Yahoo! search
58Dimensionpath1The path 1 attribute of an adData-Migration
59Dimensionpath2The path 2 attribute of an ad
60MetricreturnonadspendThe return on ad spend (ROAS). ROAS is (Revenue / Spend)
61MetricrevenueThe revenue optionally reported by the advertiser as a result of conversions1/0/1900 0:00
62MetricrevenueperassistThe revenue per assist. The formula for calculating the revenue per assist is (Revenue / Assists)
63MetricrevenueperconversionThe revenue per conversion
64MetricspendThe cost per click (CPC) summed for each click1/0/1900
65Electrik.AIsnapshot_dtDate on which the data is captured4/17/2020
66Dimensiontitlepart1The title part 1 attribute of an adDB Migration Testing Tool
67Dimensiontitlepart2The title part 2 attribute of an adSave Your Time & Efforts
68Dimensiontitlepart3The title part 3 attribute of an ad
69DimensiontopvsotherThe report will include a column that 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 UnknownBing and Yahoo! search - Top
70DimensiontrackingtemplateThe current tracking template of the ad, keyword, or criterion
71Metricviewthrough conversionsView-through conversions don't have a click associated but do have an impression associated within the advertiser defined conversion window. If the user also clicked on an ad that was delivered via the Microsoft Audience or Search network, there  won't be any view-through conversion counted. Only the click-based conversion would be counted1/0/1900 0:00
72Electrik.AIetl_orgOrganization IdORG000251
73Electrik.AIetl_projectProject IdPR000253
74Electrik.AIetl_create_utc_dttmRecord loaded/created Timestamp in UTC6/24/2020 16:07
75Electrik.AIetl_update_utc_dttmRecord Update Timestamp in UTC6/24/2020 16:07
76Electrik.AIetl_start_utc_dttmEAI Flow Start Timestamp in UTC6/24/2020 16:02
77Electrik.AIetl_flow_nmEAI Flow CodeFL001309
78Electrik.AIetl_flow_instance_idEAI Flow Execution Instance IdFL001309- 20200624103037574783

The Ad Group Performance report includes all statistics aggregated by default at the ad group level.

IndexCategoryElectrik.AI Column Name Description        Sample Value
1DimensionaccountidThe Microsoft Advertising assigned identifier of an account149039804
2DimensionaccountnameThe account nameTorana Inc.
3DimensionaccountnumberThe Microsoft Advertising assigned number of an accountF11844RA
4DimensionaccountstatusThe account statusActive
5DimensionaddistributionThe network where you want your ads to showSearch
6DimensionadgroupidThe Microsoft Advertising assigned identifier of an ad group1.26334E+15
7DimensionadgrouplabelsThe labels applied to the ad group
8DimensionadgroupnameThe ad group nameETL Testing
9DimensionadrelevanceRelevant between ad and landing page to the potential customers. A score of 3 for Above Average; 2 for Average; 1 for Below Average and "--" (double dash) for not computed. The score is calculated only based on Search Traffic.Data for this column is typically updated 14-18 hours after the UTC day ends3
10MetricallconversionrateThe conversion rate as a percentage. (Conversions / Clicks) x 100
11MetricallconversionsThe number of conversions0
12MetricallcostperconversionThe cost per conversion
13MetricallreturnonadspendThe return on ad spend (ROAS). ROAS is (Revenue / Spend).
14MetricallrevenueThe revenue optionally reported by the advertiser as a result of conversions0
15MetricallrevenueperconversionThe revenue per conversion
16MetricassistsThe number of conversions from other ads within the same account that were preceded by one or more clicks from this ad0
17MetricaveragecpcThe 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 are charged each time your ad is clicked. (Spend /Clicks)0
18MetricaveragepositionThe average position of the ad on a webpage1
19DimensionbasecampaignidThe Microsoft Advertising assigned identifier of an experiment campaign. This will be the same value as the CampaignId if the campaign is not an experiment389316749
20DimensionbidmatchtypeDefines the bid match type values that you can use to filter the report data.The report will contain keywords that set a bid value for the broad match type/Exact match type/Phrase match typeExact
21DimensioncampaignidThe Microsoft Advertising assigned identifier of a campaign389316749
22DimensioncampaignnameThe campaign nameiCEDQ - UK
23DimensioncampaignstatusThe campaign statusActive
24DimensioncampaigntypeThe campaign is an Audience campaign/Dynamic Search Ads campaign/Search campaign/Shopping campaignSearch & content
25MetricclicksClicks are what you pay for. Clicks typically include a customer clicking an ad on a search results page or on a website on the search network. Clicks can also come from other sources (for example, spiders, robots, and test servers)0
26MetricconversionrateThe conversion rate as a percentage. The formula for calculating the conversion rate is (Conversions / Clicks) x 100
27MetricconversionsThe number of conversions. Conversions are measured by adding a small bit of code to your website pages so that a visitor's progress through your site can be tracked0
28MetriccostperassistThe cost per assist
29MetriccostperconversionThe cost per conversion. The formula for calculating the cost per conversion is (Spend / Conversions). Only ads in campaigns that enable conversion tracking contribute to the conversion number, so unless all campaigns in the account enable conversion tracking, the number will not be accurate
30MetricctrThe click-through rate (CTR) is the number of times an ad was clicked, divided by the number of times the ad was shown (impressions). The formula for calculating CTR is (Clicks / Impressions) x 1000
31DimensioncurrencycodeThe account currency typeUSD
32DimensioncustomeridThe Microsoft Advertising assigned identifier of a customer162436566
33DimensioncustomernameThe customer nameTorana Inc.
34DimensioncustomparametersThe current custom parameters set for the ad group is a key and value pair and semicolon-delimited and each key is enclosed by braces and a leading underscore(Example :{_key1}=value1;{_key2}=value2)
35DimensiondeliveredmatchtypeThe match type used to deliver an ad. Identifies the delivered match type (exact, phrase, or broad) to  the user's queryExact
36DimensiondeviceosThe operating system of the device reported in the DeviceType column. The possible values include Android, Blackberry, iOS, Other, Unknown, and WindowsWindows
37DimensiondevicetypeThe type of device which showed ads. The possible values include  Computer, Smartphone,Tablet, and UnknownComputer
38MetricexpectedctrThis metric tells you if a keyword is underperforming and causing a loss in impression share, so you can make keyword changes. A score of 3 for Above Average; 2 for Average; 1 for Below Average and "--" (double dash) for not computed. The score is calculated only based on Search Traffic.Data for this column is typically updated 14-18 hours after the UTC day ends3
39DimensionfinalurlsuffixA place in your final URL where you can add parameters that will be attached to the end of your landing page URL
40DimensiongoalThe name of the goal you set for the conversions you want, meaning actions customers take after clicking your ad
41DimensiongoaltypeThe type of conversion goal. Possible values include AppInstall, Duration, Event, InStoreTransaction, OfflineConversion, PagesViewedPerVisit, and Url.
42MetrichistoricaladrelevanceHistorical average of ad relevance scores back as far as 18 months from the current date. This score may vary from the score in the AdRelevance column, which is the current score and same value for each day in the time period.
43MetrichistoricalexpectedctrHistorical average of expected click-through rate scores going back as far as 18 months from the current date.This score may vary from the score in the ExpectedCtr column, which is the current score and same value for each day in the time period.
44Metrichistoricallanding pageexperienceHistorical average of landing page experience scores back as far as 18 months from the current date. This score may vary from the score in the LandingPageExperience
45MetrichistoricalqualityscoreThe historical quality score for each row is the value that was calculated for quality score on that date. Use The historical quality score to find out how the quality score may have changed over time.This score may vary from the score in the QualityScore column. You may include this column only with Daily aggregation
46MetricImpressionsThe number of times an ad has been displayed on search results pages. Without impressions there are no clicks or conversions.
47MetriclandingpageexperienceAn aggregate quality assessment score measures whether your landing page is likely to provide a good experience to customers who click your ad and land on your website. A score of 3 for Above Average; 2 for Average; 1 for Below Average and "--" (double dash) for not computed. The score is calculated only based on Search Traffic.Data for this column is typically updated 14-18 hours after the UTC day ends3
48DimensionlanguageThe language of the country the ad is served inEnglish
49DimensionnetworkThe combined search advertising marketplace made up of Bing, AOL, Yahoo, and partner sites. Use this data to make the best decision on network selection for your ad groupsBing and Yahoo! search
50MetricphonecallsThe number of total calls to the tracked phone number that showed with your ad0
51MetricphoneimpressionsThe number of times your tracked number was shown on all devices.
52MetricptrThe phone-through rate (Ptr). The formula for calculating the Ptr is (PhoneCalls / PhoneImpressions) x 100
53MetricqualityscoreThe score measures how relevant your keywords and landing pages are to customers' search terms. The quality score is calculated by Microsoft Advertising using the ExpectedCtr, AdRelevance, and LandingPageExperience sub scores. If available, the quality score can range from a low of 1 to a high of 10. Quality score is based on the last rolling 30 days for the owned and operated search traffic9
54MetricreturnonadspendThe return on ad spend (ROAS). ROAS is (Revenue / Spend)
55MetricrevenueThe revenue optionally reported by the advertiser as a result of conversions0
56MetricrevenueperassistThe revenue per assist. The formula for calculating the revenue per assist is (Revenue / Assists)
57MetricrevenueperconversionThe revenue per conversion
58Electrik.AIsnapshot_dtThe date on which snapshot is taken6/24/2020
59MetricspendThe cost per click (CPC) summed for each click0
60DimensionstatusThe current ad group statusActive
61DimensiontopvsotherThe report will include a column that 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 UnknownBing and Yahoo! search - Top
62DimensiontrackingtemplateThe current tracking template for the ad group
63MetricviewthroughconversionsView-through conversions don't have a click associated but do have an impression associated within the advertiser defined conversion window. If the user also clicked on an ad that was delivered via the Microsoft Audience or Search network, there won't be any view-through conversion counted. Only the click-based conversion would be counted1/0/1900 0:00
64Electrik.AIetl_orgOrganization IdORG000251
65Electrik.AIetl_projectProject IdPR000253
66Electrik.AIetl_create_utc_dttmRecord loaded/created Timestamp in UTC6/24/2020 11:49
67Electrik.AIetl_update_utc_dttmRecord Update Timestamp in UTC6/24/2020
68Electrik.AIetl_start_utc_dttmEAI Flow Start Timestamp in UTC6/24/2020
69Electrik.AIetl_flow_nmEAI Flow CodeFL001313
70Electrik.AIetl_flow_instance_idEAI Flow Execution Instance IdFL001313-20200624 114214205465

The Campaigns Performance report includes all statistics aggregated by default at the campaign level.

IndexCategoryElectrik.AI Column Name Description  Sample Value
1DimensionaccountidThe Microsoft Advertising assigned identifier of an account149039804
2DimensionaccountnameThe account nameTorana Inc.
3DimensionaccountnumberThe Microsoft Advertising assigned number of an accountF11844RA
4DimensionaccountstatusThe account statusActive
5DimensionaddistributionThe network where you want your ads to showSearch
6MetricadrelevanceRelevant between ad and landing page to the potential customers. A score of 3 for Above Average; 2 for Average; 1 for Below Average and "--" (double dash) for not computed. The score is calculated only based on Search Traffic.Data for this column is typically updated 14-18 hours after the UTC day ends3
7MetricallconversionrateThe conversion rate as a percentage. (Conversions / Clicks) x 100
8MetricallconversionsThe number of conversions0
9MetricallcostperconversionThe cost per conversion
10MetricallreturnonadspendThe return on ad spend (ROAS). ROAS is (Revenue / Spend)
11MetricallrevenueThe revenue optionally reported by the advertiser as a result of conversions.Available for accounts that are setup to use analytics with Microsoft Advertising Universal Event Tracking0
12MetricallrevenueperconversionThe revenue per conversion. (Revenue / Conversions)
13MetricassistsThe number of conversions from other ads within the same account that were preceded by one or more clicks from this ad0
14MetricaveragecpcThe 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 are charged each time your ad is clicked. (Spend/Clicks)0
15MetricaveragepositionThe average position of the ad on a webpage1
16DimensionbasecampaignidThe Microsoft Advertising assigned identifier of an experiment campaign. This will be the same value as the CampaignId if the campaign is not an experiment389309238
17DimensionbidmatchtypeDefines the bid match type values that you can use to filter the report data.The report will contain keywords that set a bid value for the broad match type/Exact match type /Phrase match typeBroad
18DimensionbudgetassociationstatusIndicates whether or not the campaign is currently spending from the budget mentioned in the BudgetName column. The possible values are Current and EndedCurrent
19DimensionbudgetnameThe name of the budget
20Dimensionbudgetstatushe budget status. The possible values are Active and Deleted
21DimensioncampaignidThe Microsoft Advertising assigned identifier of a campaign389309238
22DimensioncampaignlabelsThe labels applied to the campaign
23DimensioncampaignnameThe campaign nameETL Testing
24DimensioncampaignstatusThe campaign statusActive
25DimensioncampaigntypeThe campaign is an Audience campaign /Dynamic Search Ads campaign/Search campaign/Shopping campaignSearch & content
26MetricclicksClicks are what you pay for. Clicks typically include a customer clicking an ad on a search results page or on a website on the search network. Clicks can also come from other sources (for example, spiders, robots, and test servers)0
27MetricconversionrateThe conversion rate as a percentage. The formula for calculating the conversion rate is (Conversions / Clicks) x 100
28MetricconversionsThe number of conversions. Conversions are measured by adding a small bit of code to your website pages so that a visitor's progress through your site can be tracked0
29MetriccostperassistThe cost per assist
30MetriccostperconversionThe cost per conversion. The formula for calculating the cost per conversion is (Spend / Conversions). Only ads in campaigns that enable conversion tracking contribute to the conversion number, so unless all campaigns in the account enable conversion tracking, the number will not be accurate
31MetricctrThe click-through rate (CTR) is the number of times an ad was clicked, divided by the number of times the ad was shown (impressions). The formula for calculating CTR is (Clicks / Impressions) x 1000
32DimensioncurrencycodeThe account currency typeUSD
33DimensioncustomeridThe Microsoft Advertising assigned identifier of a customer162436566
34DimensioncustomernameThe customer nameTorana Inc.
35DimensioncustomparametersThe match type used to deliver an ad. Identifies the delivered match type (exact, phrase, or broad)to the user's query
36DimensiondeliveredmatchtypeThe match type used to deliver an ad. Identifies the delivered match type (exact, phrase, or broad)to the user's queryBroad
37DimensiondeviceosThe operating system of the device reported in the DeviceType column. The possible values include Android, Blackberry, iOS, Other, Unknown, and WindowsAndroid
38DimensiondevicetypeThe type of device which showed ads. The possible values include  Computer,Smartphone, Tablet, and UnknownSmartphone
39MetricexpectedctrThis metric tells you if a keyword is underperforming and causing a loss in impression share, so you can make keyword changes. A score of 3 for Above Average; 2 for Average; 1 for Below Average and "--" (double dash) for not computed. The score is calculated only based on Search Traffic.Data for this column is typically updated 14-18 hours after the UTC day ends2
40DimensionfinalurlsuffixA place in your final URL where you can add parameters that will be attached to the end of your landing page URL
41DimensiongoalThe name of the goal you set for the conversions you want, meaning actions customers take after clicking your ad
42DimensiongoaltypeThe type of conversion goal. Possible values include AppInstall, Duration, Event, InStoreTransaction, OfflineConversion, PagesViewedPerVisit, and Url.
43MetrichistoricaladrelevanceHistorical average of ad relevance scores back as far as 18 months from the current date. This score may vary from the score in the AdRelevance column, which is the current score and same value for each day in the time period.3
44MetrichistoricalexpectedctrHistorical average of expected click-through rate scores going back as far as 18 months from the current date. This score may vary from the score in the ExpectedCtr column, which is the current score and same value for each day in the time period.2
45Metrichistoricallanding pageexperienceHistorical average of landing page experience scores back as far as 18 months from the current date. This score may vary from the score in the LandingPageExperience1/3/1900
46MetrichistoricalqualityscoreThe historical quality score for each row is the value that was calculated for quality score on that date. Use The historical quality score to find out how the quality score may have changed over time. This score may vary from the score in the QualityScore column.You may include this column only with Daily aggregation8
47MetricImpressionsThe number of times an ad has been displayed on search results pages. Without impressions there are no clicks or conversions.
48MetriclandingpageexperienceAn aggregate quality assessment score measures whether your landing page is likely to provide a good experience to customers who click your ad and land on your website. A score of 3 for Above Average; 2 for Average; 1 for Below Average and "--" (double dash) for not computed. The score is calculated only based on Search Traffic.Data for this column is typically updated 14-18 hours after the UTC day ends3
49MetriclowqualityclicksClicks that exhibit a low likelihood of commercial intent0
50MetriclowqualityclickspercentThe low-quality clicks as a percentage. The formula for calculating the low quality clicks percentage is (LowQualityClicks / Clicks) x 100
51MetriclowqualityconversionrateThe low-quality conversion rate as a percentage. The formula for calculating the conversion rate is (LowQuality Conversions / LowQualityClicks) x 100
52MetriclowqualityconversionsThe number of conversions that originate from low-quality clicks0
53MetriclowqualitygeneralclicksClicks that are filtered by general methods, such as blacklists and activity- based detection, and that exhibit a low likelihood of commercial intent1/0/1900 0:00
54MetriclowqualityImpressionsThe number of impressions that result from low-quality keyword searches.
55Metriclowquality sophisticatedclicksInvalid clicks that use sophisticated means to appear valid1/0/1900 0:00
56DimensionnetworkThe combined search advertising marketplace made up of Bing, AOL, Yahoo, and partner sites. Use this data to make the best decision on network selection for your ad groupsSyndicated search partners
57MetricphonecallsThe number of total calls to the tracked phone number that showed with your ad0
58MetricphoneimpressionsThe number of times your tracked number was shown on all devices.
59MetricptrThe phone-through rate (Ptr). The formula for calculating the Ptr is (PhoneCalls / PhoneImpressions) x 100
60MetricqualityscoreThe score measures how relevant your keywords and landing pages are to customers' search terms. The quality score is calculated by Microsoft Advertising using the ExpectedCtr, AdRelevance, and LandingPageExperience sub scores. If available, the quality score can range from a low of 1 to a high of 10. Quality score is based on the last rolling 30 days for the owned and operated search traffic8
61DimensionreturnonadspendThe return on ad spend (ROAS). ROAS is (Revenue / Spend)
62MetricrevenueThe revenue optionally reported by the advertiser as a result of conversions1/0/1900 0:00
63MetricrevenueperassistThe revenue per assist. The formula for calculating the revenue per assist is (Revenue / Assists)
64MetricrevenueperconversionThe revenue per conversion
65MetricspendThe cost per click (CPC) summed for each click0
66Electrik.AIsnapshot_dtThe date on which snapshot is taken4/3/2020
67DimensiontopvsotherThe report will include a column that 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 UnknownSyndicated search partners - Top
68DimensiontrackingtemplateThe current tracking template for the ad group
69MetricviewthroughconversionsView-through conversions don't have a click associated but do have an impression associated within the advertiser defined conversion window. If the user also clicked on an ad that was delivered via the Microsoft Audience or Search network, there won't be any view-through conversion counted. Only the click-based conversion would be counted0
70Electrik.AIetl_orgOrganization IdORG000251
71Electrik.AIetl_projectProject IdPR000253
72Electrik.AIetl_create_utc_dttmRecord loaded/created Timestamp in UTC6/17/2020 12:58
73Electrik.AIetl_update_utc_dttmRecord Update Timestamp in UTC6/17/2020 12:58
74Electrik.AIetl_start_utc_dttmEAI Flow Start Timestamp in UTC6/17/2020 12:49
75Electrik.AIetl_flow_nmEAI Flow CodeFL001257
76Electrik.AIetl_flow_instance_idEAI Flow Execution Instance IdFL001257- 20200617071 827011898

The Keywords Performance report includes all statistics aggregated at the keyword level.

IndexCategoryElectrik.AI Column Name Description Sample Value
1DimensionaccountidThe Microsoft Advertising assigned identifier of an account149039804
2DimensionaccountnameThe account nameTorana Inc.
3DimensionaccountnumberThe Microsoft Advertising assigned number of an accountF11844RA
4DimensionaccountstatusThe account statusActive
5DimensionaddistributionThe network where you want your ads to showSearch
6DimensionadgroupidThe Microsoft Advertising assigned identifier of an ad group1.26114E+15
7DimensionadgroupnameThe ad group nameDatabase Migration
8DimensionadgroupstatusThe ad statusActive
9DimensionadidThe Microsoft Advertising assigned identifier of an ad7.88214E+13
10MetricadrelevanceRelevant between ad and landing page to the potential customers. A score of 3 for Above Average; 2 for Average; 1 for Below Average and "--" (double dash) for not computed. The score is calculated only based on Search Traffic.Data for this column is typically updated 14-18 hours after the UTC day ends3
11DimensionadtypeDifferent Microsoft Advertising ad types are Expanded Text Ads; Dynamic search ads; Product ads; Microsoft Audience Ads; Microsoft Advertising in Bing Smart Search; App Install Ads; Responsive search adsExpanded text ad
12MetricallconversionrateThe conversion rate as a percentage. (Conversions / Clicks) x 100
13MetricallconversionsThe number of conversions0
14MetricallcostperconversionThe cost per conversion
15MetricallreturnonadspendThe return on ad spend (ROAS). ROAS is (Revenue / Spend)
16MetricallrevenueThe revenue optionally reported by the advertiser as a result of conversions. Available for accounts that are setup to use analytics with Microsoft Advertising Universal Event Tracking0
17MetricallrevenueperconversionThe revenue per conversion. (Revenue / Conversions)
18MetricassistsThe number of conversions from other ads within the same account that were preceded by one or more clicks from this ad0
19MetricaveragecpcThe 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 are charged each time your ad is clicked. (Spend /Clicks)0
20MetricaveragepositionThe average position of the ad on a webpage1
21DimensionbasecampaignidThe Microsoft Advertising assigned identifier of an experiment campaign. This will be the same value as the CampaignId if the campaign is not an experiment389316750
22DimensionbidmatchtypeDefines the bid match type values that you can use to filter the report data.The report will contain keywords that set a bid value for the broad match type/Exact match type/Phrase match typePhrase
23DimensionbidstrategytypeThe bid strategy type. Possible values include EnhancedCpc, ManualCpc, MaxClicks, MaxConversions, and TargetCpaMaximize clicks
24DimensioncampaignidThe Microsoft Advertising assigned identifier of a campaign389316750
25DimensioncampaignnameThe campaign nameData Migration Testing
26DimensioncampaignstatusThe campaign statusActive
27MetricclicksClicks are what you pay for. Clicks typically include a customer clicking an ad on a search results page or on a website on the search network. Clicks can also come from other sources (for example, spiders, robots, and test servers)0
28MetricconversionrateThe conversion rate as a percentage. The formula for calculating the conversion rate is (Conversions / Clicks) x 100
29MetricconversionsThe number of conversions. Conversions are measured by adding a small bit of code to your website pages so that a visitor's progress through your site can be tracked0
30MetriccostperassistThe cost per assist
31MetriccostperconversionThe cost per conversion. The formula for calculating the cost per conversion is (Spend / Conversions). Only ads in campaigns that enable conversion tracking contribute to the conversion number,so unless all campaigns in the account enable conversion tracking,the number will not be accurate
32MetricctrThe click-through rate (CTR) is the number of times an ad was clicked, divided by the number of times the ad was shown (impressions). The formula for calculating CTR is (Clicks / Impressions) x 1000
33DimensioncurrencycodeThe account currency typeUSD
34MetriccurrentmaxcpcThe maximum cost per click bid that was in effect at the time the report was generated7.24
35DimensioncustomparametersThe match type used to deliver an ad. Identifies the delivered match type (exact, phrase, or broad)to the user's query
36DimensiondeliveredmatchtypeThe match type used to deliver an ad. Identifies the delivered match type (exact, phrase, or broad)to the user's queryExact
37DimensiondestinationurlThe destination URL attribute of the ad, keyword, or ad group criterion
38DimensiondeviceosThe operating system of the device reported in the DeviceType column. The possible values include Android, Blackberry, iOS, Other, Unknown, and WindowsWindows
39DimensiondevicetypeThe type of device which showed ads. The possible values include Computer, Smartphone, Tablet, and UnknownComputer
40MetricexpectedctrThis metric tells you if a keyword is underperforming and causing a loss in impression share, so you can make keyword changes. A score of 3 for Above Average; 2 for Average; 1 for Below Average and "--" (double dash) for not computed. The score is calculated only based on Search Traffic.Data for this column is typically updated 14-18 hours after the UTC day ends2
41DimensionfinalappurlReserved for future use
42DimensionfinalmobileurlThe Final Mobile URL of the ad, keyword, or criterion
43DimensionfinalurlThe Final URL of the ad, keyword, or criterionhttp://icedq.com/data- migration-testing-tool
44DimensionfinalurlsuffixA place in your final URL where you can add parameters that will be attached to the end of your landing page URL
45MetricfirstpagebidBased on your campaign performance and marketplace dynamics, this estimate is the bid amount that Microsoft Advertising calculates for your ad to be placed on the first page in the search results
55DimensiongoalThe name of the goal you set for the conversions you want, meaning actions customers take after clicking your ad
56DimensiongoaltypeThe type of conversion goal. Possible values include AppInstall, Duration, Event, InStoreTransaction, OfflineConversion, PagesViewedPerVisit, and Url.
46MetrichistoricaladrelevanceHistorical average of ad relevance scores back as far as 18 months from the current date. This score may vary from the score in the AdRelevance column, which is the current score and same value for each day in the time period.3
47MetrichistoricalexpectedctrHistorical average of expected click-through rate scores going back as far as 18 months from the current date.This score may vary from the score in the ExpectedCtr column, which is the current score and same value for each day in the time period.3
48Metrichistoricallanding pageexperienceHistorical average of landing page experience scores back as far as 18 months from the current date. This score may vary from the score in the LandingPage Experience3
49MetrichistoricalqualityscoreThe historical quality score for each row is the value that was calculated for quality score on that date. Use The historical quality score to find out how the quality score may have changed over time.This score may vary from the score in the QualityScore column .You may include this column only with Daily aggregation10
50MetricimpressionsThe number of times an ad has been displayed on search results pages. Without impressions there are no clicks or conversions.1
51DimensionkeywordThe keyword textdata migration risks
52DimensionkeywordidKeyword ID7.88216E+13
53DimensionkeywordlabelsThe labels applied to the keyword
54DimensionkeywordstatusThe keyword statusActive
55MetriclandingpageexperienceAn aggregate quality assessment score measures whether your landing page is likely to provide a good experience to customers who click your ad and land on your website.A score of 3 for Above Average; 2 for Average; 1 for Below Average and "--" (double dash) for not computed. The score is calculated only based on Search Traffic. Data for this column is typically updated 14-18 hours after the UTC day ends3
56DimensionlanguageThe language of the country the ad is served inEnglish
57Metricmainline1bidBased on your campaign performance and marketplace dynamics, this estimate is the bid amount that Microsoft Advertising calculates will place your ad at the top of search results
58MetricmainlinebidBased on your campaign performance and marketplace dynamics, this estimate is the bid amount that Microsoft Advertising calculates for your ad to be placed on the first page in the search results
59DimensionnetworkThe combined search advertising marketplace made up of Bing, AOL, Yahoo, and partner sites. Use this data to make the best decision on network selection for your ad groupsSyndicated search partners
60MetricqualityimpactThe possible increase in the number of impressions that the keyword could receive.It could be 0 to 3 corresponding to QualityScore  underperforming; Low; Medium and High impact respectively0
61MetricqualityscoreThe score measures how relevant your keywords and landing pages are to customers' search terms. The quality score is calculated by Microsoft Advertising using the ExpectedCtr, AdRelevance, and LandingPageExperience sub scores. If available, the quality score can range from a low of 1 to a high of 10. Quality score is based on the last rolling 30 days for the owned and operated search traffic8
62MetricreturnonadspendThe return on ad spend (ROAS). ROAS is (Revenue / Spend)
63MetricrevenueThe revenue optionally reported by the advertiser as a result of conversions0
64MetricrevenueperassistThe revenue per assist. The formula for calculating the revenue per assist is (Revenue / Assists)
65MetricrevenueperconversionThe revenue per conversion
66MetricspendThe cost per click (CPC) summed for each click0
67Electrik.AIsnapshot_dtThe date on which snapshot is taken4/3/2020
68DimensiontopvsotherThe report will include a column that 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 UnknownSyndicated search partners - Top
69DimensiontrackingtemplateThe current tracking template for the ad group
70MetricviewthroughconversionsView-through conversions don't have a click associated but do have an impression associated within the advertiser defined conversion window. If the user also clicked on an ad that was delivered via the Microsoft Audience or Search network, there won't be any view-through conversion counted. Only the click-based conversion would be counted0
71Electrik.AIetl_orgOrganization IdORG000251
72Electrik.AIetl_projectProject IdPR000253
73Electrik.AIetl_create_utc_dttmRecord loaded/created Timestamp in UTC6/17/2020 12:58
74Electrik.AIetl_update_utc_dttmRecord Update Timestamp in UTC6/17/2020 12:58
75Electrik.AIetl_start_utc_dttmEAI Flow Start Timestamp in UTC6/17/2020 12:49
76Electrik.AIetl_flow_nmEAI Flow CodeFL001257
77Electrik.AIetl_flow_instance_idEAI Flow Execution Instance IdFL001257-202006170 71827011898
IndexCategoryElectrik.AI Column Name Description  Sample Value
1DimensionaccountidThe Microsoft Advertising assigned identifier of an account149039804
2DimensionaccountnameThe account nameTorana Inc.
3DimensionaccountnumberThe Microsoft Advertising assigned number of an accountF11844RA
4DimensionaccountstatusThe account statusActive
5DimensionaddescriptionThe first ad description that appears below the path in your adAutomate Data Migration Testing of Hadoop & Other Big Data Platforms With iCEDQ
6Dimensionaddescription2The second ad description that appears below the path in your ad. Ad description 2 might not appear in your ad
7DimensionaddistributionThe network where you want your ads to showSearch
8DimensionadgroupidThe Microsoft Advertising assigned identifier of an ad group1.26114E+15
9DimensionadgroupnameThe ad group nameDatabase Migration
10DimensionadgroupstatusThe ad group statusActive
11DimensionadidThe Microsoft Advertising assigned identifier of an ad7.88214E+13
12DimensionadlabelsThe labels applied to the ad
13DimensionadstatusThe ad statusPaused
14DimensionadtitleThe ad title
15DimensionadtypeDifferent Microsoft Advertising ad types are Expanded Text Ads; Dynamic search ads; Product ads; Microsoft Audience Ads; Microsoft Advertising in Bing Smart Search; App Install Ads; Responsive search adsExpanded text ad
16MetricallconversionrateThe conversion rate as a percentage. (Conversions / Clicks) x 100
17MetricallconversionsThe number of conversions0
18MetricallcostperconversionThe cost per conversion
19MetricaveragecpcThe 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 are charged each time your ad is clicked. (Spend /Clicks)0
20MetricaveragepositionThe average position of the ad on a webpage1
21MetricclicksClicks are what you pay for. Clicks typically include a customer clicking an ad on a search results page or on a website on the search network. Clicks can also come from other sources (for example, spiders, robots, and test servers)0
22MetricconversionrateThe conversion rate as a percentage. The formula for calculating the conversion rate is (Conversions / Clicks) x 100
23MetricconversionsThe number of conversions. Conversions are measured by adding a small bit of code to your website pages so that a visitor's progress through your site can be tracked0
24MetriccostperconversionThe cost per conversion. The formula for calculating the cost per conversion is (Spend / Conversions). Only ads in campaigns that enable conversion tracking contribute to the conversion number, so unless all campaigns in the account enable conversion tracking, the number will not be accurate
25MetricctrThe click-through rate (CTR) is the number of times an ad was clicked, divided by the number of times the ad was shown (impressions). The formula for calculating CTR is (Clicks / Impressions) x 1000
26DimensioncurrencycodeThe account currency typeUSD
27DimensiondestinationurlThe destination URL attribute of the ad, keyword, or ad group criterion
28DimensiondevicetypeThe type of device which showed ads. The possible values include  Computer, Smartphone,Tablet, and UnknownSmartphone
29DimensionfinalappurlReserved for future use
30DimensionfinalmobileurlThe Final Mobile URL of the ad, keyword, or criterion
31DimensionfinalurlThe Final URL of the ad, keyword, or criterionhttp://icedq.com/data- migration-testing-tool
32DimensiongoalThe name of the goal you set for the conversions you want, meaning actions customers take after clicking your ad
33DimensiongoaltypeThe type of conversion goal. Possible values include AppInstall, Duration, Event, InStoreTransaction, OfflineConversion, PagesViewedPerVisit, and Url.
34MetricimpressionsThe number of times an ad has been displayed on search results pages. Without impressions there are no clicks or conversions.1
35DimensionkeywordThe keyword text#NAME?
36DimensionkeywordstatusThe keyword statusActive
37DimensionlanguageThe language of the country the ad is served inEnglish
38Dimensionparam1The first dynamic substitution parameter (Param1) of a keyword or biddable ad group criterion
39Dimensionparam2The second dynamic substitution parameter (Param2) of a keyword or biddable ad group criterion
40Dimensionparam3The third dynamic substitution parameter (Param3) of a keyword or biddable ad group criterion
41Dimensionpath1The path 1 attribute of an adData-Migration
42Dimensionpath2The path 2 attribute of an ad
43MetricspendThe cost per click (CPC) summed for each click0
44Electrik.AIsnapshot_dtDate on which the data is captured4/17/2020
45Dimensiontitlepart1The title part 1 attribute of an adDB Migration Testing Tool
46Dimensiontitlepart2The title part 2 attribute of an adSave Your Time & Efforts
47Dimensiontitlepart3The title part 3 attribute of an ad
48MetricviewthroughconversionsView-through conversions don't have a click associated but do have an impression associated within the advertiser defined conversion window. If the user also clicked on an ad that was delivered via the Microsoft Audience or Search network, there won't be any view-through conversion counted. Only the click-based conversion would be counted0
49Electrik.AIetl_orgOrganization IdORG000251
50Electrik.AIetl_projectProject IdPR000253
51Electrik.AIetl_create_utc_dttmRecord loaded/created Timestamp in UTC6/17/2020 12:58
52Electrik.AIetl_update_utc_dttmRecord Update Timestamp in UTC6/17/2020 12:58
53Electrik.AIetl_start_utc_dttmEAI Flow Start Timestamp in UTC6/17/2020
54Electrik.AIetl_flow_nmEAI Flow CodeFL001257
55Electrik.AIetl_flow_instance_idEAI Flow Execution Instance IdFL001257-2020061 7071827011898
The Search Terms report includes all statistics aggregated at the search term level.
IndexCategoryElectrik.AI Column Name Description Sample Value
1DimensionaccountidThe Microsoft Advertising assigned identifier of an account149039804
2DimensionaccountnameThe account nameTorana Inc.
3DimensionaccountnumberThe Microsoft Advertising assigned number of an accountF11844RA
4DimensionaccountstatusThe account statusActive
5DimensionadgroupcriterionidThe Microsoft Advertising assigned identifier of an ad group criterion
6DimensionadgroupidThe Microsoft Advertising assigned identifier of an ad group1.26114E+15
7DimensionadgroupnameThe ad group nameDatabase Migration
8DimensionadgroupstatusThe ad group statusActive
9DimensionadidThe Microsoft Advertising assigned identifier of an ad7.88214E+13
10DimensionadstatusThe ad statusActive
11DimensionadtypeDifferent Microsoft Advertising ad types are Expanded Text Ads; Dynamic search ads; Product ads; Microsoft Audience Ads; Microsoft Advertising in Bing Smart Search; App Install Ads; Responsive search adsExpanded text ad
12MetricallconversionrateThe conversion rate as a percentage. (Conversions / Clicks) x 1000
13MetricallconversionsThe number of conversions0
14MetricallcostperconversionThe cost per conversion
15MetricallreturnonadspendThe return on ad spend (ROAS). ROAS is (Revenue / Spend)0
16MetricallrevenueThe revenue optionally reported by the advertiser as a result of conversions.Available for accounts that are setup to use analytics with Microsoft Advertising Universal Event Tracking0
17MetricallrevenueperconversionThe revenue per conversion. (Revenue / Conversions)
18MetricassistsThe number of conversions from other ads within the same account that were preceded by one or more clicks from this ad0
19MetricaveragecpcThe 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 are charged each time your ad is clicked. (Spend /Clicks)3.66
20MetricaveragepositionThe average position of the ad on a webpage2
21DimensionbidmatchtypeDefines the bid match type values that you can use to filter the report data.The report will contain keywords that set a bid value for the broad match type/Exact match type/Phrase match typeBroad
22DimensioncampaignidThe Microsoft Advertising assigned identifier of a campaign389316750
23DimensioncampaignnameThe campaign nameData Migration Testing
24DimensioncampaignstatusThe campaign statusActive
25DimensioncampaigntypeThe type of campaign. Possible values are Audience campaign/Dynamic Search Ads ampaign/Search campaign/ Shopping campaignSearch & content
26MetricclicksClicks are what you pay for. Clicks typically include a customer clicking an ad on a search results page or on a website on the search network. Clicks can also come from other sources (for example, spiders, robots, and test servers)1
27MetricconversionrateThe conversion rate as a percentage. The formula for calculating the conversion rate is (Conversions / Clicks) x 1000
28MetricconversionsThe number of conversions. Conversions are measured by adding a small bit of code to your website pages so that a visitor's progress through your site can be tracked0
29MetriccostperassistThe cost per assist. The formula for calculating the cost per assist is
30MetriccostperconversionThe cost per conversion. The formula for calculating the cost per conversion is (Spend / Conversions). Only ads in campaigns that enable conversion tracking contribute to the conversion number, so unless all campaigns in the account enable conversion tracking, the number will not be accurate
31MetricctrThe click-through rate (CTR) is the number of times an ad was clicked, divided by the number of times the ad was shown (impressions). The formula for calculating CTR is (Clicks / Impressions) x 100100
32DimensioncustomeridThe Microsoft Advertising assigned identifier of a customer162436566
33DimensioncustomernameThe customer nameTorana Inc.
34DimensiondeliveredmatchtypeThe match type used to deliver an ad. Identifies the delivered match type (exact, phrase, or broad)to  the user's queryPhrase
35DimensiondestinationurlThe destination URL attribute of the ad, keyword, or ad group criterion
36DimensiondeviceosThe operating system of the device reported in the DeviceType column. The possible values include Android, Blackberry, iOS, Other, Unknown, and WindowsWindows
37DimensiondevicetypeThe type of device which showed ads. The possible values include  Computer, Smartphone, ablet, and UnknownComputer
38DimensiongoalThe name of the goal you set for the conversions you want, meaning actions customers take after clicking your ad
39DimensiongoaltypeThe type of conversion goal. Possible values include AppInstall, Duration, Event, InStoreTransaction, OfflineConversion, PagesViewedPerVisit, and Url.
40MetricimpressionsThe number of times an ad has been displayed on search results pages. Without impressions there are no clicks or conversions.1
41DimensionkeywordThe keyword text#NAME?
42DimensionkeywordidKeyword ID7.88216E+13
43DimensionkeywordstatusThe keyword statusActive
44DimensionlanguageThe language of the country the ad is served inEnglish
45DimensionnetworkThe combined search advertising marketplace made up of Bing, AOL, Yahoo, and partner sites. Use this data to make the best decision on network selection for your ad groupsBing and Yahoo! search
46MetricreturnonadspendThe return on ad spend (ROAS). ROAS is (Revenue / Spend)0
47MetricrevenueThe revenue optionally reported by the advertiser as a result of conversions0
48MetricrevenueperassistThe revenue per assist. The formula for calculating the revenue per assist is (Revenue / Assists)
49MetricrevenueperconversionThe revenue per conversion
50DimensionsearchqueryThe search term used by your potential audienceteradata to redshift migration
51MetricspendThe cost per click (CPC) summed for each click3.66
52Electrik.AIsnapshot_dtThe date on which snapshot is taken6/18/2020
53DimensiontopvsotherThe report will include a column that 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 UnknownBing and Yahoo! search - Top
54Electrik.AIetl_orgOrganization IdORG000251
55Electrik.AIetl_projectProject IdPR000253
56Electrik.AIetl_create_utc_dttmRow Create Timestamp in UTC6/19/2020 6:07
57Electrik.AIetl_update_utc_dttmRow Update Timestamp in UTC6/19/2020 6:07
58Electrik.AIetl_start_utc_dttmEAI Flow Start Timestamp in UTC6/19/2020 6:02
59Electrik.AIetl_flow_nmEAI Flow CodeFL001252
60Electrik.AIetl_flow_instance_idEAI Flow Execution Instance IdFL001252-20200619 060131381709