AmpIQ
Amp360
DataGrid & AmpID
Amperity A-Z
|
Get Support
Amperity A-Z
Start Here
Glossary
Abbreviations
Naming conventions
How to use this site
Amperity Changelog
Attributes
Days since latest order
Early repeat purchaser?
One and done?
Predicted CLV
Average order revenue
Predicted lifetime value (CLV)
Lifecycle status
Lifetime value tier
Order frequency
Probability of transaction
Product affinity
Audience sizes
About audience sizes
About the purchase curve
Large
Medium
Small
Ranking
Purchase behaviors
First order
Has not purchased?
Has purchased?
Most frequent order
Repeat order
Total value of orders
RFM scores
About RFM attributes
L12M frequency
L12M monetary
L12M recency
RFM score
Campaigns
About campaigns
About the Campaigns tab
How campaigns work
Campaign workflows
About campaign workflows
Multi-channel campaigns
One-time campaigns
Recurring campaigns
Audiences
Attributes
Campaign results
Control groups
Exclusion lists
Recipient groups
Sub-audiences
How-tos
Add a sub-audience
Apply exclusion list
Archive campaigns
Build audience
Choose campaign type
Configure campaign
Multi-channel
Onetime
Recurring
Copy campaign ID
Delete campaign
Discard campaign
Download campaign results
Duplicate campaign
Edit attribute
Edit campaign
Edit sub-audience
Remove sub-audience
Schedule campaign
Select destinations
Send metadata
Set campaign launch date
Set delivery schedule
Search campaigns
Unschedule a campaign
View campaign
View campaign history
View delivery summary
View notifications
View workflow
Courier groups
About courier groups
Schedules
Wait times
Offsets
Time zones
How-tos
Add courier group
Delete courier group
Run courier groups
Automatically
For date range
For specific day
For all data
Manually
Couriers
About couriers
File couriers
About file couriers
Load settings
File patterns
About file patterns
Wildcards
Literal strings
Date components
File compression / archive
GZIP
TAR
ZIP
Pretty Good Privacy (PGP)
About PGP
Single files
Multiple files
API couriers
Snowflake couriers
About Snowflake couriers
Table lists
Stage names
Load operations
Load operation types
About load operations
Empty
Incorrect feed ID
Load files
Load ingest query
Truncate, then load
Examples by file format
Apache Avro
Apache Parquet
Campaign Monitor
CBOR
CSV
JSON
NDJSON
PSV
Salesforce Commerce Cloud
Salesforce Sales Cloud
Snowflake
TSV
XML
How-tos
Add courier
Add courier as copy
Add to courier group
Delete courier
Edit courier
Load data only
Run courier
For date range
For all data
Without downstream processing
Without load operations
View error log
View error, restart job
View couriers
Data exports
About data exports
How-tos
Add database
Add tables
Add to orchestration
Delete export
Discard export
Switch database
Remove table
View data exports
Data tables
About data tables
AmpIQ predictions
Customer lifetime value
Product affinity
Campaign recipients
Customer 360
Customer attributes
Email engagement
Attributes
Summary
Lifecycle events
Merged customers
QA
Detailed examples
Stitch blocking keys
Stitch scores
Unified changes, clusters
Unified changes, PKs
Unified preprocessed raw
Transaction attributes
Transaction attributes, extended
Unified coalesced
Unified compliance
Unified customer
Unified email events
Unified itemized transactions
Unified product catalog
Unified scores
Unified transactions
Data templates
About data templates
Campaign templates
About campaign templates
Recommended patterns
Campaign variables
Campaign names
Group names
Campaign examples
File templates
About file templates
.DONE files
Encoding methods
Escape characters
File formats
Filename templates
About filename templates
Text variable
Filters
Tokens
Template examples
Header rows
Line endings
Quote modes
API templates
Snowflake templates
About Snowflake templates
Location
Table actions
Create
Drop
Truncate
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 schema
Make available to campaigns
Databases
About databases
About the Customer 360 tab
All databases
View all databases
Customer 360 database
Multiple databases
Flexible merge rules
Table groups
Standard
Source and custom
QA
How-tos
Activate database
Add database
Add with template
Add customer 360
Add passthrough
Add Stitch QA
Add table
Add passthrough table
Add SQL table
Add w/SQL template
Add as override table
Configure database
Allow users to edit
Allow use in segments
Hide from users
Set as Customer 360
Set description
Configure table
Add field description
Apply tag to table
Enable visual segments
Flag PII columns
Manage pick-lists
Set validation rules
Delete database
Delete table
Discard drafts
Edit database
Edit table
Enforce static schemas
Explore customer profile
Add query from profile
Open Data Explorer
View interactions
View other attributes
View profile attributes
Explore database
Search Data Explorer
View details
View example data
View table schema
Export data
Profile icons
Apply icons
Refresh icons
Run databases
Run customer 360
Run with express refresh
Run with full refresh
Run with normal refresh
Stop
View all databases
View database
View notifications
View statistics
Domain tables
About domain tables
Column types
Record types
About record types
Customer records
Interaction records
Custom domain tables
About custom domain tables
Domain SQL
Use cases
Combine birthdates
Combine postal codes
Extract names
Hash resent PII
Parse multiple separators
Set non-ASCII emails to NULL
Standardize USA states
How-tos
Add domain table
Delete domain table
Edit domain table
Purge domain table
Rename domain table
Search domain tables
Truncate domain table
View domain table
View domain table history
Feeds
About feeds
About the Feed Editor
Field types
About field types
Boolean
Date
Datetime
Decimal
Float
Integer
String
About semantic tags
How-tos
Activate feed
Add feeds
For new sources
For existing sources
Apply semantic tags
About semantic tags
Customer profiles
Transactions
Itemized transactions
Custom semantics
Configure feed schema
Add fields
Delete fields
Edit domain table name
Incoming field names
Rename fields
Set primary key
Delete feeds
Edit feeds
Add columns
Add foreign keys
Change primary keys
Delete columns
Edit columns
Load new data
Generate fields
About generated fields
Add customer keys
Add foreign keys
Combine fields
Load data upon activation
Make available to Stitch
Replace data source
Resolve name conflicts
Set error thresholds
Truncate feed
View sample data
File formats
About file formats
Format types
Apache Avro
Apache Parquet
CBOR
CSV
DAT
JSON
NDJSON
PSV
Streaming JSON
TSV
XML
File uploads
File upload use cases
Query output
How-tos
Add lists
Add an uploaded file to a segment
Upload CSV file
Ingest queries
About ingest queries
Spark SQL docs
Courier load operations
About load operations
for Apache Avro
for Apache Parquet
for CBOR
for CSV
for JSON
for NDJSON
for PSV
for Streaming JSON
for TSV
for XML
Notifications
About notifications
Notification types
Running
Completed
Warnings
Errors
Notification for
Campaigns
Databases
Orchestrations
Queries
Sources
Stitch reports
Stitch runs
How-tos
Open Workflow tab
Resolve workflow errors
Orchestration groups
About orchestration groups
Schedules
Time zones
Constraints
Offsets
How-tos
Add orchestration group
Run orchestration group
Schedule orchestration group
Orchestrations
About orchestrations
How-tos
Add orchestration
Assign database export
Assign query
Delete orchestration
Edit orchestration
Run orchestration
Manually
Scheduled, always run
Scheduled, wait
Wait for changes
View notifications
Policies
About policies
How policies work
Standard policies
Amp360 User
AmpIQ User
DataGrid Operator
Administrator policies
DataGrid Administrator
Sandbox Administrator
SLA Administrator
Read-only options
Amp360 User
AmpIQ User
DataGrid Operator
Policy options
Restrict Download Access
Restrict PII Access
User Administrator
User Administrator option
Manage users
Manage resource groups
Review user activity
Allowed actions
Predictive models
Churn propensity
Predicted CLV
Product affinity
Presto SQL
About Presto SQL
Why this reference?
AWS vs. Azure
Recommendations
General
Commas
Indentation
Naming conventions
NULL values
Reserved words
One-way SHA-256 hashes
Whitespace
WITH clause
SELECT statement
SELECT DISTINCT statement
FROM clause
LEFT JOIN clause
WHERE
WHERE clause
AND operator
OR operator
NOT operator
CASE
CASE expression
Simple form
Searched form
GROUP BY
GROUP BY clause
CUBE operator
ROLLUP operator
HAVING clause
UNION clause
UNNEST clause
VALUES clause
Window functions
ORDER BY clause
LIMIT clause
Operators
About operators
ALL
ANY
BETWEEN
IS NOT NULL
IS NULL
SOME
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()
IF()
LEAST()
LENGTH()
LOWER()
MAX()
MEDIAN()
MIN()
NOW()
NTILE()
NULLIF()
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
About the Queries page
View query types
View status indicators
Search queries
Explore data
About the Data Explorer
Docked mode
Full-screen mode
Table schema
Completion
Cardinality vs. uniqueness
Table examples
Table details
Queries editor
About the Queries editor
About Presto SQL
Validate queries
How-tos
Add comment to query
Add SQL query
Add visual query
Add to orchestration
Autocomplete table names
Browse tables and columns
Comment lines
Copy column names
Copy query
Copy SELECT statement
Delete query
Discard draft query
Download query
Edit query
Enable performance mode
Enable query alerts
Format SQL
Organize queries
Add folders
Add subfolders
Move queries
Preview results
Refresh query automatically
Rename query
Run query
Run selection
Select database
Uncomment lines
Upload a file
Use keyboard shortcuts
View query
Segments
About segments
Segments tab
About the Segments tab
Recommended segments
Summary page
Customers page
Segment editor
About the segment editor
Segment names
Database tables
Attribute groups
AND vs. OR
Attribute operators
Segment insights
SQL editor
How-tos
Add attribute
Add segment
Browse tables and columns
Change insight date range
Comment on a query
Compare segment insights
Configure segments
Copy a segment ID
Copy a SQL Query
Customize insights charts
Delete a segment
Discard segment
Download segment
Duplicate segment
Edit segment from page
Edit segment from Editor
Expand a graph
Format a segment
Open data explorer
Organize segments
Add folders
Add subfolders
Move segments
Rename a segment
Rerun a segment
Search segments
Select database
Select multiple values
Set default charts
Show columns
Switch to SQL segment
Use relative dates
View a segment
View matching records
Semantic tags
About semantic tags
Semantic tag types
Blocklist
Compliance
Custom
Database
Keys
About keys semantics
Blocking keys (bk)
Customer keys (ck)
Foreign keys (fk)
Primary keys (pk)
Separation keys (sk)
Email engagement
About email engagement
Email events
Email summaries
Loyalty
Product catalog
Profile (PII)
About Profile (PII)
Address groups
Email addresses
Names
Phone numbers
Stitch labels
Transactions
Items
Orders
Single sign-on (SSO)
About SSO
How SSO works
Use cases
Request to enable
About enabing SSO
Exchange metadata
Map groups to policies
Validate SSO configuration
Spark SQL
About Spark SQL
Why this reference?
Recommendations
General
Add comments
Avoid low cardinality
Avoid multiple passes
Commas
Escape characters
Daisy-chain LEFT JOINs
Faster operations are better
Filter, then combine
Filter NULL values, then join
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
WITH clause
LATERAL VIEW clause
SELECT statement
SELECT DISTINCT statement
FROM clause
JOINs
ON() clause
USING() clause
CROSS JOIN
FULL OUTER JOIN
INNER JOIN
LEFT JOIN
OUTER JOIN
RIGHT JOIN
WHERE clause
WHERE clause
AND operator
NOT operator
OR operator
IN expression
NOT IN expression
EXISTS expression
NOT EXISTS expression
CASE expression
CASE expression
Simple form
Searched form
GROUP BY clause
HAVING clause
Window functions
ORDER BY clause
LIMIT clause
Operators
About operators
ALL
ANY
BETWEEN
IS NOT NULL
IS NULL
SOME
PIVOT operator
Functions
ABS()
AVG()
CAST()
COALESCE()
COLLECT_LIST()
CONCAT()
CONCAT_WS()
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()
LPAD()
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()
UNIX_TIMESTAMP()
UPPER()
Stitch
About Stitch
How Stitch works
About the Stitch tab
Run Stitch
About running Stitch
Select domain tables
About the Stitch run
Expore 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 stitched records
Users
About users and activity
Manage users
About managing users
Add users
Delete users
Edit users
Revoke tenant access
Allowlist domains
SSO group mappings
Resource groups
About resource groups
All resource groups
Custom resource groups
Assign users to groups
Database permissions
Multi-brand tenants
User activity
About user activity
Activity downloads
Workflows
About workflows
About the Workflows page
Workflow alerts
Resolution categories
Retry task
Restart workflow
Context-specific resolution
Resolution types
Destinations
ΒΆ
TBD