Add and Remove Accounts from Data Sources

Add and Remove Accounts from Data Sources

Info
Within a connected data source, accounts are subsets of data within data sources that can be selected individually to sync with PMA's data warehouse and use in reports. Accounts correspond to divisions within the data connector's platform, such as multiple pages under a Facebook Insights data source or multiple business locations in Google Business Profile.

Using the Manage Accounts Panel

In the Sources section of your hub, the Manage Accounts panel provides detailed control over individual accounts within your connected data sources. This panel allows you to configure settings, enable or disable specific accounts, and manage data synchronization at the account level.

Notes
Only enabled accounts will be included in your reports and data collection. Disabled accounts are automatically excluded from all reporting.
To access the Manage Accounts panel, select Action > Manage accounts next to the data source.


Add a New Account in a Connected Data Source

If you have a connected data source that contains multiple accounts (such as Facebook Ads with multiple ad accounts or Google Business Profile with multiple locations), you can enable additional accounts that are not currently active in your data source connection.

  1. Navigate to your Sources page in your Power My Analytics hub.
  2. Locate the data source containing the account you want to enable.
  3. Click the three-dot menu in the Action column and select Manage accounts.
  4. In the Manage Accounts panel, click the Enable Accounts button on the right.



  5. Under "Select accounts you want enabled or disabled," check the box next to the account name you want to include in your data source connection, or click Select all to choose all of the available accounts.



  6. Click the black Save button to confirm your selection.
Once enabled, the account will begin backfilling data and will appear in the Manage Accounts main table with an "All good" or "Syncing" status. The newly enabled account data will then be available in your reports and exports.

Understanding Account Availability

Enabled vs. Disabled Accounts

You can enable or disable accounts at any time using the Manage Accounts panel. Disabled accounts will stop syncing new data but can be re-enabled whenever you need them.

What "All Accounts" Means in Looker Studio

When configuring a PMA data source in Looker Studio, the Account multi-checkbox dropdown only displays accounts that have been enabled as synced accounts for that data source in your Hub.


If you select "All Accounts" in this dropdown, your report will include:

  • All accounts currently enabled to sync in your Hub within the connected data source
  • Only accounts that PMA currently has access to on the source platform

Important: If PMA later loses access to an account that was included in your report (whether individually selected or included via "All Accounts"), that account and its data will be automatically removed from the report.

Accounts with Lost Access

If you lose access to an account on the source platform - for example, if you are removed from a Google Ads account, lose admin permissions on a Facebook page, or are no longer associated with a business profile - that account will behave differently than a manually disabled account:

  • The account may still appear in your Hub's Manage Accounts panel but will show an error status indicating the access issue.
  • The account will not appear as an available option when configuring reports in destinations like Looker Studio, Google Sheets, or other integrations.
  • The account will not be included in "All Accounts" selections in Looker Studio, even if it was previously included.
  • Historical data for the account remains stored in your Hub, but you cannot create new reports using that account until access is restored.
  • Existing reports that included this account will have the account and its data removed automatically.

To restore reporting access:

  1. Verify your permissions on the source platform and request access from the account owner if needed.
  2. Once access is restored, reconnect or reauthenticate the data source in your Hub.
  3. The account should then reappear in your destination configuration options and be included in "All Accounts" selections.

    • Related Articles

    • Manage and Configure Data Sources

      Power My Analytics has updated the Sources page to make it easier to manage, configure, and monitor your connected data sources. This article will explain the features of the Sources section in your PMA hub and how to use it to manage your data ...

    • How Data Sources Work with Power My Analytics

      We understand that getting started with a new tool can be a bit overwhelming. This article will explain how Power My Analytics connectors, data sources, and other core features work together to provide fast and reliable data for your reports. ...

    • Why Can’t I See All of My Accounts in My Hub?

      Have you connected to a source but cannot see all of the associated accounts in your Hub or when configuring reports? This article will help you understand why accounts may be missing and how to resolve common issues. General Reasons for Missing ...

    • Sources Guide

      This guide covers everything you need to know about using Sources in Power My Analytics - from connecting your first data source to managing multiple accounts, understanding sync statuses, troubleshooting issues, and maximizing the benefits of data ...

    • WooCommerce Data Connector User Guide

      Are you looking to streamline your WooCommerce data analysis and reporting? Power My Analytics' WooCommerce connector automates the collection and integration of your e-commerce data, saving you time and providing deeper insights into your online ...