User Guides
Operators Guide
API
Amperity A-Z
User Guides
About user guides
Tools for marketers
Start here
Build segments
Create campaigns
Build journeys
Choose destinations
Tools for analysts
Start here
Build queries
Send data anywhere
Monitor workflows
AmpAI
AmpAI toolkit
About the AmpAI toolkit
Stitch
Assist
Predict
How Stitch works
AI Assistant
Predictive modeling
About predictive modeling
Customer lifetime value
Churn propensity
Event propensity
Product affinity
Recommended audiences
Segments
About segments
About the Segments page
Segments page tabs
Summary tab
Breakdown tab
Compare tab
Customers tab
How segments work
Conditions and operators
Segment names
Build segments
Segment editor
Inclusions and exclusions
Attributes
Customer lists
Purchase behaviors
Segment insights
AND vs. OR
Databases and tables
SQL editor
Standard attributes
Average number of items
Average order values
Average prices
Birthdates
Brand intervals
Brand purchases
Canceled quantities
Canceled revenue
Channel intervals
Channel purchases
Costs
Currency
Days since latest order
Digital channels
Discount amounts
Discount percents
Early repeat purchaser?
Email addresses
First-to-latest orders
First-to-second orders
Gender
Is canceled?
Is returned?
Largest order values
List prices
Multi-brand purchases?
Multichannel purchases?
Names
One and done?
Order dates and times
Order IDs
Order frequencies
Payment methods
Phone numbers
Physical addresses
Preferred brands
Preferred channels
Preferred stores
Product catalogs
Profit amounts
Quantities
Repeat within 365 days?
Returned quantities
Returned revenue
Revenue
Revenue intervals
RFM scores
Shipping amounts
Store IDs
Store visit intervals
Subtotals
Sum of item discounts
Tax amounts
Total discount amounts
Total items
Total item intervals
Predictive attributes
Audience sizes
Customer rankings
Predicted AOR
Predicted CLV
Predicted orders
Predicted status
Predicted transactions
Predicted value tiers
Purchase behaviors
First purchase
Has not purchased
Has purchased
Most frequent order
Repeat purchase
Total value of orders
Table reference
About standard tables
Customer 360
Customer attributes
Merged customers
Predicted affinity
Predicted CLV attributes
Transaction attributes
Unified itemized transactions
Unified transactions
Example segments
Active store shoppers
Dormant customers
Early repeat purchasers
High-value channels
New high-value customers
Holiday shoppers
Lapsing customers
New website customers
One and done
Purchased yesterday
Reduce paid media ad spend
Store invites
Top 10% high-value
Top 20% revenue
Win back lost customers
Campaigns
About campaigns
Build campaigns
Audience attributes
Audiences
Control groups
Default attributes
Destinations
Exclusion lists
Sub-audiences
Treatment groups
Timing and launch dates
Tests
Send campaigns to ...
ActiveCampaign
Adobe Marketo
Amazon S3
Attentive
Azure Blob Storage
Braze
Cheetah Digital
Cordial
Criteo
Criteo
Criteo Retail Media
DV360
Google Ads
Google Cloud Storage
HubSpot
Klaviyo
Listrak
Liveramp
Meta Ads Manager
Microsoft Ads
Neustar
Oracle Eloqua
Pinterest
Reddit Ads
Sailthru
Salesforce Marketing Cloud
SFTP
Snapchat
The Trade Desk
TikTok Ads Manager
Yahoo DSP
Walmart DSP
Journeys
About journeys
How journeys work
Journey setup
Who enters?
Who is excluded?
Exit conditions
Build journeys
Journey start
Activate
Delay
Split
Conditional
Percent
Split nodes
Add a node
Configure destination attributes
Set run frequency
Paid media
About paid media
What is 1st party data?
Activation scenarios
Audience expansion
Lifecycle marketing
Product marketing
Optimize bidding
Optimize budgets with CLV
Suppression lists
Prospect conversion
Match rates
Activate audiences with ...
Amazon Ads
Bing Ads
Criteo
DV360
Facebook
Facebook Messenger
Gmail
Google Ads
Google Search
Google Shopping
Instagram
LiveRamp
Meta Ads Manager
Microsoft Advertising
Neustar
Oracle DMP
Pinterest
Reddit Ads
Snapchat
The Trade Desk
TikTok Ads
WhatsApp
Yahoo DSP
YouTube
Walmart DSP
Measure paid media
Performance indicators
Example
Offline events
About offline events
Send offline events to ...
Braze
Criteo
Google Enhanced Conversions
Klaviyo
Meta Ads Manager
Pinterest
Snapchat
The Trade Desk
TikTok Ads Manager
Churn prevention
About churn prevention
Build a campaign
Define audience
Test campaign
Expand campaign
Optimize campaign
One-time buyers
About one-time buyers
Build a campaign
Define audience
Test campaign
Expand campaign
Optimize campaign
Direct mail
About direct mail
Build an audience
By value tier
By lifecycle status
Align to campaign objectives
Track campaign performance
Send to channels ...
Cross Country Computer
PebblePost
Other channels
RFM scores
About RFM scores
About RFM percentiles
Example: Top 20% revenue
How RFM scores work
Examples
Direct mail
High F, low R scores
High M, low F scores
High R, low F and M scores
High R and F, low M scores
SQL queries
About queries
Review the customer 360
Explore tables
Standard
Source and custom
QA
Review customer profiles
Build queries
SQL query editor
About the query editor
Presto SQL reference
Add queries
Preview results
Validate queries
Add to orchestrations
Example SQL queries
Cohort analysis
Count loyalty by state
Customer acquisition
Days to 2nd purchase
Google Analytics reports
Leaky bucket ratio
Missing Amperity IDs
Month-over-month revenue
One-and-done, by category
One-and-done, by year
Partition pCLV by brand
Percent rank of purchases
Products by revenue
Rank by product affinity
Rank by Amperity ID
Return percentiles
Reachable email, by state
Replenishment by date
Replenishment by decile
Revenue, 1 group
Revenue, 7-day rolling
Revenue by month
Revenue, many groups
Top 20% revenue
Totals by brand
Transactions by day
Visual Query Editor
About the Visual Query Editor
AND vs. OR
Early repeat purchasers
High-value, multichannel
New website customers
One and done
Top 20% revenue
Send query results to ...
Analytics tools ...
Amazon QuickSight
Databricks
Domo
Google BigQuery
Looker
Microsoft Power BI
Pyramid Analytics
Sisense
Tableau
Tellius
ThoughtSpot
Yellowfin
Zoho
Databases and storage ...
Amazon Redshift
Amazon S3
Amperity Bridge
Azure Blob Storage
Databricks
Google Cloud Storage
Microsoft Dataverse
Oracle Data Cloud
SFTP
Marketing applications ...
ActiveCampaign
Acxiom
Adobe AEP
Adobe Campaign
Adobe Customer Attributes
Adobe Marketo
Airship
Amazon Pinpoint
Attentive Mobile
AWS Connect
BazaarVoice
Bluecore
Braze
Cheetah Digital
Cordial
Criteo
DV360
Dynamic Yield
Evocalize
Experian
Google Ads
HubSpot
Infutor
Kibo
Klaviyo
Koupon Media
Listrak
LiveRamp
Mailchimp
Meta Ads Manager
Microsoft Advertising
Monetate
Neustar
Optimizely
Oracle DMP (BlueKai)
Oracle Eloqua
Oracle Responsys
PebblePost
Persado
Pinterest Ads
PowerReviews
Sailthru
Salesforce Marketing Cloud
Snapchat
The Trade Desk
Throtle
TikTok Ads Manager
Vibes
Zendesk
Measure campaigns
People-based measurement
Campaign recipients table
Analyze campaign data
Download recipients
Download results
Help Center
Learning Lab
System Status
Amperity.com
Is this page helpful?
About Amperity
ΒΆ