AmpIQ
Amp360
AmpID
DataGrid
Amperity A-Z
Amperity A-Z
Start Here
Connected systems
Glossary
Abbreviations
Naming conventions
How to use this site
Amperity Changelog
System status
APIs
About Amperity APIs
Profile API
Streaming Ingest API
API keys
About API keys
Add API keys
Delete API keys
Rotate API keys
Access tokens
About access tokens
Generate access tokens
Refresh access tokens
Revoke access tokens
Profile API actions
Copy endpoint URL
Copy index ID
Delete endpoint
Edit endpoint settings
Generate endpoint
View endpoint settings
Attributes
Customer profiles
Birthdates
Email addresses
Gender
Names
Phone numbers
Physical addresses
Loyalty programs
Membership
Points (balances)
Profiles
Spend
Tiers
Orders and items
Cancelled quantity
Cancelled revenue
Costs
Currency
Days since latest order
Digital channels
Discount amounts
Discount percents
Early repeat purchaser?
Intervals
Average item prices
Average order values
Largest order values
Purchased brand
Purchased channel
Order frequency
Preferred brands
Preferred channels
Preferred stores
Revenue
Store visits
Total items
Is cancelled?
Is returned?
List prices
Multi-brand purchase?
Multi-channel purchase?
One and done?
Order datetimes
Order IDs
Payment method
Product catalogs
Profit amounts
Purchase behaviors
First order
Has not purchased?
Has purchased?
Most frequent order
Repeat order
Total value of orders
Purchased brands
Purchased channels
Quantity
Repeat within 365 days?
Returned quantity
Returned revenue
Revenue
RFM scores
About RFM attributes
L12M recency
L12M frequency
L12M monetary
L12M combined score
Shipping amounts
Store IDs
Subtotals
Sum of item discount amounts
Tax amounts
Total discount amount
Total items
Predictions
Predicted CLV
Average order revenue
Predicted lifetime value (CLV)
Lifecycle status
Lifetime value tier
Order frequency
Probability of transaction
Audience sizes
About audience sizes
About the purchase curve
Large
Medium
Small
Ranking
Campaigns
About campaigns
How campaigns work
Campaign types
About campaign types
One-time campaigns
Recurring campaigns
Multi-channel campaigns
Campaign features
Attributes
Audiences
Control groups
Destinations
Exclusion lists
Treatment groups
Sub-audiences
Timing and launch dates
Default attributes
Email notifications
Campaign results
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
Enable Campaign Recipients table
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
Copy courier group
Configure duration alert
Delete courier group
Load data only for past day
Run courier group
Automatically
For date range
For specific day
For all data
Manually
Wait for missing files
Couriers
About couriers
File couriers
About file couriers
Load settings
File patterns
About file patterns
Wildcards
Wildcards within archives
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
Only load files
Run for a specific day
Run for a time period
Skip missing files
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
Unified email events
Fiscal calendar
Loyalty programs
Unified loyalty
Unified loyalty events
Merged customers
Opt-in status
Email_Opt_Status
SMS_Opt_Status
QA
Detailed examples
Stitch bad values
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 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
Custom delimiters
.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
Copy data template ID
Delete data template
Edit data template
Enable success file
Map to external schema
Make available to campaigns
Databases
About databases
About the Customer 360 page
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 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
Download schema
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
Fixed-width fields
Hash resent PII
Parse multiple separators
Set non-ASCII emails to NULL
Standardize USA states
Publish to queries
How-tos
Add domain table
Delete domain table
Delete records
About deleting records
Older than a date
Within a timeframe
With a matching value
Edit domain table
Publish to Queries page
Purge domain table
Rename domain table
Search domain tables
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
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
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 to a segment
Delete an uploaded file
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
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
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 Administrator
DataGrid Operator
Policy options
Allow API key admin
Allow Profile API admin
Allow sandbox admin
Allow source data deletion
Allow user admin
Restrict data exports
Restrict download access
Restrict PII access
Restrict upload access
Read-only options
Amp360 User
AmpIQ User
DataGrid Operator
Allowed actions
About allowed actions
Campaigns
Credentials
Customer 360
Data Explorer
Destinations
Queries
Sandboxes
Segments
Sources
Stitch
Users & Activity
Workflows
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
Set operation clauses
EXCEPT clause
INTERSECT 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
About the AI Assistant
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
Convert query to segment
Delete query
Disable AI Assistant
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
Query domain data
Refresh query automatically
Rename query
Run query
Run selection
Select database
Uncomment lines
Upload a file
Use keyboard shortcuts
View query
Recent activity
About recent activity
Notification types
Running
Completed
Warnings
Errors
Notifications for
Campaigns
Databases
Orchestrations
Queries
Sources
Stitch reports
Stitch runs
How-tos
Open the Workflows page
Resolve workflow errors
Sandboxes
About sandboxes
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
Promote changes
Pull updates from production
Resolve validation issues
Review changes
Restore changes
View sandbox details
View validation details
Segments
About segments
How segments work
Segment names
Segment attributes
Attribute conditions
Boolean
Date
Datetime
Decimal
Integer
Relative dates
String
Segment insights
Databases and tables
AND vs. OR
SQL editor
Segment overview
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
Explore a segment copy
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
View SQL for segment stats
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
Fiscal calendar
Loyalty programs
About loyalty programs
Loyalty events
Loyalty profiles
Opt-in status
Email opt-in status
SMS opt-in status
Product catalog
Profile (PII)
About Profile (PII)
Address groups
Email addresses
Names
Phone numbers
Stitch labels
Transactions
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 page
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
Allowed 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
User activity event types
Workflows
About workflows
About the Workflows page
Workflow alerts
Workflows details
About workflow details
Details page actions
About details page actions
Stop workflows
Review warnings
Review errors
Resolve failures
Common resolutions
Ignore missing file
Restart workflow
Retry task
Skip a task
Update credentials
Update error threshold
Context-specific resolutions
Campaigns
Mismatched datatype
Missing table
Unresolved column name
Workflow alerts
Courier groups
Duration alerts
Workflow alerts
Databases
Destinations
Common to destinations
ActiveCampaign
Amazon Ads
Amazon S3
Azure Blob Storage
Braze
Cordial
Google Ads
Klaviyo
Listrak
Meta Ads Manager
Microsoft Advertising
Oracle Data Cloud
Oracle DMP
Salesforce Marketing Cloud
Snapchat
TikTok Ads
Zendesk
Orchestration groups
Workflow alerts
Sources
Common to file-based sources
from Amazonn S3
from Azure Blob Storage
from Google Cloud Storage
from SFTP
Stitch
How-tos
Configure duration alerts
About duration alerts
for courier groups
Filter workflows
About filtering workflows
by status
by type
by user
Hide skipped tasks
Open workflows
Email alerts
Recent activity panes
Slack alerts
Workflows page
Resolve workflow
Search workflows
Send alerts to email
Send alerts to Slack
About Slack alerts
Authorize workspace
Configure channels
Disconnect workspace
Stop a workflow
View all workflows
View error details
View inputs and outputs
View workflow details
View resolutions
View workflow graphs
Get Support
System Status
Amperity.com
Index