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 tab About the Query Editor About Presto SQL Add queries Preview results Validate queries Add to orchestrations

Example queries: Count loyalty by state Missing transaction IDs One and dones, by category One and dones, by year Order revenue, 7-day rolling window Partition pCLV by brand Percent rank of purchases Rank by Amperity ID Return percentiles Revenue opportunity, 1 group Revenue opportunity, x groups Sort total revenue Transactions by day

Send query results

Any SFTP site Active Campaign Acxiom Adobe Campaign Adobe Customer Attributes Adobe Experience Platform Adobe Marketo Amazon S3 Attentive Mobile Azure Blob Storage BazaarVoice Databricks Bluecore Braze Campaign Monitor Cheetah Digital Cordial Criteo Dynamic Yield Evocalize Experian Facebook Ads Google Ads Google Audience Partner API Google Cloud Storage HubSpot Kibo Infutor Klaviyo Koupon Media Listrak LiveRamp Mailchimp Microsoft Advertising Microsoft Power BI Monetate Neustar Optimizely Oracle Data Cloud Oracle DMP Oracle Responsys PebblePost Persado PowerReviews Sailthru Snapchat Tableau Throtle Vibes 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