Connecting to a Data Source - Power My Analytics

Connect to a Data Source

Info
We understand that getting started with a new tool can be a bit overwhelming. In this article, we'll guide you through the process of connecting a data source to Power My Analytics and explain how our data collection works to make your experience smooth and enjoyable.

Step-by-Step Guide to Connect a Data Source

  1. Visit hub.powermyanalytics.com to get started.
  2. Click on Sources in the left navigation panel, then click on the + New Data Source button.



  3. Choose a connector from the available options. Ensure that your browser settings allow pop-ups.
  4. Authenticate the source account to complete the connection process.

What Power My Analytics Does for You Automatically

  • Historic data collection: Most connectors start collecting up to 13 months of historical data as soon as you create a report. This process typically takes a few minutes, but for some data sources, it might take a couple of hours to complete the initial backfill.
  • Daily data refreshes: We refresh your data every day with all our connectors. During these refreshes, we also update the past 7 days of data to account for any changes that may have occurred. These updates happen around midnight in the time zones set in the Sources section of your hub.



When to Manually Backfill Connection Data


  • Extended historic data collection: Some connectors allow you to force backfills of data for up to 2 years or more.
  • Troubleshooting: If you experience missing or incorrect data issues, manually backfilling connection data is often the simplest and most effective solution.
By following these steps and understanding our data collection process, you'll be well-equipped to create informative and accurate reports in Power My Analytics. If you need any assistance, don't hesitate to reach out to our friendly support team.

Google Sheets Error: "Please re-connect your account"


If you receive the error message "Please re-connect your account" while using Google Sheets with PMA, follow these steps to ensure your data source is connected:
  1. Go to your Power My Analytics hub and click on Sources in the left sidebar.
  2. Select the Filter by Status dropdown and choose Disconnected to find the disconnected data source. Click the red refresh icon next to the source to reconnect.



  3. If your data source is not listed under disconnected sources, click the + New Data Source button to connect your account as a data source again.



  4. Refresh your Google Sheets report. 


    Still having issues?
    Send us a ticket and we will get back to you.
    Submit a ticket

      • Related Articles

      • Disconnect and Reconnect a Source from Your Hub

        Are you experiencing errors in your reports? Many issues can be resolved by simply disconnecting and reconnecting a data source. This guide will walk you through the process. Issue Errors in reports that can be resolved by disconnecting and ...

      • How to Reconnect a Disconnected Data Source

        Sometimes a connected account can become disconnected from your Power My Analytics hub, causing errors in reports. This article will show you how to reconnect a disconnected data source in your hub and get your data moving again. What Happens When a ...

      • How to Connect to BigCommerce

        This guide will walk you through the process of getting the credentials you need to connect to BigCommerce with Power My Analytics. You will need to create an API Account and get an Access Token. Before Getting Started You'll Need A BigCommerce ...

      • How to Connect to Campaign Monitor

        This guide will show you how to connect to Campaign Monitor and start creating reports. You can connect using your Campaign Monitor login or using your API keys. Begin in your Power My Analytics Hub. Under Sources, click + New Data Source. ...

      • The Trade Desk Data Connector User Guide

        Are you looking to streamline your programmatic advertising data analysis? This guide will walk you through the process of integrating The Trade Desk with Power My Analytics, enabling you to automate data collection, centralize your metrics, and ...