How to add and remove data source accounts and data source connections in Excel

This guide will walk you through how to add and remove data source accounts and data source connections in Supermetrics for Excel.

Instructions

Add data source accounts

1. Open the Supermetrics sidebar.

2. Select your data source from the Data source dropdown.

3. Navigate to the Select accounts dropdown. Different data sources might name this dropdown differently — for example, if you're using Facebook Ads, you'll see Select ad accounts, and for Google Analytics 4, you'll see Select properties.

4. Click the field and select your accounts from the list, or start typing an account's name to filter for it.

Remove data source accounts

1. Open the Supermetrics sidebar.

2. Click any query on the sheet that uses the data source you want to remove accounts from.

3. Click x to close the Query info popup.

4. Navigate to the Select accounts dropdown. Different data sources might name this differently — for example, if you're using Facebook Ads, you'll see Select ad accounts, and for Google Analytics 4, you'll see Select properties.

5. Click x next to the account name to remove it.

Add data source connections

1. Open the Supermetrics sidebar.

2. Select your data source from the Data source dropdown.

3. Click +Add connection.

Remove data source connections

1. Open the Supermetrics sidebar.

2. Select your data source from the Data source dropdown.

3. Click x next to the connection name to remove it.

You can also manage your data source connections on the Supermetrics Hub, including removing and reconnecting data source connections.