SQL Mirror Changelog

Last updated: November 6, 2026

Below is a log of changes to Switchboard's SQL Mirror. For more information about the SQL Mirror, including onboarding information and data reference, see the full collection of SQL Mirror documentation. For any feedback or questions, please  email support@oneswitchboard.com.

For changes to Switchboard's API, see the API changelog.

October 2026

Broadcast A/B Test Data

  • Added the broadcast_versions table. For broadcasts that use the A/B testing feature, data about each version of the broadcast is stored in this table, including the message_text, and all of its stats like clicks, donations, and amount_raised.

    • For any broadcast that uses A/B testing (broadcasts.is_ab_test = True), there are some changes to the broadcasts table. The broadcasts.message_text and broadcasts.media_urls columns are now null, because there is no canonical text for that broadcast, each version of it has different text. You can join the broadcasts table to broadcast_versions to be able to get all of the possible message_text and media_urls values for the broadcast. If a winner version was chosen out of the multiple versions, that id is represented in broadcasts.winner_version_id. All of the stats columns (e.g. clicks, donations, etc) are available per version in the broadcast_versions table, and also in total on the broadcasts table.

Broadcasts & Email Blasts

We identified a bug where the following columns showed 0 or null instead of the real message counts:

  • broadcasts: failed_to_deliver, skipped, and previously_opted_out

  • email_blasts: failed_to_deliver, skipped and previously_unsubscribed

This bug has been fixed in both tables, including for past broadcasts and email blasts.

September 2026

Saved Searches

We identified a bug in saved_search_result_phones and saved_search_results_emails where result phones & emails were not populating for saved searches that had been edited and rerun after changing the original search criteria. This bug has now been resolved for both mirror tables, and all results should be correct and available in the mirror.

August 2026

[Existing content continues unchanged.]