This guide shows you how to use the Subscriber Snapshot Quick Export to see which opt-in keyword each of your subscribers used to join your list. This is useful when you assign different keywords to different subscriber sources. For example, one keyword for in-person sign-ups, one for your website, one for an event, etc., and you want to identify, count, or segment subscribers by where they came from.
When to Use This Report
Use the Subscriber Snapshot report when you want to:
See a list of every subscriber and the keyword they most recently opted in with
Confirm how many subscribers came in through a specific keyword (for example, an "INPERSON" or "EVENT" keyword)
Build a one-time export to share with another team or your CRM
Verify your keyword strategy is capturing the source data you expect
If you only need to send a message to subscribers based on their opt-in keyword (without exporting), use How do I send messages to subscribers based on their opt-in keyword? instead.
Prerequisites
You have multiple opt-in keywords configured on your list. To set up a new keyword, see SMS Keywords.
Steps
1. Go to Reports
In the top navigation bar of your home page, click Reports, then select Quick Export.
2. Choose Subscriber Snapshot
On the Quick Export page, select the Subscriber Snapshot report. This report uses All Time data and provides a snapshot of every subscriber on your list at the current moment. There is no date range to set.
Click the small gray arrow in the bottom-right of the report card to preview the included fields. The key field for this use case is Most Recent Opt-In Keyword.
3. Review the Fields and Run the Report
Confirm the field list includes Most Recent Opt-In Keyword, then click Next → Run Now. You'll be redirected to Activity Logs, where the report status will show "Running."
You don't need to stay on this page while it runs.
4. Download the Export
Once the status changes to "Completed":
Go to Reports → Activity Logs.
Find your Subscriber Snapshot in the list.
Click the arrow in the Actions column to download the file.
5. Filter by Keyword in Excel or Google Sheets
Open the downloaded file and apply a filter to the Most Recent Opt-In Keyword column. From there you can:
Sort to group all subscribers from the same keyword together
Filter to show only subscribers from a specific keyword (e.g., INPERSON)
Use a pivot table to count subscribers per keyword
How the "Most Recent Opt-In Keyword" Value Is Set
The keyword is set the first time a subscriber opts in.
If a subscriber re-opts-in using the same keyword, the value does not change.
If a subscriber opts out and then opts back in with a different keyword, the new keyword becomes their Most Recent Opt-In Keyword.
Subscribers who were added by import (rather than texting in) may have a blank value in this column.