Capterra PPC data warehouse table groups

  • Updated on Dec 10, 2025
  • Published on Aug 5, 2025
Prev Next

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
clicks__category
Display name Category
Description The category where the click occurred
Field type dimension
Data type string.text.value
clicks__channel
Display name Channel
Description The site where the click occurred
Field type dimension
Data type string.text.value
clicks__clicks
Display name Clicks
Description Number of clicks
Field type metric
Data type int.number.value
clicks__conversions
Display name Conversions
Description Number of conversions
Field type metric
Data type int.number.value
clicks__cost
Display name Cost (USD)
Description Advertising cost in USD
Field type metric
Data type float.currency.value
clicks__country
Display name Country
Description The country where the click occurred
Field type dimension
Data type string.geo.country
clicks__date
Display name Date
Field type dimension
Data type string.time.date
clicks__product_name
Display name Product
Description Name of the product
Field type dimension
Data type string.text.value
clicks__vendor_name
Display name Vendor
Description Name of the vendor
Field type dimension
Data type string.text.value
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