Queries¶
A query is SQL that runs from the Queries page against database tables in the Customer 360 page. A query returns a refined and filtered subset of useful customer data.
Query Editor
Presto SQL
Databases
Standard output tables
Visual Query Editor
Review Stitch results
Send data anywhere
Send query results to …¶
Send query results to downstream workflows and to support all of your brand’s marketing, customer engagement, and analytics use cases.
ActiveCampign
Acxiom
Adobe Campaign
Adobe Customer Attributes
Adobe Experience Platform
Adobe Marketo
Airship
Amazon Pinpoint
Amazon Redshift
Amazon S3
Any analytics or BI tool
Attentive (Attributes)
Attentive (Audiences)
AWS Connect
Azure Blob Storage
BazaarVoice
Bluecore
Braze
Cheetah Digital
Cordial
Criteo
Domo
DV360
Dynamic Yield
Evocalize
Experian
Google Ads
Google Cloud Storage
HupSpot
Infutor
Klaviyo
Koupon Media
Listrak
LiveRamp
Mailchimp
Meta Ads Manager
Microsoft Ads
Microsoft Dataverse
Microsoft Power BI
Monetate
Neustar
Optimizely
Oracle Data Cloud
Oracle Eloqua
Oracle Responsys
PebblePost
Persado
Pinterest
PowerReviews
Sailthru
Salesforce Marketing Cloud
SFTP
Snapchat
Tableau
The Trade Desk
Throtle
TikTok Ads
Vibes
Zendesk
Example SQL queries¶
The following examples show using the SQL Editor to build audiences.
Cohort analysis
Count loyalty by state
Customer acquisition
Days to second purchase
Google Analytics reports
Leaky bucket ratio
Missing Amperity IDs
Month-over-month revenue
One and dones, by category
One and dones, by year
Order revenue, 7-day rolling window
Partition pCLV by brand
Percent rank of purchases
Purchasers, 12-month rolling window
Product replenishment by date
Product replenishment by decile
Products by revenue
Rank by product affinity
Rank by Amperity ID
Reachable email, by state
Return percentiles
Revenue by month
Revenue opportunity, 1 group
Revenue opportunity, many groups
Top 20% revenue during previous year
Total quantity by brand
Total returns by brand
Total revenue by brand
Transactions by day
Example visual queries¶
The following examples show using the visual SQL Editor to build audiences.
Early repeat purchasers
High value multichannel customers
New website customers
One and done
Top 20% revenue customers