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.
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
Step 4: Select the Connections tab in the left most navigation bar & click on “Add” action button.
Step 5: The Source default tab is selected just click on “Microsoft Bing Ads” connection.
Step 6: Provide your Microsoft Bing Ads User Id and Password.
Step 7: Allow Electrik.AI to access your Microsoft Ads account.
Step 8: Select the Microsoft Ads Account from the dropdown whose data you wish to export.
Step 9: Click on Save button on the top.
Congratulations, you have successfully created a Microsoft Ads Connection in Electrik.AI
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
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.
Step 4: Click on Add button to create a Microsoft Ads Performance Data Extractor Flow
Step 5: Select Microsoft Ads Connection present in the list of available sources
Step 6: Select your existing Microsoft Ads connection in Electrik.AI.
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 8: Select your existing MySQL connection in Electrik.AI.
To Configure a new connection, refer to this link.
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.
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.
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.
You have now successfully setup Microsoft Ads Performance Report to MySQL Database flow in Electrik.AI
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 |
| 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 |
What is Microsoft Ads?
How to add a Microsoft Ads Source in Electrik.AI?
What are the supported Data Destinations?
How to export Microsoft Ads Data ?
Sample Microsoft Ads Data
Microsoft Ads Data Schema
Ad Performance Report
Ad Group Performance
Campaign Performance
Keyword Performance
Ad Dynamic Text Performance
Search Query Performance
