Connecting to a Data Source - Power My Analytics

Connect to a Data Source

Before you can create a report, you need to connect at least one data source. This article will show you how to easily connect sources and explain the Power My Analytics data collection process.

To connect a source, begin at hub.powermyanalytics.com  
1. Click Sources on the left navigation panel. Then click + New Data Source.



2. Select a connector from the menu. Make sure you have enabled pop-ups in your browser settings.



3. Authenticate the source Account.



What we do for you automatically
  1. Historic data collection (≤ 1 year): Most of our connectors start backfilling up to a year of data the moment you first connect.  This process generally takes less than a minute, but for some data sources it could take up to an hour to backfill initially.

  2. Daily refreshes: All of our connectors refresh your data each day.  We start the refresh at UTC 00:00 and it finishes at approximately UTC 06:00.  During these refreshes, the past 7 days of data will also be updated to reflect any changes that have occurred.

When to backfill connection data manually
  1. Historic data collection (> 1 year): Some connectors support forcing backfills of data for up to 2 years or more.

  2. Troubleshooting: Re-backfilling connection data is often the simplest and easiest way to solve missing or incorrect data issues.


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

      • Related Articles

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

      • How to Connect a Google Sheets Report to Data Studio

        Though Data Studio is the superior presentation tool, many reports are easier to create with spreadsheets. This article will help you learn how to take the reports you've created in Google Sheets and connect them to Data Studio to create a seamless ...

      • Data Studio Connector Guide

        When connecting to Google Data Studio, there are a few best practices to keep in mind.  From demo templates to customizations to troubleshooting, this guide will teach you some pro tips for using Power My Analytics data connectors. Use a Free Power ...

      • Error: Your Connection Is Not Private

        This article will assist with the following error: "Your connection is not private" pop-up when attempting to connect to a data source. Cause Power My Analytics will always make sure our security certificates are current. If you are receiving this ...