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
Build queries
Presto SQL
../reference/sql_presto.html
Databases
Review customer 360
Standard output tables
Standard output
Visual Query Editor
About the visual Query Editor
Review Stitch results
Review ID resolution
Send data anywhere
Send data with orchestrations

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
Send query results to ActiveCampaign
Acxiom
Send query results to Acxiom
Adobe Campaign
Send query results to Adobe Campaign
Adobe Customer Attributes
Send query results to Adobe Customer Attributes
Adobe Experience Platform
Send query results to Adobe Experience Platform
Adobe Marketo
Send query results to Adobe Marketo
Airship
Send query results to Airship
Amazon Pinpoint
Send query results to Amazon Pinpoint
Amazon Redshift
Send query results to Amazon Redshift
Amazon S3
Send query results to Amazon S3
Any analytics or BI tool
Send data to analytics and BI tools
Attentive (Audiences)
Send query results to Attentive
AWS Connect
Send query results to AWS Connect
Azure Blob Storage
Send query results to Azure Blob Storage
BazaarVoice
Send query results to Bazaarvoice
Bluecore
Send query results to Bluecore
Braze
Send query results to Braze
Cheetah Digital
Send query results to Cheetah Digital by Marigold
Cordial
Send query results to Cordial
Criteo
Send query results to Criteo
Domo
Send query results to Domo
DV360
Send query results to DV360
Dynamic Yield
Send query results to Dynamic Yield
Evocalize
Send query results to Evocalize
Experian
Send query results to Experian
Google Ads
Send query results to Google Ads
Google Cloud Storage
Send query results to Google Cloud Storage
HubSpot
Send query results to HubSpot
Infutor
Send query results to Infutor
Klaviyo
Send query results to Klaviyo
Koupon Media
Send query results to Koupon Media
Listrak
Send query results to Listrak
LiveRamp
Send query results to LiveRamp
Mailchimp
Send query results to Mailchimp
Meta Ads Manager
Send query results to Meta Ads Manager
Microsoft Ads
Send query results to Microsoft Advertising
Microsoft Dataverse
Send query results to Microsoft Dataverse
Microsoft Power BI
Send query results to Microsoft Power BI
Monetate
Send query results to Monetate
Neustar
Send query results to Neustar
Optimizely
Send query results to Optimizely
Oracle Data Cloud
Send query results to Oracle Data Cloud
Oracle Eloqua
Send query results to Oracle Eloqua
Oracle Responsys
Send query results to Oracle Responsys
PebblePost
Send query results to PebblePost
Persado
Send query results to Persado
Pinterest
Send query results to Pinterest Ads
PowerReviews
Send query results to PowerReviews
Reddit Ads
Send audiences to Reddit Ads
Sailthru
Send query results to Sailthru by Marigold
Salesforce Marketing Cloud
Send query results to Salesforce Marketing Cloud
SFTP
Send query results to any SFTP Site
Snapchat
Send query results to Snapchat
Tableau
Send query results to Tableau
The Trade Desk
Send query results to The Trade Desk
Throtle
Send query results to Throtle
TikTok Ads
Send query results to TikTok Ads Manager
Vibes
Send query results to Vibes
Zendesk
Send query results to Zendesk

Example SQL queries

The following examples show using the SQL Editor to build audiences.

Cohort analysis
queries_reference.html#cohort-analysis
Count loyalty by state
queries_reference.html#count-loyalty-by-state
Customer acquisition
queries_reference.html#customer-acquisition
Days to second purchase
queries_reference.html#days-to-second-purchase
Google Analytics reports
queries_reference.html#google-analytics-reports
Leaky bucket ratio
queries_reference.html#leaky-bucket-ratio
Missing Amperity IDs
queries_reference.html#missing-amperity-ids
Month-over-month revenue
queries_reference.html#month-over-month-revenue
One and dones, by category
queries_reference.html#one-and-dones-by-category
One and dones, by year
queries_reference.html#one-and-dones-by-year
Order revenue, 7-day rolling window
queries_reference.html#order-revenue-7-day-rolling-window
Partition pCLV by brand
queries_reference.html#partition-pclv-by-brand
Percent rank of purchases
queries_reference.html#percent-rank-of-purchases
Purchasers, 12-month rolling window
queries_reference.html#purchasers-12-month-rolling-window
Product replenishment by date
queries_reference.html#product-replenishment-by-date
Product replenishment by decile
queries_reference.html#product-replenishment-by-decile
Products by revenue
queries_reference.html#products-by-revenue
Rank by product affinity
queries_reference.html#rank-by-product-affinity
Rank by Amperity ID
queries_reference.html#rank-by-amperity-id
Reachable email, by state
queries_reference.html#reachable-email-by-state
Return percentiles
queries_reference.html#return-percentiles
Revenue by month
queries_reference.html#revenue-by-month
Revenue opportunity, 1 group
queries_reference.html#revenue-opportunity-1-group
Revenue opportunity, many groups
queries_reference.html#revenue-opportunity-many-groups
Top 20% revenue during previous year
queries_reference.html#top-20-revenue-during-previous-year
Total quantity by brand
queries_reference.html#total-quantity-by-brand
Total returns by brand
queries_reference.html#total-returns-by-brand
Total revenue by brand
queries_reference.html#total-revenue-by-brand
Transactions by day
queries_reference.html#transactions-by-day

Example visual queries

The following examples show using the visual SQL Editor to build audiences.

Early repeat purchasers
usecase_early_repeat_purchasers_visual.html
High value multichannel customers
usecase_customers_high_value_multichannel_visual.html
New website customers
usecase_customers_website_new_visual.html
One and done
usecase_one_and_done_visual.html
Top 20% revenue customers
usecase_customers_top20_revenue_visual.html