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:

Understanding Data Sync Status

The Data Sync column in your sources table can display one or more status pills indicating the sync state of the data source's connected accounts. When accounts are in different states, the data source shows multiple pills side by side, each with a count of the affected accounts (for example, "Synced 179" alongside "Lost Access 31"). Hover on any pill to see a tooltip with the count and status name.

Possible statuses include:

• Synced: Data is syncing successfully.
• Syncing: A backfill is in progress.
• Reconnect: The data source needs to be reconnected.
• Lost Access: PMA has lost access to a specific account on the source platform.
• Missing Permissions: Required OAuth permissions are missing (currently applies to Google data sources).
• Resolving: PMA is automatically retrying after a failed data retrieval job.
• Discontinued: This data connector is deprecated and no new data will be synced.
• Not Syncing: No data sync jobs for the source have been performed in the last 24 hours.
• No Accounts: No accounts under the data source are currently active.

For full status descriptions and troubleshooting guidance, 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/Instagram Ads, Facebook Insights, Instagram Insights, YouTube, and all Pinterest connectors 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 data source that needs to be reconnected.
• 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
  • Reconnect
  • Lost Access
  • Missing Permissions
  • Not Syncing
  • Synced
  • No 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.
• Edit Synced Accounts (button at the top right of the panel): Opens the account-selection list for choosing which accounts under the data source are enabled or disabled. The Edit Synced Accounts button may not appear for connected data sources that always have only one associated account.
• Three-dot menu (in the panel header): Opens a menu of source-level actions:
  • Set Sync Time: 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.
  • Backfill Data: Perform an immediate backfill of all accounts under the data source within their configured data ranges.
  • Reconnect Source: Immediately disconnect and reconnect the data source and all accounts included under it.
  • View Logs: View a record of scheduled tasks performed by PMA's data connector to retrieve your data, including any error messages for troubleshooting.
  • Remove Source: 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 at the top right of the panel.

   

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

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 the Lost Access status indicating the access issue. The Data Range column for the account will display "No date range" until access is restored.
• 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

• How Data Sources Work with Power My Analytics
• Connect to a Data Source
• Understanding Data Source Statuses
• Disconnect and Reconnect a Source from Your Hub