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.

The Google Ads reports give you post-click performance metrics for users who clicked on your Google Ads ads and then came through to your website, or installed and started using your mobile app.

How to add a Google Ads Source in Electrik.AI?

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

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

a. Google Ads Account User Id and Password.

Step 2: Signup for your Electrik.AI account

Step 3: Sign-in into your Electrik.AI account

Step 4: Select IO in Electrik.AI dashboard

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

Step 6: Click on “Google Ads” icon to create a Google Ads connection.

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

Google Ads User Id and Password-ElectrikAI

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

Step 9: Choose Google Ads Account for which you have to extract data.

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

Step 10: Click on Save button on the top.

Step 11: 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 databases to export Google 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

Google Big Query Data Destination-Elecrik.AI

How to export Google Ads Data ?

Electrik.AI creates a data flow (or ETL process) that exports Google 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.

Steps to create a Data Flow from Google Ads to Database

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.)
4. Database Connection Details such as Host, Port, DB Name, DB User, DB Password
Step 2: Signup for your Electrik.AI account
Step 3: Sign-in into your Electrik.AI account
Step 4: Select IO in Electrik.AI dashboard

Step 5: Click on Add button to create a Google Ads – Google Ads Performance Data Extractor Flow

Search Analytics Report Extractor Flow-Electrik.AI

Step 6: Select Google Ads Icon present in the list of available sources.

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

Step 8:Click on a database of your choice from list of available destinations.
In this example we are choosing My SQL. 

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

Select your existing MySQL connection-ElecreikAI

Step 10: Review the Data Source, Data Destination, Database Schema, Select Report Name, Provide Success Notification Email, Failure Notification Email and Click “Save” to continue.
Report Name: Electrik.AI now supports 10 reports, choose any one of them to get the appropriate data.

Electrik.AI now supports 10 reports-ElectrikAI

Success Notification Email: Provide the valid Email ID on which you will receive the Flow Success Email Notification.
Failure Notification Email: Provide the valid Email ID on which you will receive the Flow Failure Email Notification.
Note: Electrik.AI choose your Email Id (i.e Username) in the Notification Email field & you can provide multiple Email id’s also.

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.
Step 11: Please wait while you are redirected to Flow Details Screen.
Step 12: Congratulations, you have successfully setup Electrik.AI Google Ads Performance Report to Database.

Google Ads Performance Report to Database-ElectrikAI

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

Google Ads data will start loading-ElectrikAI

Google Ads Table Schemas

Ad Performance Report

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

Ad Group Performance Report

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

Campaign Performance Report

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

Keyword Performance Report

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

Index	Category	Electrik.AI Column Name	Description	Sample Value
1	Metric	absolutetop impressionpercentage	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	0
6	Metric	activeviewctr	Active View viewable CTR	0
7	Metric	activeviewimpressions	Active View viewable impressions	1
8	Metric	activeview measurability	Active View measurable impr. / impr.	100
9	Metric	activeview measurablecost	Active View measurable cost	0
10	Metric	activeview measurableimpressions	Active View measurable impr.	1
11	Metric	activeview viewability	Active View viewable impr. / measurable impr.	100
12	Dimension	adnetworktype1	Network	YouTube Videos
13	Dimension	adnetworktype2	Network (with search partners)	YouTube Videos
14	Metric	allconversionrate	All conv. rate	0
15	Metric	allconversions	All conv.	0
16	Metric	allconversionvalue	All conv. value	0
17	Metric	averagecost	Avg. Cost	0
18	Metric	averagecpc	Avg. CPC	0
19	Metric	averagecpe	Avg. CPE	0
20	Metric	averagecpm	Avg. CPM	0
21	Metric	averagecpv	Avg. CPV	0
22	Metric	averagepageviews	Pages / session	0
23	Metric	averageposition	Avg. position	null
24	Metric	averagetimeonsite	Avg. session duration (seconds)	0
25	Attribute	basecampaignid	Base Campaign ID	8626374954
26	Attribute	biddingstrategyid	Bid Strategy ID	0
27	Attribute	biddingstrategyname	Bid Strategy Name	null
28	Attribute	biddingstrategytype	Bid Strategy Type	cpv
29	Metric	bouncerate	Bounce rate	0
30	Attribute	campaignid	Campaign ID	8626374954
31	Attribute	campaignname	Campaign	Evergreen_Video Campaign
32	Attribute	campaignstatus	Campaign state	enabled
33	Metric	clickassistedconversions	Click Assisted Conv.	0
34	Metric	clickassisted conversionsover lastclickconversions	Click Assisted Conv. / Last Click Conv.	null
35	Metric	clickassisted conversionvalue	Click Assisted Conv. Value	null
36	Metric	clicks	Clicks	0
37	Metric	conversionrate	Conv. rate	0
38	Metric	conversions	Conversions	0
39	Metric	conversionvalue	Total conv. value	0
40	Metric	cost	Cost	0
41	Metric	costper allconversion	Cost / all conv.	0
42	Metric	costperconversion	Cost / conv.	0
43	Metric	costpercurrent modelattributed conversion	Cost / conv. (current model)	0
44	Attribute	cpcbid	Max. CPC	null
45	Attribute	creativequalityscore	Ad relevance	null
46	Attribute	criteria	Keyword	Content
47	Attribute	criteriadestinationurl	Destination URL	null
48	Metric	crossdevice conversions	Cross-device conv.	null
49	Metric	ctr	CTR	0
50	Metric	currentmodel attributed conversions	Conversions (current model)	0
51	Metric	currentmodel attributed conversionvalue	Conv. value (current model)	0
52	Attribute	customerdescriptivename	Client name	electrik.ai
53	Dimension	snapshot_dt	Day	2020-03-23 00:00:00 UTC
54	Metric	engagementrate	Engagement rate	0
55	Metric	engagements	Engagements	0
56	Attribute	enhancedcpcenabled	Enhanced CPC enabled	FALSE
57	Attribute	estimatedadd clicksat firstpositioncpc	Est. add. clicks/wk (first position bid)	null
58	Attribute	estimatedadd costatfirst positioncpc	Est. add. cost/wk (first position bid)	null
59	Attribute	externalcustomerid	Customer ID	9227698748
60	Attribute	finalappurls	App final URL	null
61	Attribute	finalmobileurls	Mobile final URL	null
62	Attribute	finalurls	Final URL	null
63	Attribute	finalurlsuffix	Final URL suffix	null
64	Attribute	firstpagecpc	First page CPC	0
65	Attribute	firstpositioncpc	First position CPC	null
66	Metric	gmailforwards	Gmail forwards	0
67	Metric	gmailsaves	Gmail saves	0
68	Metric	gmailsecondaryclicks	Gmail clicks to website	0
69	Attribute	hasqualityscore	Has Quality Score	FALSE
70	Attribute	id	Keyword ID	3000000
71	Metric	impressionassistedconversions	Impr. Assisted Conv.	0
72	Metric	impressionassisted conversionsoverlast clickconversions	Impr. Assisted Conv. / Last Click Conv.	null
73	Metric	impressionassisted onversionvalue	Impr. Assisted Conv. Value	null
74	Metric	impressions	Impressions	1
75	Metric	interactionrate	Interaction Rate	0
76	Metric	interactions	Interactions	0
77	Metric	interactiontypes	Interaction Types	null
78	Attribute	isnegative	Is negative	FALSE
79	Attribute	keywordmatchtype	Match type	Broad
80	Attribute	labelids	Label IDs	null
81	Attribute	labels	Labels	null
82	Metric	percentnewvisitors	% new sessions	0
83	Attribute	postclick qualityscore	Landing page experience	null
84	Attribute	qualityscore	Quality score	null
85	Metric	searchabsolute topimpressionshare	Search abs. top IS	null
86	Metric	searchbudget lostabsolutet opimpressionshare	Search lost abs. top IS (budget)	0
87	Metric	searchbudget losttopimpression share	Search lost top IS (budget)	0
88	Metric	searchexact matchimpression share	Search Exact match IS	null
89	Metric	searchimpression share	Search Impr. share	null
90	Attribute	search predictedctr	Expected clickthrough rate	null
91	Metric	searchranklost absolutetop impressionshare	Search lost abs. top IS (rank)	0
92	Metric	searchrank lostimpression share	Search Lost IS (rank)	null
93	Metric	searchrank losttopimpression share	Search lost top IS (rank)	0
94	Metric	searchtop impressionshare	Search top IS	0
95	Attribute	status	Keyword state	enabled
96	Attribute	systemservingstatus	Criterion serving status	eligible
97	Metric	topimpression percentage	Impr. (Top) %	0
98	Attribute	topofpagecpc	Top of page CPC	0
99	Attribute	trackingurltemplate	Tracking template	null
100	Attribute	urlcustomparameters	Custom parameter	null
101	Metric	valueperallconversion	Value / all conv.	0
102	Metric	valueperconversion	Value / conv.	0
103	Metric	valuepercurrent modelattributed conversion	Value / conv. (current model)	0
104	Attribute	verticalid	Vertical ID	0
105	Metric	videoquartile100rate	Video played to 100%	0
106	Metric	videoquartile25rate	Video played to 25%	100
107	Metric	videoquartile50rate	Video played to 50%	0
108	Metric	videoquartile75rate	Video played to 75%	0
109	Metric	videoviewrate	View rate	0
110	Metric	videoviews	Views	0
111	Metric	viewthrough conversions	View-through conv.	0
112	Electrik.AI	etl_org	Organization Id	ORG000850
113	Electrik.AI	etl_project	Project Id	PR000218
114	Electrik.AI	etl_create_utc_dttm	Row Create Timestamp in UTC	2020-04-14 08:54:15.172854 UTC
115	Electrik.AI	etl_update_utc_dttm	Row Update Timestamp in UTC	2020-04-14 08:54:15.172854 UTC
116	Electrik.AI	etl_start_utc_dttm	EAI Flow Start Timestamp in UTC	2020-04-14 08:45:47.109 UTC
117	Electrik.AI	etl_flow_nm	EAI Flow Code	FL001168
118	Electrik.AI	etl_flow_instance_id	EAI Flow Execution Instance Id	FL001168-20200414141525381807
119	Electrik.AI	eai_aw_account_id	Adword Account Id	9227698748

Click Performance

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	Behavior	Electrik AI DB Column	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

Marketplace Performance

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

{ Data Schema Table remains }

Search Query Performance

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

Shopping Performance

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

URL Performance

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

Video Performance

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

Google Search Console Data Export

PostgreSQL

What is Google Ads?
How to add a Google Ads Source in Electrik.AI?
What are the supported Data Destinations?
How to export Google Ads Data?
Google Ads Table Schemas
Ad Performance Report
Ad Group Performance
Campaign Performance
Keyword Performance
Click Performance
Marketplace Performance
Search Query Performance
Shopping Performance
URL Performance
Video Performance

Docs

APPLICATION

SOURCES

DESTINATIONS