We are excited to be launching support for SMS (texting) of our survey invitations. This new feature requires us to make some changes to the ClearlyRated dashboard reports. With that, an additional data field called ‘contact_sms’ will be included in the existing reports that are available to be exported from our software. This change may impact you depending on how you use these reports.

Below is a summary of the changes that will go into effect Wednesday January 29th at 8PM PST:

  • All Sent report download:
    • Added a new column called ‘contact_sms’ to be added after ‘contact_email’ column.  It will contain the SMS number of the contact if one exists.
    • Renamed the ‘bounce’ column to be ‘bounce_email’.  Content of the column will not change.
    • Added a new column called ‘bounce_sms’ after ‘bounce_email’ column.  It will contain true/false indication of whether that contact had a bounced SMS.
    • Renamed the ’email_notifications’ column to be ‘detractor_notifications’.  Content of the column will not change.
  • All Bounced report download:
    • Added a new column called ‘contact_sms’ to be added after ‘contact_email’ column.  It will contain the SMS number of the contact if one exists.
    • Renamed the ‘bounce’ column to be ‘bounce_email’.  Content of the column will not change.
    • Added timezone indication to the date/time value in the ‘bounce_email’ column.
    • Added a new column called ‘bounce_sms’ after ‘bounce_email’ column.  It will contain the date/time with timezone that the contact had an SMS bounce.
    • Renamed the ’email_notifications’ column to be ‘detractor_notifications’.  Content of the column will not change.
  • All Unsubscribed report download:
    • Added a new column called ‘contact_sms’ to be added after ‘contact_email’ column.  It will contain the SMS number of the contact if one exists.
    • Renamed the ‘unsubscribe’ column to be ‘unsubscribe_email’.  Content of the column will not change.
    • Added timezone indication to the date/time value in the ‘unsubscribe_email’ column.
    • Added a new column called ‘unsubscribe_sms’ after ‘unsubscribe_email’ column.  It will contain the date/time with timezone that the contact unsubscribed via SMS.
    • Renamed the ’email_notifications’ column to be ‘detractor_notifications’.  Content of the column will not change.
  • All Contacts, All Non-Responses, All Responses, Detractor Responses, Testimonial Responses, Shout Outs Responses report downloads:
    • Added a new column called ‘contact_sms’ to be added after ‘contact_email’ column.  It will contain the SMS number of the contact if one exists.
    • Renamed the ’email_notifications’ column to be ‘detractor_notifications’.  Content of the column will not change.

We recognize this might cause problems with internal tools you or your team may have built.  We apologize for that and we want you to know that we work very hard to limit our changes to these exports as much as possible.  We hope by giving you this heads up that you will have some time to adapt to the new downloads.

Please don’t hesitate to reach out to me with any questions or concerns!


Tracy Streebel
Vice President, Product
ClearlyRated – 503.542.3331
[email protected]