About Amp360

Review ID resolution

About ID resolution

Explore Stitch results: About Stitch results Explore by Amperity ID Explore by data source Explore previous results View cluster graph View deduplication rate View pairwise connections View Stitch metrics View stitched records

Review customer 360

About the customer 360 database Standard tables Source and custom tables QA tables Review customer profiles

Build queries

About queries About the Queries page About the Query Editor About Presto SQL Add queries Preview results Validate queries Add to orchestrations

Example queries

Count loyalty by state Days to second purchase Google Analytics reports Missing Amperity IDs One and dones, by category One and dones, by year Order revenue, 7-day rolling window Partition (P)CLV by brand Percent rank of purchases Rank by product affinity Rank by Amperity ID Reachable email, by state Return percentiles Revenue opportunity, 1 group Revenue opportunity, many groups Top 20% revenue during previous year Totals by brand Transactions by day

Send query results

Any SFTP site Active Campaign Acxiom Adobe Campaign Adobe Customer Attributes Adobe Experience Platform Adobe Marketo Airship Amazon Pinpoint Amazon Redshift Amazon S3 Attentive Mobile AWS Connect Azure Blob Storage BazaarVoice Databricks Bluecore Braze Cheetah Digital Cordial Criteo DV360 Dynamic Yield Evocalize Experian Facebook Facebook Messenger Google Ads Google Cloud Storage HubSpot Instagram Kibo Infutor Klaviyo Koupon Media Listrak LiveRamp Mailchimp Microsoft Advertising Microsoft Dataverse Microsoft Power BI Monetate Neustar Optimizely Oracle Data Cloud Oracle DMP Oracle Eloqua Oracle Responsys PebblePost Persado Pinterest PowerReviews Sailthru Salesforce Marketing Cloud Snapchat Tableau The Trade Desk Throtle TikTok Vibes WhatsApp Zendesk

Send to BI tools

About BI Connect

Enable BI Connect Request to enable warehouse Provision the warehouse Connection details Service hours Snowflake data sharing User access to warehouse Single sign-on (SSO) Service accounts Send data to warehouse Export databases and tables Send query results

Connect BI tools to BI Connect About connecting BI tools Amazon QuickSight Databricks Domo JDBC driver Looker Microsoft Power BI ODBC driver Oracle Business Analytics Qlik Sense SAP Business Objects SAS Cloud Analytic Services SQL Workbench Tableau Desktop

Send to BI tools Databricks Domo Microsoft Power BI Tableau

Analyze campaign results

About campaign results Download recipients Download results