Manage and Configure Data Sources

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 source connections.

Using the Sources Page

Add a New Data Source

To connect a new data source to your Power My Analytics hub:

  1. Visit hub.powermyanalytics.com to get started.
  2. Click on Sources in the left navigation panel, then click the orange "+ Add new source" button located above the main sources table.



  3. Select a connector from the data connector gallery.



  4. Sign in with your credentials for your account on the chosen platform.
  5. Grant Power My Analytics the required permissions to access your data.
Once connected, your new data source will appear in the main sources table and begin syncing data according to your configured schedule.

Data Sources Main Table


The main table displays all your connected data sources with the following information:

Column Description
Source Selection Checkbox for bulk actions on all checked data sources
Platform Icon of the connected platform (hover to see platform name)
Sources  Name, email address, and/or unique account identifier of the connected account
Synced Accounts Number of connected accounts within the data source (clickable link to view details in the Manage Accounts panel)
Data Sync Current sync status: "All good", “Syncing”, “Resolving”, "Disconnected", "Not syncing", “No accounts available”, or “Discontinued”.
Action Three-dot menu with available actions for each source, or "Reconnect" button if data source is disconnected

Understanding Data Sync Status

The Data Sync column in your sources table can display one of several statuses for the data source:

  • All good: Syncing has been completed successfully.
  • Syncing: Data sync is in progress.
  • Resolving: PMA is automatically retrying after a failed data retrieval job.
  • Disconnected: The data source cannot be accessed by PMA.
  • Not syncing: No data sync jobs for the source have been performed in the last 24 hours.
  • No accounts available: There is no data available from the connected data source.
  • Discontinued: This data connector is deprecated and no new data will be synced.

For more information on data source statuses and troubleshooting errors with data syncing, please see Understanding Data Source Statuses.

Data sync occurs daily at midnight in your selected time zone. Ensure your sync time is set appropriately for your reporting needs.

Available Actions for Data Sources

Click the three-dot menu in the Action column to access these options:

  • Manage accounts: Open the Manage Accounts panel to view, configure, enable and disable individual accounts under the data source.
  • Set sync time: Configure when daily data sync occurs by selecting the time zone.
    • Note: Facebook Ads, Facebook Insights, Instagram Ads, Instagram Insights, YouTube, Pinterest Ads, Pinterest Analytics, and Pinterest Lifetime Analytics do not have an adjustable data sync time zone.
  • Backfill data range: Manually backfill historical data from the data source.
    • Data range options: 24 hours, 7 days, 31 days, 3 months, 6 months, 1 year, or custom
  • Reconnect source: Re-establish connection for a disconnected data source.
  • View logs: Check data sync history, view success and error messages for tasks, and troubleshoot issues.
  • Show authorized scopes: View permissions granted to PMA to access the data source.
  • Remove source: Disconnect and remove the data source.

Bulk Actions on Sources

  1. Select data sources using the checkboxes in the main Sources table.
  2. Click the Actions dropdown menu.
  3. Choose from available bulk actions to apply to all selected data sources:
    • Set sync time: Configure sync timing for multiple sources at once.
    • Remove source(s): Delete multiple sources at once.

Search and Filter Sources

  • Search: Use the search field to find specific data sources by name.
  • Status Filter: Filter sources by their current status:
    • Syncing
    • Resolving
    • Discontinued
    • Disconnected
    • Not Syncing
    • All Good
    • Loading
    • No Sub-Accounts
  • Source Filter: Filter by specific platforms.

For more detailed information about specific data connectors, visit our connector documentation or reach out to our friendly support team.

Using the Manage Accounts Panel

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.



To access the Manage Accounts panel, click on the link for the data source under Synced Accounts in the main Sources table, or select Action > Manage accounts next to the data source.


Manage Accounts Settings

At the top of the Manage Accounts panel, you'll find several settings and actions that apply to the entire data source.


  • Authorized User (top left side of panel): Displays the name, email address, and/or unique account identifier of your account on the connected platform.
  • Set Sync Time (clock icon): Select the time zone in which the data source's daily midnight data sync is scheduled to occur, applying this setting to all accounts under the data source.
  • Manage Synced Accounts (profile icon): Select accounts you want enabled or disabled (performs the same function as the Enable Accounts button; the Enable Accounts button may not appear for all connected data sources, as some will always have only one associated account).
  • Backfill Data (calendar icon): Perform an immediate backfill of all accounts under the data source within their configured data ranges.
  • Reconnect Source (refresh and checkmark icon): Immediately disconnect and reconnect the data source and all accounts included under it.
  • View Logs (person and settings icon): View a record of scheduled tasks performed by PMA's data connector to retrieve your data, including any error messages for troubleshooting.
  • Remove Source (red exit icon): Disconnect and remove the entire data source.

You can also perform actions on multiple accounts simultaneously:

  1. Select accounts using the checkboxes in the Manage Accounts main table.
  2. Click the Actions dropdown menu at the top left of the panel.
  3. Choose Remove account(s) to delete multiple selected accounts at once.

Additionally, use the Search field at the top of the panel to quickly find specific accounts by name when working with data sources that have many connected accounts.

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 Edit Synced Accounts button in the upper right row of icons (profile icon).



  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.

Manage Accounts Main Table

The main table in the Manage Accounts panel displays detailed information about each individual account within your data source.



Column Description
Account Selection Checkbox for bulk actions on all selected accounts
Accounts Name, email address, and/or unique account identifier of the connected account
Data Range The date range of data retrieved and backfilled for the account during the daily data sync
Data Sync Current sync status: "All good", “Syncing”, “Resolving”, "Disconnected", "Not syncing", “No accounts available”, or “Discontinued”.
Sync Time The time zone in which the individual account's daily midnight data sync occurs
Action Three-dot menu with available actions for each individual account

Enable Accounts

The Enable Accounts feature (also known as Edit Synced Accounts) allows you to control which accounts within a data source are actively synchronized with Power My Analytics. This is particularly useful for data sources that contain multiple accounts, such as Facebook Ads with multiple ad accounts or Google Business Profile with multiple locations.

How Enabled Accounts Affect Reporting Destinations

When you configure a PMA data source in a destination like Looker Studio, the Account multi-checkbox dropdown will only display accounts that have been enabled to sync in your Hub. If you select "All Accounts" in Looker Studio:
  • The report will include all accounts enabled to sync in your Hub within the connected data source.
  • The report will only include accounts PMA currently has access to - accounts with lost access are excluded.
  • If access is lost later, any account that PMA can no longer access will be automatically removed from the report along with its data.

This means "All Accounts" represents a dynamic selection that reflects your current enabled and accessible accounts, not a static snapshot of accounts at the time of report creation.

Enable an Individual Account
  1. Open the Manage Accounts panel and click the Edit Synced Accounts button.



  2. Check the box next to the account name under "Enable or disable account-level data syncing" to include the account in your data source connection.



  3. Click the black Save button and the data for the account will begin backfilling.
Disable an Individual Account
  1. Open the Manage Accounts panel and click the Edit Synced Accounts button.
  2. Uncheck the box next to the account name under "Select accounts you want enabled or disabled" to exclude the account from your data source connection.
  3. Click the black Save button, and the data for the account will no longer be backfilled and cached in the PMA data warehouse.
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 - even if historical data for that account exists in your Hub.
  • The account will be excluded from "All Accounts" selections in Looker Studio, and will be removed from existing reports that included it.
  • Historical data for the account remains stored in your Hub, but you cannot create new reports using that account until access is restored.
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 the data source in your Hub.
  3. The account should then reappear in your destination configuration options and be included when "All Accounts" is selected.

Available Actions for Accounts

Click the three-dot menu in the Action column next to any individual account to access these account-specific options:

  • Backfill data range: Manually backfill historical data for the specific account.
    • Data range options: 24 hours, 7 days, 31 days, 3 months, 6 months, 1 year, or custom
  • History: Opens the comprehensive history of backfilling, data sync jobs, and gaps in data by table for the selected account.
    • Chart: Shows a visual history of backfills and their illustrated date ranges over time.
    • Jobs: Displays detailed log entries of data sync jobs organized by date.
    • Data Gaps: A timeline display showing any gaps of missing data in the account's data stored in PMA's warehouse, organized by tables of fields available in the data source's connector.
  • Get account information: Copies the diagnostic information associated with the connected account to the clipboard, for use when contacting PMA customer support (includes Organization ID, Account ID, and Sub-Account ID).
  • Remove account: Remove the individual account from the data source.

When Will My Bill Be Reduced?

Any usage of any connectors during a billing period will be billed for the entire month and will not be prorated. Your bill will reflect the reduction in the first full billing period after the data sources were removed.

Learn More About Data Sources

  1. How Data Sources Work with Power My Analytics
  2. Connect to a Data Source

    • Related Articles

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

    • Understanding Data Source Statuses

      The status of a data source, shown in the Sources section of your Power My Analytics hub, indicates whether data from the connection is successfully being retrieved by PMA. Source statuses may also alert you to issues with your data source connection ...

    • Missing POS Location Name Data in Shopify

      If you're seeing blank or missing data or "0" values for metrics when using the POS Location Name dimension in your Shopify reports, this article will help you resolve the issue. This problem occurs when your Shopify connection doesn't have the ...

    • Manage Team Roles and Permissions

      As a Hub owner, you may want to add team members as editors or billing managers to delegate roles and provide access. This article will show you where to find the tools you need to manage your team. Team members are users who authenticate and connect ...

    • Add and Remove Accounts from Data Sources

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