One of the most powerful things about ActionSprout is the ability to export supporter and donation data for use with your other communication tools.
Exporting CSV Files
When you choose to export your supporter data, it will be emailed to you as a CSV file for easy manipulation and analysis.
ActionSprout uses the most common character encoding system, UTF-8, for international characters. Currently Excel is unable to read these UTF-8 CSV encoded characters, so international characters may appear as a ? in Microsoft Excel. Opening the file in Numbers or Google Docs will render these characters properly.
Please note: If your file size is rather large, (half a million people or more) your export will be queued and delivered via email once it’s processed and ready for you to download. This may take up to a few hours depending on list size.
Types of Exports
Exports come in four types:
- People exports
- Action exports
- Donation exports
- Comment exports
People exports happen under the People section of your account. The data in these exports centers around individual supporters. This data is helpful when you want to learn how engaged and active your supporters are or want to answer supporter centric questions.
Action exports happen under the Social Actions section of your account. The data centers around the social action. This data is helpful when your questions pertain to a particular action. How many people have taken action? When did they take action? What sources brought in the most signatures?
This data can then be exported from your list of actions like this:
You can also export it from the Editing screen for an action, under the small People tab:
Conveniently, you also have the option to export a master list of all donors and donations made thus far through ActionSprout! Look for it under Account Settings and then Integrations.
Locate the Stripe app and click the Export Donations button.
Please note: The majority of your donor and donation information will be captured in Stripe.
Under Timeline, you'll find the option to export comments made on any of your Facebook posts. This is found by clicking the More arrow, or Details button, on any Facebook post. Then click the Export Comments button at the top of the resulting menu:
The resulting CSV file will be emailed to the address we have on file for you. This file may contain the following fields:
- Name - Name of the person who left the comment.
- Comment - The comment in full.
- Comment ID - The Facebook ID attached to this particular comment.
- Date - The date the comment was made.
- Comment Likes - How many times did other people like this person's comment?
- Comment Replies - How many replies did this person's comment receive?
- Hidden - Was this comment hidden by you or by someone on your team?
Have questions about exports or your date? Ask us at email@example.com