How to Export to FTP
FTP can be a valuable way for Custom plan users whose plan includes data exports to export their Data Builder reports. Data exports are not automatically included in all Custom plans; availability depends on the terms of your specific agreement. 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 Builder.
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 Builder 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 Builder, 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
BigQuery Export Limitations
Your data exports to BigQuery may encounter errors in certain situations such as large export sizes. This article will help you identify and resolve common BigQuery export issues including timeout errors, "Failed to Fetch" errors, and hung exports. ...Amazon Seller Data Connector User Guide
Amazon Seller Central is a powerful platform for managing your e-commerce business on Amazon. This guide will help you connect your Amazon Seller Central account to Power My Analytics, enabling you to automate data collection and create insightful ...Export a Data Studio Report to PDF
This article will show you how to export your Data Studio report to a downloadable PDF format. To export your Data Studio report to a PDF, open your report. Click the down arrow on the Share button. Then click Download report. Select the pages you ...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 ...How Often Your Data Refreshes (and How to Add Hourly Refreshes)
Power My Analytics keeps your marketing data current with an automatic daily Data Sync. If you need updates more often than once a day, the Hourly Refreshes add-on lets your reports and data exports refresh as frequently as every hour. This article ...