AD_QUERIES_ANALYTICS_GOOGLE

Get metrics such as clicks, CPM, CPC, CTR, and impressions about your Ad campaigns by date and queries.

Websites
icon of Google AnalyticsGoogle Analytics
Not a big fan of functions?
Use the Actions Wizard to configure any action in Rows without functions.

Parameter List

Syntax
AD_QUERIES_ANALYTICS_GOOGLE(iddate_range
[campaign]
[ad_group]
[query]
[metrics]
)
id

The unique view profile ID. For example: 108740273. Use LIST_ACCOUNTS_ANALYTICS_GOOGLE() to find the ID.

date_range

Date range, i.e.: ">2019", ">2019-11-01" or "[2010-01-01;2019-01-01]".

[optional] campaign

Name or ID of your compaign. For example: "Website Campaign".

[optional] ad_group

Name or ID of your ad group. For example: "Berlin group".

[optional] query

Value of the query you would like to filter the result for. For example: "crm".

[optional] metrics

Range of metrics to retrieve about the campaign. By default, it will return the most common metrics about the ad account. For example: "ga:adCost,ga:adClicks". For a complete list of possible metrics, see this Google documentation.

Selected options:
Ad clicks
Ad cost
CPM
CPC
CTR
Cost per transaction
Cost per goal conversion
Impressions
Cost per conversion
RPC
ROAS

Examples

AD_QUERIES_ANALYTICS_GOOGLE("ga:108740273", ">2020") returns default metrics about search queries linked to the `ga:108740273` account since 2020.