About Amperity¶
Review ID resolution¶
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 ● Kibo ● Klaviyo ● Koupon Media ● Listrak ● LiveRamp ● Mailchimp ● Microsoft Advertising ● Microsoft Dataverse ● Microsoft Power BI ● Neustar ● Optimizely ● Oracle Data Cloud ● 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