[Deprecated] SQL Mirror August 2025 Updates
Last updated: October 3, 2025
All future updates will be included in https://support.oneswitchboard.com/articles/3812514429-sql-mirror-changelog
📈 New Data
You can now access data about saved searches and about phone opt out sources.
The new tables are:
saved_searchessaved_search_result_phonessaved_search_result_emailsphone_opt_outs
We've also added a new column to the phones table called is_opted_out (more on that below!).
As always, head on over to our SQL mirror documentation to learn more about these new tables.
🐛 Bug Fixes
We recently improved alignment between the phone_messages table and phone_message_actions so that more actions data is available in phone_messages.
Several fields in phone_messages related to delayed message activities are not 100% complete. The most accurate sources for donations and actions data are phone_message_actions and actblue_donations. Read through the docs, including the updated note in phone_messages, for more information.
🔜 Future Plans
🚨Upcoming column removal🚨
At the beginning of October, we will be removing the column opt_in_status from the phones table. We recently added a new column called is_opted_out that contains similar information; please migrate to using that column between now and October.
Some additional details on these two columns:
The existing column, opt_in_status, is a string that contains one of three possible values, opted_out, opted_in, or unknown.
The new column, is_opted_out, is a boolean that is True if a phone has opted out (eg, if it would have the value opted_out in the old column). It does not contain information on if a phone is unknown vs opted in.
Please reach out to us at support@oneswitchboard.com if you have any questions or concerns about this change!