Open navigation

Capterra PPC and Capterra Reviews connection guide

Use this guide to learn how to connect your Capterra PPC or Capterra Reviews data to Supermetrics. Both of these data sources follow the same steps, with a few minor variations.


If you need to connect either of these data sources to one of our data warehouse or cloud storage destinations, explore our prerequisite and filling guides.


Before you begin

To connect Supermetrics to Capterra PPC, you need:

  • API access and an API key enabled by the Capterra account manager.


To connect Supermetrics to Capterra Reviews, you need:

  • A Capterra product identifier for search. This identifier can be taken from the URL of the product page in Capterra. 
    • For example, if the product URL in Capterra is capterra[dot]com/p/135003/Slack, the identifier is 135003.


Instructions

For Excel users

If your team uses Supermetrics for Excel, you'll see different options for managing and sharing data source connections in that destination. Learn more.


Google Sheets Data StudioExcel

Make sure you've installed the Supermetrics add-on before you connect.

  1. Open a new Google Sheets file.
  2. Navigate to ExtensionsSupermetricsLaunch sidebar to open Supermetrics.
  3. Click Create new query.
  4. Under Data source, select Capterra PPC or Capterra Reviews.
  5. To connect Capterra PPC, enter your account name and API key, and click Start.
  6. To connect Capterra Reviews, click Start, and then navigate to Report configuration. Enter your software ID in the field of the same name.

Learn about advanced settings, best practices, and troubleshooting tips for Supermetrics for Google Sheets.


More resources

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.