Exporting Flows' content to a CSV from the Experience Home

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.

Bear in mind

The Facebook Reactions Count filter does not collect content. This filter only collects statistics data. If your Flows contain this filter type, the CSV will be empty. 

  • From Experience Home go to Flows list and select the one you want to export to CSV.


  • 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)

  • Select the content status to export only the content that is:
    • Pending
    • Accepted
    • Rejected
    • All of them or any combination

  • Finally, 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 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 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


Was this article helpful?