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.

Data tables: Campaign Recipients ● Customer 360 ● Customer Attributes ● Detailed Examples ● Email Engagement Attributes ● Email Engagement Summary ● Merged Customers ● Predicted Affinity ● Predicted CLV Attributes ● Stitch Blocking Keys ● Stitch Scores ● Transaction Attributes ● Transaction Attributes Extended ● Unified Changes Clusters ● Unified Changes PKS ● Unified Coalesced ● Unified Customer ● Unified Email Events ● Unified Itemized Transactions ● Unified Preprocessed Raw ● Unified Product Catalog ● Unified Scores ● Unified Transactions

Data templates¶

About data templates ● File templates

Common settings: .DONE files ● Encoding methods ● Escape characters ● File formats ● Filename templates ● Header rows ● Line endings ● Quote modes
Specific settings: Amazon S3 ● Azure Blob Storage ● Google Cloud Storage ● SFTP ● API templates ● Snowflake templates
How-tos: Add data template ● Allow to send queries ● Allow to send PII ● Delete data template ● Edit data template ● Enable success file ● Map to external schemas ● Make available to campaigns

Databases¶

Core tables

About core tables ● Standard core tables ● Custom core tables

Core table how-tos Add custom core table ● Delete custom core table ● Edit custom core table ● Search core tables ● View core tables ● View SQL for core table

Databases

About databases ● Flexible merge rules ● Customer 360 database ● Empty database ● Multiple customer 360 databases ● Passthrough database ● Stitch QA database ● Custom SQL ● Passthrough ● Visual templates

Database how-tos Activate database ● Add customer 360 database ● Add empty database ● Add passthrough database ● Add Stitch QA database ● Configure permissions ● Delete database ● Download schema ● Duplicate database ● Edit database ● Explore database ● Export database ● Run database ● View all databases ● View database ● View permissions ● View recent activity ● View run history

Database table how-tos Add core table override ● Add custom SQL table ● Add passthrough table ● Add visual template table ● Allow table in segments ● Apply table semantic tags ● Copy database table ● Delete database table ● Discard draft table ● Edit database table ● Enable table versioning ● Enforce static table schemas ● Export database table ● Hide database table ● Mark columns as PII ● Configure pick-lists ● Set validation rules

Profiles

Customer profiles ● About profile attributes ● Refresh customer profile icons

Domain tables¶

About domain tables ● Column types ● Customer records ● Interaction records ● Custom domain tables ● Domain SQL

Domain SQL examples: Combine day, month, year as birthdate ● Combine five- and four-digit postal codes ● Extract first and last names ● Hash PII data that has been resent to Amperity ● Parse fields with multiple separators ● Set non-US-ASCII email addresses to NULL ● Standardize values for USA states
How-tos: Add domain table ● Add custom domain table ● Delete domain table ● Delete records ● Edit domain table ● Explore domain table ● View sample data ● View schema ● Purge domain table ● Rename domain table ● Search domain tables ● View domain table ● View domain table history

Feeds¶

About feeds ● Feed Editor ● Apply semantic tags

Field types: Boolean ● Date ● Datetime ● Decimal ● Float ● Integer ● String
How-tos: Activate feed ● Add column ● Add feeds from new sources ● Add feeds from existing sources ● Add field ● Add foreign key ● Apply custom semantic tags ● Apply customer profile (PII) semantic tags ● Apply transaction semantic tags ● Edit primary key ● Delete columns ● Delete fields ● Edit domain table name ● Generate combined keys ● Generate customer keys ● Generate foreign keys ● Incoming field names ● Load new data ● Make available to Stitch ● Rename fields ● Replace data source ● Resolve name conflicts ● Set error thresholds ● Set last updated field ● Set error thresholds ● Truncate feed ● View sample data

File formats¶

About file formats ● Apache Avro ● Apache Parquet ● CBOR ● CSV ● DAT ● JSON ● NDJSON ● PSV ● Streaming JSON ● TSV ● XML

Ingest queries¶

About ingest queries ● Spark SQL

Example courier load operations: Apache Avro ● Apache Parquet ● CBOR ● CSV ● JSON ● NDJSON ● PSV ● Streaming JSON ● TSV ● XML
Example ingest queries: Build birthdate ● Concatenate columns ● Explode transactions ● Find records ● Flatten with identifiers ● Import billing as address ● JOIN datasets ● Parse nested records ● Remove field ● Select all fields
How-tos: Add ingest query ● Add to courier as load operation ● Delete ingest query ● Edit ingest query

Orchestration groups¶

About orchestration groups ● Run after courier group ● Run on a schedule ● Run manually

Orchestrations¶

About orchestrations

How-tos: Add orchestration ● Assign database export ● Assign query ● Delete orchestration ● Edit orchestration ● Manually ● Scheduled, always run ● Scheduled, wait for changes ● Wait for changes

Policies¶

About policies ● How policies work

Standard policies: Amp360 User ● AmpIQ User ● DataGrid Administrator ● DataGrid Operator
Policy options: Allow API key administration ● Allow Profile API administration ● Allow sandbox administration ● Allow source data deletion ● Allow user administration ● Restrict data exports ● Restrict download access ● Restrict PII access ● Restrict upload access
Read-only policies: Amp360 User ● AmpIQ User ● DataGrid Operator
Allowed actions: Sources ● Stitch ● Customer 360 ● Queries ● Segments ● Campaigns ● Destinations ● Workflows ● Users & Activity ● Credentials ● Data Explorer ● Sandboxes

Predictive models¶

Churn propensity ● Predicted CLV ● Product affinity ● Event propensity

Presto SQL¶

About Presto SQL

General recommendations: General recommendations ● Commas ● Indentation ● Naming conventions ● NULL values ● Reserved words ● One-way SHA-256 hashes ● Whitespace
SELECT statements, operators, and clauses: WITH clause ● SELECT statement ● SELECT DISTINCT statement ● FROM clause ● LEFT JOIN clause ● WHERE clause ● CASE expression ● GROUP BY clause ● HAVING clause ● UNION clause ● UNNEST clause ● VALUES clause ● Window functions ● ORDER BY clause ● LIMIT clause ● Operators ● PIVOT operator
Functions: ARRAY_AGG() ● ARRAY_JOIN() ● AVG() ● CAST() ● CHR() ● COALESCE() ● CONCAT() ● COUNT() ● CURRENT_DATE ● CURRENT_TIMESTAMP ● DATE_DIFF() ● DATE_FORMAT() ● DATE_TRUNC() ● DAY(), MONTH(), YEAR() ● DENSE_RANK() ● FROM_UNIXTIME() ● GREATEST() ● IF() ● LEAST() ● LENGTH() ● LOWER() ● MAX() ● MEDIAN() ● MIN() ● NOW() ● NTILE() ● PERCENT_RANK() ● PERCENTILE() ● RANK() ● REGEXP_EXTRACT() ● REGEXP_LIKE() ● REGEXP_REPLACE() ● REPLACE() ● ROUND() ● SPLIT() ● SPLIT_PART() ● SUBSTR() ● SUM() ● TO_HEX() ● TO_UNIXTIME() ● TRIM() ● TRY_CAST() ● UPPER()

Queries¶

About queries ● Queries page

Data explorer: About the data explorer ● Docked mode ● Full screen mode ● Table schema ● Completion ● Cardinality vs. uniqueness ● Table examples ● Table details
Query editor: Query editor ● About Presto SQL ● Validate queries
How-tos: Add comment to query ● Add as SQL query ● Add as visual query ● Add to orchestration ● Autocomplete table names ● Browse tables and columns ● Comment lines ● Copy column names ● Add as copy ● Copy SELECT statement ● Delete query ● Discard a draft query ● Download query ● Edit query ● Enable query alerts ● Format SQL ● Open query ● Organize queries ● Add folder ● Add subfolder ● Move query ● Preview results ● Refresh query automatically ● Rename query ● Run query ● Run selection ● Select database ● Uncomment lines ● Use keyboard shortcuts ● View notifications ● View recently edited queries ● View related orchestrations ● View query ● View query details

Recent activity¶

About notifications

Sandboxes¶

About sandboxes ● Allow sandbox administration ● About sandbox workflows

Best practices: Continuous validation ● Data across environments ● Run partial workflows ● Short-lived sandboxes
How-tos: Access a sandbox ● Add a sandbox ● Delete a sandbox ● Edit sandbox details ● Open a sandbox ● Pull updates from production ● Promote changes ● Resolve validation issues ● Review changes ● View sandbox details ● View validation details

Segments¶

About the Segments page ● Recommended segments ● Segment tabs ● Summary tab ● Breakdown tab ● Compare tab ● Customers tab

Segment Editor: Segment names ● Inclusions ● Exclusions ● AND vs. OR ● Segment conditions ● Attributes ● Customer lists ● Purchase behaviors ● Operators ● Boolean ● Date ● Datetime ● Decimal ● Integer ● String ● NULL and NOT NULL values ● Relative dates ● Segment insights ● Databases and tables ● SQL Editor
How-tos:: Add attribute from table ● Add conditions ● Add exclusions ● Add folders ● Add purchase behaviors ● Use query ● Add sections ● Use segment ● Add subfolders ● Use uploaded file ● Bulk delete segments ● Bulk move segments ● Choose AND/OR from toggle ● Change comparison date range ● Change insights date range ● Change baseline comparison ● Change database source ● Add comment to SQL segment ● Compare segment insights ● Set recommended segments ● Copy a column to the clipboard ● Copy a segment ID ● Copy a SQL Query ● Create a campaign ● Customer lists ● New segment from intersection ● Create SQL segment in a folder ● Create segment in a folder ● Customize comparison charts ● Delete a segment ● Download segment ● Duplicate segment ● Edit segment from Segments page ● Edit segment from Segment Editor ● Expand a graph ● Explore a segment copy ● Format a SQL segment ● Move segment ● Organize segments ● Rename a segment ● Rerun a segment ● Save segment to a folder ● Search segments ● Configure overlap chart ● Select database ● Select multiple values ● Set default charts ● Show columns ● Switch to SQL segment ● Use relative dates ● View a segment ● View edit history ● View matching records ● View overlap between segments ● For attribute charts ● For revenue tree ● For statistics

Semantic tags¶

About semantic tags ● Blocklist ● Compliance ● Custom ● Database ● Email events ● Email opt-in status ● Email summary ● Keys ● Loyalty programs ● Profile (PII) ● SMS opt-in status ● Stitch labels ● Transactions

Settings¶

User settings: About user settings ● Add users ● Delete users ● Edit users ● Revoke tenant access ● Allowed domains
Security settings: About security settings ● About SSO group mappings ● About resource groups ● “All resource groups” ● Custom resource groups ● Assign users to resource groups ● Database permissions ● Multi-brand tenants ● About API keys
Credentials: About credentials
Sandbox settings: About sandbox settings
Integrations: About integrations ● About BI Connect ● Add BI Connect users ● About Slack
Activity logs: About activity logs ● Download user activity ● User activity event types

Single sign-on (SSO)¶

About single sign-on (SSO) ● How SSO works (with Amperity) ● Use cases ● Request to enable

Spark SQL¶

About Spark SQL

General recommendations: General recommendations ● Add comments ● Avoid low cardinality ● Avoid multiple passes ● Commas ● Escape characters ● Daisy-chain LEFT JOINs ● Faster operations are better ● Filter, then combine ● Identifiers ● Indentation ● Limit expensive operations ● Limit extra work ● Limit tables ● Load sizes ● Naming conventions ● NULL values ● One-way SHA-256 hashes ● Reserved words ● Subqueries ● Temporary tables ● Whitespace
SELECT statements, operators, and clauses: WITH clause ● LATERAL VIEW clause ● SELECT statement ● SELECT DISTINCT statement ● FROM clause ● JOIN clauses ● WHERE clause ● CASE expression ● GROUP BY clause ● HAVING clause ● Window functions ● ORDER BY clause ● LIMIT clause ● Operators ● PIVOT operator
Functions: ABS() ● AVG() ● CAST() ● COALESCE() ● COLLECT_LIST() ● COLLECT_SET() ● CONCAT() ● COUNT() ● COUNT(DISTINCT) ● CURRENT_DATE() ● CURRENT_TIMESTAMP() ● DATE() ● DATE_ADD() ● DATE_TRUNC() ● DATEDIFF() ● DECODE() ● DENSE_RANK() ● EXPLODE() ● FIRST_VALUE() ● IF() ● ISNOTNULL() ● ISNULL() ● LAST() ● LEAST() ● LEFT() ● LENGTH() ● LOCATE ● LOWER() ● MAX() ● MIN() ● MONTHS_BETWEEN() ● NOW() ● NTILE() ● NULLIF() ● RAND() ● RANK() ● REGEXP_EXTRACT() ● REGEXP_REPLACE() ● RLIKE() ● ROUND() ● ROW_NUMBER() ● SHA2() ● SPLIT() ● STRPOS() ● SUBSTR() ● SUBSTRING() ● SUM() ● TO_DATE() ● TO_TIMESTAMP() ● TRANSLATE() ● TRIM() ● UPPER()

Stitch¶

About Stitch ● Run Stitch ● Select domain tables

Stitch results: About Stitch results ● Explore Stitch results ● Explore by Amperity ID ● Explore by data source ● Explore previous Stitch results ● Explore semantics ● View cluster graph ● View deduplication rate ● View pairwise connections ● View Stitch metrics ● View stitched records

Unified ID 2.0 (UID2)¶

About Unified ID 2.0 (UID2) ● How UID2 works ● About UID2 workflows

Prerequisites: About prerequisites ● Get access to UID2 ● Participate in UID2 ● Get Mapper credentials
Configure Amperity: Configure Amperity ● Add Mapper credentials ● Enable UID2 token generation ● Add UID2 table to database

Workflows¶

About workflows ● About the Workflows page ● About workflow alerts

Common resolutions: Ignore missing file ● Restart workflow ● Retry task ● Skip a task ● Update credentials ● Update error threshold ●
Context-specific resolutions: for campaigns ● for courier groups ● for databases ● for destinations ● for scheduled orchestration groups ● for sources ● for Stitch
How-tos: Configure runtime alerts ● Filter workflows ● Hide skipped tasks ● Resolve workflows ● Search workflows ● Send alerts to email addresses ● Send alerts to Slack channels ● View all workflows ● View details ● View resolutions ● View workflow graphs
Open workflow alerts: from email alerts ● from Recent activity pane ● from Slack alerts ● from Workflow page ●