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 |