---
title: "Capterra PPC data warehouse table groups"
slug: "capterra-ppc-data-warehouse-table-groups"
description: "Explore the complete Supermetrics data warehouse table groups for Capterra PPC. See all the tables and the fields included in them."
updated: 2026-04-08T07:01:15Z
published: 2026-04-08T07:01:15Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.supermetrics.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Capterra PPC data warehouse table groups

Search fields<input type="text" id="field-search" placeholder="Search by field name, label, or description…" aria-label="Search fields by name, label, or description" autocomplete="off">

### Table: CLICK_REPORT

| \| clicks__avg_position** \| \| --- \| \| \\| Display name \\| Average position \\| \\| --- \\| --- \\| \\| Description \\| Average position for the requested period. Note: the value is calculated as average of daily average values \\| \\| Field type \\| metric \\| \\| Data type \\| [float.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Average position \| \| Description \| Average position for the requested period. Note: the value is calculated as average of daily average values \| \| Field type \| metric \| \| Data type \| [float.number.value](/apidocs/field-data-types#number) \| |
| --- |
| clicks__avg_position** |
| \| Display name \| Average position \| \| --- \| --- \| \| Description \| Average position for the requested period. Note: the value is calculated as average of daily average values \| \| Field type \| metric \| \| Data type \| [float.number.value](/apidocs/field-data-types#number) \| |
| Display name | Average position |
| Description | Average position for the requested period. Note: the value is calculated as average of daily average values |
| Field type | metric |
| Data type | [float.number.value](/apidocs/field-data-types#number) |
| \| clicks__category** \| \| --- \| \| \\| Display name \\| Category \\| \\| --- \\| --- \\| \\| Description \\| The category where the click occurred \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Category \| \| Description \| The category where the click occurred \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| clicks__category** |
| \| Display name \| Category \| \| --- \| --- \| \| Description \| The category where the click occurred \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Category |
| Description | The category where the click occurred |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| clicks__channel** \| \| --- \| \| \\| Display name \\| Channel \\| \\| --- \\| --- \\| \\| Description \\| The site where the click occurred \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Channel \| \| Description \| The site where the click occurred \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| clicks__channel** |
| \| Display name \| Channel \| \| --- \| --- \| \| Description \| The site where the click occurred \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Channel |
| Description | The site where the click occurred |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| clicks__clicks** \| \| --- \| \| \\| Display name \\| Clicks \\| \\| --- \\| --- \\| \\| Description \\| Number of clicks \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Clicks \| \| Description \| Number of clicks \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| clicks__clicks** |
| \| Display name \| Clicks \| \| --- \| --- \| \| Description \| Number of clicks \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Clicks |
| Description | Number of clicks |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| clicks__conversions** \| \| --- \| \| \\| Display name \\| Conversions \\| \\| --- \\| --- \\| \\| Description \\| Number of conversions \\| \\| Field type \\| metric \\| \\| Data type \\| [int.number.value](/apidocs/field-data-types#number) \\| \| \| Display name \| Conversions \| \| Description \| Number of conversions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| clicks__conversions** |
| \| Display name \| Conversions \| \| --- \| --- \| \| Description \| Number of conversions \| \| Field type \| metric \| \| Data type \| [int.number.value](/apidocs/field-data-types#number) \| |
| Display name | Conversions |
| Description | Number of conversions |
| Field type | metric |
| Data type | [int.number.value](/apidocs/field-data-types#number) |
| \| clicks__cost** \| \| --- \| \| \\| Display name \\| Cost (USD) \\| \\| --- \\| --- \\| \\| Description \\| Advertising cost in USD \\| \\| Field type \\| metric \\| \\| Data type \\| [float.currency.value](/apidocs/field-data-types#currency) \\| \| \| Display name \| Cost (USD) \| \| Description \| Advertising cost in USD \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| clicks__cost** |
| \| Display name \| Cost (USD) \| \| --- \| --- \| \| Description \| Advertising cost in USD \| \| Field type \| metric \| \| Data type \| [float.currency.value](/apidocs/field-data-types#currency) \| |
| Display name | Cost (USD) |
| Description | Advertising cost in USD |
| Field type | metric |
| Data type | [float.currency.value](/apidocs/field-data-types#currency) |
| \| clicks__country** \| \| --- \| \| \\| Display name \\| Country \\| \\| --- \\| --- \\| \\| Description \\| The country where the click occurred \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.geo.country](/apidocs/field-data-types#geographical) \\| \| \| Display name \| Country \| \| Description \| The country where the click occurred \| \| Field type \| dimension \| \| Data type \| [string.geo.country](/apidocs/field-data-types#geographical) \| |
| clicks__country** |
| \| Display name \| Country \| \| --- \| --- \| \| Description \| The country where the click occurred \| \| Field type \| dimension \| \| Data type \| [string.geo.country](/apidocs/field-data-types#geographical) \| |
| Display name | Country |
| Description | The country where the click occurred |
| Field type | dimension |
| Data type | [string.geo.country](/apidocs/field-data-types#geographical) |
| \| clicks__date** \| \| --- \| \| \\| Display name \\| Date \\| \\| --- \\| --- \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.time.date](/apidocs/field-data-types#time) \\| \| \| Display name \| Date \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| clicks__date** |
| \| Display name \| Date \| \| --- \| --- \| \| Field type \| dimension \| \| Data type \| [string.time.date](/apidocs/field-data-types#time) \| |
| Display name | Date |
| Field type | dimension |
| Data type | [string.time.date](/apidocs/field-data-types#time) |
| \| clicks__product_name** \| \| --- \| \| \\| Display name \\| Product \\| \\| --- \\| --- \\| \\| Description \\| Name of the product \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Product \| \| Description \| Name of the product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| clicks__product_name** |
| \| Display name \| Product \| \| --- \| --- \| \| Description \| Name of the product \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Product |
| Description | Name of the product |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| clicks__vendor_name** \| \| --- \| \| \\| Display name \\| Vendor \\| \\| --- \\| --- \\| \\| Description \\| Name of the vendor (campaign) \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Vendor \| \| Description \| Name of the vendor (campaign) \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| clicks__vendor_name** |
| \| Display name \| Vendor \| \| --- \| --- \| \| Description \| Name of the vendor (campaign) \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Vendor |
| Description | Name of the vendor (campaign) |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |
| \| dataSourceName** \| \| --- \| \| \\| Display name \\| Data source \\| \\| --- \\| --- \\| \\| Description \\| The name of the source for this data, as listed on supermetrics.com/docs \\| \\| Field type \\| dimension \\| \\| Data type \\| [string.text.value](/apidocs/field-data-types#text) \\| \| \| Display name \| Data source \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| dataSourceName** |
| \| Display name \| Data source \| \| --- \| --- \| \| Description \| The name of the source for this data, as listed on supermetrics.com/docs \| \| Field type \| dimension \| \| Data type \| [string.text.value](/apidocs/field-data-types#text) \| |
| Display name | Data source |
| Description | The name of the source for this data, as listed on supermetrics.com/docs |
| Field type | dimension |
| Data type | [string.text.value](/apidocs/field-data-types#text) |