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 using the IP address 35.188.118.242, which can be whitelisted.
What is the data format?
You can choose to export in JSON or CSV format.
Related Articles
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 PostgreSQL
Our PostgreSQL export feature enables flexible access to your data in the form of tables in a PostgreSQL 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 PostgreSQL ...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 ...Error: Exporting report '[report name]', the owner of the report has left the organization. Please assign a new owner.
This article explains what to do when you encounter an error message indicating that a report owner has left your organization when attempting to export to BigQuery. Error Message Error: Exporting report '[report name]', the owner of the report has ...