Rokt Lite
Rokt is a software platform that personalizes customer interactions during transactions.
Features
Feature Name | Supported | Notes |
---|---|---|
Capture deletes | check | CAMPAIGN_METADATA table |
History mode | ||
Custom data | ||
Data blocking | check | |
Column hashing | check | |
Re-sync | check | |
API configurable | check | API configuration |
Priority-first sync | ||
Fivetran data models | ||
Private networking | ||
Authorization via API | check |
Setup guide
Follow our step-by-step Rokt setup guide to connect Rokt with your destination using Fivetran connectors.
Sync overview
To capture new records, we incrementally sync the following tables and their child tables:
ACCOUNT_SUMMARY
ACCOUNT_TRANSACTION_BREAKDOWN
ACCOUNT_TRANSACTION_OVERVIEW
ACCOUNT_CAMPAIGN_BREAKDOWN
CAMPAIGN_BREAKDOWN_AUDIENCE
CAMPAIGN_BREAKDOWN_COUNTRY
CAMPAIGN_BREAKDOWN_CREATIVE
CAMPAIGN_BREAKDOWN_SUBVERTICAL
CAMPAIGN_HISTOGRAM
We sync the metadata of all the tables into the CAMPAIGN_METADATA
table.
Schema information
This schema applies to all Rokt connectors.
Explore Rokt schema ERD