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 avaliable in Piwik PRO when you use Google Ads integration.

google_ads_average_cpc

ScopesGoogle Ads
Typefloat

google_ads_clicks

ScopesGoogle Ads
Typeint

google_ads_cost

ScopesGoogle Ads
Typefloat

google_ads_ctr

ScopesGoogle Ads
Typefloat

google_ads_impressions

ScopesGoogle Ads
Typeint

google_ads_roas

Scopesevent, session
Typefloat

Dimensions

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

device_type

Scopesevent, product, session
Type[int, str]
Database typeuint8
NullableTrue
Notesdevice_type.json

google_ads_ad_group_ad_id

Scopesevent, product, session
Typestr_id
Database typestring
NullableTrue

google_ads_ad_group_id

Scopesevent, product, session
Typeint_id
Database typeint64
NullableTrue

google_ads_ad_group_name

Scopesevent, product, session
Type[int, str]
Database typeint64
NullableFalse

google_ads_ad_network_type

Scopesevent, product, session
Type[str, str]
Database typestring
NullableFalse
Notesgoogle_ads_ad_network_type.json

google_ads_campaign_id

Scopesevent, product, session
Typeint_id
Database typeint64
NullableFalse

google_ads_campaign_name

Scopesevent, product, session
Type[int, str]
Database typeint64
NullableFalse

google_ads_customer_id

Scopesevent, product, session
Typestr_id
Database typestring
NullableFalse

google_ads_customer_name

Scopesevent, product, session
Type[str, str]
Database typestring
NullableFalse

google_ads_keyword_match_type

ScopesGoogle Ads
Type[str, str]
Database typestring
NullableFalse
Notesgoogle_ads_keyword_match_type.json

keyword

Scopesevent, product, session
Typestr
Database typestring
NullableFalse

medium

Scopesevent, product, session
Typestr_nocase
Database typestring
NullableFalse

session_entry_url

Scopesevent, product, session
Typestr
Database typestring
NullableFalse

source

Scopesevent, product, session
Typestr_nocase
Database typestring
NullableFalse

source_medium

Scopesevent, product, session
Typestr_nocase
Database typestring
NullableFalse

timestamp

Scopesevent, product, session
Typedate
Database typenot applicable
NullableFalse
Notesby default in Raw data API (server time in the website’s timezone)

website_name

Scopesevent, product, session
Type[str, str]
Database typenot applicable
NullableFalse
Noteswebsite UUID

Note: The Database type column shows the source type for each dimension. For enum dimensions, it displays the ID type. For not applicable source type, the column indicates 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.

device_type

Scopesevent, product, session
Type[int, str]
Database typeuint8
NullableTrue
Notesdevice_type.json

google_ads_ad_group_ad_id

Scopesevent, product, session
Typestr_id
Database typestring
NullableTrue

google_ads_ad_group_id

Scopesevent, product, session
Typeint_id
Database typeint64
NullableTrue

google_ads_ad_group_name

Scopesevent, product, session
Type[int, str]
Database typeint64
NullableFalse

google_ads_ad_network_type

Scopesevent, product, session
Type[str, str]
Database typestring
NullableFalse
Notesgoogle_ads_ad_network_type.json

google_ads_campaign_id

Scopesevent, product, session
Typeint_id
Database typeint64
NullableFalse

google_ads_campaign_name

Scopesevent, product, session
Type[int, str]
Database typeint64
NullableFalse

google_ads_customer_id

Scopesevent, product, session
Typestr_id
Database typestring
NullableFalse

google_ads_customer_name

Scopesevent, product, session
Type[str, str]
Database typestring
NullableFalse

keyword

Scopesevent, product, session
Typestr
Database typestring
NullableFalse

medium

Scopesevent, product, session
Typestr_nocase
Database typestring
NullableFalse

session_entry_url

Scopesevent, product, session
Typestr
Database typestring
NullableFalse

source

Scopesevent, product, session
Typestr_nocase
Database typestring
NullableFalse

source_medium

Scopesevent, product, session
Typestr_nocase
Database typestring
NullableFalse

timestamp

Scopesevent, product, session
Typedate
Database typenot applicable
NullableFalse
Notesby default in Raw data API (server time in the website’s timezone)

website_name

Scopesevent, product, session
Type[str, str]
Database typenot applicable
NullableFalse
Noteswebsite UUID

Note:

• The Database type column shows the source type for each dimension. For enum dimensions, it displays the ID type. For not applicable source type, the column indicates a dynamic dimension.

• Using dimensions not listed in the table above as query columns or filters will result in a Bad Request response.