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.

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 360

table_customer_360.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

Fiscal Calendar

table_fiscal_calendar.html

Merged Customers

table_merged_customers.html

Merged Households

table_merged_households.html

PII

table_pii.html

Predicted Affinity

table_predicted_affinity.html

Predicted CLV Attributes

table_predicted_clv_attributes.html

SMS Opt Status

table_sms_opt_status.html

Stitch Blocking Keys

table_stitch_blocking_keys.html

Stitch Blocklist Values

table_stitch_blocklistvalues.html

Stitch Scores

table_stitch_scores.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 Loyalty

table_unified_loyalty.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 Scores

table_unified_scores.html

Unified Transactions

table_unified_transactions.html