Open navigation

Adobe Analytics and Adobe Analytics 2.0: Authentication guide

This guide will walk you through how to authenticate or reauthenticate Adobe Analytics and Adobe Analytics 2.0 with Google Sheets, Data Studio, and Microsoft Excel, as well as data warehouse destinations like Google Cloud Storage, BigQuery, and API. 


Adobe Analytics 2.0 is in early access, which means we're still fine-tuning all of its features. We'd love to hear your feedback.

Before you begin

There are two ways to authenticate Adobe Analytics and Adobe Analytics 2.0:

  • Recommended: Connect with a service account
  • Connect with OAuth

These authentication methods both work differently and have different advantages.


Authentication methodDetails
Service account
  • Authentication is valid for 10 years
  • The service account is a separate user, which offers additional flexibility but means that all segments and calculated fields must be shared with it
  • Requires developer access
OAuth
  • Requires manual reauthentication every 14 days
  • Log in with your own Adobe Analytics credentials
  • All the settings, segments, and fields available to your account are instantly available in Supermetrics



Prerequisites: Create and connect a service account

To connect Supermetrics to Adobe Analytics or Adobe Analytics 2.0 with a service account you need:

When you're ready, follow our detailed guide to create and connect your Adobe Analytics service account.

Prerequisites: Connect with OAuth

To connect Supermetrics Adobe Analytics or Adobe Analytics 2.0 with OAuth, you need:


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.

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. Click Create query.
  4. Under Data source, select Adobe Analytics or Adobe Analytics 2.0.
  5. Choose your authentication method.
  6. If you choose Service account

    Enter your client ID, technical account ID, organization ID, client secret, and click Start.

    If you choose OAuth:
    Enter your email address and password and click Log in.

  7. Select your accounts.



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.