Google Ads

Note:

• Google Ads data isn't available in the real-time API.

• For the data to be available, set up the Google Ads integration in Menu > Analytics > Settings > Integrations.

Metrics

Here’s a list of metrics that are available in Piwik PRO when you use Google Ads integration.

google_ads_average_cpc


Name	Average CPC (Google Ads)
Scopes	Google Ads
Availability	Query API
Type	float

google_ads_clicks


Name	Clicks (Google Ads)
Scopes	Google Ads
Availability	Query API
Type	int

google_ads_cost


Name	Cost (Google Ads)
Scopes	Google Ads
Availability	Query API
Type	float

google_ads_ctr


Name	CTR (Google Ads)
Scopes	Google Ads
Availability	Query API
Type	float

google_ads_impressions


Name	Impressions (Google Ads)
Scopes	Google Ads
Availability	Query API
Type	int

google_ads_roas


Name	ROAS (Google Ads)
Scopes	event, session
Availability	Query API
Type	float

Dimensions

Here’s a list of dimensions that are available in Piwik PRO when you use Google Ads integration.

device_type


Name	Device type
Scopes	event, product, session
Availability	Real-time, Query API, Raw data API
Type	[int, str]
Database type	uint8
Nullable	true
Notes	device_type.json

google_ads_ad_group_ad_id


Name	Ad group ad ID (Google Ads)
Scopes	event, product, session
Availability	Query API, Raw data API
Type	str_id
Database type	string
Nullable	true

google_ads_ad_group_id


Name	Ad group ID (Google Ads)
Scopes	event, product, session
Availability	Query API, Raw data API
Type	int_id
Database type	int64
Nullable	true

google_ads_ad_group_name


Name	Ad group name (Google Ads)
Scopes	event, product, session
Availability	Query API, Raw data API
Type	[int, str]
Database type	int64
Nullable	false

google_ads_ad_network_type


Name	Ad network type (Google Ads)
Scopes	event, product, session
Availability	Query API, Raw data API
Type	[str, str]
Database type	string
Nullable	false
Notes	google_ads_ad_network_type.json

google_ads_campaign_id


Name	Campaign ID (Google Ads)
Scopes	event, product, session
Availability	Query API, Raw data API
Type	int_id
Database type	int64
Nullable	false

google_ads_campaign_name


Name	Campaign name (Google Ads)
Scopes	event, product, session
Availability	Query API, Raw data API
Type	[int, str]
Database type	int64
Nullable	false

google_ads_customer_id


Name	Account ID (Google Ads)
Scopes	event, product, session
Availability	Query API, Raw data API
Type	str_id
Database type	string
Nullable	false

google_ads_customer_name


Name	Account (Google Ads)
Scopes	event, product, session
Availability	Query API, Raw data API
Type	[str, str]
Database type	string
Nullable	false

google_ads_keyword_match_type


Name	Keyword match type (Google Ads)
Scopes	Google Ads
Availability	Query API
Type	[str, str]
Database type	string
Nullable	false
Notes	google_ads_keyword_match_type.json

keyword


Name	Keyword
Scopes	event, product, session
Availability	Real-time, Query API, Raw data API
Type	str
Database type	string
Nullable	false

medium


Name	Medium
Scopes	event, product, session
Availability	Real-time, Query API, Raw data API
Type	str_nocase
Database type	string
Nullable	false

session_entry_url


Name	Session entry URL
Scopes	event, product, session
Availability	Query API, Raw data API
Type	str
Database type	string
Nullable	false

source


Name	Source
Scopes	event, product, session
Availability	Real-time, Query API, Raw data API
Type	str_nocase
Database type	string
Nullable	false

source_medium


Name	Source / medium
Scopes	event, product, session
Availability	Real-time, Query API, Raw data API
Type	str_nocase
Database type	string
Nullable	false

timestamp


Name	Date
Scopes	event, product, session
Availability	Real-time, Query API
Type	date
Database type	not applicable
Nullable	false
Notes	server time in the website’s time zone

website_name


Name	Site or app name
Scopes	event, product, session
Availability	Real-time, Query API, Raw data API
Type	[str, str]
Database type	not applicable
Nullable	false
Notes	website UUID

Note:

The Database type column displays the source type associated with each dimension. For the enum dimensions, it displays the ID type. For the not applicable source type, this column represents a dynamic dimension.

Mixed queries

You can request both internal analytics and Google Ads metrics in a single query, for example Sessions and Clicks (Google Ads). However, only the common dimensions listed below can be used in these queries.

Here’s a list of the dimensions that you can use.