You can export all the content collected by your Flows to a CSV File.
This report is coming 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.
Bear in mind
The Facebook Reactions Count filter does not collect content. This filter only collects statistics data, so if your Flows contain this filter type the CSV will come empty.
Export CSV from the Content Inbox
Keep in mind that by using this option, you will not be able to choose the content status. This is because it will be exported in the same way that it has been filtered in the Content Inbox. Content can be filtered by:
User
Content
Type of post
Social network
User rights
Curation
Specify a time range to narrow your search. It is possible to export posts with a time range equal to a single day.
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)
Click Export to finalize the process.
Decompressing a CSV file
To decompress a CSV file, you can use 7-Zip (for windows). Download it here.
After downloading and decompressing the CSV, check out the How to open a CSV file into an Excel sheet article to avoid having weird characters on your Excel worksheet.
What kind of content will I get?
If you choose to export All Content, you will get:
Id | Post Id |
Publisher | Twitter / Instagram / Facebook / YouTube / WhatsApp |
Date | Date and time the post was made |
Text | Post's 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's URL |
Action | Post Status: Accept / Pending / Reject |
If you choose to export the Audience, then you will get:
Id | Post Id |
Publisher | Twitter / Instagram / Facebook / YouTube / WhatsApp |
Date | Date and time the post was made |
Text | Post's 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's URL |
Action | Post Status: Accept / Pending / Reject |