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.
Here’s a list of metrics that are available in Piwik PRO when you use Google Ads integration.
| |
|---|
| 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 |
| |
|---|
| Name | Clicks (Google Ads) |
| Description | The number of times people click on your ad. |
| Scopes | Google Ads |
| Availability | Query API |
| Type | int |
| |
|---|
| Name | Cost (Google Ads) |
| Description | The amount you've paid for your ads in Google Ads. |
| Scopes | Google Ads |
| Availability | Query API |
| Type | float |
| |
|---|
| 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 |
| |
|---|
| 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 |
| |
|---|
| 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 |
| |
|---|
| 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 |
| |
|---|
| 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 |
Here’s a list of dimensions that are available in Piwik PRO when you use Google Ads integration.
| |
|---|
| 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 |
| |
|---|
| 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 |
| |
|---|
| 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 |
| |
|---|
| 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 |
| |
|---|
| 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 |
| |
|---|
| 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 |
| |
|---|
| 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 |
| |
|---|
| 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 |
| |
|---|
| 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 |
| |
|---|
| 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 |
| |
|---|
| 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 |
| |
|---|
| 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 |
| |
|---|
| 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 |
| |
|---|
| 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 |
| |
|---|
| 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 |
| |
|---|
| 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 |
| |
|---|
| 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 |
| |
|---|
| 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 |
| |
|---|
| 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 |
| |
|---|
| 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 |
| |
|---|
| 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 |
| |
|---|
| 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 |
| |
|---|
| 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.
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.
| |
|---|
| 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 |
| |
|---|
| 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 |
| |
|---|
| 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 |
| |
|---|
| 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 |
| |
|---|
| 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 |
| |
|---|
| 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 |
| |
|---|
| 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 |
| |
|---|
| 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 |
| |
|---|
| 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 |
| |
|---|
| 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 |
| |
|---|
| 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 |
| |
|---|
| 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 |
| |
|---|
| 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 |
| |
|---|
| 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 |
| |
|---|
| 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 |
| |
|---|
| 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 |
| |
|---|
| 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 |
| |
|---|
| 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 |
| |
|---|
| 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 |
| |
|---|
| 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 |
| |
|---|
| 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 |
| |
|---|
| 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.
