Skip to main content
Postscript is an SMS marketing platform. SourceMedium lands Postscript data through Data Warehouse Push to BigQuery: messages, clicks, subscribers, unsubscribes, and order attribution. Postscript pushes the data into your warehouse; there is no API key to paste. Data Warehouse Push is in beta for Postscript Enterprise brands, so ask your Postscript CSM to enable it first. Who can self-serve: Pro, which delivers a dedicated BigQuery project you administer. On Foundation, the shared project, SourceMedium creates the destination. Use Request integration in Connect. See Foundation and Pro.
You connect data sources yourself in SourceMedium. Sign in to your SourceMedium account, open your store, then in the Data sources section click Connect data source and choose the platform. You need an Editor or Admin role on the store. If you have view-only access, ask an admin or editor on your team to connect it.Once it is connected, what happens next covers first-sync timing and what each connection status means.

​
Vendor documentation

You share a GCP project ID and a Cloud Storage staging bucket name with Postscript. Postscript sends a Prequel connection link. You complete that link so Postscript never sees your credentials. Historical data is pushed first, then new data every hour.

​
Foundation: request integration

Foundation delivers a shared project, so you cannot create the bucket or dataset yourself.
  1. In SourceMedium, open Connect a data source and find Postscript.
  2. Enter your Postscript account or Shopify shop domain and click Request integration.
  3. That opens a support ticket. SourceMedium creates the destination and coordinates Data Warehouse Push with Postscript. The card shows Setting up.
Do not email credentials.

​
Pro: self-serve BigQuery destination

Pro delivers a dedicated BigQuery project you administer. Connect shows the project ID.

​
What you need

  • Postscript Enterprise with Data Warehouse Push enabled (ask your Postscript CSM)
  • Access to your dedicated GCP project (Connect shows the project ID)

​
How to connect

1

Create a staging bucket

In Cloud Storage, in the same dedicated project, create a bucket Postscript can stage files in. Note the bucket name and region.
2

Share the project ID and bucket with Postscript

Send your Postscript contact the project ID from Connect and the bucket name. Postscript’s BigQuery guide lists those two fields.
3

Complete the Prequel connection link

Postscript sends a secure Prequel link. Open it and finish BigQuery setup (dataset, service account, permissions) there. Postscript never sees the credentials.
4

Confirm in SourceMedium

Click Connect on Postscript in SourceMedium so we can mark the source as in setup and start reading the tables.

​
What data syncs

Messages, clicks, order attribution, subscribers, and unsubscribes. Grain and columns follow Postscript’s warehouse tables. Historical data is included in the first push.

​
Notes

  • Data Warehouse Push cannot be customized; Postscript sends the full set above.
  • SourceMedium no longer pulls Postscript through its API. Data Warehouse Push is the only path.