Guide to Postscript Reports

Postscript strongly believes in SMS as an "owned-channel" and gives all brands the freedom to export their shop data when they want. In this article, we'll discuss each report available for export and provide resources to learn more about each specific report.

By having access to export your data, you: 

To navigate to your Reports page, select Analytics in the side menu of your Postscript dashboard, then select Reports.

Key Information

Subscriber Lists

When you navigate to your reports page, you can not only easily export your active subscriber list, but you can also export a list of people who have unsubscribed from your brand.

When you create a segment, you can download that segment. Once you select Download, the segment report will be available on your Reports page.

An active subscriber report includes the following information:

• Automation_and_campaign_texts_sent_count: The amount of combined automation and campaign messages sent to the subscriber.
• Customer_id: The customer's ID in Shopify.
• Email: The email associated with the subscriber.
• First_name: The subscriber's first name.
• Last_keyword_subscribed_to: The last keyword the subscriber replied with.
• Last_name: The subscriber's last name.
• Phone_number: The phone number associated with the subscriber's profile.
• Subscriber_created_at_UTC: The time the subscriber opted into your SMS program in Coordinated Universal Time.

An unsubscribed subscriber report includes the following information:

• Customer_id: The customer's ID in Shopify.
• Email: The email associated with the subscriber.
• First_name: The subscriber's first name.
• Keyword_subscribed_to: The last keyword the subscriber replied with.
• Last_name: The subscriber's last name.
• Opt_out_reason: The reason a subscriber has been opted out (Note: A subscriber's phone number will be removed if our records indicate it's been deactivated by carriers. Learn more about how Postscript protects you with automatic removals).
• Opt_out_time: The time the subscriber opted out of your SMS program
• Phone_number: The phone number associated with the subscriber's profile.
• Subscriber_created_at_UTC: The time the subscriber opted into your SMS program in Coordinated Universal Time.

Revenue Report

From your Reports page, you are able to export a revenue report that includes the last 90 days of revenue.

This revenue report includes the following information:

• Amount_in_cents: The revenue amount in cents that was attributed to a specific message.
• Minutes_from_view_or_click: How many minutes the subscriber took before clicking or viewing the message (whether a subscriber clicked or just viewed a message is also denoted in the report).
• Order_created_at: A timestamp of when the subscriber placed an order with your brand denoted in Coordinated Universal Time (UTC).
• Order_ID: The identifier associated with the order this subscriber placed (Note: Shopify uses Order Number, though you can cross reference order ID to find the associated order number in Shopify).
• Postscript_coupon_used_in_order: The specific Postscript coupon that was applied at checkout.
• Sent_message_time: A timestamp of when the message was sent to the subscriber denoted in Coordinated Universal Time (UTC).
• Text: The message copy sent to the subscriber.
• Type: Denotes if the message was an automation, campaign, keyword, etc.
• Type_name: The name of the campaign or automation as it's listed in Postscript.
• View_or_click: Denotes whether the subscriber clicked the message or viewed it.

Back in Stock Details

Our Back in Stock automation and list growth tool allows you to grow your subscriber list with high-intent users as well as reclaim potentially lost revenue. Within your Reports page, you are able to run a Back in Stock detail report containing several different data points. We've got two that we want to call out specifically and do so below the image. 

A Back in Stock Report includes the following information:

• Customer_id: The customer's ID in Shopify.
• Product_id. The ID number of the product that the subscriber would like to be notified when back-in-stock.
• Product_title.The title of the product that the subscriber would like to be notified when back-in-stock.
• Sent_at_UTC: A timestamp of when the back-in-stock message was sent to the subscriber denoted in Coordinated Universal Time (UTC).
• sku: The sku number of the product the subscriber would like to be notified when back-in-stock.
• Status: The status of the back-in-stock notification (e.g., queue means the product has not been restocked and the back in stock message has not been sent to the subscriber).
• Subscribed_at_UTC: A timestamp of when the subscriber opted into your SMS program in Coordinated Universal Time (UTC).
• Subscriber_id: The subscriber's ID in Postscript.
• Variant_id: The variant ID of the product that the subscriber would like to be notified when back-in-stock.
• Variant_title: The variant title of the product that the subscriber would like to be notified when back-in-stock.

Message Analytics

Message analytics gives you an aggregate overview of your message performance broken down into several criterion including revenue, unsubscribes, click-through rate, and more. Available data updates every 15 minutes.

If you wish to run your analysis of this data, you can export it to a spreadsheet by selecting the Export Data button between the graph and data table. This report will be available to download on your Reports page. You can learn more about message analytics here.

A Message Analytics report includes the following information:

• Archived: A true / false boolean indicating if the message type has been archived.
• Ctr: The aggregate click-through-ratio of the message. CTR is calculated by taking total clicks on all links divided by the total number of messages sent.
• Name: The title of the message (e.g., Browse Abandonment, Welcome Series, etc.).
• Orders: Number of orders attributed to that message.
• Revenue: Total revenue attributed to that message.
• Total_clicks: The aggregate number of clicks on links in the listed message.
• Total_failed: The total number of messages that were not delivered.
• Total_message_count_mms: The number of MMS (text messages with media) were sent.
• Total_message_count_sms: The number of SMS (text messages without media) were sent.
• Total_unsubs: The number of subscribers that opted out of your message after receiving this message (i.e., this was the last message received before they opted out).
• Type: Message type (i.e., campaign, keyword, double opt-in reply, automation, etc.).
• Type_id: The ID of the message. This ID number can also be found in the URL when editing your keyword, automation, campaign in the Postscript app.
• Unique_clicks: The number of clicks done by a unique subscriber (i.e., if the same person clicked the link three times, that is only 1 unique click). 
• Unique_CTR: The number of unique clicks divided by the total number of messages sent.
• Unsub_percentage: The percentage of subscribers who received this message and opted ou.

Subscriber Analytics

Subscriber analytics allow you to have a more in-depth understanding of your subscribers, their behavior, and the success of your various opt-in sources. Like with Message analytics, available data updates every 15 minutes. 

If you wish to run your analysis of this data, you can export it to a spreadsheet by selecting the Export Data button. This report will be available to download on your Reports page. You can learn more about subscriber analytics here.

A subscriber analytics report includes the following information:

• Earnings_per_message: [total revenue] / [# of messages delivered]
• Keyword: The keyword that subscriber last opted in with.
• Keyword_id: The ID of the keyword. This ID number can also be found in the URL when editing your keyword in the Postscript app.
• Messages_received: The amount of messages the subscriber has received from your brand.
• Opt_in_source: How the subscriber opted into your brand's SMS program (i.e, keyword, popup).
• Orders: The number of orders attributed to this message.
• Popup_id: The ID of the popup. This ID number can also be found in the URL when editing your popup in the Postscript app.
• Popup_name: The name of the popup in your Postscript account.
• Revenue: The total dollar amount attributed to that message.
• Revenue_per_subscriber: The total revenue / subscribers that received the message.
• Subscribers: The number of subscribers that message was sent to.

Response Labels Details

When you export your response labels detail report, you have an aggregated view of responses your subscribers sent you, their sentiment, customer and subscriber IDs, and the topic of the response. 

This report includes responses from the last 30 days.

A Response Labels Details Report includes the following information:

• Body: The contents of the message that you received from the subscriber.
• Customer_id: The customer's ID in Shopify.
• Received_date: The date and time the subscriber responded to your brand.
• Sentiment: The sentiment label of the response your brand received from the subscriber.
• Subscriber_ID: The subscriber's ID in Postscript.
• Topic: The topic of the response including; shipping, interest, payment, etc.

If you need to brush up on topic and sentiment labels for subscriber responses, we've got you covered with this guide.

Popup Analytics

With Postscript popups, you can view impression, engagement, and conversion metrics for both desktop and mobile popups. Postscript popups collecting phone numbers and email will see broken-out conversation metrics for each.

To export your popup analytics, head to your Reports page. Select Generate Report in the upper-right corner, then select Popup Analytics. When the report generates, select the Download button to save the spreadsheet to your device.

A popups analytics report includes the following information:

• Email_converisions: We calculate email conversation rate as (total impressions) / (# of visitors who subscribed to email) * 100
• Impressions: The number of times a pop up was presented to a shopper.
  • If doesn't matter if the popup has 1 or 2 steps, it only counts as one impression.
  • Every time a popup bubble in the bottom-left corner is opened, it counts as an additional impression.
  • If the bubble is present in the bottom-left corner, but not opened, it does not count as an impression.
• Engagements: The number of popup pages a shopper interacts with. (Note: an interaction is any click on a field/button, excluding the close button. If a subscriber interacts with one specific page multiple times, it counts as one engagement).
• Phone_conversions: We calculate phone conversation rate as (total impressions) / (# of visitors who subscribed to SMS) * 100
• Popup_id: The ID of the popup. This ID number can also be found in the URL when editing your popup in the Postscript app.
• Popup_name: The name of the popup in your Postscript account.

Subscriber Lifetime Value

When you export your Subscriber Lifetime Value (Subscriber LTV) report, the data displayed will depend on the time period you select. You can choose 7 days, 30 days, 60 days, or you can define a custom range.

The data included in this report includes a daily look at your ARMR scores -- Acquisition Rate, Revenue per Message, Messages per Subscriber, and Retention rate. It also includes your Subscriber LTV on a rolling 90 day average. You can do a deep dive into Subscriber LTV and ARMR (its contributing metrics) in this guide.

Before You Go

Get Support

Have questions? Please feel free to reach out to our wonderful Support team at support@postscript.io or via live chat. You can also submit a support request here!

Need ongoing channel strategy guidance? Please fill out this form and we'll connect you to one of our certified partners.