Integration Specifications

This article will help you learn about how Daasity replicates data from Postscript, limitations to the data we can extract, and where the data is stored in the Postscript schema.

Integration Overview

Postscript is an SMS marketing platform that helps you communicate with customers and prospective customers.

The Daasity Postscript integration helps get you data on messages sent through the platform, subscribers, and order attribution.

Integration Availability

This beta integration is available for:

• Enterprise

• Growth

Entity Relationship Diagram (ERD)

Click here to view the ERD for the Daasity Postscript integration illustrating the different tables and keys to join across tables.

Postscript Schema

• Attribution

• Messages (Dimension)

• Messages (Fact)

• Platform Action Details

• Platform Actions

• Shops

• Subscribers

Attribution

• Table Name: [postscript.fct_attribution]

Export Column	Database Column
ATTRIBUTION_ID	ATTRIBUTION_ID
MESSAGE_ID	MESSAGE_ID
ORDER_ID	ORDER_ID
AMOUNT_IN_CENTS	AMOUNT_IN_CENTS
ACTION_TYPE	ACTION_TYPE
COUPON_USED	COUPON_USED
SHOP_ID	SHOP_ID
SUBSCRIBER_ID	SUBSCRIBER_ID
CUSTOMER_ID	CUSTOMER_ID
MINUTES_FROM_ACTION	MINUTES_FROM_ACTION
ORDER_CREATED_AT	ORDER_CREATED_AT
_UPDATED_AT	_UPDATED_AT
__SYNCED_AT	__SYNCED_AT

Messages (Dimension)

• Table Name: [postscript.dim_messages]

Export Column	Database Column
MESSAGE_ID	MESSAGE_ID
SHOP_ID	SHOP_ID
POSTSCRIPT_MESSAGE_ID	POSTSCRIPT_MESSAGE_ID
DIRECTION	DIRECTION
MESSAGE_SERVICE	MESSAGE_SERVICE
FAILED_AT	FAILED_AT
FAILED	FAILED
TEXT	TEXT
MEDIA_URL	MEDIA_URL
TYPE	TYPE
TYPE_NAME	TYPE_NAME
_UPDATED_AT	_UPDATED_AT
__SYNCED_AT	__SYNCED_AT

Messages (Fact)

• Table Name: [postscript.fct_messages]

Export Column	Database Column
MESSAGE_ID	MESSAGE_ID
SHOP_ID	SHOP_ID
DIRECTION	DIRECTION
SUBSCRIBER_ID	SUBSCRIBER_ID
CREATED_AT	CREATED_AT
_UPDATED_AT	_UPDATED_AT
__SYNCED_AT	__SYNCED_AT

Platform Action Details

• Table Name: [postscript.dim_platform_action_details]

Export Column	Database Column
PLATFORM_ACTION_DETAIL_ID	PLATFORM_ACTION_DETAIL_ID
ACTION_TYPE	ACTION_TYPE
SHOP_ID	SHOP_ID
ACTION_DATA	ACTION_DATA
_UPDATED_AT	_UPDATED_AT
__SYNCED_AT	__SYNCED_AT

Platform Actions

• Table Name: [postscript.dim_platform_actions]

Export Column	Database Column
PLATFORM_ACTION_ID	PLATFORM_ACTION_ID
PLATFORM_ACTION_DETAIL_ID	PLATFORM_ACTION_DETAIL_ID
ACTION_TYPE	ACTION_TYPE
SHOP_ID	SHOP_ID
SUBSCRIBER_ID	SUBSCRIBER_ID
MESSAGE_ID	MESSAGE_ID
ACTION_PERFORMED_AT	ACTION_PERFORMED_AT
_UPDATED_AT	_UPDATED_AT
__SYNCED_AT	__SYNCED_AT

Shops

• Table Name: [postscript.dim_shops]

Export Column	Database Column
SHOP_ID	SHOP_ID
ENTITY_NAME	ENTITY_NAME
_UPDATED_AT	_UPDATED_AT
__SYNCED_AT	__SYNCED_AT

Subscribers

• Table Name: [postscript.dim_subscribers]

Export Column	Database Column
SUBSCRIBER_ID	SUBSCRIBER_ID
POSTSCRIPT_SUBSCRIBER_ID	POSTSCRIPT_SUBSCRIBER_ID
SHOP_ID	SHOP_ID
IS_INTERNATIONAL	IS_INTERNATIONAL
DO_NOT_SEND_AT	DO_NOT_SEND_AT
TRANSACTIONAL_ONLY	TRANSACTIONAL_ONLY
DO_NOT_SEND	DO_NOT_SEND
DO_NOT_SEND_REASON	DO_NOT_SEND_REASON
PHONE_NUMBER	PHONE_NUMBER
CREATED_AT	CREATED_AT
_UPDATED_AT	_UPDATED_AT
__SYNCED_AT	__SYNCED_AT