Data tables

Data tables represent a unified view of your customers, including customer profiles, transactions and interactions, Stitch results, and predictive modeling.

The following diagram shows the data model for core tables in Amperity. Color coded sections identify which groups of tables are associated with customer profiles, interactions records, Stitch QA, and predictive modeling.

Note

Click this diagram to open it in your full browser window. Click HERE to open this diagram in a new tab or right-click that link to save a copy to your computer.

The core data model for Amperity.

Amperity data tables

Click any of the following cards to open a page about that table.

Activation States
Activation States tables
All Opted-in Emails
All Opted-In Emails table
Campaign Recipients
Campaign Recipients table
Customer 360
Customer 360 table
Customer Attributes
Customer Attributes table
Detailed Examples
Detailed Examples table
Email AmpID Assignment
Email AmpID Assignment table
Email Engagement Attributes
Email Engagement Attributes table
Email Engagement Summary
Email Engagement Summary table
Email Opt Status
Email Opt Status table
Event Propensity
Event Propensity table
Fiscal Calendar
Fiscal Calendar table
Merged Customers
Merged Customers table
Merged Households
Merged Households table
PII
PII table
Predicted Affinity
Predicted Affinity table
Predicted CLV Attributes
Predicted CLV Attributes table
SMS Opt Status
SMS Opt Status table
Stitch Blocking Keys
Stitch Blocking Keys table
Stitch Blocklist Values
Stitch BlocklistValues table
Stitch Scores
Stitch Scores table
Transaction Attributes Extended
Transaction Attributes Extended table
Unified Changes Clusters
Unified Changes Clusters table
Unified Changes PKs
Unified Changes PKS table
Unified Coalesced
Unified Coalesced table
Unified Customers
Unified Customer table
Unified Email Events
Unified Email Events table
Unified Itemized Transactions
Unified Itemized Transactions table
Unified Loyalty Events
Unified Loyalty Events table
Unified Loyalty
Unified Loyalty table
Unified Paid Media
Unified Paid Media table
Unified Preprocessed Raw
Unified Preprocessed Raw table
Unified Product Catalog
Unified Product Catalog table
Unified Scores
Unified Scores table
Unified Transactions
Unified Transactions table