Open navigation

Capterra PPC and Capterra Reviews: Authentication and reauthentication guide

This guide will walk you through how to authenticate or reauthenticate Capterra PPC and Capterra Reviews with Google Sheets, Data Studio, and Excel.

Before you begin

To connect Supermetrics to Capterra PPC, you need:

  • API access and an API key to be 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. 


With Capterra PPC, you can:

  • Report all the basic metrics for your advertising and promotions: cost, clicks, conversions, average position, CPC, and CPA/CPL.
  • Fetch data by vendor, product, country, channel, or by time.

  • Report data from three different platforms: Capterra, GetApp, and Software Advice.

With Capterra Reviews, you can:

  • Fetch data from 250 most recent reviews for any product.


Google Sheets Data Studio  Excel
Before you can authenticate the data source in Google Sheets, you need to install the Supermetrics add-on.
  1. Open a new Google Sheets file 
  2. Click Add-ons → Supermetrics → Launch to open the sidebar.
  3. Under Data source, select Capterra PPC or Capterra Reviews.
  4. For Capterra PPC:
    Enter your Account name and API key, and click Start.
    Navigate to Report configuration.

    For Capterra Reviews:
    Click Start.
    Navigate to Report configuration.
    Under Software ID, insert the software ID. 


Learn how to reauthenticate the data source with Supermetrics in Google Sheets.


  • If you encounter an authentication error such as “authentication failed”, “you need to reauthenticate” or similar, see this guide
  • If you're missing an account from the drop-down list, follow these steps
  • If you encounter a permission error such as “user permission denied” or similar, follow this guide.

Did you find it helpful? Yes No

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