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)
Description	Average cost-per-click (CPC) is the amount you’ve paid for your ad divided by its total clicks. Average CPC = (Cost / Click) * 100%.
Scopes	Google Ads
Availability	Query API
Type	float

google_ads_clicks


Name	Clicks (Google Ads)
Description	The number of times people click on your ad.
Scopes	Google Ads
Availability	Query API
Type	int

google_ads_cost


Name	Cost (Google Ads)
Description	The amount you’ve paid for your ads in Google Ads.
Scopes	Google Ads
Availability	Query API
Type	float

google_ads_cost_app_currency


Name	Cost (converted) (Google Ads)
Description	The amount you've paid for your ads in Google Ads, converted to the site or app currency.
Scopes	Google Ads
Availability	Query API
Type	float

google_ads_cost_base_currency


Name	Cost (USD) (Google Ads)
Description	The amount you've paid for your ads in Google Ads, converted to the base currency (USD).
Scopes	Google Ads
Availability	Query API
Type	float

google_ads_ctr


Name	CTR (Google Ads)
Description	Click-through rate (CTR) measures how often people click your ad in Google Ads after it’s shown to them. (CTR = (Clicks / Impressions) * 100%).
Scopes	Google Ads
Availability	Query API
Type	float

google_ads_impressions


Name	Impressions (Google Ads)
Description	The number of times your ad was served on Google or Google Network.
Scopes	Google Ads
Availability	Query API
Type	int

google_ads_roas


Name	ROAS (Google Ads)
Description	ROAS (return on ad spend) is a web analytics metric that shows how much revenue is generated for every dollar spent on Google Ads. ROAS is a ratio of revenue from conversions to ad spend. A ROAS of $3.20 means that each $1 spent on ads generated $3.20 in revenue. Formula: ROAS = (Sum of revenue + Sum of goal revenue) / Cost (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.

app_currency


Name	Currency (site or app)
Description	The currency set in the site or app settings at the time the event was tracked, used during data processing.
Scopes	event, product
Availability	Real-time, Query API, Raw data API
Type	[str, str]
Database type	string(3)
Nullable	false
Notes	app_currency.json

app_currency_conversion_rate


Name	Currency conversion rate
Description	The exchange rate used for currency conversion.
Scopes	event, product
Availability	Real-time, Query API, Raw data API
Type	float
Database type	float64
Nullable	true

currency_conversion_rates_date


Name	Currency conversion date
Description	The date of the exchange rate used for currency conversion.
Scopes	event, product
Availability	Real-time, Query API, Raw data API
Type	date
Database type	date
Nullable	true

device_type


Name	Device type
Description	The type of the visitor’s device.
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)
Description	The combination of a unique number that’s assigned to each group and each ad in Google Ads. Ad group ad ID = Ad group + Ad ID.
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)
Description	The unique number that’s assigned to each ad group in 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)
Description	The name of your ad group in 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)
Description	The network where your ad was displayed. The networks are: content, mixed, search, search partners, unknown, unspecified, YouTube search, and YouTube watch.
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_app_currency


Name	Currency (site or app)
Scopes	event, product
Availability	Real-time, Query API, Raw data API
Type	[str, str]
Database type	string(3)
Nullable	false
Notes	google_ads_app_currency.json

google_ads_campaign_id


Name	Campaign ID (Google Ads)
Description	The unique number that’s assigned to each campaign in 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)
Description	The name of your campaign in Google Ads.
Scopes	event, product, session
Availability	Query API, Raw data API
Type	[int, str]
Database type	int64
Nullable	false

google_ads_currency


Name	Currency (Google Ads)
Description	The currency set in your Google Ads account settings. It's imported with other Google Ads data.
Scopes	event, product
Availability	Query API, Raw data API
Type	[str, str]
Database type	string(3)
Nullable	false
Notes	google_ads_currency.json

google_ads_customer_id


Name	Account ID (Google Ads)
Description	The unique number that’s assigned to each Google Ads account.
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)
Description	The name of your Google Ads account.
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)
Description	The keyword matching option that you’ve used for keywords in Google Ads. The match types are: broad, exact, and phrase.
Scopes	Google Ads
Availability	Query API
Type	[str, str]
Database type	string
Nullable	false
Notes	google_ads_keyword_match_type.json

keyword


Name	Keyword
Description	The keyword that a visitor used in a search engine or a keyword added as a campaign parameter.
Scopes	event, product, session
Availability	Real-time, Query API, Raw data API
Type	str
Database type	string
Nullable	false

medium


Name	Medium
Description	The category of the source such as organic (unpaid search in the search engine), cpc (paid search in the search engine), referral (web referral), email (email campaign), and the like.
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
Description	The URL of the first visited page during the session.
Scopes	event, product, session
Availability	Query API, Raw data API
Type	str
Database type	string
Nullable	false

source


Name	Source
Description	The origin of the incoming traffic such as direct, a search engine (for example, google) or a domain (example.com).
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
Description	A dimension that combines two dimensions: source and medium. Source is the origin of the incoming traffic. Medium is the category of the source.
Scopes	event, product, session
Availability	Real-time, Query API, Raw data API
Type	str_nocase
Database type	string
Nullable	false

timestamp


Name	Date
Description	Day and time of the event in the site’s time zone.
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

tracked_currency


Name	Currency (event)
Description	The local currency tracked with an event.
Scopes	event, product
Availability	Real-time, Query API, Raw data API
Type	[str, str]
Database type	string(3)
Nullable	false
Notes	tracked_currency.json

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.