Docs

Google Ads Performance Data Export

What is Google Ads?

Google Ads previously known as Google AdWords is an online advertising platform developed by Google, where advertisers pay to display brief advertisements, service offerings, product listings, video content, and generate mobile application installs within the Google Ad network to web users.

Follow these steps to connect your Google Ads account to Electrik.AI

Step 1: Ensure you have the following prerequisites to create a Google Ads Connection in Electrik.AI

a. Google Ads Account User Id and Password.

Step 2: Sign in to your Electrik.AI account.

Step 3: Select IO in Electrik.AI dashboard.

Select IO in Electrik.AI dashboard

Step 4: Select the Connections Icon in the left most panel and click on “Add” button the top.

Select-the-Connections-tab-in-the-left-most-navigation-bar-click-on-Add-action-

Step 5: The Source default tab is selected just click on “ Google Ads” connection.

Google Ads ElectrikAI

Step 6: Enter your Google Ads User Id and Password.

Google Ads User Id and Password ElectrikAI
Sign in with Google ElectrikAI

Step 7:  Allow Electrik.AI to access your Google Ads account.

Allow Google Ads account ElectrikAI

Step 8: Choose a Google Ads Account for which you want to extract data.

Choose Google Ads Account for which you have to extract data ElectrikAI

Step 9: Click on Save button on the top.

Connection-Save-ElectrikAI

Congratulations, you have successfully created a Google Ads Connection in Electrik.AI.

Successfully created a Google Ads Connection ElectrikAI

What are the supported Data Destinations?

Electrik.AI supports the following destination to export Google Ads Performance Data.

PostgreSQL Data Destination-Eletrik.AI
MySQL Data Destination-Electrik.AI
AzureSQL Data Destination-Eletrik.AI
Google Big Query Data Destination-Elecrik.AI
Snowflake-Data-Destination-Electrik.AI
EletrikAI
Amazon S3-ElectrikAI

In Electrik.AI, create a data flow (ETL process) that exports Google Ads performance reports of your choice to a target database or data warehouse. This process runs daily at a scheduled time and exports data for the previous day.

Step 1: Ensure you have the following prerequisites.

  1. Access to Google Ads.
  2. Google Ads Account User Id and Passwords.
  3. Access to a Database of your choice (PostgreSQL, MySQL, Azure SQL, BigQuery, Snowflake, Amazon S3, Electrik.AI).
  4. Database Connection Details such as Host, Port, DB Name, DB User, DB Password.

Step 2: Sign in to your Electrik.AI account.
Step 3: Select IO in Electrik.AI dashboard.

Select IO in Electrik.AI dashboard

Step 4: Click on Add button to create a Google Ads Performance Data Extractor Flow.

Click on Add button to create a Flow

Step 5: Select Google Ads connection present in the list of available sources.

Flow Step 5 Select Google Ads Connection present in the list of available sources ElectrikAI

Step 6:  Select your existing Google Ads connection in Electrik.AI.
To Configure a new connection, refer to this link.

Flow Step 6 Select your existing Google Ads connection in ElectrikAI

Step 7: Click on a destination of your choice from list of available destinations.
In this example we are choosing BigQuery.

Click-on-a-destination-of-your-choice-from-list-of-available-destinations-ElectrikAI

Step 8: Select your existing BigQuery connection in Electrik.AI.
To Configure a new connection, refer to this link.

FlowStep9

Step 9: Review the Data Source, Data Destination, Database Schema, Select Report Name, Provide Success Notification Email, Failure Notification Email and Click “Save” to continue.
Choose a Google Ads Account for which you want to extract data. In this example we are choosing all.

FlowStep9a

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.

Google Ads Flow 9b ElectrikAI

Note: Electrik.AI choose a Database Schema from the list of existing schemas to load your Google Ads Report by default.
You can also create a new schema in your database by selecting the “Create New Schema” radio button.
Congratulations, Flow is created. Please wait while you are redirected to Flow Details Screen.

FlowStep11

You have now successfully setup Google Ads to BigQuery Data Warehouse flow in Electrik.AI

FlowStep12

Your Google Ads data will start loading after 24 hours in your Database.

Google Ads data will start loading-ElectrikAI

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

Index Category Electrik.AI Column Name Description Sample Value
1 Metric absolutetopimpressionpercentage Impr. (Abs. Top) % 0
2 Attribute accentcolor Accent color (responsive) null
3 Attribute accountcurrencycode Currency USD
4 Attribute accountdescriptivename Account electrik.ai
5 Attribute accounttimezone Time zone (GMT-05:00) Eastern Time
6 Metric activeviewcpm Active View avg. CPM 61534500
7 Metric activeviewctr Active View viewable CTR 0
8 Metric activeviewimpressions Active View viewable impressions 2
9 Metric activeviewmeasurability Active View measurable
>impr. / impr.
100
10 Metric activeviewmeasurablecost Active View measurable cost 123069
11 Metric activeviewmeasurableimpressions Active View measurable impr. 2
12 Metric activeviewviewability Active View viewable
impr. / measurable impr.
100
13 Attribute adgroupid Ad group ID 89386507320
14 Attribute adgroupname Ad group Google Analytics Video
15 Attribute adgroupstatus Ad group state enabled
16 Dimension adnetworktype1 Network YouTube Videos
17 Dimension adnetworktype2 Network
(with search partners)
YouTube Videos
18 Attribute adstrengthinfo Ad strength QUALITY_SCORE_UNKNOWN
19 Attribute adtype Ad type null
20 Metric allconversionrate All conv. rate 0
21 Metric allconversions All conv. 0
22 Metric allconversionvalue All conv. value 0
23 Attribute allowflexiblecolor Allow flexible
color (responsive)
null
24 Attribute automated Auto-applied ad
suggestion
No
25 Metric averagecost Avg. Cost 123069
26 Metric averagecpc Avg. CPC 0
27 Metric averagecpe Avg. CPE 0
28 Metric averagecpm Avg. CPM 61534500
29 Metric averagecpv Avg. CPV 123069
30 Metric averagepageviews Pages / session 0
31 Metric averageposition Avg. position null
32 Metric averagetimeonsite Avg. session
duration (seconds)
0
33 Attribute baseadgroupid Base Ad group ID 89386507320
34 Attribute basecampaignid Base Campaign ID 8626374954
35 Metric bouncerate Bounce rate 0
36 Attribute businessname Business name null
37 Attribute callonlyphonenumber Call-only ad
phone number
null
38 Attribute calltoactiontext Call to action
text (responsive)
null
39 Attribute campaignid Campaign ID 8626374954
40 Attribute campaignname Campaign Evergreen_Video
Campaign
41 Attribute campaignstatus Campaign state enabled
42 Metric clickassisted
conversions
Click Assisted Conv. 0
43 Metric clickassistedconversions
overlastclickconversions
Click Assisted Conv.
/ Last Click Conv.
null
44 Metric clickassisted
conversionvalue
Click Assisted
Conv. Value
null
45 Metric clicks Clicks 0
46 Attribute combined
approvalstatus
Approval status approved
47 Metric conversionrate Conv. rate 0
48 Metric conversions Conversions 0
49 Metric conversion
value
Total conv.
value
0
50 Metric cost Cost 123069
51 Metric costperall
conversion
Cost / all conv. 0
52 Metric costper
conversion
Cost / conv. 0
53 Metric costpercurrentmodel
attributedconversion
Cost / conv.
(current model)
0
54 Attribute creative
destinationurl
Destination URL null
55 Attribute creative
finalappurls
App final URL null
56 Attribute creative
finalmobileurls
Mobile final URL null
57 Attribute creativefinalurls Final URL “[“”https://electrik.ai/
google-analytics-hit-data-extractor?utm_source=Youtube&utm_medium=Video&utm_campaign=Skippable_in-stream_ad””]”
58 Attribute creative
finalurlsuffix
Final URL suffix null
59 Attribute creativetracking
urltemplate
Tracking template null
60 Attribute creativeurl
customparameters
Custom parameter null
61 Dimension Criterionid Keyword ID 3000000
62 Dimension Criteriontype Criteria Type Keyword
63 Metric crossdevice
conversions
Cross-device
conv.
null
64 Metric Ctr CTR 0
65 Metric currentmodel
attributedconversions
Conversions
(current model)
0
66 Metric currentmodelattribute
dconversionvalue
Conv. value
(current model)
0
67 Attribute customer
descriptivename
Client name electrik.ai
68 Dimension snapshot_dt Day 2020-04-13
00:00:00 UTC
69 Attribute description Description null
70 Attribute description1 Description
line 1
null
71 Attribute description2 Description
line 2
null
72 Attribute device
preference
Device
preference
null
73 Attribute displayurl Display URL Electrik.AI
74 Metric engagemen
trate
Engagement rate 0
75 Metric engagements Engagements 0
76 Attribute enhanceddisplay
creativelandscapelogoimagemediaid
Landscape logo ID
(responsive)
null
77 Attribute enhanceddisplay
creativelogoimagemediaid
Logo ID
(responsive)
null
78 Attribute enhanceddisplay
creativemarketingimagemediaid
Image ID
(responsive)
null
79 Attribute enhanceddisplay
creativemarketingimagesquaremediaid
Square image ID
(responsive)
null
80 Attribute expandeddynamic
searchcreativedescription2
Expanded Dynamic Search
Ad Description 2
null
81 Attribute expandedtext
addescription2
Expanded Text
Ad Description 2
null
82 Attribute expandedtext
adheadlinepart3
Expanded Text
Ad Headline 3
null
83 Attribute external
customerid
Customer ID 9227698748
84 Attribute format
setting
Ad format
preference (responsive)
null
85 Attribute gmailcreative
headerimagemediaid
Gmail ad header
image media id
null
86 Attribute gmailcreativelogo
imagemediaid
Gmail ad logo image
media id
null
87 Attribute gmailcreative
marketingimagemediaid
Gmail ad marketing
image media id
null
88 Metric gmail
forwards
Gmail forwards 0
89 Metric gmailsaves Gmail saves 0
90 Metric gmailsecondary
clicks
Gmail clicks to
website
0
91 Attribute gmailteaser
businessname
Gmail ad
business name
null
92 Attribute gmailteaser
description
Gmail ad
description
null
93 Attribute gmailteaser
headline
Gmail ad
headline
null
94 Attribute headline Ad GA Promo Video
95 Attribute headlinepart1 Headline 1 null
96 Attribute headlinepart2 Headline 2 null
97 Attribute ad_id Ad ID 4.19723E+11
98 Attribute imageadurl Image Ad URL null
99 Attribute imagecreative
imageheight
Image Height null
100 Attribute imagecreative
imagewidth
Image Width null
101 Attribute imagecreative
mimetype
Image Mime Type null
102 Attribute imagecreativename Image ad name GA Promo Video
103 Metric impressionassisted
conversions
Impr. Assisted Conv. 0
104 Metric impressionassisted
conversionsoverlastclickconversions
Impr. Assisted Conv. /
Last Click Conv.
null
105 Metric impressionassisted
conversionvalue
Impr. Assisted Conv.
Value
null
106 Metric impressions Impressions 2
107 Metric interactionrate Interaction Rate 50
108 Metric interactions Interactions 1
109 Metric interactiontypes Interaction Types “[“”Views””]”
110 Attribute isnegative Is negative FALSE
111 Attribute labelids Label IDs null
112 Attribute labels Labels null
113 Attribute longheadline Long headline null
114 Attribute maincolor Main color
(responsive)
null
115 Attribute marketingimage
calltoactiontext
Gmail ad marketing image call
to action text
null
116 Attribute marketingimage
calltoactiontextcolor
Gmail ad marketing
image call to action
text color
null
117 Attribute marketingimage
description
Gmail ad marketing
image description
null
118 Attribute marketing
imageheadline
Gmail ad marketing
image headline
null
119 Attribute multiassetresponsive
displayadaccentcolor
Accent color (multi asset
responsive display)
null
120 Attribute multiassetresponsivedisplay
adallowflexiblcolor
Allow flexible color
(multi asset responsive display)
null
121 Attribute multiassetresponsive
displayadbusinessname
Business name (multi asset
responsive display)
null
122 Attribute multiassetresponsive
displayadcalltoactiontext
Call to action text (multi
asset responsive display)
null
123 Attribute multiassetresponsive
displayaddescriptions
Descriptions (multi
asset responsive display)
null
124 Attribute multiassetresponsive
displayaddynamicsettingspriceprefix
Price prefix (multi
asset responsive display)
null
125 Attribute multiassetresponsive
displayaddynamicsettingspromotext
Promotion text (multi
asset responsive display)
null
126 Attribute multiasset
responsivedisplayadformatsetting
Ad format preference
(multi asset responsive display)
null
127 Attribute multiassetresponsive
displayadheadlines
Headlines (multi
asset responsive display)
null
128 Attribute multiassetresponsive
displayadlandscapelogoimages
Landscape logos (multi
asset responsive display)
null
129 Attribute multiassetresponsive
displayadlogoimages
Logos (multi asset
responsive display)
null
130 Attribute multiassetresponsive
displayadlongheadline
Long headline (multi
asset responsive display)
null
131 Attribute multiassetresponsive
displayadmaincolor
Main color (multi asset
responsive display)
null
132 Attribute multiassetresponsivedisplay
admarketingimages
Images (multi asset
responsive display)
null
133 Attribute multiassetresponsive
displayadsquaremarketingimages
Square images (multi asset
responsive display)
null
134 Attribute multiassetresponsive
displayadyoutubevideos
Youtube videos (multi asset
responsive display)
null
135 Attribute path1 Path 1 null
136 Attribute path2 Path 2 null
137 Metric percentnewvisitors % new sessions 0
138 Attribute policysummary Policy null
139 Attribute priceprefix Price prefix (responsive) null
140 Attribute promotext Promotion text
(responsive)
null
141 Attribute responsivesearchad
descriptions
Responsive Search
Ad descriptions
null
142 Attribute responsivesearch
adheadlines
Responsive Search
Ad headlines
null
143 Attribute responsivesearch
adpath1
Responsive Search
Ad path 1
null
144 Attribute responsivesearch
adpath2
Responsive Search
Ad path 2
null
145 Attribute shortheadline Short headline null
146 Attribute status Ad state enabled
147 Attribute systemmanaged
entitysource
System managed
Entity Source
null
148 Metric topimpression
percentage
Impr. (Top) % 0
149 Attribute universal
appaddescriptions
Universal App Ad
descriptions
null
150 Attribute universal
appadheadlines
Universal App
Ad headlines
null
151 Attribute universalappad
html5mediabundles
Universal App Ad
html5 media bundles
null
152 Attribute universalapp
adimages
Universal App
Ad images
null
153 Attribute universalapp
admandatoryadtext
Universal App
Ad mandatory ad text
null
154 Attribute universalappad
youtubevideos
Universal App Ad
youTube videos
null
155 Metric valueper
allconversion
Value /
all conv.
0
156 Metric valueper
conversion
Value /
conv.
0
157 Metric valuepercurrent
modelattributedconversion
Value / conv.
(current model)
0
158 Metric videoquartile
100rate
Video played
to 100%
50
159 Metric videoquartile
25rate
Video played to
25%
50
160 Metric videoquartile
50rate
Video played
to 50%
50
161 Metric videoquartile
75rate
Video played
to 75%
50
162 Metric videoviewrate View rate 50
163 Metric videoviews Views 1
164 Metric viewthrough
conversions
View-through
conv.
0
165 Electrik.AI eai_aw_account_id Adword Account Id 9227698748
166 Electrik.AI etl_org Organization Id OR000001
167 Electrik.AI etl_project Project Id PR000140
168 Electrik.AI etl_create_utc_dttm Row Create
Timestamp in UTC
2020-04-21
10:36:31.204366 UTC
169 Electrik.AI etl_update_utc_dttm Row Update
Timestamp in UTC
2020-04-21
10:36:31.204366 UTC
170 Electrik.AI etl_start_utc_dttm EAI Flow Start
Timestamp in UTC
2020-04-21
10:31:20.203 UTC
171 Electrik.AI etl_flow_nm EAI Flow Code FL001135
172 Electrik.AI etl_flow_instance_id EAI Flow Execution Instance Id FL001135-
20200421103036738506

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 Attribute accountdescriptivename The descriptive name of the Customer account. iCEDQ
2 Metric activeviewcpm Average cost of viewable impressions (ActiveViewImpressions) 20050000
3 Metric activeviewmeasurablecost The cost of the impressions you received that were measurable by Active View. 80200
4 Metric activeviewmeasurable impressions The number of times your ads are appearing on placements in positions where they can be seen. 5
5 Metric activeviewctr How often people clicked your ad after it became viewable. 0.00%
6 Metric activeviewimpressions How often your ad has become viewable on a Display Network site. 4
7 Attribute adgroupname The name of the AdGroup. In-Stream Ads
8 Attribute adgroupid The ID of the AdGroup. 69973910847
9 Attribute adgroupstatus Status of the ad group. enabled
10 Attribute adgrouptype The type of ad group. In-stream
11 Metric allconversions Best estimate of the total number of conversions that Google Ads drives. Includes website, cross-device, and phone call conversions 1
12 Metric allconversionrate AllConversions divided by total clicks that can be conversion-tracked 50.00%
13 Metric allconversionvalue The total value of all of your conversions, including those that are estimated 0
14 Metric averagecost The average amount you pay per interaction. This amount is the total cost of your ads divided by the total number of interactions. 40100
15 Metric averagecpc The total cost of all clicks divided by the total number of clicks received 80200
16 Metric averagecpe The average amount that you’ve been charged for an ad engagement. This amount is the total cost of all ad engagements divided by the total number of ad engagements 0
17 Metric averagecpm Average Cost-per-thousand impressions (CPM) 16040000
18 Metric averagecpv The average amount you pay each time someone views your ad. The average CPV is defined by the total cost of all ad views divided by the number of views. 40100
19 Metric averageposition Your ad’s position relative to those of other advertisers.  —
20 Attribute baseadgroupid The ID of base ad group of trial ad groups. For regular ad groups, this is equal to AdGroupId. For campaign-level user lists, this will always be 0. 69973910847
21 Attribute basecampaignid The ID of base campaign of trial campaigns. For regular campaigns, this is equal to CampaignId. 1701235089
22 Attribute campaignname The name of the Campaign. YouTube Ads
23 Attribute campaignid The ID of the Campaign. 1701235089
24 Attribute campaignstatus The status of the Campaign. enabled
25 Metric clicks The number of clicks. 1
26 Attribute customer descriptivename The descriptive name of the Customer. iCEDQ
27 Metric conversionrate The number of conversions divided by total clicks that can be tracked to conversions 0.00%
28 Metric currentmodelattributed conversionvalue Conv. value (current model) 0
29 Metric conversions The number of conversions for all conversion actions that you have opted into optimization. 0
30 Metric currentmodelattributed conversions Conversions (current model) 0
31 Metric cost The sum of your cost-per-click (CPC) and cost-per-thousand impressions (CPM) costs during this period. 80200
32 Metric costperallconversion Total cost divided by all conversions. 80200
33 Metric costperconversion The Cost attributable to conversion-tracked clicks divided by the number of conversions. 0
34 Metric costpercurrentmodel attributedconversion Cost / conv. (current model) 0
35 Metric crossdeviceconversions Conversions from when a customer clicks on an ad on one device, then converts on a different device or browser. Cross-device conversions are already included in your AllConversions column  —
36 Metric ctr The number of clicks your ad receives (Clicks) divided by the number of times your ad is shown (Impressions). Percentage returned as “x.xx%”. 20.00%
37 Attribute accountcurrencycode The currency of the Customer account. USD
38 Attribute externalcustomerid The Customer ID. 2395363118
39 Dimension date The date formatted as yyyy-MM-dd. 8/13/2019
40 Dimension device Device type where the impression was shown. Mobile devices with full browsers
41 Metric engagementrate How often people engage with your ad after it’s shown to them. This is the number of ad expansions divided by the number of times your ad is shown 0.00%
42 Metric engagements The number of engagements. An engagement occurs when a viewer expands your Lightbox ad 0
43 Metric gmailsecondaryclicks The number of clicks to your landing page on the expanded state of Gmail ads. 0
44 Metric gmailforwards The number of times your ad was forwarded to someone else as a message. 0
45 Metric gmailsaves The number of times someone has saved your Gmail ad to their inbox as a message. 0
46 Metric absolutetopimpression percentage The percent of your ad impressions that are shown as the very first ad above the organic search results 0
47 Metric topimpressionpercentage The percent of your ad impressions that are shown anywhere above the organic search results 0
48 Metric impressions Count of how often your ad has appeared on a search results page or website on the Google Network. 5
49 Metric interactionrate How often people interact with your ad after it is shown to them. This is the number of interactions divided by the number of times your ad is shown 40.00%
50 Metric interactiontypes The types of interactions that are reflected in the Interactions, InteractionRate, and AverageCost columns. [“Views”]
51 Metric interactions The number of interactions. An interaction is the main user action associated with an ad format–clicks for text and shopping ads, views for video ads, and so on. 2
52 Attribute labelids Label IDs  —
53 Attribute labels Labels  —
54 Dimension adnetworktype1 First level network type. YouTube Videos
55 Dimension adnetworktype2 Second level network type (includes search partners). YouTube Videos
56 Attribute accounttimezone Name of the timezone selected for the Customer account (GMT-05:00) Eastern Time
57 Metric conversionvalue The sum of conversion values for all conversions 0
58 Metric valueperallconversion The value, on average, of all conversions. 0
59 Metric valueperconversion The total value of your conversions divided by the total number of conversions 0
60 Metric valuepercurrentmodel attributedconversion Value / conv. (current model) 0
61 Metric videoquartile100rate Video played to 100% 25.00%
62 Metric videoquartile25rate Video played to 25% 25.00%
63 Metric videoquartile50rate Video played to 50% 25.00%
64 Metric videoquartile75rate Video played to 75% 25.00%
65 Metric videoviewrate The number of views your TrueView video ad receives divided by its number of impressions, including thumbnail impressions for TrueView in-display ads 40.00%
66 Metric videoviews The number of times your video ads were viewed. 2
67 Metric viewthroughconversions The total number of view-through conversions 0
68 Electrik.AI eai_aw_account_id Adword Account Id 9227698748
69 Electrik.AI etl_org Organization Id OR000001
70 Electrik.AI etl_project Project Id PR000140
71 Electrik.AI etl_create_utc_dttm Row Create Timestamp in UTC 2020-04-21 10:36:31.204366 UTC
72 Electrik.AI etl_update_utc_dttm Row Update Timestamp in UTC 2020-04-21 10:36:31.204366 UTC
73 Electrik.AI etl_start_utc_dttm EAI Flow Start Timestamp in UTC 2020-04-21 10:31:20.203 UTC
74 Electrik.AI etl_flow_nm EAI Flow Code FL001136-20200421103036738506
75 Electrik.AI etl_flow_instance_id EAI Flow Execution Instance Id FL001136-20200421103036738506

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

Index Category Electrik.AI Column Name Description Sample Value
1 Metric absolutetopimpressionpercentage Impr. (Abs. Top) % 0
2 Attribute accountcurrencycode Currency USD
3 Attribute accountdescriptivename Account electrik.ai
4 Attribute accounttimezone Time zone (GMT-05:00) Eastern Time
5 Metric activeviewcpm Active View avg. CPM 3165211
6 Metric activeviewctr Active View viewable CTR 0
7 Metric activeviewimpressions Active View viewable impressions 19
8 Metric activeviewmeasurability Active View measurable impr. / impr. 100
9 Metric activeviewmeasurablecost Active View measurable cost 60139
10 Metric activeviewmeasurableimpressions Active View measurable impr. 19
11 Metric activeviewviewability Active View viewable impr. / measurable impr. 100
12 Dimension adnetworktype1 Network YouTube Videos
13 Dimension adnetworktype2 Network (with search partners) YouTube Videos
14 Attribute advertisingchannelsubtype Advertising Sub Channel null
15 Attribute advertisingchanneltype Advertising Channel Video
16 Metric allconversionrate All conv. rate 0
17 Metric allconversions All conv. 0
18 Metric allconversionvalue All conv. value 0
19 Attribute amount Budget 30000000
20 Metric averagecost Avg. Cost 0
21 Metric averagecpc Avg. CPC 0
22 Metric averagecpe Avg. CPE 0
23 Metric averagecpm Avg. CPM 3165211
24 Metric averagecpv Avg. CPV 0
25 Metric averagefrequency Avg. impr. freq. per cookie 0
26 Metric averagepageviews Pages / session 0
27 Metric averageposition Avg. position null
28 Metric averagetimeonsite Avg. session duration (seconds) 0
29 Attribute basecampaignid Base Campaign ID 9428320745
30 Attribute biddingstrategyid Bid Strategy ID 0
31 Attribute biddingstrategyname Bid Strategy Name null
32 Attribute biddingstrategytype Bid Strategy Type null
33 Metric bouncerate Bounce rate 0
34 Attribute budgetid Budget ID 6821681471
35 Attribute campaigndesktopbidmodifier Desktop bid adj. null
36 Attribute campaigngroupid Campaign Group ID 0
37 Attribute campaignid Campaign ID 9428320745
38 Attribute campaignmobilebidmodifier Mobile bid adj. null
39 Attribute campaignname Campaign Evergreen_YouTube Video Non-skippable
40 Attribute campaignstatus Campaign state enabled
41 Attribute campaigntabletbidmodifier Tablet bid adj. null
42 Attribute campaigntrialtype Campaign Trial Type base campaign
43 Metric clickassistedconversions Click Assisted Conv. 0
44 Metric clickassisted conversionsoverlastclick conversions Click Assisted Conv. / Last Click Conv. null
45 Metric clickassistedconversionvalue Click Assisted Conv. Value null
46 Metric clicks Clicks 0
47 Metric contentbudgetlostimpressionshare Content Lost IS (budget) 0
48 Metric contentimpressionshare Content Impr. share < 10
49 Metric contentranklostimpressionshare Content Lost IS (rank) > 90
50 Metric conversionrate Conv. rate 0
51 Metric conversions Conversions 0
52 Metric conversionvalue Total conv. value 0
53 Metric cost Cost 60139
54 Metric costperallconversion Cost / all conv. 0
55 Metric costperconversion Cost / conv. 0
56 Metric costpercurrentmodel attributedconversion Cost / conv. (current model) 0
57 Metric crossdeviceconversions Cross-device conv. null
58 Metric ctr CTR 0
59 Metric currentmodelattributed conversions Conversions (current model) 0
60 Metric currentmodelattributed conversionvalue Conv. value (current model) 0
61 Attribute customerdescriptivename Client name electrik.ai
62 Dimension snapshot_dt Day 2020-04-03 00:00:00 UTC
63 Attribute enddate End date null
64 Metric engagementrate Engagement rate 0
65 Metric engagements Engagements 0
66 Attribute enhancedcpcenabled Enhanced CPC enabled FALSE
67 Attribute externalcustomerid Customer ID 9227698748
68 Attribute finalurlsuffix Final URL suffix null
69 Metric gmailforwards Gmail forwards 0
70 Metric gmailsaves Gmail saves 0
71 Metric gmailsecondaryclicks Gmail clicks to website 0
72 Attribute hasrecommendedbudget Has recommended Budget FALSE
73 Metric impressionassisted conversions Impr. Assisted Conv. 0
74 Metric impressionassisted conversionsoverlast clickconversions Impr. Assisted Conv. / Last Click Conv. null
75 Metric impressionassisted conversionvalue Impr. Assisted Conv. Value null
76 Metric impressionreach Unique cookies null
77 Metric impressions Impressions 19
78 Metric interactionrate Interaction Rate 0
79 Metric interactions Interactions 0
80 Metric interactiontypes Interaction Types null
81 Metric invalidclickrate Invalid click rate 0
82 Metric invalidclicks Invalid clicks 0
83 Attribute isbudgetexplicitlyshared Budget explicitly shared FALSE
84 Attribute labelids Label IDs [4850756772]
85 Attribute labels Labels null
86 Attribute maximizeconversion valuetargetroas Target ROAS (Maximize Conversion Value) 0
87 Metric numoffline impressions Phone impressions 0
88 Metric numoffline interactions Phone calls 0
89 Metric offlineinteraction rate PTR 0
90 Metric percentnewvisitors % new sessions 0
91 Attribute period Budget period day
92 Attribute recommended budgetamount Recommended Budget amount null
93 Metric relativectr Relative CTR null
94 Metric searchabsolutetop impressionshare Search abs. top IS null
95 Metric searchbudgetlostabsolutet opimpressionshare Search lost abs. top IS (budget) 0
96 Metric searchbudgetlost impressionshare Search Lost IS (budget) null
97 Metric searchbudgetlosttop impressionshare Search lost top IS (budget) 0
98 Metric searchclickshare Click share null
99 Metric searchexactmatch impressionshare Search Exact match IS null
100 Metric searchimpressionshare Search Impr. share null
101 Metric searchranklostabsolute topimpressionshare Search lost abs. top IS (rank) 0
102 Metric searchranklost impressionshare Search Lost IS (rank) null
103 Metric searchranklosttop impressionshare Search lost top IS (rank) 0
104 Metric searchtopimpressionshare Search top IS 0
105 Attribute servingstatus Campaign serving status eligible
106 Attribute startdate Start date 2020-02-18 00:00:00 UTC
107 Metric topimpressionpercentage Impr. (Top) % 0
108 Attribute totalamount Total Budget amount null
109 Attribute trackingurltemplate Tracking template null
110 Attribute urlcustomparameters Custom parameter null
111 Metric valueperallconversion Value / all conv. 0
112 Metric valueperconversion Value / conv. 0
113 Metric valuepercurrentmodel attributed conversion Value / conv. (current model) 0
114 Metric videoquartile100rate Video played to 100% 100
115 Metric videoquartile25rate Video played to 25% 100
116 Metric videoquartile50rate Video played to 50% 100
117 Metric videoquartile75rate Video played to 75% 100
118 Metric videoviewrate View rate 0
119 Metric videoviews Views 0
120 Metric viewthroughconversions View-through conv. 0
121 Electrik.AI eai_aw_account_id Adword Account Id 9227698748
122 Electrik.AI etl_org Organization Id OR000001
123 Electrik.AI etl_project Project Id PR000140
124 Electrik.AI etl_create_utc_dttm Row Create Timestamp in UTC 2020-04-22 07:51:59.653392 UTC
125 Electrik.AI etl_update_utc_dttm Row Update Timestamp in UTC 2020-04-22 07:51:59.653392 UTC
126 Electrik.AI etl_start_utc_dttm EAI Flow Start Timestamp in UTC 2020-04-22 07:47:15.010 UTC
127 Electrik.AI etl_flow_nm EAI Flow Code FL001136
128 Electrik.AI etl_flow_instance_id EAI Flow Execution Instance Id FL001136-20200422074625492531

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

Index Category Electrik.AI Column Name Description Sample Value
1 Metric absolutetopimpressionpercentage Impr. (Abs. Top) % 0
2 Attribute accountcurrencycode Currency USD
3 Attribute accountdescriptivename Account electrik.ai
4 Attribute accounttimezone Time zone (GMT-05:00) Eastern Time
5 Metric activeviewcpm Active View avg. CPM 3165211
6 Metric activeviewctr Active View viewable CTR 0
7 Metric activeviewimpressions Active View viewable impressions 19
8 Metric activeviewmeasurability Active View measurable impr. / impr. 100
9 Metric activeviewmeasurablecost Active View measurable cost 60139
10 Metric activeviewmeasurableimpressions Active View measurable impr. 19
11 Metric activeviewviewability Active View viewable impr. / measurable impr. 100
12 Dimension adnetworktype1 Network YouTube Videos
13 Dimension adnetworktype2 Network (with search partners) YouTube Videos
14 Attribute advertisingchannelsubtype Advertising Sub Channel null
15 Attribute advertisingchanneltype Advertising Channel Video
16 Metric allconversionrate All conv. rate 0
17 Metric allconversions All conv. 0
18 Metric allconversionvalue All conv. value 0
19 Attribute amount Budget 30000000
20 Metric averagecost Avg. Cost 0
21 Metric averagecpc Avg. CPC 0
22 Metric averagecpe Avg. CPE 0
23 Metric averagecpm Avg. CPM 3165211
24 Metric averagecpv Avg. CPV 0
25 Metric averagefrequency Avg. impr. freq. per cookie 0
26 Metric averagepageviews Pages / session 0
27 Metric averageposition Avg. position null
28 Metric averagetimeonsite Avg. session duration (seconds) 0
29 Attribute basecampaignid Base Campaign ID 9428320745
30 Attribute biddingstrategyid Bid Strategy ID 0
31 Attribute biddingstrategyname Bid Strategy Name null
32 Attribute biddingstrategytype Bid Strategy Type null
33 Metric bouncerate Bounce rate 0
34 Attribute budgetid Budget ID 6821681471
35 Attribute campaigndesktopbidmodifier Desktop bid adj. null
36 Attribute campaigngroupid Campaign Group ID 0
37 Attribute campaignid Campaign ID 9428320745
38 Attribute campaignmobilebidmodifier Mobile bid adj. null
39 Attribute campaignname Campaign Evergreen_YouTube Video Non-skippable
40 Attribute campaignstatus Campaign state enabled
41 Attribute campaigntabletbidmodifier Tablet bid adj. null
42 Attribute campaigntrialtype Campaign Trial Type base campaign
43 Metric clickassistedconversions Click Assisted Conv. 0
44 Metric clickassisted conversionsoverlastclick conversions Click Assisted Conv. / Last Click Conv. null
45 Metric clickassistedconversionvalue Click Assisted Conv. Value null
46 Metric clicks Clicks 0
47 Metric contentbudgetlostimpressionshare Content Lost IS (budget) 0
48 Metric contentimpressionshare Content Impr. share < 10
49 Metric contentranklostimpressionshare Content Lost IS (rank) > 90
50 Metric conversionrate Conv. rate 0
51 Metric conversions Conversions 0
52 Metric conversionvalue Total conv. value 0
53 Metric cost Cost 60139
54 Metric costperallconversion Cost / all conv. 0
55 Metric costperconversion Cost / conv. 0
56 Metric costpercurrentmodel attributedconversion Cost / conv. (current model) 0
57 Metric crossdeviceconversions Cross-device conv. null
58 Metric ctr CTR 0
59 Metric currentmodelattributed conversions Conversions (current model) 0
60 Metric currentmodelattributed conversionvalue Conv. value (current model) 0
61 Attribute customerdescriptivename Client name electrik.ai
62 Dimension snapshot_dt Day 2020-04-03 00:00:00 UTC
63 Attribute enddate End date null
64 Metric engagementrate Engagement rate 0
65 Metric engagements Engagements 0
66 Attribute enhancedcpcenabled Enhanced CPC enabled FALSE
67 Attribute externalcustomerid Customer ID 9227698748
68 Attribute finalurlsuffix Final URL suffix null
69 Metric gmailforwards Gmail forwards 0
70 Metric gmailsaves Gmail saves 0
71 Metric gmailsecondaryclicks Gmail clicks to website 0
72 Attribute hasrecommendedbudget Has recommended Budget FALSE
73 Metric impressionassisted conversions Impr. Assisted Conv. 0
74 Metric impressionassisted conversionsoverlast clickconversions Impr. Assisted Conv. / Last Click Conv. null
75 Metric impressionassisted conversionvalue Impr. Assisted Conv. Value null
76 Metric impressionreach Unique cookies null
77 Metric impressions Impressions 19
78 Metric interactionrate Interaction Rate 0
79 Metric interactions Interactions 0
80 Metric interactiontypes Interaction Types null
81 Metric invalidclickrate Invalid click rate 0
82 Metric invalidclicks Invalid clicks 0
83 Attribute isbudgetexplicitlyshared Budget explicitly shared FALSE
84 Attribute labelids Label IDs [4850756772]
85 Attribute labels Labels null
86 Attribute maximizeconversion valuetargetroas Target ROAS (Maximize Conversion Value) 0
87 Metric numoffline impressions Phone impressions 0
88 Metric numoffline interactions Phone calls 0
89 Metric offlineinteraction rate PTR 0
90 Metric percentnewvisitors % new sessions 0
91 Attribute period Budget period day
92 Attribute recommended budgetamount Recommended Budget amount null
93 Metric relativectr Relative CTR null
94 Metric searchabsolutetop impressionshare Search abs. top IS null
95 Metric searchbudgetlostabsolutet opimpressionshare Search lost abs. top IS (budget) 0
96 Metric searchbudgetlost impressionshare Search Lost IS (budget) null
97 Metric searchbudgetlosttop impressionshare Search lost top IS (budget) 0
98 Metric searchclickshare Click share null
99 Metric searchexactmatch impressionshare Search Exact match IS null
100 Metric searchimpressionshare Search Impr. share null
101 Metric searchranklostabsolute topimpressionshare Search lost abs. top IS (rank) 0
102 Metric searchranklost impressionshare Search Lost IS (rank) null
103 Metric searchranklosttop impressionshare Search lost top IS (rank) 0
104 Metric searchtopimpressionshare Search top IS 0
105 Attribute servingstatus Campaign serving status eligible
106 Attribute startdate Start date 2020-02-18 00:00:00 UTC
107 Metric topimpressionpercentage Impr. (Top) % 0
108 Attribute totalamount Total Budget amount null
109 Attribute trackingurltemplate Tracking template null
110 Attribute urlcustomparameters Custom parameter null
111 Metric valueperallconversion Value / all conv. 0
112 Metric valueperconversion Value / conv. 0
113 Metric valuepercurrentmodel attributed conversion Value / conv. (current model) 0
114 Metric videoquartile100rate Video played to 100% 100
115 Metric videoquartile25rate Video played to 25% 100
116 Metric videoquartile50rate Video played to 50% 100
117 Metric videoquartile75rate Video played to 75% 100
118 Metric videoviewrate View rate 0
119 Metric videoviews Views 0
120 Metric viewthroughconversions View-through conv. 0
121 Electrik.AI eai_aw_account_id Adword Account Id 9227698748
122 Electrik.AI etl_org Organization Id OR000001
123 Electrik.AI etl_project Project Id PR000140
124 Electrik.AI etl_create_utc_dttm Row Create Timestamp in UTC 2020-04-22 07:51:59.653392 UTC
125 Electrik.AI etl_update_utc_dttm Row Update Timestamp in UTC 2020-04-22 07:51:59.653392 UTC
126 Electrik.AI etl_start_utc_dttm EAI Flow Start Timestamp in UTC 2020-04-22 07:47:15.010 UTC
127 Electrik.AI etl_flow_nm EAI Flow Code FL001136
128 Electrik.AI etl_flow_instance_id EAI Flow Execution Instance Id FL001136-20200422074625492531

The Click Performance report includes stats aggregated at each click level, and includes both valid and invalid clicks.

For non-Search campaigns, the Clicks field represents the number of valid and invalid interactions instead of clicks.

Index Category Electrik.AI Column Name Description Sample Value
1 Attribute accountdescriptivename The descriptive name of the Customer account. iCEDQ
2 Attribute adgroupname The name of the AdGroup. YouTube & Display Ads
3 Attribute adgroupid The ID of the AdGroup. 80630220887
4 Attribute adgroupstatus Status of the ad group. enabled
5 Attribute creativeid ID of the ad. 3.76269E+11
6 Attribute adformat Ad type video
7 Attribute advariationcontroltrialarmid If the impression was part of an ad variation and in the control arm, this represents the ad variation control arm ID. 0
8 Attribute advariationtreatmenttrialarmid If the impression was part of an ad variation and in the treatment arm, this represents the ad variation treatment arm ID. 0
9 Attribute advariationtrialid If the impression was part of an ad variation, this represents the ad variation trial ID. 0
10 Attribute campaignname The name of the Campaign. TrueView Ads
11 Attribute campaignid The ID of the Campaign. 2089199007
12 Attribute campaignlocationtargetid Location ID of the matching campaign criterion. 2840
13 Attribute campaignstatus The status of the Campaign. enabled
14 Attribute aoicitycriteriaid City (Location of interest)  —
15 Attribute lopcitycriteriaid City (Physical location) 9051675
16 Attribute clicktype Indicates the click type for metric fields such as Impressions. Since ads that serve can be attributed to multiple click types, metric fields may be decimal-counted and thus totals may not be accurate, especially for Display network campaigns. Engagement
17 Attribute clicks The number of clicks. 1
18 Attribute aoicountrycriteriaid Country/Territory (Location of interest)  —
19 Attribute lopcountrycriteriaid Country/Territory (Physical location) 2840
20 Attribute externalcustomerid The Customer ID. 2395363118
21 Attribute snapshot_dt The date formatted as yyyy-MM-dd. 1/21/2020
22 Attribute device Device type where the impression was shown. Computers
23 Attribute gclid The Google Click ID. CjwKCAiA35rxBRAWEiw ADqB375DsYAtWjagCqfg cRvo-8lP2twSpE2jBwf5 jLUU4oBgF9A2GQGBI8RoC 62EQAvD_BwE
24 Attribute criteriaparameters Keyword / Placement 0%-50%
25 Attribute criteriaid The Criterion ID. 510001
26 Attribute keywordmatchtype The match type for the Keyword.  —
27 Attribute aoimetrocriteriaid Metro area (Location of interest)  —
28 Attribute lopmetrocriteriaid Metro area (Physical location) 200536
29 Attribute aoimostspecifictargetid Most specific location target (Location of interest)  —
30 Attribute lopmostspecifictargetid Most specific location target (Physical location) 9015207
31 Attribute adnetworktype1 First level network type. YouTube Videos
32 Attribute adnetworktype2 Second level network type (includes search partners). YouTube Videos
33 Attribute page Page number in search results where the ad was shown. 1
34 Attribute aoiregioncriteriaid Region (Location of interest)  —
35 Attribute lopregioncriteriaid Region (Physical location) 21168
36 Attribute slot The position of the Ad. Google Display Network
37 Attribute userlistid The ID of the UserList (audience).  —
38 Electrik.AI etl_org Organization Id OR000001
39 Electrik.AI etl_project Project Id PR000140
40 Electrik.AI etl_create_utc_dttm Row Create Timestamp in UTC 1/28/2020 15:23
41 Electrik.AI etl_update_utc_dttm Row Update Timestamp in UTC 1/28/2020 15:23
42 Electrik.AI etl_start_utc_dttm EAI Flow Start Timestamp in UTC 1/28/2020 15:20
43 Electrik.AI etl_flow_nm EAI Flow Code FL001142
44 Electrik.AI etl_flow_instance_id EAI Flow Execution Instance Id FL001142-20200 428151938662057
45 Electrik.AI eai_aw_account_id Adword Account Id 9227698455

The Marketplace Performance report includes all statistics of ads displayed on the Marketplace, aggregated by default at the account level.

The Search Terms report includes all statistics aggregated at the search term level.
Index Category Electrik.AI Column Name Description Sample Value
1 Metric absolutetopimpressionpercentage The percent of your ad impressions 1
2 Metric accountcurrencycode The currency of the  account. USD
3 Attribute accountdescriptivename The descriptive name of the  account electrik.ai
4 Attribute accounttimezone Time zone  selected for the  account (GMT-05:00) Eastern Time
5 Dimension activeviewctr Active view ctr text
6 Metric adgroupid Ad group ID 85404108936
7 Metric adgroupname Ad group name GA Data Extract
8 Metric adgroupstatus Ad group status enabled
9 Metric adnetworktype1 First level network type. Search Network
10 Metric adnetworktype2 Second level network type (includes search partners). Google search
11 Metric allconversionrate Conversion rate 0
12 Metric allconversions Conversions 0
13 Metric allconversionvalue Conversion value 0
14 Metric averagecost Avg. Cost 0
15 Attribute averagecpc Avg. CPC 0
16 Attribute averagecpe Avg. CPE 0
17 Attribute averagecpm Avg. CPM 0
18 Metric averagecpv Avg. CPV 0
19 Metric averageposition Average Position
20 Dimension campaignid Campaign ID 8247077736
21 Metric campaignname Campaign name Evergreen_GA Hit Data Extractor Cmpgn
22 Metric campaignstatus Campaign state enabled
23 Attribute clicks Clicks 0
24 Attribute conversionrate Conv. rate 0
25 Metric conversions Conversions 0
26 Metric conversionvalue Total conv. value 0
27 Attribute cost Cost 0
28 Attribute costperallconversion Cost / all conv. 0
29 Metric costperconversion Cost / conv. 0
30 Metric creativeid Ad ID 4.10259E+11
31 Metric crossdeviceconversions Cross-device conv.
32 Metric ctr CTR 0
33 Attribute customerdescriptivename Client name electrik.ai
34 Metric snapshot_dt Day 4/6/2020
35 Metric destinationurl Destination URL
36 Metric engagementrate Engagement rate 0
37 Metric engagements Engagements 0
38 Metric externalcustomerid Customer ID 9227698748
39 Metric finalappurls Final URL https://electrik.ai/google-analytics-hit-data-extractor
40 Footer impressions Impressions 1
41 Footer interactionrate Interaction Rate 0
42 Footer interactions Interactions 0
43 Footer interactiontypes Interaction Types
44 Footer keywordid Keyword ID 8.46062E+11
45 Attribute keywordtextmatchingquery Keyword "+export +Google +Analytics +data"
46 Attribute query Search term export google analytics data
47 Attribute querytargetingstatus Added/Excluded Added
48 Metric topimpressionpercentage Impr. (Top) % 1
49 Attribute trackingurltemplate Tracking template
50 Metric valueperallconversion Value / all conv. 0
51 Metric valueperconversion Value / conv. 0
52 Metric videoquartile100rate Video played to 100% 0
53 Metric videoquartile25rate Video played to 25% 0
54 Metric videoquartile50rate Video played to 50% 0
55 Metric videoquartile75rate Video played to 75% 0
56 Metric videoviewrate View rate 0
57 Metric videoviews Views 0
58 Metric viewthroughconversions View-through conv. 0
59 Electrik.AI eai_aw_account_id Adword Account Id 9227698748
60 Electrik.AI etl_org Organization Id ORG000251
61 Electrik.AI etl_project Project Id PR000142
62 Electrik.AI etl_create_utc_dttm Row Create Timestamp in UTC 4/30/2020 15:29
63 Electrik.AI etl_update_utc_dttm Row Update Timestamp in UTC 4/30/2020 15:29
64 Electrik.AI etl_start_utc_dttm EAI Flow Start Timestamp in UTC 4/30/2020 15:25
65 Electrik.AI etl_flow_nm EAI Flow Code FL001054
66 Electrik.AI etl_flow_instance_id EAI Flow Execution Instance Id FL001054-20200430152421532595

The URL Performance report includes all statistics aggregated at the URL and criterion level.

The Shopping Performance report provides shopping campaign statistics aggregated at the product (OfferId field) level. Product dimension values from Merchant Center such as brand, category, custom attributes, product condition and product type will reflect the state of each dimension as of the date and time when AdWords recorded the corresponding event.
Index Category Electrik.AI Column Name Description Sample Value
1 Attribute accountdescriptivename The descriptive name of the Customer account. 2276175868
2 Attribute adgroupid The ID of the AdGroup. 1.01689E+11
3 Attribute adgroupname The name of the AdGroup. Mosnil Products
4 Dimension adgroupstatus Status of the ad group. enabled
5 Dimension adnetworktype1 First level network type. Search Network
6 Dimension adnetworktype2 Second level network type (includes search partners) Google search
7 Attribute aggregatorid The multi-client account ID from Merchant Center
8 Metric averagecpc Average CPC 0
9 Attribute brand Product Brand value mosnil
10 Attribute campaignid Campaign ID 9817125989
11 Attribute campaignname Campaign Name Mosnil Website Traffic
12 Dimension campaignstatus Campaign Status paused
13 Attribute categoryl1 The ProductBiddingCategory level 1 value
14 Attribute categoryl2 The ProductBiddingCategory level 2 value
15 Attribute categoryl3 The ProductBiddingCategory level 3 value
16 Attribute categoryl4 The ProductBiddingCategory level 4 value
17 Attribute categoryl5 The ProductBiddingCategory level 5 value
18 Dimension channel Channel of the product. Online
19 Dimension channelexclusivity Channel exclusivity of the product. Single Channel
20 Metric clicks The number of clicks. 0
21 Metric cost The sum of CPC and CPM costs 0
22 Attribute countrycriteriaid Country Criteria Id 2356
23 Metric ctr The number of clicks your ad receives divided by the number of times your ad is shown (Impressions) 0
24 Attribute customattribute0 The ProductCustomAttribute level 0 value
25 Attribute customattribute1 The ProductCustomAttribute level 1 value
26 Attribute customattribute2 The ProductCustomAttribute level 2 value
27 Attribute customattribute3 The ProductCustomAttribute level 3 value
28 Attribute customattribute4 The ProductCustomAttribute level 4 value
29 Dimension snapshot_dt The date formatted as yyyy-MM-dd. 4/24/2020 0:00
30 Dimension device Device type where the impression was shown. Mobile devices with full browsers
31 Attribute externalcustomerid The Customer ID 2276175868
32 Metric impressions Count of how often your ad has appeared on a search results page or website on the Google Network. 1
33 Attribute languagecriteriaid Language of the product information. 1000
34 Attribute merchantid ID of the Google Merchant Center account associated with the products being advertised. 182128668
35 Attribute offerid Offer/item ID of the product. wihhoshh
36 Attribute producttitle The title of the product. Herbal Mosquito Repellent Liquid Vaporizer - Cironella Mix 45 ML
37 Dimension productcondition The Product Canonical Condition New
38 Attribute producttypel1 The ProductType level 1 value home & garden
39 Attribute producttypel2 The ProductType level 2 value household supplies
40 Attribute producttypel3 The ProductType level 3 value pest control
41 Attribute producttypel4 The ProductType level 4 value repellents
42 Attribute producttypel5 The ProductType level 5 value
43 Metric searchabsolutetop impressionshare Impression received in the absolute top location
44 Metric searchclickshare Number of clicks on search network
45 Metric searchimpressionshare Impressions received on the search network
46 Electrik.AI eai_aw_account_id Adword Account Id 2276175868
47 Electrik.AI etl_org Organization Id ORG000859
48 Electrik.AI etl_project Project Id PR000240
49 Electrik.AI etl_create_utc_dttm Row Create Timestamp in UTC 5/6/2020 14:35
50 Electrik.AI etl_update_utc_dttm Row Update Timestamp in UTC 5/6/2020 14:35
51 Electrik.AI etl_start_utc_dttm EAI Flow Start Timestamp in UTC 5/6/2020 14:28
52 Electrik.AI etl_flow_nm EAI Flow Code FL001239
53 Electrik.AI etl_flow_instance_id EAI Flow Execution Instance Id FL001239-202005061 42759550760

The URL Performance report includes all statistics aggregated at the URL and criterion level.

Index Category Electrik.AI Column Name Description Sample Value
1 Attribute accountcurrencycode The currency of the  account USD
2 Attribute accountdescriptivename The descriptive name of the  account electrik.ai
3 Attribute accounttimezone Time zone  selected for the  account (GMT-05:00) Eastern Time
4 Metric activeviewcpm Active View avg. CPM 560680
5 Metric activeviewctr Active View viewable CTR 0
6 Metric activeviewimpressions Active View viewable impressions 231
7 Metric activeviewmeasurability Active View measurable impr. / impr. 100
8 Metric activeviewmeasurablecost Active View measurable cost 129517
9 Metric activeviewmeasurableimpressions Active View measurable impr. 238
10 Metric activeviewviewability Active View viewable impr. / measurable impr. 97.06
11 Dimension adformat Ad type text
12 Attribute adgroupcriterionstatus Keyword/Placement state removed
13 Attribute adgroupid Ad group ID 87518807715
14 Attribute adgroupname Ad group Name Targeting Keywords
15 Attribute adgroupstatus Ad group status enabled
16 Attribute adnetworktype1 First level network type. Display Network
17 Dimension adnetworktype2 Second level network type (includes search partners). Display Network
18 Metric allconversionrate All conversions rate 0
19 Metric allconversions All conversions 0
20 Metric allconversionvalue All conversion value 0
21 Metric averagecost Avg. Cost 0
22 Metric averagecpc Avg. CPC 0
23 Metric averagecpe Avg. CPE 0
24 Metric averagecpm Avg. CPM 544189
25 Metric averagecpv Avg. CPV 0
26 Attribute campaignid Campaign ID 8627558597
27 Attribute campaignname Campaign Name Evergreen_Display Campaign
28 Attribute campaignstatus Campaign status enabled
29 Metric clicks The total number of Clicks 0
30 Metric cost Cost 129517
31 Metric costperallconversion Cost / all conv. 0
32 Metric costperconversion Cost / conv. 0
33 Attribute criteriaparameters Keyword / Placement Content
34 Metric crossdeviceconversions Cross-device conv.
35 Metric ctr CTR 0
36 Attribute customerdescriptivename The descriptive name of the Customer. electrik.ai
37 Dimension snapshot_dt The date formatted as yyyy-MM-dd. 1/7/2020 0:00
38 Dimension device Device type where the impression was shown. Computers
39 Attribute displayname Criteria Display Name socialblade.com/ youtube/c/ tseriesmusic
40 Attribute domain The domain of the URL (placement) where the impression was shown socialblade.com
41 Metric engagementrate Engagement rate 0
42 Metric engagements Engagements 0
43 Attribute externalcustomerid Customer ID 9227698748
44 Metric impressions Count of how often your ad has appeared on a search results page or website on the Google Network 238
45 Metric interactionrate Interaction Rate 0
46 Metric interactions Interactions 0
47 Metric interactiontypes Interaction Types
48 Dimension isautooptimized Indicates if Display Campaign Optimizer is enabled for the ad group Auto-optimized
49 Attribute isbidonpath Indicates if the placement was added as a criterion. FALSE
50 Attribute ispathexcluded Indicates if the URL or placement is currently excluded. FALSE
51 Attribute url The URL (placement) where the impression was shown. socialblade.com/ youtube/c/ tseriesmusic
52 Metric valueperallconversion Value / all conv. 0
53 Metric valueperconversion Value / conv. 0
54 Metric videoquartile100rate Video played to 100% 0
55 Metric videoquartile25rate Video played to 25% 0
56 Metric videoquartile50rate Video played to 50% 0
57 Metric videoquartile75rate Video played to 75% 0
58 Metric videoviewrate View rate 0
59 Metric videoviews Views 0
60 Metric viewthroughconversions View-through conv. 0
61 Electrik.AI eai_aw_account_id Adword Account Id 9227698568
62 Electrik.AI etl_org Organization Id OR000001
63 Electrik.AI etl_project Project Id PR000168
64 Electrik.AI etl_create_utc_dttm Row Create Timestamp in UTC 3/9/2020 14:02
65 Electrik.AI etl_update_utc_dttm Row Update Timestamp in UTC 3/9/2020 14:02
66 Electrik.AI etl_start_utc_dttm EAI Flow Start Timestamp in UTC 3/9/2020 13:57
67 Electrik.AI etl_flow_nm EAI Flow Code FL001094
68 Electrik.AI etl_flow_instance_id EAI Flow Execution Instance Id FL001094- 20200309135618828458

The Video Performance report includes statistics for your account’s upgraded AdWords for Video campaigns.

Index Category Electrik.AI Column Name Description Sample Value
1 Attribute accountcurrencycode The currency of the  account. USD
2 Attribute accountdescriptivename The descriptive name of the  account. iCEDQ
3 Attribute accounttimezone Time zone  selected for the  account (GMT-05:00) Eastern Time
4 Attribute adgroupid Ad group ID 57307939333
5 Attribute adgroupname Ad group name In Stream Video Ad
6 Attribute adgroupstatus Ad group status enabled
7 Dimension adnetworktype1 First level network type. YouTube Videos
8 Dimension adnetworktype2 Second level network type (includes search partners). YouTube Videos
9 Metric allconversionrate All conversions rate 0
10 Metric allconversions All conversions 0
11 Metric allconversionvalue All conversion value 0
12 Metric averagecpm Average Cost per click (Values can be micros,bid,no bid, etc.) 9694428
13 Metric averagecpv Average Cost-per-thousand impressions(Values can be micros,bid,no bid, etc.) 83372
14 Attribute campaignid Campaign ID 1491535886
15 Attribute campaignname Campaign Name True View Campaign
16 Attribute campaignstatus Campaign status paused
17 Metric clicks The total number of Clicks 0
18 Metric conversionrate Conversion rate 0
19 Metric conversions Conversions 0
20 Metric conversionvalue Conversion value 0
21 Metric cost Cost 2084302
22 Metric costperallconversion Cost / all conversion 0
23 Metric costperconversion Cost / conversion 0
24 Attribute creativeid Ad ID 3.2453E+11
25 Attribute creativestatus Ad state disabled
26 Metric crossdeviceconversions Cross-device conversions  --
27 Metric ctr The number of clicks your ad receives divided by the number of times your ad is shown (Impressions) 0
28 Attribute customerdescriptivename Client name iCEDQ
29 Dimension snapshot_dt The date formatted as yyyy-MM-dd. 43476
30 Dimension device Device type where the impression was shown. Computers
31 Metric engagementrate Engagement rate 0.3302
32 Metric engagements Engagements 71
33 Attribute externalcustomerid Customer ID 2395363118
34 Metric impressions Impressions 215
35 Metric valueperallconversion Value / all conversion 0
36 Attribute videochannelid Video Channel Id UCMJbItxBj7bwRE HR7xwYZxw
37 Attribute videoduration Video Duration 80015
38 Attribute videoid Video Id vjpS0_sNThQ
39 Metric videoquartile100rate Video played to 100% 0.0279
40 Metric videoquartile25rate Video played to 25% 0.1767
41 Metric videoquartile50rate Video played to 50% 0.0744
42 Metric videoquartile75rate Video played to 75% 0.0558
43 Attribute videotitle Video Title iCEDQ - DataOps Platform for Data Test Automation and Monitoring
44 Metric videoviewrate View rate 0.1163
45 Metric videoviews Views 25
46 Metric viewthroughconversions View-through conversions 0
47 Electrik.AI eai_aw_account_id Adword Account Id 9227698568
48 Electrik.AI etl_org Organization Id OR000001
49 Electrik.AI etl_project Project Id PR000168
50 Electrik.AI etl_create_utc_dttm Row Create Timestamp in UTC 3/9/2020 14:02
51 Electrik.AI etl_update_utc_dttm Row Update Timestamp in UTC 3/9/2020 14:02
52 Electrik.AI etl_start_utc_dttm EAI Flow Start Timestamp in UTC 3/9/2020 13:57
53 Electrik.AI etl_flow_nm EAI Flow Code FL001095
54 Electrik.AI etl_flow_instance_id EAI Flow Execution Instance Id FL001095-20200309135618828458