Open navigation

Salesforce Marketing Cloud: Authentication and reauthentication guide

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


Before you begin

To connect Supermetrics to Salesforce Marketing Cloud, you need:

  • A Salesforce Marketing Cloud account, which is either Pro, Corporate, or Enterprise edition.
  • A Salesforce Marketing Cloud user with the role of Administrator or Marketing Cloud Administrator.

Please note: the Marketing Cloud Administrator right is not needed every time you connect Salesforce Marketing Cloud to Supermetrics. You only need it when you create the installed package for the first time.

Here’s an example of sufficient user permissions:

Before you can authenticate Salesforce Marketing Cloud in Supermetrics, you need to follow these steps:

Step 1: Generate a client ID, client secret, and subdomain
  1. Log in to your Salesforce Marketing Cloud account with a Marketing Cloud Administrator or Administrator account.
  2. Insert your username and password and click Log in.
  3. Go to your username icon, under Settings, and click Setup.



  4. Navigate to Apps. Click the right-side arrow and select Installed packages.



  5. Click New on the top right-hand corner.
  6. Give a name to the package: for example "Supermetrics". The description field can be left empty. Click Save to confirm.

Step 2: Add API integration component
  1. Go to Installed packages and find the newly created Supermetrics package. Click it to open the configuration view.
  2. Click Add component.
  3. Select API Integration as the component type. Click Next.


  4. Select Server-to-Server as the integration type. Click Next.
  5. Add Read permission to the following properties:
    • Email
    • Push
    • SMS
    • Documents & Images
    • Journeys
    • List and Subscribers
    • Tracking Events
    • Campaign
    • Accounts
    • Users
  6. Click Save to confirm.

    Make sure to give the following scopes, or the authentication will not work:
Step 3: Find the client ID, client secret, and subdomain for the installed package
The client ID and client secret are shown to you on the page:


Subdomain can be copied from Authentication Base URI section, where it is the text between "https://" and ".auth.marketingcloudapis.com/"



Make a note of your client ID, client secret, and subdomain — you’ll need them when connecting Salesforce Marketing Cloud to Supermetrics.


Data protection agreement 

If you have any questions about how Supermetrics handles and secures your data, read our policy on data privacy and security.


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. Click Add-ons → Supermetrics → Launch to open the sidebar.
  3. Under Data source, select the data source.
  4. Click Start.
  5. Enter your Client ID, Client Secret and Subdomain, and click Start
  6. Under Select accounts, select the accounts.


Reauthenticate

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



Troubleshooting

  • 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.