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 |