How to Create an FTP Export

How to Create an FTP Export


Once you have a report ready in Data Explorer, you are able to export it to FTP. This export option is included in the Enterprise plan. Follow the instructions in this article to get started.


Begin in Your Hub

Select FTP from the left navigation pane under Exports then click Create Export.



Click the blue plus sign to add a destination.



Enter your server name and credentials to create an FTP destination.



You will now be able to select the destination from a drop-down box. Enter the Directory Path created in your FTP server.



Choose whether you'd like to export a single report or group of reports from the Data Explorer.



Schedule your refresh period. You can choose monthly, daily, weekly, or hourly. Then select a time that works well for you. We suggest setting the time for an hour before the start of your workday.

Remember: Each scheduled export will overwrite data in the date range of the report.  To accumulate data over time, choose a report date range with an end date of today or yesterday. When you are creating your report in Data Explorer, choose a Custom Start option under Date Range to accumulate data over time. Fixed time frame options like Last 7 days will export only the most recent 7 days of data with each refresh. Data from before that period will not be overwritten.



Manage Existing Exports

Click the blue pencil icon to edit any aspect of your existing report.



Pause, delete, or run your export now with these controls.



FAQ: What Is the Source IP?

PMA exports are transmitted via Google Cloud which has a lot of different IP addresses. We do not know and cannot control the IP address from which the export originates. 

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

      • How to Create a Report in Data Explorer

        Data Explorer is a valuable tool that can be used to create reports for export to BigQuery or FTP , to test out a connection, or even to create a CSV file. This tool is available to all Power My Analytics customers and is included in the cost of your ...
      • BigQuery Export Limitations

        Your data exports to BigQuery may encounter errors in certain situations such as large export sizes. This article will show you how to identify and correct errors with your BigQuery exports. Export Limitations Make sure the report you are trying to ...
      • How to Export to BigQuery

        Once you have a report ready in Data Explorer, you are able to export it to BigQuery. This export option is included in the Enterprise plan. Follow the instructions in this article to get started. Grant Required Roles and Permissions A successful ...
      • How to Use Schema Explorer

        The PMA Schema Explorer is an easy way to find metrics and dimensions that are available for your connectors and identify any possible conflicts or errors. Schema Explorer can find additional fields that are compatible with your selected fields and ...
      • Data Imports: How to Create a Data Set In Google Analytics

        The Data Sets you create can be selected in the Data Import drop-down when creating Google Analytics imports. The same Data Import can be used with multiple connectors for this property (for example: both Microsoft Ads and Facebook Ads cost data). ...