Follow this integration guide to connect your Postscript data to SourceMedium.
Postscript is the leading SMS marketing platform for Shopify brands. SourceMedium syncs Postscript message events, subscriber actions, and attribution data to your warehouse. Every sent SMS is tracked through delivery, click, and attributed order, giving you full send-to-revenue visibility by flow and campaign type.Requirements
- Active Postscript account connected to your Shopify store
- Postscript API key with read access
Steps
- In Postscript, navigate to Settings in the left sidebar
- Select API under the Developer section
- Generate a new API key and label it SourceMedium
- Share the API key with your SourceMedium account manager or send it to integrations@sourcemedium.com
What data syncs
| Field | Description |
|---|---|
sms_unique_sends | Count of outbound SMS messages sent per campaign or flow |
message_unique_bounces | Count of messages that bounced or failed delivery |
message_unique_clicks | Count of link clicks from SMS messages |
platform_reported_orders | Orders attributed to SMS sends by Postscript |
platform_reported_order_revenue | Revenue attributed to SMS sends by Postscript |
message_type (automation vs broadcast) and message_name (the campaign or flow name).
Primary table: rpt_outbound_message_performance_daily
Query with source_system = 'postscript' and sm_message_channel = 'sms' to filter to Postscript SMS data, or compare directly against Klaviyo email in the same table.
Questions you can answer
- What is our SMS click-through rate by flow type this month?
- Which Postscript campaigns drove the most attributed revenue last quarter?
- How does SMS delivery failure rate trend over time?
- What is the average time from SMS send to placed order for our welcome flow?
- Compare Postscript SMS revenue vs Klaviyo email revenue for the same period
- Which message type (automation vs broadcast) has the higher revenue-per-send?
Notes
- Postscript message data is available at daily granularity, grouped by message type and campaign name.
- Attribution uses Postscript’s native attribution window (
minutes_from_actionfield available for custom window analysis). - Historical data backfill is available upon request.