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
creativelandscapelogo
imagemediaid | Landscape logo ID
(responsive) | null |
77 | Attribute | enhanceddisplay
creativelogo
imagemediaid | Logo ID
(responsive) | null |
78 | Attribute | enhanceddisplay
creativemarketing
imagemediaid | Image ID
(responsive) | null |
79 | Attribute | enhanceddisplay
creativemarketing
imagesquaremediaid | Square image ID
(responsive) | null |
80 | Attribute | expandeddynamic
searchcreative
description2 | 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
marketingimageme
diaid | 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
conversionsover
lastclickconversions | 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
calltoaction
text | Gmail ad marketing image call
to action text | null |
116 | Attribute | marketingimage
calltoaction
textcolor | 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
displayadaccent
color | Accent color (multi asset
responsive display) | null |
120 | Attribute | multiassetresponsivedisplay
adallowflexibl
color | Allow flexible color
(multi asset responsive display) | null |
121 | Attribute | multiassetresponsive
displayadbusinessname | Business name (multi asset
responsive display) | null |
122 | Attribute | multiassetresponsive
displayadcall
toactiontext | Call to action text (multi
asset responsive display) | null |
123 | Attribute | multiassetresponsive
displayaddescriptions | Descriptions (multi
asset responsive display) | null |
124 | Attribute | multiassetresponsive
displayaddynamicsettings
priceprefix | Price prefix (multi
asset responsive display) | null |
125 | Attribute | multiassetresponsive
displayaddynamicsettings
promotext | Promotion text (multi
asset responsive display) | null |
126 | Attribute | multiasset
responsivedisplayad
formatsetting | Ad format preference
(multi asset responsive display) | null |
127 | Attribute | multiassetresponsive
displayadheadlines | Headlines (multi
asset responsive display) | null |
128 | Attribute | multiassetresponsive
displayadlandscape
logoimages | 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
displayadsquaremarketing
images | Square images (multi asset
responsive display) | null |
134 | Attribute | multiassetresponsive
displayadyoutube
videos | 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
appadde
scriptions | 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
modelattributed
conversion | 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 |