The Power My Analytics (PMA) Data Connector is your gateway from Data Builder datasets to your reporting destinations. Design your datasets in Data Builder, then report your data in Looker Studio or Sheets or export to destinations like BigQuery and SQL.

What is the Power My Analytics (PMA) Data Connector?

Power My Analytics offers over 60 data connectors supporting a variety of advertising, sales, and social platforms. In addition, we now offer the Power My Analytics Data Connector for Data Builder, our powerful platform for dataset design and blending data sources.

The Data Builder Difference

By using the PMA Data Connector, you can load your Data Builder datasets and tables into destinations like Looker Studio, Google Sheets/Microsoft Excel, BigQuery, SQL, and more. This is an excellent choice for users who want to blend data from multiple sources before using it in a report, without relying on destinations like Looker Studio to perform blending.

While Looker Studio has a 5-source limit on data blending in reports, PMA’s Data Builder has no limitation on the number of sources you can blend. This guide will show you:

• How to prepare your data sources and Data Builder reports.
• How to use the PMA Data Connector to report your Data Builder data.
• How to navigate your PMA Data Connector reports and exports.

Step 1: Connect Your Data Sources with PMA’s Platform Connectors

First, you’ll need to connect data sources from the platforms you’d like to report. For example, these might be Google Ads and Google Analytics 4 (GA4) data sources that you’d like to blend together in a single Data Builder dataset table.

1. Click on Sources on the left menu of your hub.
   
   
2. Follow the instructions in Connect to a Data Source and connect your source.
   
3. Repeat this for each of the sources you’ll be using in your report.

Once your sources are connected, they will be available for use in creating Data Builder reports.

Step 2: Create a Data Builder Dataset and Table with Your Sources

PMA’s Data Builder allows you to blend potentially endless combinations of data from your connected sources.

1. Click on Data Builder on the left menu of your hub.
2. Follow the instructions in the Data Builder Guide to create a Data Builder dataset using your source or sources, with at least one data table configured.
   
3. Optional: Choose blendable fields to use as a join key when building data tables from multiple data sources in your dataset.

In this example, we’ll use a Data Builder data table that joins Google Ads and GA4 account data on the fields Date and Campaign Name, reporting Conversions and Cost from Google Ads and Transactions from GA4.

The resulting data table’s contents can be seen in the Preview Data section of Data Builder:

When your Data Builder dataset is created with at least one data table, you’re ready to start using the PMA Data Connector.

Step 3: Use the PMA Data Connector to Report from Data Builder

Note: In addition to the fields you’ve selected in your Data Builder data tables, all Data Builder datasets reported via the PMA Data Connector contain several useful fields for working with your data. These include:

• Data Platform
• Data Source
• Data Source Logo
• Data Table
• Data Table ID
• Dataset
• Dataset ID
• Dataset URL
• Organization ID

These fields can be helpful when reporting data from multiple data tables.

Looker Studio

To create a Looker Studio report using the PMA Data Connector:

1. Under Reports in your hub, click Looker Studio.
   
   
2. Select Power My Analytics under Create Looker Studio Report. You’ll be taken to the Looker Studio configuration page for the PMA Data Connector.
   
   
3. For Power My Analytics Hub, select the name of your PMA hub.
   
4. For Power My Analytics Dataset, choose the Data Builder dataset that contains the table you’d like to report.
   
1. Optional: Check Allow "Power My Analytics Dataset" to be modified in reports if you’d like to be able to select from your Data Builder datasets in your report.
   
   
5. Optional: Leave “Use report template for new reports” checked to use Power My Analytics’ default template in your report.
   
   
6. Click the Connect button in the upper right corner.
7. Click the Create Report button in the upper right corner to continue, then click Create Report in the popup to confirm.

Your Looker Studio report will open without any premade charts, and the data fields from your Data Builder tables will be available in the right-hand Data column for use in your report. These fields will be sorted by the data table they are in (for instance, “Ads/Analytics Blend”):

For example, you can recreate the Google Ads/GA4 data table by adding the same fields to a Looker Studio table:

Google Sheets and Microsoft Excel

Note: Your PMA subscription must include spreadsheets in order to create Google Sheets or Microsoft Excel reports using your data. The Pro and Custom (formerly Enterprise) plans include the Spreadsheets addon.

To report your data in Google Sheets or Microsoft Excel:

1. Create a new document and open the Power My Analytics sidebar. In this example, we’ll use a Google Sheets spreadsheet.
2. Click the blue plus button, then select Add Report to create a new report.
   
   
3. Under Connector, select Power My Analytics.
   
   
4. In the Data Account section, select your Power My Analytics Hub, followed by your Account.
   
   
5. Under Configure, select your Power My Analytics Dataset from the dropdown. Then click the Set Config button.
   
   
6. In Date Range, click Choose date range to select the range of data to include in your report. Then click the Set Range button.
   
   
7. Under Fields, click Select fields and choose the metrics and dimensions from your data tables that you’d like to include in your spreadsheet. When you’re finished choosing fields, click the Set Fields button.
   
   
8. Optional: Add filters to your data under the Filter section. If no filters are needed, click the Set Filter button to continue.
9. Under Options, click Order By to select a field by which to sort your data. You can choose between an Ascending and Descending sort, set a row limit, or select other options.
   
   
10. Give your report a name, then click the Create Report button.
    
    

Data Exports

Note: You must have the Custom (formerly Enterprise) plan in order to create BigQuery, SQL, FTP, or Amazon S3 exports using your data.

To export your data to one of PMA’s export destinations:

1. Follow the instructions to begin creating an export to one of the following data destinations:
   • MySQL
     
   • Azure SQL Database
     
   • PostgreSQL
     
   • BigQuery
     
   • Amazon S3
     
   • FTP
     
2. In the Reports section of the export configuration, under Report or Report Group, select Group of reports. Then, under Report Group, select the Data Builder dataset you’d like to report.
   
   
3. When you’ve selected your dataset, click the Next button. Follow the instructions for your chosen destination to finish setting up your data export.

Additional Information

• Connect to a Data Source
  
• Data Builder Guide
  
• Google Sheets Data Integration Guide
  
• Microsoft Excel Data Integration Guide
  
• How to export to:
  
  • MySQL
    
  • Azure SQL Database
    
  • PostgreSQL
    
  • BigQuery
    
  • Amazon S3
    
  • FTP

Troubleshooting

Please see our article Basic Troubleshooting for information on issues that may affect PMA’s data source connectors, or contact our support team for assistance.