Skip to main content

Download "Surveys Sent" History

Jomar
Updated

 

Introduction

Need a full view of survey activity—not just responses, but who received, opened, or ignored your survey? The Surveys Sent Report gives you all that and more.

It combines information from the Responses page and the Contacts list, so you can see:

  • ✅ Who received a survey

  • 👁️ Who opened it

  • 🗣️ Who responded with a score/comment

  • ❌ Who never saw or responded

This article outlines three easy ways to download your Sent Survey history:

  1. From the Responses page

  2. Via an API call (Excel)

  3. Via an API call (JSON)

Option 1: One-Click Download from the Responses Page (Easiest)

  1. Navigate to the Responses page.

  2. Use the filters at the top to set your desired date range, Contact segment, or other conditions.

  3. Click the Download dropdown.

  4. Select Filtered Surveys Sent.

This downloads a spreadsheet (CSV) showing all Contacts who were sent a survey within your filter criteria.

📌 What the report includes:

  • Email address

  • Sent timestamp

  • Opened timestamp

  • Survey answer (if submitted)

  • All custom data fields associated with each Contact

🔍 How to read the data:

  • A score of -1 in the "answer" column means no survey response was submitted.

  • If no "opened" timestamp appears, the email was not opened.

  • If there's an "opened" timestamp but no score, the email was opened, but no response was given.

Option 2: API Call to Download as a Spreadsheet (Excel Format)

For those comfortable using APIs, this method offers more flexibility.

🔗 URL Format:

https://YOURDOMAIN.asknice.ly/api/v1/responses/desc/10000/1/0/excel/raw?X-apikey=YOURAPIKEY&realdates=yes

Required components:

  • YOURDOMAIN = your AskNicely subdomain (e.g., jarvis)

  • YOURAPIKEY = your API Key (found in Settings > Show API Key)

  • 10000 = number of responses to download (adjust as needed)

✅ Pasting this link into your browser will immediately download an Excel file.

Option 3: API Call to Download as JSON

Same as above, but return the data in JSON format for development or integration purposes.

🔗 JSON URL Format:

https://YOURDOMAIN.asknice.ly/api/v1/responses/desc/10000/1/0/json/raw?X-apikey=YOURAPIKEY&realdates=yes

You’ll see all sent survey data rendered in JSON format within your browser or API client.

🔧 Key Terms

Term Description
Domain The part of your AskNicely URL before asknice.ly (e.g., jarvis)
API Key Found in Settings (click the ⚙️ Cog in the lower left, then "Show API Key")
10000 Number of survey records to retrieve—adjust as needed

💡 Hot Tips

  • ✅ Change the number 10000 in the API URL to fetch more or fewer records.

  • 🔐 Keep your API key secure—only use it in private or authenticated environments.

  • 🧪 Test the URL in your browser or use tools like Postman to build more complex queries.

FAQs & Common Issues

  • Q: Why do I see “-1” in the answer column?
    A: That means no response was submitted for that survey.

  • Q: Can I export survey sends for a specific segment?
    A: Yes—apply filters on the Responses page before downloading.

  • Q: Can I automate this report with the API?
    A: Yes, you can schedule or embed the API call in your reporting system.

Next Steps & Related Articles

Video Tutorial

🎥 

Need Help?

If you need help customizing your API call, filtering the data, or troubleshooting the export, reach out via the chat icon or email support@asknice.ly.

Related articles