Capterra PPC fields

  • Updated on Sep 11, 2025
  • Published on Aug 5, 2025
Prev Next

Supermetrics brings all your Capterra PPC data into Google Sheets, Looker Studio, Power BI, Excel, BigQuery, Snowflake, Redshift, Azure

9 metrics31 dimensions

ACCOUNT

clicks__vendor_name
Field label Vendor
Description Name of the vendor
Field type dimension
Data type string.text.value
clicks__product_name
Field label Product
Description Name of the product
Field type dimension
Data type string.text.value
clicks__category
Field label Category
Description The category where the click occurred
Field type dimension
Data type string.text.value
clicks__channel
Field label Channel
Description The site where the click occurred
Field type dimension
Data type string.text.value
clicks__country
Field label Country
Description The country where the click occurred
Field type dimension
Data type string.geo.country

DATASOURCE

dataSourceName
Field label 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
Destinations API, Data warehouse
system_metadata.data_source_logins
Field label Data source logins
Description The data source login accounts that were used to authenticate against the data source
Field type dimension
Data type string.text.json
system_metadata.data_source_login_owners
Field label Data source login owners
Description The Supermetrics users that created the data source login connections
Field type dimension
Data type string.text.json

PERFORMANCE

clicks__clicks
Field label Clicks
Description Number of clicks
Field type metric
Data type int.number.value
clicks__cost
Field label Cost (USD)
Description Advertising cost in USD
Field type metric
Data type float.currency.value
clicks__cost_from_usd_to_eur
Field label Cost (EUR)
Description Advertising cost converted to EUR
Field type metric
Data type float.currency.value
Services Currency conversion
clicks__cost_from_usd_to_gbp
Field label Cost (GBP)
Description Advertising cost converted to GBP
Field type metric
Data type float.currency.value
Services Currency conversion
clicks__cost_per_click
Field label CPC
Description Cost per Click. Cost / clicks
Field type metric
Data type float.currency.value
clicks__conversions
Field label Conversions
Description Number of conversions
Field type metric
Data type int.number.value
clicks__conversion_rate
Field label Conversion rate
Description Conversions divided by clicks
Field type metric
Data type float.number.ratio
clicks__cost_per_lead
Field label CPL
Description Cost per lead. Cost / conversions
Field type metric
Data type float.currency.value
clicks__avg_position
Field label 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

QUERY

system_metadata.query_date_range_start
Field label Start date
Description The start date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_date_range_end
Field label End date
Description The end date of the requested query
Field type dimension
Data type string.time.date
system_metadata.query_timezone
Field label Timezone
Description The timezone that is supplied to the query
Field type dimension
Data type string.time.timezone
system_metadata.query_filters
Field label Filters
Description All filters used in the query
Field type dimension
Data type string.text.json
system_metadata.query_date_start
Field label Start
Description When the query was started
Field type dimension
Data type string.time.datetime
system_metadata.query_date_end
Field label End
Description When the query completed
Field type dimension
Data type string.time.datetime
system_metadata.query_duration
Field label Duration
Description The duration in seconds of the query
Field type dimension
Data type int.duration.seconds
system_metadata.query_accounts
Field label Accounts
Description A list of accounts of which the data was pulled from
Field type dimension
Data type string.text.json

TIME

today
Field label Today
Description Today's date, e.g. 2017-01-31
Field type dimension
Data type string.time.date
Destinations API, Data warehouse
clicks__year
Field label Year
Field type dimension
Data type string.time.year
clicks__year_of_week
Field label Year of week (Sun-Sat)
Field type dimension
Data type string.time.year
clicks__year_of_week_iso
Field label Year of week (Mon-Sun)
Field type dimension
Data type string.time.year
clicks__year_month
Field label Year & month
Field type dimension
Data type string.time.yearmonth
clicks__month
Field label Month
Field type dimension
Data type string.time.month
clicks__year_week
Field label Year & week (Sun-Sat)
Field type dimension
Data type string.time.yearweek
clicks__year_week_iso
Field label Year & week (Mon-Sun)
Field type dimension
Data type string.time.yearweekiso
clicks__week
Field label Week (Sun-Sat)
Field type dimension
Data type string.time.week
clicks__week_iso
Field label Week (Mon-Sun)
Field type dimension
Data type string.time.weekiso
clicks__day_of_month
Field label Day of month
Field type dimension
Data type string.time.dayofmonth
clicks__day_of_week_name
Field label Day of week (Sun-Sat)
Field type dimension
Data type string.time.dayofweek
clicks__day_of_week_name_iso
Field label Day of week (Mon-Sun)
Field type dimension
Data type string.time.dayofweekiso
clicks__date
Field label Date
Field type dimension
Data type string.time.date
clicks__atom
Field label Datetime
Field type dimension
Data type string.time.datetime