Docs

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

Step 3 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.

Step 3 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

Ad Performance

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

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

Ad Group Performance

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

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

Campaign Performance Report

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

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

Keyword Performance

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

IndexCategoryElectrik.AI Column Name Description Sample Value
1DimensionaccountidThe Microsoft Advertising
assigned identifier of an account		149039804
2DimensionaccountnameThe account nameTorana Inc.
3DimensionaccountnumberThe Microsoft Advertising
assigned number of an account		F11844RA
4DimensionaccountstatusThe account statusActive
5DimensionaddistributionThe network where you
want your ads to show		Search
6DimensionadgroupidThe Microsoft Advertising
assigned identifier of an ad
group		1.26114E+15
7DimensionadgroupnameThe ad group nameDatabase Migration
8DimensionadgroupstatusThe ad statusActive
9DimensionadidThe Microsoft Advertising
assigned identifier of an ad		7.88214E+13
10MetricadrelevanceRelevant between ad and
landing page to the potential
customers. A score of 3 for
Above Average; 2 for Average;
1 for Below Average and “–”
(double dash) for not computed.
The score is calculated only
based on Search Traffic.Data
for this column is typically
updated 14-18 hours after
the UTC day ends		3
11DimensionadtypeDifferent Microsoft
Advertising ad types are
Expanded Text Ads; Dynamic
search ads; Product ads;
Microsoft Audience Ads;
Microsoft Advertising in
Bing Smart Search; App
Install Ads; Responsive
search ads		Expanded text ad
12MetricallconversionrateThe conversion rate as a
percentage. (Conversions /
Clicks) x 100
13MetricallconversionsThe number of conversions0
14MetricallcostperconversionThe cost per conversion
15MetricallreturnonadspendThe return on ad spend (ROAS).
ROAS is (Revenue / Spend)
16MetricallrevenueThe revenue optionally
reported by the advertiser
as a result of conversions.
Available for accounts that
are setup to use analytics with
Microsoft Advertising Universal
Event Tracking		0
17MetricallrevenueperconversionThe revenue per conversion.
(Revenue / Conversions)
18MetricassistsThe number of conversions
from other ads within the same
account that were preceded by
one or more clicks from this
ad		0
19MetricaveragecpcThe average cost per click
(CPC). The total cost of all
clicks on an ad divided by the
number of clicks. This is the
average amount you are charged
each time your ad is clicked.
(Spend /Clicks)		0
20MetricaveragepositionThe average position of the ad
on a webpage		1
21DimensionbasecampaignidThe 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
22DimensionbidmatchtypeDefines the bid match
type values that you can
use to filter the report
data.The report will contain
keywords that set a bid
value for the broad match
type/Exact match type/Phrase
match type		Phrase
23DimensionbidstrategytypeThe bid strategy type.
Possible values include
EnhancedCpc, ManualCpc,
MaxClicks, MaxConversions,
and TargetCpa		Maximize clicks
24DimensioncampaignidThe Microsoft
Advertising assigned
identifier of a
campaign		389316750
25DimensioncampaignnameThe campaign nameData Migration Testing
26DimensioncampaignstatusThe campaign statusActive
27MetricclicksClicks are what you
pay for. Clicks typically
include a customer clicking
an ad on a search results
page or on a website on the
search network. Clicks can
also come from other sources
(for example, spiders, robots,
and test servers)		0
28MetricconversionrateThe conversion rate as
a percentage. The formula
for calculating the conversion
rate is (Conversions / Clicks)
x 100
29MetricconversionsThe number of conversions.
Conversions are measured by
adding a small bit of code to
your website pages so that a
visitor’s progress through your
site can be tracked		0
30MetriccostperassistThe cost per assist
31MetriccostperconversionThe cost per conversion.
The formula for calculating
the cost per conversion is
(Spend / Conversions). Only
ads in campaigns that enable
conversion tracking contribute
to the conversion number,so
unless all campaigns in the
account enable conversion
tracking,the number will
not be accurate
32MetricctrThe click-through rate
(CTR) is the number of times
an ad was clicked, divided
by the number of times the
ad was shown (impressions).
The formula for calculating
CTR is (Clicks / Impressions)
x 100		0
33DimensioncurrencycodeThe account currency
type		USD
34MetriccurrentmaxcpcThe maximum cost per
click bid that was in
effect at the time the
report was generated		7.24
35DimensioncustomparametersThe match type used to
deliver an ad. Identifies
the delivered match type
(exact, phrase, or broad)to
the user’s query
36DimensiondeliveredmatchtypeThe match type used to
deliver an ad. Identifies
the delivered match type
(exact, phrase, or broad)to
the user’s query		Exact
37DimensiondestinationurlThe destination URL
attribute of the ad,
keyword, or ad group
criterion
38DimensiondeviceosThe operating system
of the device reported in
the DeviceType column. The
possible values include Android,
Blackberry, iOS, Other, Unknown,
and Windows		Windows
39DimensiondevicetypeThe type of device which
showed ads. The possible values
include Computer, Smartphone,
Tablet, and Unknown		Computer
40MetricexpectedctrThis metric tells you
if a keyword is underperforming
and causing a loss in impression
share, so you can make keyword
changes. A score of 3 for Above
Average; 2 for Average; 1 for
Below Average and “–” (double
dash) for not computed. The
score is calculated only based
on Search Traffic.Data for this
column is typically updated 14-18
hours after the UTC day ends		2
41DimensionfinalappurlReserved for future use
42DimensionfinalmobileurlThe Final Mobile URL of
the ad, keyword, or criterion
43DimensionfinalurlThe Final URL of the ad,
keyword, or criterion		http://icedq.com/data-
migration-testing-tool
44DimensionfinalurlsuffixA place in your final
URL where you can add
parameters that will be
attached to the end of your
landing page URL
45MetricfirstpagebidBased on your campaign
performance and marketplace
dynamics, this estimate is
the bid amount that Microsoft
Advertising calculates for
your ad to be placed on the
first page in the search
results
55DimensiongoalThe name of the goal you set
for the conversions you want,
meaning actions customers take
after clicking your ad
56DimensiongoaltypeThe type of conversion
goal. Possible values include
AppInstall, Duration, Event,
InStoreTransaction, OfflineConversion,
PagesViewedPerVisit,
and Url.
46MetrichistoricaladrelevanceHistorical average of ad
relevance scores back as far
as 18 months from the current
date. This score may vary from
the score in the AdRelevance
column, which is the current
score and same value for each
day in the time period.		3
47MetrichistoricalexpectedctrHistorical average of
expected click-through rate
scores going back as far as
18 months from the current
date.This score may vary from
the score in the ExpectedCtr
column, which is the current
score and same value for
each day in the time period.		3
48Metrichistoricallanding
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
49MetrichistoricalqualityscoreThe historical quality
score for each row is the
value that was calculated for
quality score on that date.
Use The historical quality
score to find out how the quality
score may have changed over
time.This score may vary from
the score in the QualityScore
column .You may include this
column only with Daily
aggregation		10
50MetricimpressionsThe number of times an ad
has been displayed on search
results pages. Without impressions
there are no clicks or conversions.		1
51DimensionkeywordThe keyword textdata migration risks
52DimensionkeywordidKeyword ID7.88216E+13
53DimensionkeywordlabelsThe labels applied to the
keyword
54DimensionkeywordstatusThe keyword statusActive
55MetriclandingpageexperienceAn aggregate quality
assessment score measures whether
your landing page is likely to
provide a good experience to
customers who click your ad and
land on your website.A score of
3 for Above Average; 2 for Average;
1 for Below Average and “–”
(double dash) for not computed.
The score is calculated
only based on Search Traffic.
Data for this column is
typically updated 14-18 hours
after the UTC day ends		3
56DimensionlanguageThe language of the
country the ad is
served in		English
57Metricmainline1bidBased on your campaign
performance and marketplace
dynamics, this estimate is
the bid amount that Microsoft
Advertising calculates will
place your ad at the top of
search results
58MetricmainlinebidBased on your campaign
performance and marketplace
dynamics, this estimate is the
bid amount that Microsoft
Advertising calculates for
your ad to be placed on the
first page in the search
results
59DimensionnetworkThe combined search
advertising marketplace made
up of Bing, AOL, Yahoo, and
partner sites. Use this data
to make the best decision
on network selection for
your ad groups		Syndicated search
partners
60MetricqualityimpactThe possible increase in
the number of impressions that
the keyword could receive.It
could be 0 to 3 corresponding
to QualityScore  underperforming;
Low; Medium and High impact
respectively		0
61MetricqualityscoreThe score measures how
relevant your keywords and landing
pages are to customers’ search terms.
The quality score is calculated by
Microsoft Advertising using the
ExpectedCtr, AdRelevance, and
LandingPageExperience sub scores.
If available, the quality score
can range from a low of 1 to a
high of 10. Quality score is based
on the last rolling 30 days for the
owned and operated search traffic		8
62MetricreturnonadspendThe return on ad spend (ROAS).
ROAS is (Revenue / Spend)
63MetricrevenueThe revenue optionally reported
by the advertiser as a result of
conversions		0
64MetricrevenueperassistThe revenue per assist. The
formula for calculating the
revenue per assist is
(Revenue / Assists)
65MetricrevenueperconversionThe revenue per conversion
66MetricspendThe cost per click (CPC)
summed for each click		0
67Electrik.AIsnapshot_dtThe date on which snapshot is
taken		4/3/2020
68DimensiontopvsotherThe report will include a
column that indicates whether
the ad impression appeared in a
top position or elsewhere. The
possible values include AOL
search – Top, AOL search –
Other, Audience network,
Bing and Yahoo! search
– Top, Bing and Yahoo!
search – Other, Syndicated
search partners – Top,
Syndicated search partners –
Other, Content network, and
Unknown		Syndicated search
partners – Top
69DimensiontrackingtemplateThe current tracking
template for the
ad group
70MetricviewthroughconversionsView-through conversions
don’t have a click associated
but do have an impression associated
within the advertiser defined conversion
window. If the user also clicked on an
ad that was delivered via the Microsoft
Audience or Search network, there won’t
be any view-through conversion counted.
Only the click-based conversion would
be counted		0
71Electrik.AIetl_orgOrganization IdORG000251
72Electrik.AIetl_projectProject IdPR000253
73Electrik.AIetl_create_utc_dttmRecord loaded/created
Timestamp in UTC		6/17/2020 12:58
74Electrik.AIetl_update_utc_dttmRecord Update Timestamp in UTC6/17/2020 12:58
75Electrik.AIetl_start_utc_dttmEAI Flow Start Timestamp in UTC6/17/2020 12:49
76Electrik.AIetl_flow_nmEAI Flow CodeFL001257
77Electrik.AIetl_flow_instance_idEAI Flow Execution Instance IdFL001257-202006170
71827011898

Ad Dynamic Text Performance

IndexCategoryElectrik.AI Column Name Description  Sample Value
1DimensionaccountidThe Microsoft Advertising
assigned identifier of an
account		149039804
2DimensionaccountnameThe account nameTorana Inc.
3DimensionaccountnumberThe Microsoft Advertising
assigned number of an account		F11844RA
4DimensionaccountstatusThe account statusActive
5DimensionaddescriptionThe first ad description
that appears below the path
in your ad		Automate Data Migration
Testing of Hadoop & Other
Big Data Platforms With iCEDQ
6Dimensionaddescription2The second ad description
that appears below the path in
your ad. Ad description 2 might
not appear in your ad
7DimensionaddistributionThe network where you
want your ads to show		Search
8DimensionadgroupidThe Microsoft Advertising
assigned identifier of an ad
group		1.26114E+15
9DimensionadgroupnameThe ad group nameDatabase Migration
10DimensionadgroupstatusThe ad group statusActive
11DimensionadidThe Microsoft Advertising
assigned identifier of an ad		7.88214E+13
12DimensionadlabelsThe labels applied to the ad
13DimensionadstatusThe ad statusPaused
14DimensionadtitleThe ad title
15DimensionadtypeDifferent Microsoft Advertising
ad types are Expanded Text Ads;
Dynamic search ads; Product ads;
Microsoft Audience Ads; Microsoft
Advertising in Bing Smart Search;
App Install Ads; Responsive search
ads		Expanded text ad
16MetricallconversionrateThe conversion rate as
a percentage. (Conversions
/ Clicks) x 100
17MetricallconversionsThe number of conversions0
18MetricallcostperconversionThe cost per conversion
19MetricaveragecpcThe average cost per click
(CPC). The total cost of all
clicks on an ad divided by the
number of clicks. This is the
average amount you are charged
each time your ad is clicked.
(Spend /Clicks)		0
20MetricaveragepositionThe average position
of the ad on a webpage		1
21MetricclicksClicks are what you pay for.
Clicks typically include a
customer clicking an ad on a
search results page or on a
website on the search network.
Clicks can also come from other
sources (for example, spiders,
robots, and test servers)		0
22MetricconversionrateThe conversion rate as a
percentage. The formula for
calculating the conversion
rate is (Conversions / Clicks)
x 100
23MetricconversionsThe number of conversions.
Conversions are measured by
adding a small bit of code to
your website pages so that a
visitor’s progress through
your site can be tracked		0
24MetriccostperconversionThe cost per conversion.
The formula for calculating
the cost per conversion is
(Spend / Conversions). Only
ads in campaigns that enable
conversion tracking contribute
to the conversion number, so
unless all campaigns in the
account enable conversion
tracking, the number will
not be accurate
25MetricctrThe click-through rate (CTR)
is the number of times an ad was
clicked, divided by the number
of times the ad was shown
(impressions). The formula
for calculating CTR is (Clicks
/ Impressions) x 100		0
26DimensioncurrencycodeThe account currency
type		USD
27DimensiondestinationurlThe destination URL attribute
of the ad, keyword, or ad group
criterion
28DimensiondevicetypeThe type of device which
showed ads. The possible
values include  Computer,
Smartphone,Tablet, and
Unknown		Smartphone
29DimensionfinalappurlReserved for future use
30DimensionfinalmobileurlThe Final Mobile URL of the
ad, keyword, or criterion
31DimensionfinalurlThe Final URL of the
ad, keyword, or criterion		http://icedq.com/data-
migration-testing-tool
32DimensiongoalThe name of the goal you set
for the conversions you want,
meaning actions customers take
after clicking your ad
33DimensiongoaltypeThe type of conversion goal.
Possible values include
AppInstall, Duration, Event,
InStoreTransaction,
OfflineConversion,
PagesViewedPerVisit,
and Url.
34MetricimpressionsThe number of times an ad
has been displayed on search
results pages. Without
impressions there are no
clicks or conversions.		1
35DimensionkeywordThe keyword text#NAME?
36DimensionkeywordstatusThe keyword statusActive
37DimensionlanguageThe language of the country
the ad is served in		English
38Dimensionparam1The first dynamic substitution
parameter (Param1) of a
keyword or biddable ad group
criterion
39Dimensionparam2The second dynamic substitution
parameter (Param2) of a keyword or
biddable ad group criterion
40Dimensionparam3The third dynamic substitution
parameter (Param3) of a keyword or
biddable ad group criterion
41Dimensionpath1The path 1 attribute of an adData-Migration
42Dimensionpath2The path 2 attribute of an ad
43MetricspendThe cost per click (CPC)
summed for each click		0
44Electrik.AIsnapshot_dtDate on which the data is
captured		4/17/2020
45Dimensiontitlepart1The title part 1 attribute
of an ad		DB Migration Testing Tool
46Dimensiontitlepart2The title part 2 attribute
of an ad		Save Your Time & Efforts
47Dimensiontitlepart3The title part 3 attribute of
an ad
48MetricviewthroughconversionsView-through conversions don’t
have a click associated but do
have an impression associated
within the advertiser defined
conversion window. If the user
also clicked on an ad that was
delivered via the Microsoft
Audience or Search network,
there won’t be any view-through
conversion counted. Only the
click-based conversion would
be counted		0
49Electrik.AIetl_orgOrganization IdORG000251
50Electrik.AIetl_projectProject IdPR000253
51Electrik.AIetl_create_utc_dttmRecord loaded/created
Timestamp in UTC		6/17/2020 12:58
52Electrik.AIetl_update_utc_dttmRecord Update Timestamp
in UTC		6/17/2020 12:58
53Electrik.AIetl_start_utc_dttmEAI Flow Start Timestamp
in UTC		6/17/2020
54Electrik.AIetl_flow_nmEAI Flow CodeFL001257
55Electrik.AIetl_flow_instance_idEAI Flow Execution
Instance Id		FL001257-2020061
7071827011898

Search Query Performance

The Search Terms report includes all statistics aggregated at the search term level.

IndexCategoryElectrik.AI Column Name Description Sample Value
1DimensionaccountidThe Microsoft Advertising assigned
identifier of an account		149039804
2DimensionaccountnameThe account nameTorana Inc.
3DimensionaccountnumberThe Microsoft Advertising assigned
number of an account		F11844RA
4DimensionaccountstatusThe account statusActive
5DimensionadgroupcriterionidThe Microsoft Advertising assigned
identifier of an ad group criterion
6DimensionadgroupidThe Microsoft Advertising assigned
identifier of an ad group		1.26114E+15
7DimensionadgroupnameThe ad group nameDatabase Migration
8DimensionadgroupstatusThe ad group statusActive
9DimensionadidThe Microsoft Advertising assigned
identifier of an ad		7.88214E+13
10DimensionadstatusThe ad statusActive
11DimensionadtypeDifferent Microsoft Advertising
ad types are Expanded Text Ads;
Dynamic search ads; Product ads;
Microsoft Audience Ads; Microsoft
Advertising in Bing Smart Search;
App Install Ads; Responsive search ads		Expanded text ad
12MetricallconversionrateThe conversion rate as a percentage.
(Conversions / Clicks) x 100		0
13MetricallconversionsThe number of conversions0
14MetricallcostperconversionThe cost per conversion
15MetricallreturnonadspendThe return on ad spend (ROAS).
ROAS is (Revenue / Spend)		0
16MetricallrevenueThe revenue optionally reported
by the advertiser as a result of
conversions.Available for accounts
that are setup to use analytics with
Microsoft Advertising Universal Event
Tracking		0
17MetricallrevenueperconversionThe revenue per conversion.
(Revenue / Conversions)
18MetricassistsThe number of conversions
from other ads within the same
account that were preceded by
one or more clicks from this ad		0
19MetricaveragecpcThe average cost per click (CPC).
The total cost of all clicks on an ad
divided by the number of clicks.
This is the average amount you are
charged each time your ad is clicked.
(Spend /Clicks)		3.66
20MetricaveragepositionThe average position of the ad
on a webpage		2
21DimensionbidmatchtypeDefines the bid match type values
that you can use to filter the report
data.The report will contain keywords
that set a bid value for the broad
match type/Exact match type/Phrase
match type		Broad
22DimensioncampaignidThe Microsoft Advertising assigned
identifier of a campaign		389316750
23DimensioncampaignnameThe campaign nameData Migration Testing
24DimensioncampaignstatusThe campaign statusActive
25DimensioncampaigntypeThe type of campaign. Possible
values are Audience campaign/Dynamic
Search Ads ampaign/Search campaign/
Shopping campaign		Search & content
26MetricclicksClicks are what you pay for.
Clicks typically include a customer
clicking an ad on a search results
page or on a website on the search
network. Clicks can also come from
other sources (for example, spiders,
robots, and test servers)		1
27MetricconversionrateThe conversion rate as a percentage.
The formula for calculating the
conversion rate is (Conversions
/ Clicks) x 100		0
28MetricconversionsThe number of conversions.
Conversions are measured by adding
a small bit of code to your website
pages so that a visitor’s progress
through your site can be tracked		0
29MetriccostperassistThe cost per assist. The formula
for calculating the cost per assist is
30MetriccostperconversionThe cost per conversion. The formula
for calculating the cost per conversion
is (Spend / Conversions). Only ads in
campaigns that enable conversion
tracking contribute to the conversion
number, so unless all campaigns in
the account enable conversion
tracking, the number will
not be accurate
31MetricctrThe click-through rate (CTR) is
the number of times an ad was clicked,
divided by the number of times the ad
was shown (impressions). The formula
for calculating CTR is (Clicks /
Impressions) x 100		100
32DimensioncustomeridThe Microsoft Advertising
assigned identifier of a
customer		162436566
33DimensioncustomernameThe customer nameTorana Inc.
34DimensiondeliveredmatchtypeThe match type used to deliver
an ad. Identifies the delivered
match type (exact, phrase, or
broad)to  the user’s query		Phrase
35DimensiondestinationurlThe destination URL attribute of the
ad, keyword, or ad group criterion
36DimensiondeviceosThe operating system of the
device reported in the DeviceType
column. The possible values include
Android, Blackberry, iOS, Other,
Unknown, and Windows		Windows
37DimensiondevicetypeThe type of device which showed ads.
The possible values include  Computer,
Smartphone, ablet, and Unknown		Computer
38DimensiongoalThe name of the goal you set for
the conversions you want, meaning
actions customers take after clicking
your ad
39DimensiongoaltypeThe type of conversion goal.
Possible values include AppInstall,
Duration, Event, InStoreTransaction,
OfflineConversion, PagesViewedPerVisit,
and Url.
40MetricimpressionsThe number of times an ad has
been displayed on search results
pages. Without impressions there
are no clicks or conversions.		1
41DimensionkeywordThe keyword text#NAME?
42DimensionkeywordidKeyword ID7.88216E+13
43DimensionkeywordstatusThe keyword statusActive
44DimensionlanguageThe language of the country
the ad is served in		English
45DimensionnetworkThe combined search advertising
marketplace made up of Bing, AOL,
Yahoo, and partner sites. Use this
data to make the best decision on
network selection for your ad groups		Bing and Yahoo! search
46MetricreturnonadspendThe return on ad spend (ROAS). ROAS
is (Revenue / Spend)		0
47MetricrevenueThe revenue optionally reported by
the advertiser as a result of conversions		0
48MetricrevenueperassistThe revenue per assist. The formula for
calculating the revenue per assist is
(Revenue / Assists)
49MetricrevenueperconversionThe revenue per conversion
50DimensionsearchqueryThe search term used by your potential
audience		teradata to redshift migration
51MetricspendThe cost per click (CPC) summed for
each click		3.66
52Electrik.AIsnapshot_dtThe date on which snapshot is taken6/18/2020
53DimensiontopvsotherThe report will include a column that
indicates whether the ad impression
appeared in a top position or elsewhere.
The possible values include AOL search
-Top, AOL search – Other, Audience
network, Bing and Yahoo! search – Top,
Bing and Yahoo! search – Other,
Syndicated search partners – Top,
Syndicated search partners – Other,
Content network, and Unknown		Bing and Yahoo! search – Top
54Electrik.AIetl_orgOrganization IdORG000251
55Electrik.AIetl_projectProject IdPR000253
56Electrik.AIetl_create_utc_dttmRow Create Timestamp in UTC6/19/2020 6:07
57Electrik.AIetl_update_utc_dttmRow Update Timestamp in UTC6/19/2020 6:07
58Electrik.AIetl_start_utc_dttmEAI Flow Start Timestamp in UTC6/19/2020 6:02
59Electrik.AIetl_flow_nmEAI Flow CodeFL001252
60Electrik.AIetl_flow_instance_idEAI Flow Execution Instance IdFL001252-20200619
060131381709
Google Ads Data Export
Facebook Ads Data Export

On this page

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 ?
Microsoft Ads Data Schema
Ad Performance Report
Ad Group Performance
Campaign Performance
Keyword Performance
Ad Dynamic Text Performance
Search Query Performance