How it works?
The process of syncing data into SuprSend is a ETL process wherein:1
2
Create a list or choose an existing list to sync data:
The data extracted from your database will always be synced into a list of users. List is a cohort of users whom you would want to send notification.
3
Write SQL query to extract and transform data:
Once your database connection is setup, you can write SQL query to extract the data required for list and user profile sync. This will first create/update user profile and then load it into the list. Make sure that you optimize the query so that it only returns the rows and columns that you need. You can also user
{{last_sync_time}}
in case of recurring sync to only return the data that changed after your last successful sync. Know more about setting up your sync task here4
Setup sync to load the transformed data into your list:
Once you have written and tested your SQL query, you can save it and Commit setup list sync. It can be a one time list sync for sending one time campaigns like announcements, reminder to users who registered for an event, or a recurring sync for sending crons or regular scheduled notifications like send card abandonment notification to users who left items in their in the last 7 days, onboarding sequences, payment reminders etc.