About Amperity¶
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 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 Purchasers, 12-month rolling window 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 Bluecore Braze Cheetah Digital Cordial Criteo Domo 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
Analyze campaign results¶
About campaign results Download recipients Download results