How to Create an FTP Export
FTP can be a valuable way for Enterprise users to export their Data Explorer reports. In this article, we will walk you through creating an FTP export, including selecting an FTP destination, scheduling data refreshes, and managing your exports to ensure seamless data transfer.
Click the blue plus sign to add a destination.
Select the type of FTP connection you want to use (FTP or SFTP). Then enter a name for your server, its hostname, your username and password.
Then click the Connect button. You will now be able to select the destination from the drop-down box. Choose a file format of CSV or JSON, and enter the Directory Path you want to use on 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 Data Explorer 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 icons under Actions to edit, pause/resume, or delete an existing export, run the export now, or view export logs.
FAQ
What is the source IP?
PMA exports are transmitted via Google Cloud which uses varying IP addresses. We do not know and cannot control the IP address from which the export originates.
What is the data format?
You can choose to export in JSON or CSV format.
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 ...Set Up GA4 Cost Data Imports Over Secure FTP
If you've recently migrated your Google Analytics accounts from Universal Analytics to Google Analytics 4, you might be wondering how to import your cost data into GA4. Power My Analytics makes it easy to import your historical cost data to GA4 over ...How to Export to MySQL
Our MySQL export feature enables flexible access to your data in the form of tables in a MySQL database hosted on the server of your choice. Once you've prepared a report in Data Explorer, you're ready to export your data to your MySQL server. With ...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 If you are using connectors other than ...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 ...