• 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_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
Return on ad spend (ROAS) shows if your ad spend in Google Ads has returned in revenue from conversions. (ROAS = (Goal revenue + Ecommerce revenue) / Cost (Google Ads)) * 100%).
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.
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.
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
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.
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.
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_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
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
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.
• Using dimensions not listed in the table above as query columns or filters will result in a Bad Request response.