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.

Index Category Electrik.AI Column Name Description         Sample Value
1 Dimension accountid The Microsoft Advertising assigned identifier of an account 149039804
2 Dimension accountname The account name Torana Inc.
3 Dimension accountnumber The Microsoft Advertising assigned number of an account F11844RA
4 Dimension accountstatus The account status Active
5 Dimension addescription The first ad description that appears below the path in your ad Automate Data Migration Testing of Hadoop & Other Big Data Platforms With iCEDQ
6 Dimension addescription2 The second ad description that appears below the path in your ad. Ad description 2 might not appear in your ad
7 Dimension addistribution The network where you want your ads to show Search
8 Dimension adgroupid The Microsoft Advertising assigned identifier of an ad group 1.26114E+15
9 Dimension adgroupname The ad group name Database Migration
10 Dimension adgroupstatus The ad status Active
11 Dimension adid The Microsoft Advertising assigned identifier of an ad 7.88214E+13
12 Dimension adlabels The labels applied to the ad
13 Dimension adstatus The ad status Paused
14 Dimension adtitle The ad title
15 Dimension adtype Different 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 ads Expanded text ad
16 Metric allconversionrate The conversion rate as a percentage. (Conversions / Clicks) x 100
17 Metric allconversions The number of conversions 0
18 Metric allcostperconversion The cost per conversion
19 Metric allreturnonadspend The return on ad spend (ROAS). ROAS is (Revenue / Spend)
20 Metric allrevenue The 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 Tracking 0
21 Metric allrevenueper conversion The revenue per conversion. (Revenue / Conversions)
22 Metric assists The number of conversions from other ads within the same account that were preceded by one or more clicks from this ad 0
23 Metric averagecpc 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 are charged each time your ad is clicked. (Spend /Clicks) 0
24 Metric averageposition The average position of the ad on a webpage 1
25 Dimension basecampaignid The Microsoft Advertising assigned identifier of an experiment campaign.This will be the same value as the CampaignId if the campaign is not an experiment 389316750
26 Dimension bidmatchtype Defines 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 type Broad
27 Dimension businessname This column only applies to Audience campaigns.Your business's name may appear in your ad depending on your responsive ad's placement
28 Dimension campaignid The Microsoft Advertising assigned identifier of a campaign 389316750
29 Dimension campaignname The campaign name Data Migration Testing
30 Dimension campaignstatus The campaign status Active
31 Dimension campaigntype The campaign is an Audience campaign/Dynamic Search Ads campaign/Search campaign/Shopping/campaign Search & content
32 Metric clicks Clicks 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
33 Metric conversionrate The conversion rate as a percentage. The formula for calculating the conversion rate is (Conversions / Clicks) x 100
34 Metric conversions The 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 tracked 0
35 Metric costperassist The cost per assist
36 Metric costperconversion The 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
37 Metric ctr The 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 100 0
38 Dimension currencycode The account currency type USD
39 Dimension customerid The Microsoft Advertising assigned identifier of a customer 162436566
40 Dimension customername The customer name Torana Inc.
41 Dimension customparameters The match type used to deliver an ad. Identifies the delivered match type (exact, phrase, or broad) to  the user's query
42 Dimension deliveredmatchtype The match type used to deliver an ad. Identifies the delivered match type (exact, phrase, or broad)to the user's query Exact
43 Dimension destinationurl The destination URL attribute of the ad, keyword, or ad group criterion
44 Dimension deviceos The operating system of the device reported in the DeviceType column. The possible values include Android, Blackberry, iOS, Other, Unknown, and Windows Android
45 Dimension devicetype The type of device which showed ads. The possible values include Computer,Smartphone, Tablet, and Unknown Smartphone
46 Dimension displayurl The ad display URL icedq.com
47 Dimension finalappurl Reserved for future use
48 Dimension finalmobileurl The Final Mobile URL of the ad, keyword, or criterion
49 Dimension finalurl The Final URL of the ad, keyword, or criterion http://icedq.com/ data-migration-testing-tool
50 Dimension finalurlsuffix A place in your final URL where you can add parameters that will be attached to the end of your landing page URL
51 Dimension goal The name of the goal you set for the conversions you want, meaning actions customers take after clicking your ad
52 Dimension goaltype The type of conversion goal.Possible values include AppInstall, Duration, Event, InStoreTransaction, OfflineConversion, PagesViewedPerVisit, and Url.
53 Dimension headline The shorter of two possible responsive ad headlines for Audience campaigns
54 Metric impressions The 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
55 Dimension language The language of the country the ad is served in English
56 Dimension longheadline The longer of two possible responsive ad headlines for Audience campaigns
57 Dimension network The 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 groups Bing and Yahoo! search
58 Dimension path1 The path 1 attribute of an ad Data-Migration
59 Dimension path2 The path 2 attribute of an ad
60 Metric returnonadspend The return on ad spend (ROAS). ROAS is (Revenue / Spend)
61 Metric revenue The revenue optionally reported by the advertiser as a result of conversions 1/0/1900 0:00
62 Metric revenueperassist The revenue per assist. The formula for calculating the revenue per assist is (Revenue / Assists)
63 Metric revenueperconversion The revenue per conversion
64 Metric spend The cost per click (CPC) summed for each click 1/0/1900
65 Electrik.AI snapshot_dt Date on which the data is captured 4/17/2020
66 Dimension titlepart1 The title part 1 attribute of an ad DB Migration Testing Tool
67 Dimension titlepart2 The title part 2 attribute of an ad Save Your Time & Efforts
68 Dimension titlepart3 The title part 3 attribute of an ad
69 Dimension topvsother The 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 Unknown Bing and Yahoo! search - Top
70 Dimension trackingtemplate The current tracking template of the ad, keyword, or criterion
71 Metric viewthrough conversions View-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 counted 1/0/1900 0:00
72 Electrik.AI etl_org Organization Id ORG000251
73 Electrik.AI etl_project Project Id PR000253
74 Electrik.AI etl_create_utc_dttm Record loaded/created Timestamp in UTC 6/24/2020 16:07
75 Electrik.AI etl_update_utc_dttm Record Update Timestamp in UTC 6/24/2020 16:07
76 Electrik.AI etl_start_utc_dttm EAI Flow Start Timestamp in UTC 6/24/2020 16:02
77 Electrik.AI etl_flow_nm EAI Flow Code FL001309
78 Electrik.AI etl_flow_instance_id EAI Flow Execution Instance Id FL001309- 20200624103037574783

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

Index Category Electrik.AI Column Name Description         Sample Value
1 Dimension accountid The Microsoft Advertising assigned identifier of an account 149039804
2 Dimension accountname The account name Torana Inc.
3 Dimension accountnumber The Microsoft Advertising assigned number of an account F11844RA
4 Dimension accountstatus The account status Active
5 Dimension addistribution The network where you want your ads to show Search
6 Dimension adgroupid The Microsoft Advertising assigned identifier of an ad group 1.26334E+15
7 Dimension adgrouplabels The labels applied to the ad group
8 Dimension adgroupname The ad group name ETL Testing
9 Dimension adrelevance Relevant 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 ends 3
10 Metric allconversionrate The conversion rate as a percentage. (Conversions / Clicks) x 100
11 Metric allconversions The number of conversions 0
12 Metric allcostperconversion The cost per conversion
13 Metric allreturnonadspend The return on ad spend (ROAS). ROAS is (Revenue / Spend).
14 Metric allrevenue The revenue optionally reported by the advertiser as a result of conversions 0
15 Metric allrevenueperconversion The revenue per conversion
16 Metric assists The number of conversions from other ads within the same account that were preceded by one or more clicks from this ad 0
17 Metric averagecpc 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 are charged each time your ad is clicked. (Spend /Clicks) 0
18 Metric averageposition The average position of the ad on a webpage 1
19 Dimension basecampaignid The Microsoft Advertising assigned identifier of an experiment campaign. This will be the same value as the CampaignId if the campaign is not an experiment 389316749
20 Dimension bidmatchtype Defines 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 type Exact
21 Dimension campaignid The Microsoft Advertising assigned identifier of a campaign 389316749
22 Dimension campaignname The campaign name iCEDQ - UK
23 Dimension campaignstatus The campaign status Active
24 Dimension campaigntype The campaign is an Audience campaign/Dynamic Search Ads campaign/Search campaign/Shopping campaign Search & content
25 Metric clicks Clicks 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
26 Metric conversionrate The conversion rate as a percentage. The formula for calculating the conversion rate is (Conversions / Clicks) x 100
27 Metric conversions The 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 tracked 0
28 Metric costperassist The cost per assist
29 Metric costperconversion The 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
30 Metric ctr The 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 100 0
31 Dimension currencycode The account currency type USD
32 Dimension customerid The Microsoft Advertising assigned identifier of a customer 162436566
33 Dimension customername The customer name Torana Inc.
34 Dimension customparameters The 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)
35 Dimension deliveredmatchtype The match type used to deliver an ad. Identifies the delivered match type (exact, phrase, or broad) to  the user's query Exact
36 Dimension deviceos The operating system of the device reported in the DeviceType column. The possible values include Android, Blackberry, iOS, Other, Unknown, and Windows Windows
37 Dimension devicetype The type of device which showed ads. The possible values include  Computer, Smartphone,Tablet, and Unknown Computer
38 Metric expectedctr This 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 ends 3
39 Dimension finalurlsuffix A place in your final URL where you can add parameters that will be attached to the end of your landing page URL
40 Dimension goal The name of the goal you set for the conversions you want, meaning actions customers take after clicking your ad
41 Dimension goaltype The type of conversion goal. Possible values include AppInstall, Duration, Event, InStoreTransaction, OfflineConversion, PagesViewedPerVisit, and Url.
42 Metric historicaladrelevance Historical 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.
43 Metric historicalexpectedctr Historical 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.
44 Metric historicallanding pageexperience Historical 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
45 Metric historicalqualityscore The 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
46 Metric Impressions The number of times an ad has been displayed on search results pages. Without impressions there are no clicks or conversions.
47 Metric landingpageexperience An 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 ends 3
48 Dimension language The language of the country the ad is served in English
49 Dimension network The 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 groups Bing and Yahoo! search
50 Metric phonecalls The number of total calls to the tracked phone number that showed with your ad 0
51 Metric phoneimpressions The number of times your tracked number was shown on all devices.
52 Metric ptr The phone-through rate (Ptr). The formula for calculating the Ptr is (PhoneCalls / PhoneImpressions) x 100
53 Metric qualityscore The 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 traffic 9
54 Metric returnonadspend The return on ad spend (ROAS). ROAS is (Revenue / Spend)
55 Metric revenue The revenue optionally reported by the advertiser as a result of conversions 0
56 Metric revenueperassist The revenue per assist. The formula for calculating the revenue per assist is (Revenue / Assists)
57 Metric revenueperconversion The revenue per conversion
58 Electrik.AI snapshot_dt The date on which snapshot is taken 6/24/2020
59 Metric spend The cost per click (CPC) summed for each click 0
60 Dimension status The current ad group status Active
61 Dimension topvsother The 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 Unknown Bing and Yahoo! search - Top
62 Dimension trackingtemplate The current tracking template for the ad group
63 Metric viewthroughconversions View-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 counted 1/0/1900 0:00
64 Electrik.AI etl_org Organization Id ORG000251
65 Electrik.AI etl_project Project Id PR000253
66 Electrik.AI etl_create_utc_dttm Record loaded/created Timestamp in UTC 6/24/2020 11:49
67 Electrik.AI etl_update_utc_dttm Record Update Timestamp in UTC 6/24/2020
68 Electrik.AI etl_start_utc_dttm EAI Flow Start Timestamp in UTC 6/24/2020
69 Electrik.AI etl_flow_nm EAI Flow Code FL001313
70 Electrik.AI etl_flow_instance_id EAI Flow Execution Instance Id FL001313-20200624 114214205465

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

Index Category Electrik.AI Column Name Description   Sample Value
1 Dimension accountid The Microsoft Advertising assigned identifier of an account 149039804
2 Dimension accountname The account name Torana Inc.
3 Dimension accountnumber The Microsoft Advertising assigned number of an account F11844RA
4 Dimension accountstatus The account status Active
5 Dimension addistribution The network where you want your ads to show Search
6 Metric adrelevance Relevant 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 ends 3
7 Metric allconversionrate The conversion rate as a percentage. (Conversions / Clicks) x 100
8 Metric allconversions The number of conversions 0
9 Metric allcostperconversion The cost per conversion
10 Metric allreturnonadspend The return on ad spend (ROAS). ROAS is (Revenue / Spend)
11 Metric allrevenue The 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 Tracking 0
12 Metric allrevenueperconversion The revenue per conversion. (Revenue / Conversions)
13 Metric assists The number of conversions from other ads within the same account that were preceded by one or more clicks from this ad 0
14 Metric averagecpc 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 are charged each time your ad is clicked. (Spend/Clicks) 0
15 Metric averageposition The average position of the ad on a webpage 1
16 Dimension basecampaignid The Microsoft Advertising assigned identifier of an experiment campaign. This will be the same value as the CampaignId if the campaign is not an experiment 389309238
17 Dimension bidmatchtype Defines 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 type Broad
18 Dimension budgetassociationstatus Indicates whether or not the campaign is currently spending from the budget mentioned in the BudgetName column. The possible values are Current and Ended Current
19 Dimension budgetname The name of the budget
20 Dimension budgetstatus he budget status. The possible values are Active and Deleted
21 Dimension campaignid The Microsoft Advertising assigned identifier of a campaign 389309238
22 Dimension campaignlabels The labels applied to the campaign
23 Dimension campaignname The campaign name ETL Testing
24 Dimension campaignstatus The campaign status Active
25 Dimension campaigntype The campaign is an Audience campaign /Dynamic Search Ads campaign/Search campaign/Shopping campaign Search & content
26 Metric clicks Clicks 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
27 Metric conversionrate The conversion rate as a percentage. The formula for calculating the conversion rate is (Conversions / Clicks) x 100
28 Metric conversions The 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 tracked 0
29 Metric costperassist The cost per assist
30 Metric costperconversion The 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
31 Metric ctr The 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 100 0
32 Dimension currencycode The account currency type USD
33 Dimension customerid The Microsoft Advertising assigned identifier of a customer 162436566
34 Dimension customername The customer name Torana Inc.
35 Dimension customparameters The match type used to deliver an ad. Identifies the delivered match type (exact, phrase, or broad)to the user's query
36 Dimension deliveredmatchtype The match type used to deliver an ad. Identifies the delivered match type (exact, phrase, or broad)to the user's query Broad
37 Dimension deviceos The operating system of the device reported in the DeviceType column. The possible values include Android, Blackberry, iOS, Other, Unknown, and Windows Android
38 Dimension devicetype The type of device which showed ads. The possible values include  Computer,Smartphone, Tablet, and Unknown Smartphone
39 Metric expectedctr This 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 ends 2
40 Dimension finalurlsuffix A place in your final URL where you can add parameters that will be attached to the end of your landing page URL
41 Dimension goal The name of the goal you set for the conversions you want, meaning actions customers take after clicking your ad
42 Dimension goaltype The type of conversion goal. Possible values include AppInstall, Duration, Event, InStoreTransaction, OfflineConversion, PagesViewedPerVisit, and Url.
43 Metric historicaladrelevance Historical 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
44 Metric historicalexpectedctr Historical 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
45 Metric historicallanding pageexperience Historical 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 1/3/1900
46 Metric historicalqualityscore The 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 8
47 Metric Impressions The number of times an ad has been displayed on search results pages. Without impressions there are no clicks or conversions.
48 Metric landingpageexperience An 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 ends 3
49 Metric lowqualityclicks Clicks that exhibit a low likelihood of commercial intent 0
50 Metric lowqualityclickspercent The low-quality clicks as a percentage. The formula for calculating the low quality clicks percentage is (LowQualityClicks / Clicks) x 100
51 Metric lowqualityconversionrate The low-quality conversion rate as a percentage. The formula for calculating the conversion rate is (LowQuality Conversions / LowQualityClicks) x 100
52 Metric lowqualityconversions The number of conversions that originate from low-quality clicks 0
53 Metric lowqualitygeneralclicks Clicks that are filtered by general methods, such as blacklists and activity- based detection, and that exhibit a low likelihood of commercial intent 1/0/1900 0:00
54 Metric lowqualityImpressions The number of impressions that result from low-quality keyword searches.
55 Metric lowquality sophisticatedclicks Invalid clicks that use sophisticated means to appear valid 1/0/1900 0:00
56 Dimension network The 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 groups Syndicated search partners
57 Metric phonecalls The number of total calls to the tracked phone number that showed with your ad 0
58 Metric phoneimpressions The number of times your tracked number was shown on all devices.
59 Metric ptr The phone-through rate (Ptr). The formula for calculating the Ptr is (PhoneCalls / PhoneImpressions) x 100
60 Metric qualityscore The 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 traffic 8
61 Dimension returnonadspend The return on ad spend (ROAS). ROAS is (Revenue / Spend)
62 Metric revenue The revenue optionally reported by the advertiser as a result of conversions 1/0/1900 0:00
63 Metric revenueperassist The revenue per assist. The formula for calculating the revenue per assist is (Revenue / Assists)
64 Metric revenueperconversion The revenue per conversion
65 Metric spend The cost per click (CPC) summed for each click 0
66 Electrik.AI snapshot_dt The date on which snapshot is taken 4/3/2020
67 Dimension topvsother The 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 Unknown Syndicated search partners - Top
68 Dimension trackingtemplate The current tracking template for the ad group
69 Metric viewthroughconversions View-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 counted 0
70 Electrik.AI etl_org Organization Id ORG000251
71 Electrik.AI etl_project Project Id PR000253
72 Electrik.AI etl_create_utc_dttm Record loaded/created Timestamp in UTC 6/17/2020 12:58
73 Electrik.AI etl_update_utc_dttm Record Update Timestamp in UTC 6/17/2020 12:58
74 Electrik.AI etl_start_utc_dttm EAI Flow Start Timestamp in UTC 6/17/2020 12:49
75 Electrik.AI etl_flow_nm EAI Flow Code FL001257
76 Electrik.AI etl_flow_instance_id EAI Flow Execution Instance Id FL001257- 20200617071 827011898

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

Index Category Electrik.AI Column Name Description  Sample Value
1 Dimension accountid The Microsoft Advertising assigned identifier of an account 149039804
2 Dimension accountname The account name Torana Inc.
3 Dimension accountnumber The Microsoft Advertising assigned number of an account F11844RA
4 Dimension accountstatus The account status Active
5 Dimension addistribution The network where you want your ads to show Search
6 Dimension adgroupid The Microsoft Advertising assigned identifier of an ad group 1.26114E+15
7 Dimension adgroupname The ad group name Database Migration
8 Dimension adgroupstatus The ad status Active
9 Dimension adid The Microsoft Advertising assigned identifier of an ad 7.88214E+13
10 Metric adrelevance Relevant 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 ends 3
11 Dimension adtype Different 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 ads Expanded text ad
12 Metric allconversionrate The conversion rate as a percentage. (Conversions / Clicks) x 100
13 Metric allconversions The number of conversions 0
14 Metric allcostperconversion The cost per conversion
15 Metric allreturnonadspend The return on ad spend (ROAS). ROAS is (Revenue / Spend)
16 Metric allrevenue The 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 Tracking 0
17 Metric allrevenueperconversion The revenue per conversion. (Revenue / Conversions)
18 Metric assists The number of conversions from other ads within the same account that were preceded by one or more clicks from this ad 0
19 Metric averagecpc 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 are charged each time your ad is clicked. (Spend /Clicks) 0
20 Metric averageposition The average position of the ad on a webpage 1
21 Dimension basecampaignid The Microsoft Advertising assigned identifier of an experiment campaign. This will be the same value as the CampaignId if the campaign is not an experiment 389316750
22 Dimension bidmatchtype Defines 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 type Phrase
23 Dimension bidstrategytype The bid strategy type. Possible values include EnhancedCpc, ManualCpc, MaxClicks, MaxConversions, and TargetCpa Maximize clicks
24 Dimension campaignid The Microsoft Advertising assigned identifier of a campaign 389316750
25 Dimension campaignname The campaign name Data Migration Testing
26 Dimension campaignstatus The campaign status Active
27 Metric clicks Clicks 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
28 Metric conversionrate The conversion rate as a percentage. The formula for calculating the conversion rate is (Conversions / Clicks) x 100
29 Metric conversions The 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 tracked 0
30 Metric costperassist The cost per assist
31 Metric costperconversion The 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
32 Metric ctr The 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 100 0
33 Dimension currencycode The account currency type USD
34 Metric currentmaxcpc The maximum cost per click bid that was in effect at the time the report was generated 7.24
35 Dimension customparameters The match type used to deliver an ad. Identifies the delivered match type (exact, phrase, or broad)to the user's query
36 Dimension deliveredmatchtype The match type used to deliver an ad. Identifies the delivered match type (exact, phrase, or broad)to the user's query Exact
37 Dimension destinationurl The destination URL attribute of the ad, keyword, or ad group criterion
38 Dimension deviceos The operating system of the device reported in the DeviceType column. The possible values include Android, Blackberry, iOS, Other, Unknown, and Windows Windows
39 Dimension devicetype The type of device which showed ads. The possible values include Computer, Smartphone, Tablet, and Unknown Computer
40 Metric expectedctr This 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 ends 2
41 Dimension finalappurl Reserved for future use
42 Dimension finalmobileurl The Final Mobile URL of the ad, keyword, or criterion
43 Dimension finalurl The Final URL of the ad, keyword, or criterion http://icedq.com/data- migration-testing-tool
44 Dimension finalurlsuffix A place in your final URL where you can add parameters that will be attached to the end of your landing page URL
45 Metric firstpagebid Based 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
55 Dimension goal The name of the goal you set for the conversions you want, meaning actions customers take after clicking your ad
56 Dimension goaltype The type of conversion goal. Possible values include AppInstall, Duration, Event, InStoreTransaction, OfflineConversion, PagesViewedPerVisit, and Url.
46 Metric historicaladrelevance Historical 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
47 Metric historicalexpectedctr Historical 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
48 Metric historicallanding pageexperience Historical 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 Experience 3
49 Metric historicalqualityscore The 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 10
50 Metric impressions The number of times an ad has been displayed on search results pages. Without impressions there are no clicks or conversions. 1
51 Dimension keyword The keyword text data migration risks
52 Dimension keywordid Keyword ID 7.88216E+13
53 Dimension keywordlabels The labels applied to the keyword
54 Dimension keywordstatus The keyword status Active
55 Metric landingpageexperience An 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 ends 3
56 Dimension language The language of the country the ad is served in English
57 Metric mainline1bid Based 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
58 Metric mainlinebid Based 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
59 Dimension network The 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 groups Syndicated search partners
60 Metric qualityimpact The 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 respectively 0
61 Metric qualityscore The 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 traffic 8
62 Metric returnonadspend The return on ad spend (ROAS). ROAS is (Revenue / Spend)
63 Metric revenue The revenue optionally reported by the advertiser as a result of conversions 0
64 Metric revenueperassist The revenue per assist. The formula for calculating the revenue per assist is (Revenue / Assists)
65 Metric revenueperconversion The revenue per conversion
66 Metric spend The cost per click (CPC) summed for each click 0
67 Electrik.AI snapshot_dt The date on which snapshot is taken 4/3/2020
68 Dimension topvsother The 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 Unknown Syndicated search partners - Top
69 Dimension trackingtemplate The current tracking template for the ad group
70 Metric viewthroughconversions View-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 counted 0
71 Electrik.AI etl_org Organization Id ORG000251
72 Electrik.AI etl_project Project Id PR000253
73 Electrik.AI etl_create_utc_dttm Record loaded/created Timestamp in UTC 6/17/2020 12:58
74 Electrik.AI etl_update_utc_dttm Record Update Timestamp in UTC 6/17/2020 12:58
75 Electrik.AI etl_start_utc_dttm EAI Flow Start Timestamp in UTC 6/17/2020 12:49
76 Electrik.AI etl_flow_nm EAI Flow Code FL001257
77 Electrik.AI etl_flow_instance_id EAI Flow Execution Instance Id FL001257-202006170 71827011898
Index Category Electrik.AI Column Name Description   Sample Value
1 Dimension accountid The Microsoft Advertising assigned identifier of an account 149039804
2 Dimension accountname The account name Torana Inc.
3 Dimension accountnumber The Microsoft Advertising assigned number of an account F11844RA
4 Dimension accountstatus The account status Active
5 Dimension addescription The first ad description that appears below the path in your ad Automate Data Migration Testing of Hadoop & Other Big Data Platforms With iCEDQ
6 Dimension addescription2 The second ad description that appears below the path in your ad. Ad description 2 might not appear in your ad
7 Dimension addistribution The network where you want your ads to show Search
8 Dimension adgroupid The Microsoft Advertising assigned identifier of an ad group 1.26114E+15
9 Dimension adgroupname The ad group name Database Migration
10 Dimension adgroupstatus The ad group status Active
11 Dimension adid The Microsoft Advertising assigned identifier of an ad 7.88214E+13
12 Dimension adlabels The labels applied to the ad
13 Dimension adstatus The ad status Paused
14 Dimension adtitle The ad title
15 Dimension adtype Different 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 ads Expanded text ad
16 Metric allconversionrate The conversion rate as a percentage. (Conversions / Clicks) x 100
17 Metric allconversions The number of conversions 0
18 Metric allcostperconversion The cost per conversion
19 Metric averagecpc 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 are charged each time your ad is clicked. (Spend /Clicks) 0
20 Metric averageposition The average position of the ad on a webpage 1
21 Metric clicks Clicks 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
22 Metric conversionrate The conversion rate as a percentage. The formula for calculating the conversion rate is (Conversions / Clicks) x 100
23 Metric conversions The 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 tracked 0
24 Metric costperconversion The 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
25 Metric ctr The 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 100 0
26 Dimension currencycode The account currency type USD
27 Dimension destinationurl The destination URL attribute of the ad, keyword, or ad group criterion
28 Dimension devicetype The type of device which showed ads. The possible values include  Computer, Smartphone,Tablet, and Unknown Smartphone
29 Dimension finalappurl Reserved for future use
30 Dimension finalmobileurl The Final Mobile URL of the ad, keyword, or criterion
31 Dimension finalurl The Final URL of the ad, keyword, or criterion http://icedq.com/data- migration-testing-tool
32 Dimension goal The name of the goal you set for the conversions you want, meaning actions customers take after clicking your ad
33 Dimension goaltype The type of conversion goal. Possible values include AppInstall, Duration, Event, InStoreTransaction, OfflineConversion, PagesViewedPerVisit, and Url.
34 Metric impressions The number of times an ad has been displayed on search results pages. Without impressions there are no clicks or conversions. 1
35 Dimension keyword The keyword text #NAME?
36 Dimension keywordstatus The keyword status Active
37 Dimension language The language of the country the ad is served in English
38 Dimension param1 The first dynamic substitution parameter (Param1) of a keyword or biddable ad group criterion
39 Dimension param2 The second dynamic substitution parameter (Param2) of a keyword or biddable ad group criterion
40 Dimension param3 The third dynamic substitution parameter (Param3) of a keyword or biddable ad group criterion
41 Dimension path1 The path 1 attribute of an ad Data-Migration
42 Dimension path2 The path 2 attribute of an ad
43 Metric spend The cost per click (CPC) summed for each click 0
44 Electrik.AI snapshot_dt Date on which the data is captured 4/17/2020
45 Dimension titlepart1 The title part 1 attribute of an ad DB Migration Testing Tool
46 Dimension titlepart2 The title part 2 attribute of an ad Save Your Time & Efforts
47 Dimension titlepart3 The title part 3 attribute of an ad
48 Metric viewthroughconversions View-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 counted 0
49 Electrik.AI etl_org Organization Id ORG000251
50 Electrik.AI etl_project Project Id PR000253
51 Electrik.AI etl_create_utc_dttm Record loaded/created Timestamp in UTC 6/17/2020 12:58
52 Electrik.AI etl_update_utc_dttm Record Update Timestamp in UTC 6/17/2020 12:58
53 Electrik.AI etl_start_utc_dttm EAI Flow Start Timestamp in UTC 6/17/2020
54 Electrik.AI etl_flow_nm EAI Flow Code FL001257
55 Electrik.AI etl_flow_instance_id EAI Flow Execution Instance Id FL001257-2020061 7071827011898
The Search Terms report includes all statistics aggregated at the search term level.
Index Category Electrik.AI Column Name Description  Sample Value
1 Dimension accountid The Microsoft Advertising assigned identifier of an account 149039804
2 Dimension accountname The account name Torana Inc.
3 Dimension accountnumber The Microsoft Advertising assigned number of an account F11844RA
4 Dimension accountstatus The account status Active
5 Dimension adgroupcriterionid The Microsoft Advertising assigned identifier of an ad group criterion
6 Dimension adgroupid The Microsoft Advertising assigned identifier of an ad group 1.26114E+15
7 Dimension adgroupname The ad group name Database Migration
8 Dimension adgroupstatus The ad group status Active
9 Dimension adid The Microsoft Advertising assigned identifier of an ad 7.88214E+13
10 Dimension adstatus The ad status Active
11 Dimension adtype Different 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 ads Expanded text ad
12 Metric allconversionrate The conversion rate as a percentage. (Conversions / Clicks) x 100 0
13 Metric allconversions The number of conversions 0
14 Metric allcostperconversion The cost per conversion
15 Metric allreturnonadspend The return on ad spend (ROAS). ROAS is (Revenue / Spend) 0
16 Metric allrevenue The 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 Tracking 0
17 Metric allrevenueperconversion The revenue per conversion. (Revenue / Conversions)
18 Metric assists The number of conversions from other ads within the same account that were preceded by one or more clicks from this ad 0
19 Metric averagecpc 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 are charged each time your ad is clicked. (Spend /Clicks) 3.66
20 Metric averageposition The average position of the ad on a webpage 2
21 Dimension bidmatchtype Defines 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 type Broad
22 Dimension campaignid The Microsoft Advertising assigned identifier of a campaign 389316750
23 Dimension campaignname The campaign name Data Migration Testing
24 Dimension campaignstatus The campaign status Active
25 Dimension campaigntype The type of campaign. Possible values are Audience campaign/Dynamic Search Ads ampaign/Search campaign/ Shopping campaign Search & content
26 Metric clicks Clicks 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
27 Metric conversionrate The conversion rate as a percentage. The formula for calculating the conversion rate is (Conversions / Clicks) x 100 0
28 Metric conversions The 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 tracked 0
29 Metric costperassist The cost per assist. The formula for calculating the cost per assist is
30 Metric costperconversion The 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
31 Metric ctr The 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 100 100
32 Dimension customerid The Microsoft Advertising assigned identifier of a customer 162436566
33 Dimension customername The customer name Torana Inc.
34 Dimension deliveredmatchtype The match type used to deliver an ad. Identifies the delivered match type (exact, phrase, or broad)to  the user's query Phrase
35 Dimension destinationurl The destination URL attribute of the ad, keyword, or ad group criterion
36 Dimension deviceos The operating system of the device reported in the DeviceType column. The possible values include Android, Blackberry, iOS, Other, Unknown, and Windows Windows
37 Dimension devicetype The type of device which showed ads. The possible values include  Computer, Smartphone, ablet, and Unknown Computer
38 Dimension goal The name of the goal you set for the conversions you want, meaning actions customers take after clicking your ad
39 Dimension goaltype The type of conversion goal. Possible values include AppInstall, Duration, Event, InStoreTransaction, OfflineConversion, PagesViewedPerVisit, and Url.
40 Metric impressions The number of times an ad has been displayed on search results pages. Without impressions there are no clicks or conversions. 1
41 Dimension keyword The keyword text #NAME?
42 Dimension keywordid Keyword ID 7.88216E+13
43 Dimension keywordstatus The keyword status Active
44 Dimension language The language of the country the ad is served in English
45 Dimension network The 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 groups Bing and Yahoo! search
46 Metric returnonadspend The return on ad spend (ROAS). ROAS is (Revenue / Spend) 0
47 Metric revenue The revenue optionally reported by the advertiser as a result of conversions 0
48 Metric revenueperassist The revenue per assist. The formula for calculating the revenue per assist is (Revenue / Assists)
49 Metric revenueperconversion The revenue per conversion
50 Dimension searchquery The search term used by your potential audience teradata to redshift migration
51 Metric spend The cost per click (CPC) summed for each click 3.66
52 Electrik.AI snapshot_dt The date on which snapshot is taken 6/18/2020
53 Dimension topvsother The 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 Unknown Bing and Yahoo! search - Top
54 Electrik.AI etl_org Organization Id ORG000251
55 Electrik.AI etl_project Project Id PR000253
56 Electrik.AI etl_create_utc_dttm Row Create Timestamp in UTC 6/19/2020 6:07
57 Electrik.AI etl_update_utc_dttm Row Update Timestamp in UTC 6/19/2020 6:07
58 Electrik.AI etl_start_utc_dttm EAI Flow Start Timestamp in UTC 6/19/2020 6:02
59 Electrik.AI etl_flow_nm EAI Flow Code FL001252
60 Electrik.AI etl_flow_instance_id EAI Flow Execution Instance Id FL001252-20200619 060131381709