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.
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.
Step 8: Allow Electrik.AI to access your Google Ads account.
Step 9: Choose Google Ads Account for which you have to extract data.
Step 10: Click on Save button on the top.
Step 11: Congratulations, you have successfully created a Google Ads Connection in Electrik.AI.
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
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.
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
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.
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.
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.
Your Google Ads data will start loading after 24 hours in your Database.
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 |
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 | 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 |
The Marketplace Performance report includes all statistics of ads displayed on the Marketplace, aggregated by default at the account 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.
| 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 |
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