You can export all the content collected by your Flows to a CSV File.
This report is downloaded as a compressed file (.gz format) that you need to decompress and then import to an Excel sheet, Google Spreadsheet, or Numbers (Mac), among others.
Exporting content to CSV
From the Project Home go to the Flows list and select the one you want to export to CSV.
(1) Specify a time range to narrow your search. It is possible to export posts with a time range equal to a single day.
(2) Choose between the following two export types:
- All Content (Including the text posts. Imported archives do not include media content)
- Audience (You will get unique users and not repeated users)
(3) Select the content status to export only the content that is:
- Pending
- Accepted
- Rejected
You can select all of them or any combination.
(4) Click on Export.
Decompressing a CSV file
- To decompress a CSV file, you can use 7-Zip (for Windows). Download it free here.
- After downloading and decompressing the CSV, check out the Importing a CSV file into an Excel sheet article to avoid having weird characters on your worksheet.
What kind of content will I get?
If you choose to export All Content, you will get the following:
| Id | Post Id |
| Publisher | Twitter / Instagram / Facebook / YouTube / WhatsApp |
| Date | Date and time the post was made. Time in UTC |
| Text | Post text |
| Device | Web / iOS / Android |
| Is Retweet | True / False |
| Retweeted Count | Number of times the post was rt-ed |
| Time Zone | Is the browser's day |
| Location | Post's latitude and longitude if it comes geolocalized |
| Author Name | Author's full name |
| Account | @handle |
| Reference | Post URL |
| Action | Post Status: Accept / Pending / Reject |
If you choose to export Audience, you will get the following:
| Id | User Id |
| Publisher | Twitter / Instagram / Facebook / YouTube / WhatsApp |
| Date | Date and time the post was made |
| Text | Post text |
| Device | Web / iOS / Android |
| Is Retweet | True / False |
| Retweeted Count | Number of times the post was rt-ed |
| Time Zone | Is the browser's day |
| Location | Post's latitude and longitude if it comes geolocalized |
| Author Name | Author's full name |
| Account | @handle |
| Reference | Post URL |
| Action | Post Status: Accept / Pending / Reject |