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

queries_reference.html

Presto SQL

../reference/sql_presto.html

Databases

databases.html

Standard output tables

standard_output.html

Visual Query Editor

queries_visual.html

Review Stitch results

stitch_results.html

Send data anywhere

send_data.html

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

destination_active_campaign.html

Acxiom

destination_acxiom.html

Adobe Campaign

destination_adobe_campaign.html

Adobe Customer Attributes

destination_adobe_customer_attributes.html

Adobe Experience Platform

destination_adobe_aep.html

Adobe Marketo

destination_adobe_marketo.html

Airship

destination_airship.html

Amazon Pinpoint

destination_amazon_pinpoint.html

Amazon Redshift

destination_amazon_redshift.html

Amazon S3

destination_amazon_s3.html

Any analytics or BI tool

sendto_analytics_bi.html

Attentive (Attributes)

destination_attentive_mobile_api.html

Attentive (Audiences)

destination_attentive_mobile.html

AWS Connect

destination_aws_connect.html

Azure Blob Storage

destination_azure_blob_storage.html

BazaarVoice

destination_bazaarvoice.html

Bluecore

destination_bluecore.html

Braze

destination_braze.html

Cheetah Digital

destination_cheetah_digital.html

Cordial

destination_cordial.html

Criteo

destination_criteo.html

Domo

destination_domo.html

DV360

destination_dv360.html

Dynamic Yield

destination_dynamic_yield.html

Evocalize

destination_evocalize.html

Experian

destination_experian.html

Google Ads

destination_google_ads.html

Google Cloud Storage

destination_google_cloud_storage.html

HupSpot

destination_hubspot.html

Infutor

destination_infutor.html

Klaviyo

destination_klaviyo.html

Koupon Media

destination_koupon_media.html

Listrak

destination_listrak.html

LiveRamp

destination_liveramp.html

Mailchimp

destination_mailchimp.html

Meta Ads Manager

destination_meta_ads_manager.html

Microsoft Ads

destination_microsoft_ads.html

Microsoft Dataverse

destination_microsoft_dataverse.html

Microsoft Power BI

destination_power_bi.html

Monetate

destination_monetate.html

Neustar

destination_neustar.html

Optimizely

destination_optimizely.html

Oracle Data Cloud

destination_oracle_data_cloud.html

Oracle Eloqua

destination_oracle_eloqua.html

Oracle Responsys

destination_oracle_responsys.html

PebblePost

destination_pebblepost.html

Persado

destination_persado.html

Pinterest

destination_pinterest.html

PowerReviews

destination_powerreviews.html

Reddit Ads

destination_reddit_ads.html

Sailthru

destination_sailthru.html

Salesforce Marketing Cloud

destination_salesforce_marketing_cloud.html

SFTP

destination_sftp.html

Snapchat

destination_snapchat.html

Tableau

destination_tableau.html

The Trade Desk

destination_the_trade_desk.html

Throtle

destination_throtle.html

TikTok Ads

destination_tiktok_ads.html

Vibes

destination_vibes.html

Zendesk

destination_zendesk.html

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