Microsoft Excel Data Integration Guide

Microsoft Excel Data Integration Guide

To install the Excel add-on, you can find it here:

Once the add-on is installed, follow the instructions on the page to launch it:


Click on the "+" logo to create a new report:


Select the data source you would like to report:


Select your Hub and account for the data source:



This "account" may be a Business Manager account in Facebook or some other higher-level account than the actual account you will report.  The selection of the actual account under a Business Manager account will come in a later step).


Select the date range you would like to report:


Additional configuration settings will be selected in the next step.  If you selected certain data sources, the actual Account, Page, Instance, etc. will be selected in this step:



Select the fields you would like to report.  You can click the "+" icon to browse them all or type in the box to search for the fields:


Note:
Once you select field(s), incompatible fields will not display via search or browsing.  If you cannot find a field, try removing one or more fields selected to see if that field becomes available.

Familiarize yourself with the fields available for each connector.  Creating a Looker Studio report with our template is an excellent way to see the field names and what they report.  The following article provides instructions for how to create a report in Looker Studio using our template:

Set how the data should be ordered and select the row limit.  If you want to report as much data as possible, select the largest value in the "Limit" list:


Click "Create Report" to generate the report:


The report will run on the page:


There will be a new page created called "PMA Config".  This is the page that lists all reports created and their settings.  


Editing and Scheduling Report Updates
To edit a report, click the 3 dot menu to the right of the report:


Then proceed to make any edits and save the report:




Scheduling Updates
Please Note:  There is presently no way to schedule an automatic update to the report.  We will investigate a solution in the future.





Have Questions Or Getting Errors?  Click on the bug icon to 



Enter your question or error details and click "Submit".  We will respond promptly!























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

      • Microsoft Ads Data Connector User Guide

        The following article is a guide to automating reports with your Microsoft Ads connector. It includes information on available data as well as currently unavailable data and tips on how to get the most out of your Microsoft Ads reports. To begin ...
      • Installing the Power My Analytics Add-in for Microsoft Excel

        If you'd like to merge and manipulate data from popular sales and advertising platforms with Microsoft Excel to create insightful and automated reporting, follow the instructions below to install and launch the Power My Analytics Excel Data ...
      • Choose a Data Destination

        Not sure where to begin with making reports or having trouble deciding which reporting tool will be best for your business? Let us help! This article will tell you what you need to know about which reporting options are available with your plan and ...
      • Google Sheets Data Integration Guide

        Integrate your marketing data into Google Sheets to build custom reports and dashboards. This guide will walk through how to install the Sheets add-on, create reports, edit reports, refresh data, and more. Install the Google Sheets Add-on To install ...
      • Sample Data Guide

        Sample Data is an innovative offering from Power My Analytics. This guide will dive into the details of the Sample Data, its value, and how to use it. It covers two primary topics: The Value of Sample Data, and How to Use Sample Data. The Value of ...