<aside>

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.

</aside>

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.

1. Follow the instructions in Connect to a Data Source and connect your source.
2. 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.