Syncing NPS Responses

Step 1 - Query

After connecting to your warehouse, you can start syncing NPS Responses by configuring the query that Vitally will run against your warehouse on each sync.

Once you've entered your query, be sure to click the Preview Query button, which will execute your query against your warehouse and return the first row fetched from your targeted table.

You'll use the previewed query and returned row further along in the configuration below.

Incremental Sync

Incremental sync is a process of syncing warehouse data that has only been added or modified since the last sync cycle, instead of processing the entire dataset each time. This approach is more efficient as it minimizes the amount of data queried and processed during each sync, making the update process quicker and resource-efficient.

Incremental sync is required for syncing NPS Responses

In order to incrementally query your data each sync, you'll need to add a clause to your query with the variable $LAST_SYNC_TIMESTAMP. We'll fill in that variable with the timestamp of the last sync each time we query the warehouse.

Incremental syncs should compare the $LAST_SYNC_TIMESTAMP with a timestamp that reflects when the data was synced to the data warehouse. This is particularly important when data is synced to the data warehouse in batches.

SELECT id, "userId", score, feedback, "respondedAt"
FROM "Nps_Session"
WHERE "respondedAt" > $LAST_SYNC_TIMESTAMP;

Step 2 - Configure

Once you input and preview your query, you'll be presented with a few additional configuration options to map the columns from your SELECT statement to the required Vitally fields.

Step 3 - Continue Configuration

If you have other features to sync continue configuring those.

pageConfiguring Sync

OR Step 3 - Enable Sync

pageEnabling Sync