Open navigation

Smarp: Authentication guide

This guide will walk you through how to authenticate or reauthenticate Smarp in Supermetrics with Google Sheets, Data Studio, and Excel.

 

Before you begin

To connect Supermetrics to Smarp, you need:

  • An account name. This is the name you choose for your login. We recommend using your account's name.
  • Smarp subdomain. This is the subdomain from your URL. 
  • API key. This is the token you use to authenticate queries to the API. You can find this in the Smarp dashboard. Read the Authentication section of Smarp's basic concepts documentation to learn more.


Query types

For most query types, you'll need the Company Admin role level.

  • Clicks: Returns all clicks based on the period in which clicks happened.
  • Campaigns: Returns campaigns for a specific company.
  • Groups: Returns all groups within the instance.
  • Posts: Returns posts based on the period in which posts were published.
    • Posts that have been deleted or were published in private channels won't be returned.
  • Shares: Returns all shares based on the period in which the share was done.
  • Teams: Returns all teams in the instance.
  • Users: Returns users in the company.


Instructions


Google Sheets Data Studio  Excel Data integrations
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. Navigate to ExtensionsSupermetricsLaunch to open the Supermetrics sidebar.
  3. Under Data source, select Smarp.
  4. Click Start.
  5. Enter your account name, Smarp subdomain, and API key.
  6. Navigate to Report configuration
  7. Select the query type.



Troubleshooting

  • If you encounter an authentication error such as “authentication failed”, “you need to reauthenticate” or similar, see this guide
  • 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.