User Guides
Operators Guide
API
Amperity A-Z
Operators Guide
About the Operators Guide
Spark SQL reference
Use sandboxes
About sandboxes
Allow sandbox administration
Safely make changes
1. Create sandbox
2. Configure your tenant
3. Promote sandbox
Best practices
Continuous validation
Data across environments
Delete sandbox on promote
Run partial workflows
Short-lived sandboxes
Common activities
Sync data
About Amperity Bridge
Sync data with ...
Databricks
Snowflake
Manage sources
General advice
Pull data from ...
Any SFTP site
Acxiom
Adobe
Adobe Analytics
Adobe Campaign
Adobe Commerce
Adobe Customer Attributes
Amazon S3
Attentive Mobile
Azure Blob Storage
Bazaarvoice
Bluecore
Braze
Camelot SMM
Cheetah Digital
Cordial
Cross Country Computer
Dynamic Yield
Emarsys
Epsilon
Epsilon Abacus
Epsilon Conversant
Epsilon Targeting
Experian
Fivetran
Google Analytics
Google Cloud Storage
Heap
HubSpot
Infutor
Klaviyo
Koupon Media
Kustomer
Listrak
Microsoft Dataverse
Monetate
Neustar
Optimizely
Oracle
Oracle Data Cloud
Oracle OPERA
Oracle Responsys
PebblePost
PowerReviews
Quad
RR Donnelly
Sailthru
Salesforce
Commerce Cloud
Marketing Cloud
Pardot
Sales Cloud
Shopify
SMG
SoundCommerce
Square
Streaming Ingest API
Vibes
Zendesk
Stream data to ...
Real-time tables
Streaming Ingest API
Reshape data on ingest
About ingest queries
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
Example ingest queries
Build birthdate
Concatenate columns
Explode transactions
Find records
Flatten with identifiers
Import billing as address
JOIN datasets
Load XML data
Parse fields from files
Parse nested records
Remove field
Select all fields
Apply semantic tags
Configure feeds
About feeds
Set the primary key
Apply semantic tags
Select last updated field
Make available to Stitch
Profiles
About profiles
Address groups
About address groups
Apply ordinals
Email addresses
About email addresses
Apply namespaces
Apply ordinals
Consolidate emails
Exclude duplicates
Ignore email addresses
Update merge rules
Loyalty programs
Names
About names
Deriving names
Deriving generational suffix
Phone numbers
About phone numbers
Last 10 digits
Apply namespaces
Apply ordinals
Consolidate numbers
Update merge rules
Interactions
About interactions
Domain SQL vs. feeds
Associate to Amperity ID
Customer records
Interaction records
Custom semantics
Keys
About keys
Blocking keys
About blocking keys
Label foreign keys
Update blocking strategy
Customer keys
Foreign keys
About foreign keys
Link transactions
Prioritize matching
Use case-sensitive keys
Primary keys
Separation keys
About separation keys
Apply to brand names
Associate to semantics
Prioritize unmatching
Product catalogs
About product catalogs
Define product catalogs
About custom domain tables
Review domain data
About domain data
Review domain data
About reviewing data
Amperity-added columns
Column types
Record types
About record types
Customer records
Interaction records
Reshape domain data
About reshaping data
About Domain SQL
Examples
Build birthdates
Combine postal codes
Extract names
Hash profile data
Parse multiple separators
Set non-USA email to NULL
Standardize phone numbers
Standardize USA states
Input validation reports
Run Stitch
Add tables to Stitch run
Run Stitch
Configure Stitch
Build databases
Add customer profiles
About customer profiles
Apply semantics
Review validations
Run Stitch
Build database
About database tables
Unified coalesced
Best email address
Merged customers
Customer 360
Activate database
Add transactions
About transactions
Apply semantics
About semantics
Purchase histories
Product catalogs
Review validations
Associate to profiles
Extend database
About transaction tables
Itemized transactions
Unified transactions
Extended attributes
Transaction attributes
Optional attributes
About optional attributes
Cancellations
Fiscal calendars
Net order revenue
Order costs
Order discount amounts
Returns
RFM
Refresh database
C360 validations
Enable AmpIQ
Add data assets
About data assets
Best email address
Customer attributes
Customer consent
About customer consent
All opted-in email addresses
Email opt status
SMS opt status
Email engagement
About email engagement
Engagement attributes
Engagement summary
Unified email events
Fiscal calendars
About fiscal calendars
NRF calendar
Extended fiscal calendar
Add fiscal calendar table
Loyalty programs
About loyalty programs
Loyalty events
Loyalty profiles
Paid media
Reference data assets
Address standardization
Gender name ratios
Lookup: Countries
Lookup: United States
Lookup: Zip codes
Normalization: United States
Enable campaigns
About campaigns
Verify prerequisites
Review data requirements
About data requirements
for columns and tables
for fields
for additional data sources
Enable visual segments
Review features
Enable predictive models
About predictive models
Predictive models workflow
Verify prerequisites
Review data requirements
About data requirements
for columns and tables
for fields
Configure predictive tables
Add affinity table
Add pCLV attributes table
Define product catalog
Add pCLV attributes
Review tables
Affinity
Predicted pCLV Attributes
Validate results
Review ID resolution
About ID resolution
Explore Stitch results
By Amperity ID
By data source
Cluster graphs
Deduplication rate
Pairwise connections
Previous results
Semantics
Stitch metrics
Stitched records
Manage Stitch QA
About Stitch QA
Add database
Add queries
Extend Stitch QA
Add blocklist values
Join to Unified_Coalesced
What to look for?
Anomalies in output
Blocking keys
Customer keys
Foreign keys
Overclustering
Problematic nicknames
Record pairs and scores
Review cluster details
Semantic tags
Supersized clusters
Underclustering
Values to blocklist
Manage transactions QA
About transactions QA
Add queries
Rollup validation queries
for item-level rollups
for order-level rollups
Prioritize Amperity IDs
Bad-values blocklist
Add Stitch labels
Manage nicknames
Configure Stitch
About Stitch settings
Allowed empty tables
Bad values
Blocking strategy
Case-sensitive foreign keys
Clustering algorithm
Days of recorded history
Email addresses
Force Stitch to run
Ignore jitter alerts
Matching strategy
About matching strategies
Foreign key matching
Separation key unmatching
Matching thresholds
One-to-one Stitch
Preprocessing profiles
Semantic exclusions
Skip unified changes
Skip unified scores
Stable ID assignment
About Stable ID assignment
Disable stable IDs
Increase partitions
Staple
Stitch reports
Supersized clusters
Trivial duplicates
Manage databases
About databases
About Spark SQL
About table types
Standard tables
Source and custom tables
QA tables
Define customer profile
Filtered 360 databases
Manage databases
Add empty database
Add from template
About database templates
Customer 360 template
Passthrough template
Stitch QA template
Use multiple databases
Apply flexible merge rules
Manage tables
Add as passthrough
Add as SQL
Add from table template
About table templates
Standard table templates
Other templates
Validation alerts
About validation alerts
Implicit CROSS JOIN
OVER without PARTITION BY
Unescaped backslashes
Unintentional broadcast joins
Query historical data
About historical data
Available versions
Return versions w/datetime
Return versions w/created_at
View all versioned tables
Extend databases
Add graph database
Add householding
Add PII table
Add SHA-256 hashed columns
Calculate nearest store
Predict gender
Use first-party data
Use third-party data
Export databases, tables
Configure destinations
Any SFTP site
ActiveCampaign
Acxiom
Adobe
Adobe Campaign
Adobe Customer Attributes
Adobe Experience Platform
Adobe Marketo
Airship
Amazon Ads
Amazon Pinpoint
Amazon Redshift
Amazon S3
Attentive Mobile
About Attentive Mobile
Audience segments
Custom attributes
AWS Connect
Azure Blob Storage
Azure Synapse
Bazaarvoice
Bluecore
Braze
Camelot SMM
Cordial
Criteo
Criteo
Criteo Retail Media
Cross Country Computer
Domo
DV360
Dynamic Yield
Dynamics 365 Marketing
Epsilon
Epsilon Abacus
Epsilon Conversant
Epsilon Targeting
Evocalize
Experian
Google
Google Ads
Google BigQuery
Google Cloud Storage
Google Enhanced Conversions
HubSpot
Infutor
Kibo
Klaviyo
Koupon Media
Listrak
LiveRamp
Mailchimp
Marigold
Cheetah Digital by Marigold
Sailthru by Marigold
Meta Ads Manager
About Meta Ads Manager
Custom audiences
Offline events
Microsoft
Microsoft Advertising
Microsoft Dataverse
Microsoft Dynamics
Microsoft PowerBI
Neustar
Optimizely
Oracle
Data Cloud
Eloqua
Responsys
PebblePost
Persado
Pinterest
PowerReviews
Profile API
Quad
RR Donnelly
Salesforce
Marketing Cloud
Personalization
Sales Cloud
SMG
Snapchat
SoundCommerce
Tableau
About Tableau
Connect Tableau to ...
Amazon Redshift
Azure Synapse Analytics
Google BigQuery
Snowflake
The Trade Desk
About The Trade Desk
Custom audiences
Offline events
Throtle
TikTok Ads Manager
About TikTok Ads Manager
Custom audiences
Offline events
Tulip
Vibes
Walmart DSP
Webhook
Yahoo DSP
Zendesk
Privacy rights
About privacy rights
How it works
Data subject access requests
Delete records
Delete PII
Request types
Request strategies
Enable workflows
Inbound requests table
Apply semantic tags
Use custom keys
Configure source keys
Create linkage tables
Reports tables
Unified Compliance Overview
Unified Compliance
Automate workflows
About automated workflows
Couriers
Bridges
Activations
About activations
Orchestrations
Profile API indexes
Recurring campaigns
Help Center
Learning Lab
System Status
Amperity.com
Is this page helpful?
Site index
ΒΆ