Google AdsNot a big fan of functions?
Use the Actions Wizard to configure any action in Rows without functions.
Parameter List
Syntax
GET_CAMPAIGN_METRICS_GOOGLE_ADS(account_name,
[campaign]
, [date_range]
, [metrics]
, [dimensions]
)account_name
Name or ID of your Google Ads account. For example: "Personal Ads account".
[optional] campaign
Name or ID of your campaign. For example: "Website Campaign".
[optional] date_range
The date range for your report.: ">2019", ">2019-11-01" or "[2010-01-01;2019-01-01]".
[optional] metrics
The metrics from your Campaign. For example: metrics.CTR or metrics.average_cost. By default, it returns the most common metrics about the Campaign.
Selected options:
Absolute top impression percentage
Active view CPM
Active view CTR
Active view impressions
Active view measurability
Active view measurable cost
Active view measurable impressions
Active view viewability
All conversions
All conversions by conversion date
All conversions from click to call
All conversions from directions
All conversions from interactions rate
All conversions from menu
All conversions from order
All conversions from other engagement
All conversions from store visit
All conversions from store website
All conversions value
All conversions value by conversion date
All new customer lifetime value
Average cart size
Average cost
Average CPC
Average CPE
Average CPM
Average CPV
Average impression frequency per user
Average order value
Average page views
Average target cpa
Average target roas
Average time on site
Bounce rate
Clicks
Content budget lost impression share
Content impression share
Content rank lost impression share
Conversions
Conversions by conversion date
Conversions from interactions rate
Conversions value
Conversions value by conversion date
Cost
Cost of goods sold
Cost per all conversions
Cost per conversion
Cost per current model attributed conversion
Cross device conversions
Cross sell cost of goods sold
Cross sell gross profit
Cross sell revenue
Cross sell units sold
Ctr
Current model attributed conversions
Current model attributed conversions from interactions rate
Current model attributed conversions from interactions value per interaction
Current model attributed conversions value
Current model attributed conversions value per cost
Engagement rate
Engagements
Gmail forwards
Gmail saves
Gmail secondary clicks
Gross profit margin
Gross profit
Impressions
Interaction event types
Interaction rate
Interactions
Invalid click rate
Invalid clicks
Lead cost of goods sold
Lead gross profit
Lead revenue
Lead units sold
New customer lifetime value
Orders
Percent new visitors
Phone calls
Phone impressions
Phone through rate
Publisher organic clicks
Publisher purchased clicks
Publisher unknown clicks
Relative CTR
Revenue
Search absolute top impression share
Search budget lost absolute top impression share
Search budget lost impression share
Search budget lost top impression share
Search click share
Search exact match impression share
Search impression share
Search rank lost absolute top impression share
Search rank lost impression share
Search rank lost top impression share
Search top impression share
Sk ad network installs
Sk ad network total conversions
Top impression percentage
Unique users
Units sold
value per all conversions
value per all conversions by conversion date
value per conversion
value per conversions by conversion date
value per current model attributed conversion
Video quartile p100 rate
Video quartile p25 rate
Video quartile p50 rate
Video quartile p75 rate
Video view rate
Video views
View through conversions
[optional] dimensions
A field or segment of your report. For example, the bidding strategy.
Selected options:
Account
Ad destination type
Ad event type (Store Kit)
Ad network - attribution credit (Store Kit)
Ad network - coarse conversion value (Store Kit)
Ad network - conversion value (Store Kit)
Ad network - postback sequence index (Store Kit)
Ad network source - App ID (Store Kit)
Ad network - source domain (Store Kit)
Ad network - source type (Store Kit)
Ad network type
Ad network - user type (Store Kit)
Advertising channel sub type
Advertising channel type
Asset interaction target
Auction insight domain
Bidding strategy
Bidding strategy type
Campaign
Campaign budget
Campaign group
Campaign ID
Campaign name
Campaign optimization score
Campaign status
Click type
Conversion (Action)
Conversion (Action Category)
Conversion (Action Name)
Conversion adjustment
Conversion attribution (Event Type)
Conversion - lag bucket
Conversion or Adjustment lag bucket
Conversion value (Primary Dimension)
Date
Day of the Week
Device
End Date
External conversion (Source)
Hour
Interaction target
Labels
Location goal for target IS
Max CPC bid limit for target IS
Month
Month of Year
New vs Returning customers
Quarter
Recommendation type
Slot
Start Date
Target CPA
Target impression share
Target ROAS
Week
Year