About Amp360¶
Review 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 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 Responsys PebblePost Persado PowerReviews Sailthru Salesforce Marketing Cloud Snapchat Tableau Throtle TikTok Vibes WhatsApp Zendesk
Send to BI tools¶
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