Google Ads V2
Guide to integrate your Google Ads data to Sprinkle
Last updated
Guide to integrate your Google Ads data to Sprinkle
Last updated
Before setting up the data import, learn about data import concepts
To learn about Connection, refer
Log into the Sprinkle application
Navigate to Ingest-> Connections Tab -> Setup Connection
Select Google Ads V2
Provide all the mandatory details
Name: Name to identify this connection
Developer Token: Sign in to the MANAGER ACCOUNT, then navigate to TOOLS & SETTINGS > SETUP > API Center. for more details ->
Client Id: This is at the top right corner near the account id.
Connect to Google
Advance Settings: Refer
Test Connection
Create
Navigate to Ingest -> Data Imports -> Setup sources
Select Google Ads V2
Provide the name -> Create
Connection Tab:
Select Choose from saved connections. From the drop-down, select the name of the connection created in STEP-2.
Click on the Next: Select datasets button.
Customer Clients (Optional)
Table Type (Required):
Reports
Report Type
Metrics Fields
Segments Fields
Ingestion Mode
Complete
Incremental
Start Date: Pull the data from this date: Format is YYYY-MM-DD
Window for Backfill: Mention window for backfill, for backfilling metrics in every run to include updates from attribution window. Can take values 1, 7 and 28.
Where Clause
Query
Flatten Level(Required): Select One Level or Multi Level. In one level, flattening will not be applied on complex type. They will be stored as string. In multi level, flattening will be applied in complex level till they become simple type.
Destination Schema (Required): Data warehouse schema where the table will be ingested into
Destination Table name (Required): It is the table name to be created on the warehouse. If not given, sprinkle will create like ds_<datasourcename>_<tablename>
Create
In the Ingestion Jobs tab:
Trigger the Job, using Run button
To schedule, enable Auto-Run. Change the frequency if needed
API Read Timeout (In seconds): Maximum time of inactivity between two data packets when waiting for the server's response. The default value is 30 seconds.
API Connection Timeout (In seconds): Time period within which a connection between a client and a server must be established.
Retry Limit: Number of retries allowed when an API call fails. For example if an API call fails and retry limit is 5 then it will check 5 times for that API call and if it succeeded then it will stop checking.
Retry Sleep Time (In milliseconds): Given time, after which retry should happen in case an API call fails.
Incremental Batch Size (In days): No of days in one batch for which data is being downloaded during incremental ingestion.
Version: It gives information about the version of Google Ads API being used.
customer_resourcename
metrics_activeviewcpm
metrics_activeviewctr
metrics_activeviewimpressions
metrics_activeviewmeasureability
metrics_activeviewmeasurablecostmicros
metrics_activeviewmeasurableimpressions
metrics_activeviewviewability
metrics_allconversions
metrics_allconversionsbyconversiondate
metrics_allconversionsfrominteractionsrate
metrics_allconversionsvalue
metrics_allconversionsvaluebyconversiondate
metrics_averagecost
metrics_averagecpc
metrics_averagecpe
metrics_averagecpm
metrics_averagecpv
metrics_clicks
metrics_contentbudgetlostimpressionshare
metrics_contentimpressionshare
metrics_contentranklostimpressionshare
metrics_conversions
metrics_conversionsbyconversiondate
metrics_conversionsfrominteractionsrate
metrics_conversionsvalue
metrics_conversionsvaluebyconversiondate
metrics_costmicros
metrics_costperallconversions
metrics_costperconversion
metrics_crossdeviceconversions
metrics_ctr
metrics_engagementrate
metrics_engagments
metrics_impressions
metrics_interactioneventtypes
metrics_interactionrate
metrics_interactions
metrics_invalidclickrate
metrics_invalidclicks
metrics_optimizationscoreuplift
metrics_optimizationscoreurl
metrics_searchbudgetlostimpressionshare
metrics_searchexactmatchimpressionshare
metrics_searchimpressionshare
metrics_searchranklostimpressionshare
metrics_skadnetworkconversions
metrics_valueperallconversions
metrics_valueperallconversionsbyconversiondate
metrics_valueperconversion
metrics_valueperconversionsbyconversiondate
metrics_videoviewrate
metrics_videoviews
metrics_viewthroughconversions
adgroupad_resourcename
adgroupad_ad_resourcename
metrics_absolutetopimpressionpercentage
metrics_activeviewcpm
metrics_activeviewctr
metrics_activeviewimpressions
metrics_activeviewmeasurability
metrics_activeviewmeasurablecostmicros
metrics_activeviewmeasurableimpressions
metrics_activeviewviewability
metrics_allconversions
metrics_allconversionsbyconversiondate
metrics_allconversionsfrominteractionsrate
metrics_allconversionsvalue
metrics_allconversionsvaluebyconversiondate
metrics_averagecost
metrics_averagecpc
metrics_averagecpe
metrics_averagecpm
metrics_averagecpv
metrics_averagepageviews
metrics_averagetimeonsite
metrics_bouncerate
metrics_clicks
metrics_conversions
metrics_conversionsbyconversiondate
metrics_conversionsfrominteractionsrate
metrics_conversionsvalue
metrics_conversionsvaluebyconversiondate
metrics_costmicros
metrics_costperallconversions
metrics_costperconversion
metrics_costpercurrentmodelattributedconversion
metrics_crossdeviceconversions
metrics_ctr
metrics_currentmodelattributedconversions
metrics_currentmodelattributedconversionsvalue
metrics_engagementrate
metrics_engagements
metrics_gmailforwards
metrics_gmailsaves
metrics_gmailsecondaryclicks
metrics_impressions
metrics_interactioneventtypes
metrics_interactionrate
metrics_interactions
metrics_percentnewvisitors
metrics_topimpressionpercentage
metrics_valueperallconversions
metrics_valueperallconversionsbyconversiondate
metrics_valueperconversion
metrics_valueperconversionsbyconversiondate
metrics_valuepercurrentmodelattributedconversion
metrics_videoquartilep100rate
metrics_videoquartilep25rate
metrics_videoquartilep50rate
metrics_videoquartilep75rate
metrics_videoviewrate
metrics_videoviews
metrics_viewthroughconversions
adgroup_resourcename
metrics_absolutetopimpressionpercentage
metrics_activeviewcpm
metrics_activeviewctr
metrics_activeviewimpressions
metrics_activeviewmeasurability
metrics_activeviewmeasurablecostmicros
metrics_activeviewmeasurableimpressions
metrics_activeviewviewability
metrics_allconversions
metrics_allconversionsbyconversiondate
metrics_allconversionsfrominteractionsrate
metrics_allconversionsvalue
metrics_allconversionsvaluebyconversiondate
metrics_averagecost
metrics_averagecpc
metrics_averagecpe
metrics_averagecpm
metrics_averagecpv
metrics_averagepageviews
metrics_averagetimeonsite
metrics_bouncerate
metrics_clicks
metrics_contentimpressionshare
metrics_contentranklostimpressionshare
metrics_conversions
metrics_conversionsbyconversiondate
metrics_conversionsfrominteractionsrate
metrics_conversionsvalue
metrics_conversionsvaluebyconversiondate
metrics_costmicros
metrics_costperallconversions
metrics_costperconversion
metrics_costpercurrentmodelattributedconversion
metrics_crossdeviceconversions
metrics_ctr
metrics_currentmodelattributedconversions
metrics_currentmodelattributedconversionsvalue
metrics_engagementrate
metrics_engagements
metrics_gmailforwards
metrics_gmailsaves
metrics_gmailsecondaryclicks
metrics_impressions
metrics_interactioneventtypes
metrics_interactionrate
metrics_interactions
metrics_percentnewvisitors
metrics_phonecalls
metrics_phoneimpressions
metrics_phonethroughrate
metrics_searchranklostabsolutetopimpressionshare
metrics_searchranklostimpressionshare
metrics_searchranklosttopimpressionshare
metrics_searchtopimpressionshare
metrics_topimpressionpercentage
metrics_valueperallconversions
metrics_valueperallconversionsbyconversiondate
metrics_valueperconversion
metrics_valueperconversionsbyconversiondate
metrics_valuepercurrentmodelattributedconversion
metrics_videoquartilep100rate
metrics_videoquartilep25rate
metrics_videoquartilep50rate
metrics_videoquartilep75rate
metrics_videoviewrate
metrics_videoviews
metrics_viewthroughconversions
agerangeview_resourcename
metrics_activeviewcpm
metrics_activeviewctr
metrics_activeviewimpressions
metrics_activeviewmeasurability
metrics_activeviewmeasurablecostmicros
metrics_activeviewmeasurableimpressions
metrics_activeviewviewability
metrics_allconversions
metrics_allconversionsfrominteractionsrate
metrics_allconversionsfrominteractionsvalueperinteraction
metrics_allconversionsvalue
metrics_allconversionsvaluepercost
metrics_averagecost
metrics_averagecpc
metrics_averagecpe
metrics_averagecpm
metrics_averagecpv
metrics_clicks
metrics_conversions
metrics_conversionsfrominteractionsrate
metrics_conversionsvalue
metrics_costmicros
metrics_costperallconversions
metrics_costperconversion
metrics_crossdeviceconversions
metrics_ctr
metrics_engagementrate
metrics_engagements
metrics_gmailforwards
metrics_gmailsaves
metrics_gmailsecondaryclicks
metrics_impressions
metrics_interactioneventtypes
metrics_interactionrate
metrics_interactions
metrics_valueperallconversions
metrics_valueperconversion
metrics_videoquartilep100rate
metrics_videoquartilep25rate
metrics_videoquartilep50rate
metrics_videoquartilep75rate
metrics_videoviewrate
metrics_videoviews
metrics_viewthroughconversions
campaignbudget_resourcename
metrics_allconversions
metrics_allconversionsfrominteractionsrate
metrics_allconversionsvalue
metrics_averagecost
metrics_averagecpc
metrics_averagecpe
metrics_averagecpm
metrics_averagecpv
metrics_clicks
metrics_conversions
metrics_conversionsfrominteractionsrate
metrics_conversionsvalue
metrics_costmicros
metrics_costperallconversions
metrics_costperconversion
metrics_crossdeviceconversions
metrics_ctr
metrics_engagementrate
metrics_engagements
metrics_impressions
metrics_interactioneventtypes
metrics_interactionrate
metrics_interactions
metrics_valueperallconversions
metrics_valueperconversion
metrics_videoviewrate
metrics_videoviews
metrics_viewthroughconversions
campaignaudienceview_resourcename
metrics_activeviewcpm
metrics_activeviewctr
metrics_activeviewimpressions
metrics_activeviewmeasurability
metrics_activeviewmeasurablecostmicros
metrics_activeviewmeasurableimpressions
metrics_activeviewviewability
metrics_allconversions
metrics_allconversionsbyconversiondate
metrics_allconversionsfrominteractionsrate
metrics_allconversionsfrominteractionsvalueperinteraction
metrics_allconversionsvalue
metrics_allconversionsvaluebyconversiondate
metrics_averagecost
metrics_averagecpc
metrics_averagecpe
metrics_averagecpm
metrics_averagecpv
metrics_clicks
metrics_conversions
metrics_conversionsbyconversiondate
metrics_conversionsfrominteractionsrate
metrics_conversionsvalue
metrics_conversionsvaluebyconversiondate
metrics_costmicros
metrics_costperallconversions
metrics_costperconversion
metrics_crossdeviceconversions
metrics_ctr
metrics_engagementrate
metrics_engagements
metrics_gmailforwards
metrics_gmailsaves
metrics_gmailsecondaryclicks
metrics_impressions
metrics_interactioneventtypes
metrics_interactionrate
metrics_interactions
metrics_valueperallconversions
metrics_valueperallconversionsbyconversiondate
metrics_valueperconversion
metrics_valueperconversionsbyconversiondate
metrics_videoquartilep100rate
metrics_videoquartilep25rate
metrics_videoquartilep50rate
metrics_videoquartilep75rate
metrics_videoviewrate
metrics_videoviews
metrics_viewthroughconversions
groupplacementview_resourcename
metrics_activeviewcpm
metrics_activeviewctr
metrics_activeviewimpressions
metrics_activeviewmeasurability
metrics_activeviewmeasurablecostmicros
metrics_activeviewmeasurableimpressions
metrics_activeviewviewability
metrics_allconversions
metrics_allconversionsfrominteractionsrate
metrics_allconversionsvalue
metrics_allconversionsvaluepercost
metrics_averagecost
metrics_averagecpc
metrics_averagecpe
metrics_averagecpm
metrics_averagecpv
metrics_clicks
metrics_conversions
metrics_conversionsfrominteractionsrate
metrics_conversionsvalue
metrics_costmicros
metrics_costperallconversions
metrics_costperconversion
metrics_crossdeviceconversions
metrics_ctr
metrics_engagementrate
metrics_engagements
metrics_impressions
metrics_interactioneventtypes
metrics_interactionrate
metrics_interactions
metrics_valueperallconversions
metrics_valueperconversion
metrics_videoviewrate
metrics_videoviews
metrics_viewthroughconversions
biddingstrategy_resourcename
metrics_allconversions
metrics_allconversionsfrominteractionsrate
metrics_allconversionsvalue
metrics_averagecpc
metrics_averagecpm
metrics_clicks
metrics_conversions
metrics_conversionsfrominteractionsrate
metrics_conversionsvalue
metrics_costmicros
metrics_costperallconversions
metrics_costperconversion
metrics_crossdeviceconversions
metrics_ctr
metrics_impressions
metrics_valueperallconversions
metrics_valueperconversion
metrics_viewthroughconversions
adscheduleview_resourcename
metrics_allconversions
metrics_allconversionsfrominteractionsrate
metrics_allconversionsvalue
metrics_averagecost
metrics_averagecpc
metrics_averagecpe
metrics_averagecpm
metrics_averagecpv
metrics_clicks
metrics_conversions
metrics_conversionsfrominteractionsrate
metrics_conversionsvalue
metrics_costmicros
metrics_costperallconversions
metrics_costperconversion
metrics_crossdeviceconversions
metrics_ctr
metrics_engagementrate
metrics_engagements
metrics_impressions
metrics_interactioneventtypes
metrics_interactionrate
metrics_interactions
metrics_valueperallconversions
metrics_valueperconversion
metrics_videoquartilep100rate
metrics_videoquartilep25rate
metrics_videoquartilep50rate
metrics_videoquartilep75rate
metrics_videoviewrate
metrics_videoviews
metrics_viewthroughconversions
campaign_resourcename
metrics_activeviewcpm
metrics_activeviewctr
metrics_activeviewimpressions
metrics_activeviewmeasurability
metrics_activeviewmeasurablecostmicros
metrics_activeviewmeasurableimpressions
metrics_activeviewviewability
metrics_allconversions
metrics_allconversionsbyconversiondate
metrics_conversionsfrominteractionsrate
metrics_conversionsvalue
metrics_conversionsvaluebyconversiondate
metrics_averagecost
metrics_averagecpc
metrics_averagecpe
metrics_averagecpm
metrics_averagecpv
metrics_averagepageviews
metrics_averagetimeonsite
metrics_bouncerate
metrics_clicks
metrics_contentbudgetlostimpressionshare
metrics_contentimpressionshare
metrics-contentranklostimpressionshare
metrics_conversions
metrics_conversionsbyconversiondate
metrics_conversionsfrominteractionsrate
metrics_conversionsvalue
metrics_conversionsvaluebyconversiondate
metrics_costmicros
metrics_costperallconversions
metrics_costperconversion
metrics_costpercurrentmodelattributedconversion
metrics_crossdeviceconversions
metrics_ctr
metrics_currentmodelattributedconversions
metrics_currentmodelattributedconversionsfrominteractionsrate
metrics_currentmodelattributedconversionsfromiteractionsvalueperinteraction
metrics_currentmodelattributedconversionsvalue
metrics_currentmodelattributedconversionsvaluepercost
metrics_engagementrate
metrics_engagements
metrics_gmailforwards
metrics_gmailsaves
metrics_gmailsecondaryclicks
metrics_impressions
metrics_interactioneventtypes
metrics_interactionrate
metrics_interactions
metrics_invalidclickrate
metrics_invalidclicks
metrics_optimizationscoreuplift
metrics_optimizationscoreurl
metrics_percentnewvisitors
metrics_phonecalls
metrics_phoneimpressions
metrics_phonethroughrate
metrics_relativectr
metrics_searchabsolutetopimpressionshare
metrics_searchbudgetlostabsolutetopimpressionshare
metrics_searchbudgetlostimpressionshare
metrics_searchbudgetlosttopimpressionshare
metrics_searchclickshare
metrics_searchexactmatchimpressionshare
metrics_searchimpressionshare
metrics_searchranklostabsolutetopimpressionshare
metrics_searchranklostimpressionshare
metrics_searchranklosttopimpressionshare
metrics_searchtopimpressionshare
metrics_skadnetworkconversions
metrics_topimpressionpercentage
metrics_valueperallconversions
metrics_valueperallconversionsbyconversiondate
metrics_valueperconversion
metrics_valueperconversionbyconversiondate
metrics_valuepercurrentmodelattributedconversions
metrics_videoquartilep100rate
metrics_videoquartilep25rate
metrics_videoquartilep50rate
metrics_videoquartilep75rate
metrics_videoviewrate
metrics_videoviews
metrics_viewthroughconversions
locationview_resourcename
metrics_allconversions
metrics_allconversionsfrominteractionsrate
metrics_allconversionsvalue
metrics_averagecost
metrics_averagecpc
metrics_averagecpe
metrics_averagecpm
metrics_averagecpv
metrics_clicks
metrics_conversions
metrics_conversionsfrominteractionsrate
metrics_conversionsvalue
metrics_costmicros
metrics_costperallconversions
metrics_costperconversion
metrics_crossdeviceconversions
metrics_ctr
metrics_engagementrate
metrics_engagements
metrics_impressions
metrics_interactioneventtypes
metrics_interactionrate
metrics_interactions
metrics_valueperallconversions
metrics_valueperconversion
metrics_videoviewrate
metrics_videoviews
metrics_viewthroughconversions
displaykeywordview_resourcename
metrics_activeviewcpm
metrics_activeviewctr
metrics_activeviewimpressions
metrics_activeviewmeasurability
metrics_activeviewmeasurablecostmicros
metrics_activeviewmeasurableimpressions
metrics_activeviewviewability
metrics_allconversions
metrics_allconversionsfrominteractionsrate
metrics_allconversionsfrominteractionsvalueperinteraction
metrics_allconversionsvalue
metrics_allconversionsvaluepercost
metrics_averagecost
metrics_averagecpc
metrics_averagecpe
metrics_averagecpm
metrics_averagecpv
metrics_clicks
metrics_conversions
metrics_conversionsfrominteractionsrate
metrics_conversionsvalue
metrics_costmicros
metrics_costperallconversions
metrics_costperconversion
metrics_crossdeviceconversions
metrics_ctr
metrics_engagementrate
metrics_engagements
metrics_gmailforwards
metrics_gmailsaves
metrics_gmailsecondaryclicks
metrics_impressions
metrics_interactioneventtypes
metrics_interactionrate
metrics_interactions
metrics_valueperallconversions
metrics_valueperconversion
metrics_videoquartilep100rate
metrics_videoquartilep25rate
metrics_videoquartilep50rate
metrics_videoquartilep75rate
metrics_videoviewrate
metrics_videoviews
metrics_viewthroughconversions
topicview_resourcename
metrics_activeviewcpm
metrics_activeviewctr
metrics_activeviewimpressions
metrics_activeviewmeasurability
metrics_activeviewmeasurablecostmicros
metrics_activeviewmeasurableimpressions
metrics_activeviewviewability
metrics_allconversions
metrics_allconversionsfrominteractionsrate
metrics_allconversionsfrominteractionsvalueperinteraction
metrics_allconversionsvalue
metrics_allconversionsvaluepercost
metrics_averagecost
metrics_averagecpc
metrics_averagecpe
metrics_averagecpm
metrics_averagecpv
metrics_clicks
metrics_conversions
metrics_conversionsfrominteractionsrate
metrics_conversionsvalue
metrics_costmicros
metrics_costperallconversions
metrics_costperconversion
metrics_crossdeviceconversions
metrics_ctr
metrics_engagementrate
metrics_engagements
metrics_gmailforwards
metrics_gmailsaves
metrics_gmailsecondaryclicks
metrics_impressions
metrics_interactioneventtypes
metrics_interactionrate
metrics_interactions
metrics_valueperallconversions
metrics_valueperconversion
metrics_videoquartilep100rate
metrics_videoquartilep25rate
metrics_videoquartilep50rate
metrics_videoquartilep75rate
metrics_videoviewrate
metrics_videoviews
metrics_viewthroughconversions
genderview_resourcename
metrics_activeviewcpm
metrics_activeviewctr
metrics_activeviewimpressions
metrics_activeviewmeasurability
metrics_activeviewmeasurablecostmicros
metrics_activeviewmeasurableimpressions
metrics_activeviewviewability
metrics_allconversions
metrics_allconversionsfrominteractionsrate
metrics_allconversionsfrominteractionsvalueperinteraction
metrics_allconversionsvalue
metrics_allconversionsvaluepercost
metrics_averagecost
metrics_averagecpc
metrics_averagecpe
metrics_averagecpm
metrics_averagecpv
metrics_clicks
metrics_conversions
metrics_conversionsfrominteractionsrate
metrics_conversionsvalue
metrics_costmicros
metrics_costperallconversions
metrics_costperconversion
metrics_crossdeviceconversions
metrics_ctr
metrics_engagementrate
metrics_engagements
metrics_gmailforwards
metrics_gmailsaves
metrics_gmailsecondaryclicks
metrics_impressions
metrics_interactioneventtypes
metrics_interactionrate
metrics_interactions
metrics_valueperallconversions
metrics_valueperconversion
metrics_videoquartilep100rate
metrics_videoquartilep25rate
metrics_videoquartilep50rate
metrics_videoquartilep75rate
metrics_videoviewrate
metrics_videoviews
metrics_viewthroughconversions
geographicview_resourcename
metrics_allconversions
metrics_allconversionsfrominteractionsrate
metrics_allconversionsvalue
metrics_averagecost
metrics_averagecpc
metrics_averagecpe
metrics_averagecpm
metrics_averagecpv
metrics_clicks
metrics_conversions
metrics_conversionsfrominteractionsrate
metrics_conversionsvalue
metrics_costmicros
metrics_costperallconversions
metrics_costperconversion
metrics_crossdeviceconversions
metrics_ctr
metrics_impressions
metrics_interactioneventtypes
metrics_interactionrate
metrics_interactions
metrics_valueperallconversions
metrics_valueperconversion
metrics_videoviewrate
metrics_videoviews
metrics_viewthroughconversions
dynamicsearchadssearchtermview_resourcename
metrics_allconversions
metrics_allconversionsfrominteractionsrate
metrics_allconversionsvalue
metrics_averagecpc
metrics_averagecpm
metrics_clicks
metrics_conversions
metrics_conversionsfrominteractionsrate
metrics_conversionsvalue
metrics_costmicros
metrics_costperallconversions
metrics_costperconversion
metrics_crossdeviceconversions
metrics_ctr
metrics_impressions
metrics_valueperallconversions
metrics_valueperconversion
keywordview_resourcename
metrics_absolutetopimpressionpercentage
metrics_activeviewcpm
metrics_activeviewctr
metrics_activeviewimpressions
metrics_activeviewmeasurability
metrics_activeviewmeasurablecostmicros
metrics_activeviewmeasurableimpressions
metrics_activeviewviewability
metrics_allconversions
metrics_allconversionsbyconversiondate
metrics_allconversionsfrominteractionsrate
metrics_allconversionsfrominteractionsvalueperinteraction
metrics_allconversionsvalue
metrics_allconversionsvaluebyconversiondate
metrics_allconversionsvaluepercost
metrics_averagepageviews
metrics_averagecost
metrics_averagecpc
metrics_averagecpe
metrics_averagecpm
metrics_averagecpv
metrics_averagetimeonsite
metrics_bouncerate
metrics_clicks
metrics_conversions
metrics_conversionsbyconversiondate
metrics_conversionsfrominteractionsrate
metrics_conversionsvalue
metrics_conversionsvaluebyconversiondate
metrics_conversionsvaluepercost
metrics_costmicros
metrics_costperallconversions
metrics_costperconversion
metrics_costpercurrentmodelattributedconversion
metrics_crossdeviceconversions
metrics_ctr
metrics_currentmodelattributedconversions
metrics_currentmodelattributedconversionsvalue
metrics_engagementrate
metrics_engagements
metrics_gmailforwards
metrics_gmailsaves
metrics_gmailsecondaryclicks
metrics_historicalcreativequalityscore
metrics_historicallandingpagequalityscore
metrics_historicalqualityscore
metrics_historicalsearchpredictedctr
metrics_impressions
metrics_interactioneventtypes
metrics_interactionrate
metrics_interactions
metrics_percentnewvisitors
metrics_searchabsolutetopimpressionshare
metrics_searchbudgetlostabsolutetopimpressionshare
metrics_searchbudgetlosttopimpressionshare
metrics_searchclickshare
metrics_searchexactmatchimpressionshare
metrics_searchimpressionshare
metrics_searchranklostabsolutetopimpressionshare
metrics_searchranklostpimpressionshare
metrics_searchranklosttopimpressionshare
metrics_searchtopimpressionshare
metrics_topimpressionpercentage
metrics_valueperallconversions
metrics_valueperallconversionsbyconversiondate
metrics_valueperconversion
metrics_valueperconversionsbyconversiondate
metrics_valuepercurrentmodelattributedcovnersions
metrics_videoquartilep100rate
metrics_videoquartilep25rate
metrics_videoquartilep50rate
metrics_videoquartilep75rate
metrics_videoviewrate
metrics_videoviews
metrics_viewthroughconversions
landingpageview_resourcename
metrics_activeviewcpm
metrics_activeviewctr
metrics_activeviewimpressions
metrics_activeviewmeasurability
metrics_activeviewmeasurablecostmicros
metrics_activeviewmeasurableimpressions
metrics_activeviewviewability
metrics_allconversions
metrics_allconversionsfrominteractionsrate
metrics_allconversionsfrominteractionsvalueperinteraction
metrics_allconversionsvalue
metrics_allconversionsvaluepercost
metrics_averagecost
metrics_averagecpc
metrics_averagecpe
metrics_averagecpm
metrics_averagecpv
metrics_clicks
metrics_conversions
metrics_conversionsfrominteractionsrate
metrics_conversionsfrominteractionsvalueperinteraction
metrics_conversionsvalue
metrics_conversionsvaluepercost
metrics_costmicros
metrics_costperallconversions
metrics_costperconversion
metrics_crossdeviceconversions
metrics_ctr
metrics_engagementrate
metrics_engagements
metrics_impressions
metrics_interactioneventtypes
metrics_interactionrate
metrics_interactions
metrics_mobilefriendlyclickspercentage
metrics_speedscore
metrics_validacceleratedmobilepagesclickspercentage
metrics_valueperallconversions
metrics_valueperconversion
metrics_videoviewrate
metrics_videoviews
paidorganicsearchtermview_resourcename
metrics_averagecpc
metrics_clicks
metrics_combinedclicks
metrics_combinedclicksperquery
metrics_combinedqueries
metrics_ctr
metrics_impressions
metrics_organicclicks
metrics_organicclicksperquery
metrics_organicimpressions
metrics_organicimpressionsperquery
metrics_organicqueries
parentalstatusview_resourcename
metrics_activeviewcpm
metrics_activeviewctr
metrics_activeviewimpressions
metrics_activeviewmeasurability
metrics_activeviewmeasurablecostmicros
metrics_activeviewmeasurableimpressions
metrics_activeviewviewability
metrics_allconversions
metrics_allconversionsfrominteractionsrate
metrics_allconversionsfrominteractionsvalueperinteraction
metrics_allconversionsvalue
metrics_allconversionsvaluepercost
metrics_averagecost
metrics_averagecpc
metrics_averagecpe
metrics_averagecpm
metrics_averagecpv
metrics_clicks
metrics_conversions
metrics_conversionsfrominteractionsrate
metrics_conversionsvalue
metrics_costmicros
metrics_costperallconversions
metrics_costperconversion
metrics_crossdeviceconversions
metrics_ctr
metrics_engagementrate
metrics_engagements
metrics_gmailforwards
metrics_gmailsaves
metrics_gmailsecondaryclicks
metrics_impressions
metrics_interactioneventtypes
metrics_interactionrate
metrics_interactions
metrics_valueperallconversions
metrics_valueperconversions
metrics_videoquartilep100rate
metrics_videoquartilep25rate
metrics_videoquartilep50rate
metrics_videoquartilep75rate
metrics_videoviewrate
metrics_videoviews
metrics_viewthroughconversions
feeditem_resourcename
metrics_absolutetopimpressionpercentage
metrics_allconversions
metrics_allconversionsfrominteractionrate
metrics_allconversionsvalue
metrics_averagecost
metrics_averagecpc
metrics_averagecpe
metrics_averagecpm
metrics_averagecpv
metrics_clicks
metrics_conversions
metrics_conversionsfrominteractionsrate
metrics_conversionsvalue
metrics_costmicros
metrics_costperallconversions
metrics_costperconversion
metrics_crossdeviceconversions
metrics_ctr
metrics_engagementrate
metrics_engagements
metrics_impressions
metrics_interactioneventtypes
metrics_interactionrate
metrics_interactions
metrics_topimpessionpercentage
metrics_valueperallconversions
metrics_valueperconversions
metrics_videoviewrate
metrics_videoviews
feedplaceholderview_resourcename
metrics_allconversions
metrics_allconversionsfrominteractionrate
metrics_allconversionsvalue
metrics_averagecost
metrics_averagecpc
metrics_averagecpe
metrics_averagecpm
metrics_averagecpv
metrics_clicks
metrics_conversions
metrics_conversionsfrominteractionsrate
metrics_conversionsvalue
metrics_costmicros
metrics_costperallconversions
metrics_costperconversion
metrics_crossdeviceconversions
metrics_ctr
metrics_engagementrate
metrics_engagements
metrics_impressions
metrics_interactioneventtypes
metrics_interactionrate
metrics_interactions
metrics_valueperallconversions
metrics_valueperconversions
metrics_videoviewrate
metrics_videoviews
metrics_viewthroughconversions
managedplacementview_resourcename
metrics_activeviewcpm
metrics_activeviewctr
metrics_activeviewimpressions
metrics_activeviewmeasurability
metrics_activeviewmeasurablecostmicros
metrics_activeviewmeasurableimpressions
metrics_activeviewviewability
metrics_allconversions
metrics_allconversionsfrominteractionsrate
metrics_allconversionsfrominteractionsvalueperinteraction
metrics_allconversionsvalue
metrics_allconversionsvaluepercost
metrics_averagecost
metrics_averagecpc
metrics_averagecpe
metrics_averagecpm
metrics_averagecpv
metrics_clicks
metrics_conversions
metrics_conversionsfrominteractionsrate
metrics_conversionsvalue
metrics_costmicros
metrics_costperallconversions
metrics_costperconversion
metrics_crossdeviceconversions
metrics_ctr
metrics_engagementrate
metrics_engagements
metrics_gmailforwards
metrics_gmailsaves
metrics_gmailsecondaryclicks
metrics_impressions
metrics_interactioneventtypes
metrics_interactionrate
metrics_interactions
metrics_valueperallconversions
metrics_valueperconversion
metrics_videoquartilep100rate
metrics_videoquartilep25rate
metrics_videoquartilep50rate
metrics_videoquartilep75rate
metrics_videoviewrate
metrics_videoviews
metrics_viewthroughconversions
productgroupview_resourcename
metrics_allconversions
metrics_allconversionsfrominteractionsrate
metrics_allconversionsvalue
metrics_averagecpc
metrics_averagecpm
metrics_benchmarkaveragemaxcpc
metrics_benchmarkctr
metrics_clicks
metrics_conversions
metrics_conversionsfrominteractionsrate
metrics_conversionsvalue
metrics_costmicros
metrics_costperallconversions
metrics_costperconversion
metrics_crossdeviceconversions
metrics_ctr
metrics_impressions
metrics_searchabsolutetopimpressionshare
metrics_searchclickshare
metrics_searchimpressionshare
metrics_valueperallconversions
metrics_valueperconversions
metrics_viewthroughconversions
searchtermview_resourcename
metrics_absolutetopimpressionpercentage
metrics_allconversions
metrics_allconversionsfrominteractionsrate
metrics_allconversionsfrominteractionsvalueperinteraction
metrics_allconversionsvalue
metrics_allconversionsvaluepercost
metrics_averagecost
metrics_averagecpc
metrics_averagecpe
metrics_averagecpm
metrics_averagecpv
metrics_clicks
metrics_conversions
metrics_conversionsfrominteractionsrate
metrics_conversionsfrominteractionsvalueperinteraction
metrics_conversionsvalue
metrics_conversionsvaluepercost
metrics_costmicros
metrics_costperallconversions
metrics_costperconversion
metrics_crossdeviceconversions
metrics_ctr
metrics_engagementrate
metrics_engagements
metrics_impressions
metrics_interactioneventtypes
metrics_interactionrate
metrics_interactions
metrics_topimpessionpercentage
metrics_valueperallconversions
metrics_valueperconversion
metrics_videoquartilep100rate
metrics_videoquartilep25rate
metrics_videoquartilep50rate
metrics_videoquartilep75rate
metrics_videoviewrate
metrics_videoviews
metrics_viewthroughconversions
shoppingperformanceview_resourcename
metrics_allconversions
metrics_allconversionsfrominteractionsrate
metrics_allconversionsvalue
metrics_averagecpc
metrics_clicks
metrics_conversions
metrics_conversionsfrominteractionsrate
metrics_conversionsvalue
metrics_costmicros
metrics_costperallconversions
metrics_costperconversion
metrics_crossdeviceconversions
metrics_ctr
metrics_impressions
metrics_searchabsolutetopimpressionshare
metrics_searchclickshare
metrics_searchimpressionshare
metrics_valueperallconversions
metrics_valueperconversion
detailplacementview_resourcename
metrics_activeviewcpm
metrics_activeviewctr
metrics_activeviewimpressions
metrics_activeviewmeasurability
metrics_activeviewmeasurablecostmicros
metrics_activeviewmeasurableimpressions
metrics_activeviewviewability
metrics_allconversions
metrics_allconversionsfrominteractionsrate
metrics_allconversionsvalue
metrics_averagecost
metrics_averagecpc
metrics_averagecpe
metrics_averagecpm
metrics_averagecpv
metrics_clicks
metrics_conversions
metrics_conversionsvalue
metrics_costmicros
metrics_costperallconversions
metrics_costperconversion
metrics_crossdeviceconversions
metrics_ctr
metrics_engagementrate
metrics_engagements
metrics_impressions
metrics_interactioneventtypes
metrics_interactionrate
metrics_interactions
metrics_valueperallconversions
metrics_valueperconversion
metrics_videoquartilep100rate
metrics_videoquartilep25rate
metrics_videoquartilep50rate
metrics_videoquartilep75rate
metrics_videoviewrate
metrics_videoviews
metrics_viewthroughconversions
distanceview_resourcename
metrics_allconversions
metrics_allconversionsfrominteractionsrate
metrics_allconversionsvalue
metrics_averagecpc
metrics_averagecpm
metrics_clicks
metrics_conversions
metrics_conversionsfrominteractionsrate
metrics_conversionsvalue
metrics_costmicros
metrics_costperallconversions
metrics_costperconversion
metrics_crossdeviceconversions
metrics_ctr
metrics_impressions
metrics_valueperallconversions
metrics_valueperconversion
metrics_viewthroughconversions
video_resourcename
metrics_allconversions
metrics_allconversionsfrominteractionsrate
metrics_allconversionsvalue
metrics_averagecpc
metrics_averagecpe
metrics_averagecpm
metrics_averagecpv
metrics_clicks
metrics_conversions
metrics_conversionsfrominteractionsrate
metrics_conversionsfrominteractionsvalueperinteraction
metrics_conversionsvalue
metrics_costmicros
metrics_costperallconversions
metrics_costperconversion
metrics_crossdeviceconversions
metrics_ctr
metrics_engagementrate
metrics_engagements
metrics_impressions
metrics_valueperallconversions
metrics_valueperconversion
metrics_videoquartilep100rate
metrics_videoquartilep25rate
metrics_videoquartilep50rate
metrics_videoquartilep75rate
metrics_videoviewrate
metrics_videoviews
metrics_viewthroughconversions
To learn about data import, refer
Datasets Tab: To learn about Dataset, refer . Add a Dataset for each report/dataset that you want to integrate, providing the following details:
GAQL: You can use the Google Ads Query Language. Refer for more information.
Destination Create Table Clause: Provide additional clauses to warehouse-create table queries such as clustering, partitioning, and more, useful for optimizing DML statements. on how to use this field.