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 |