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.

All Opted-in Emails
table_all_opted_in_emails.html
Campaign Recipients
table_campaign_recipients.html
Customer Attributes
table_customer_attributes.html
Detailed Examples
table_detailed_examples.html
Email AmpID Assignment
table_email_ampid_assignment.html
Email Engagement Attributes
table_email_engagement_attributes.html
Email Engagement Summary
table_email_engagement_summary.html
Email Opt Status
table_email_opt_status.html
Event Propensity
table_event_propensity.html
Merged Customers
table_merged_customers.html
Merged Households
table_merged_households.html
Predicted Affinity
table_predicted_affinity.html
Predicted CLV Attributes
table_predicted_clv_attributes.html
Stitch Blocking Keys
table_stitch_blocking_keys.html
Stitch Blocklist Values
table_stitch_blocklistvalues.html
Transaction Attributes Extended
table_transaction_attributes_extended.html
Unified Changes Clusters
table_unified_changes_clusters.html
Unified Changes PKs
table_unified_changes_pks.html
Unified Coalesced
table_unified_coalesced.html
Unified Customers
table_unified_customers.html
Unified Email Events
table_unified_email_events.html
Unified Itemized Transactions
table_unified_itemized_transactions.html
Unified Loyalty Events
table_unified_loyalty_events.html
Unified Paid Media
table_unified_paid_media.html
Unified Preprocessed Raw
table_unified_preprocessed_raw.html
Unified Product Catalog
table_unified_product_catalog.html
Unified Transactions
table_unified_transactions.html