DataBot is an AI reporting tool that allows you to use natural language to pull reports on the data in your group. Click here to learn more about how it works. This feature is only available to partners who are part of Boost. Click here to learn more and join Boost.
Below are some useful queries you can use to make the best of use of DataBot. Use this as a starting point to see what it's capable of before writing your own queries!
Measure your digital program's effectiveness
Find new subscribers who joined your list through a source code
How many new subscribers on my list with the source code [your desired source code here] are still subscribed to the list?
Then, as a follow up:
How many have donated since January 1, 2026? What is the count of donations and the total amount raised in that that time period?
Action takers on specific action types by year
Give me counts for petition signers, letters sent from letter campaigns, form submits and event RSVPs broken down by year in 2025 and 2024.
See if buttons or text links generate more clicks
Do emails containing button links get more clicks than emails containing only text links? Consider emails sent over the past year from the [your group] group. Use click rate as the metric. Classify an email as a 'button email' if its HTML contains a button-like < a > (e.g. contains button or inline styles like background-color / border-radius).
Discover how email customization affects performance
Do emails sent from the [your group] group that have customized preview text get better open rates than emails that do not have customized preview text? Consider emails sent over the past two years.
Find which emails generated the highest number of actions
Please provide me with the subject lines and dates of the 5 emails sent in the last 60 days with the highest number of actions. Only include actions that were taken in the last 60 days.
Find actions that were most successful
What were the top actions taken from emails with [key word] in the admin name between [date range]? Produce a table with names of the actions, the types of actions, and the total number of action takers attributable to those emails.
Discover data about activists
Find misspelled email addresses
Find all subscribed email addresses with misspelled domains like yaho.com, yahoo.con, gnail.com, gmil.com, gmal.com and any similar variations. Give me a list of all of them with counts of how many of this variation are subscribed to my email list.
Then, as a follow up:
Now can you give me a list of all these full email addresses?
Find activists with missing data
Can you give me a list of 30-day actives who are missing first and/or last name? Anyone who subscribed, took any action, or opened or clicked on an email, is an active. Provide the results as export-ready columns including email address.
Find unused tags and custom fields
Show me a list of tags that haven’t been used or updated in the last 12 months with a count of how many records are attached to each one.
Then, as a follow up:
Do the same for custom fields.
Discover insights into your list's behavior
For activists on the [your group] list who have unsubscribed in the past year, how long on average did they stay on the list? Use the proxy start date of first time a source code was attached.
Note: I use a proxy start date here because the SQL database does not store when someone was first added to your list. Another proxy start date you could try is 'first recorded action'. In my testing, I found similar results for both versions of this query.
Then, as a follow up:
How many of the activists who unsubscribed in the past year had taken at least 3 actions within the past two years?
Get insights into group deliverability
Generate deliverability stats for emails in your group
Produce a data table including columns for DATE, ADMINISTRATIVE NAME, OPEN RATE, and CLICK RATE including all emails in the [group name] group with "[key word]" in the administrative title. Show click and open rates as percentages, not raw numbers.
Uncover deliverability trends
What day of the week do I get the highest open rates on my emails? What about click rates?
Find the best performing emails in your group
What were my top 5 emails over the past 6 months in terms of clicks/open ratio? Please only include emails that went to at least [a significant number for your list size] activists.
Identify poor performing emails
Show me the 10 emails sent from the [your group] group with the highest spam complaint rates over the past three years. Include the subject line, administrative title, open rate, spam complaint rate, and date and time of each email. Only include emails sent to at least 10,000 people.
Find segments of key activists
Filter and sort action takers
Show me a data table with the number of activists who took action on the form with the administrative title [ADMIN TITLE OF ACTION] in the past year, arranged by week. For weeks with 0 activists who took action, include the week in the table and note that 0 activists took action.
Find top action takers in your group
How many activists on my list have taken at least 5 actions in the past year?
Then, as a follow up:
What are the top 5 source codes for those activists?
Track who clicked on a specific link in an email
Send me a list of all activists who clicked on the link with link_id=[your link ID] on the email with Email ID [your email ID]. Include the email address and first and last name for each activist.
Find recently engaged activists
Give me a breakdown of how many activists on the [your group] list have subscribed, opened or clicked an email, or taken action per week since [date].
Categorize your activists based on engagement levels
Show me the number of activists in the [your group] group who fall under each of the following categories. Category 1: Activists who have opened, clicked, taken action, or subscribed in the past 90 days. Category 2: Activists who have opened, clicked, taken action, or subscribed between 91 and 180 days ago. Category 3: Activists who have opened, clicked, taken action, or subscribed between 181 and 270 days ago. Category 4: Activists who have opened, clicked, taken action, or subscribed between 271 and 360 days ago. Category 5: Activists who have not opened, clicked, taken action, or subscribed in the past 360 days. Taken action should include all action types in the [your group] group. Subscribed should mean joined the [your group] list. Use the following groups: [your group name as it appears in the URL — see note below].
Note: In the last sentence of this query I specified the group names based on what appears in the group URL. For example, if your group's URL is actionnetwork.org/groups/your-group-name/, list your-group-name in the query.
Other useful queries
Track list growth over time
Show me a chart with the new to list activist count for the [your group name] group per month since [month, year].
Get a mobile cost estimate based on actual usage
How many SMS segments were sent from the [your group] group in [month, date, year — whatever period of time you want]? What was the estimated cost of sending those SMS segments during that time period? SMS segment cost is $[dollar amount]/segment.