About Amp360¶
Amp360 merges behavioral, contextual, and transactional data into useful profiles, even when your data sources are incomplete, inconsistent, or lack linking keys.
A user of Amp360 should be comfortable using SQL to build databases and tables, design queries, understand what is required to synchronize a dataset with external systems and workflows (both upstream and downstream), and how to use attributes available from within Amperity to help their organizations learn more about their customers.

Common workflows¶
The most common workflows for Amp360 focus on data and databases, writing SQL to define tables and enable workflows, and interacting with attributes (both those output by Stitch and those generated by how semantic tags are applied to your tenant). Use Amp360 to:
Build your customer 360
Use SQL to define multiple databases, custom databases, and custom tables
Extend your customer 360 to make use of vertical-specific attributes and to define your own custom attributes
Explore data using the Data Explorer
The SQL query editor enable workflows, such as:
Linking the Amperity ID (first-party) to third-party provider person IDs
Enriching third-party non-PII data for customer analysis, segmentation, and targeting
Standardizing data for certain PII details
Using data hygiene to verify accuracy of PII with third-party data providers
Linking unknown IDs to known customers
Mapping unknown users to known customers
Mapping anonymous users to known customers
Customer 360 database¶
The customer 360 database is the most important database you can build in Amperity. It is the source from which all queries and segments are created and from which data will be sent to external systems for downstream workflows.
Flexible merge rules¶
Some customer data platforms require using an inflexible merge rule across multiple fields, which results in lower quality data across your customer 360 profile. This problem is magnified when that inflexible merge rule must also be applied to multuple customer 360 databases.
Amperity combines the use of flexible merge rules with a patented system that allows multiple customer 360 databases to exist within the same tenant. This ensures that:
Merge rules are 100% configurable
Each field can have its own merge rule
Each customer 360 database can have its own set of merge rules
Each tenant can support a variety of merge rules to meet all of the requirements for any individual use case
For example, data sources from call centers, online transactions, and email platforms may contain slightly different sets of customer profile data.

After loading this data to Amperity and assigning the Amperity ID to each of your customers, you can use flexible merge rules to support multiple customer 360 databases.
Your operations teams can combine prioritizing the most common values for each customer with deterministic matching
Your email marketing team can combine prioritizing customer profile values from your email platform with probabilistic matching
Your paid media team can combine all possible values to improve match rates on platforms like Google Ads and Facebook
Ask your Amperity implementation team for recommendations and best practices for how you can configure flexible merge rules to support all of your use cases.
Customer profiles¶
A customer profile is a collection of attributes that are associated with a single unique individual in the customer 360 database. The total number of customer profiles is equal to the total number of rows in the Customer 360 data table. This total correlates strongly, but not exactly, to the total number of Amperity IDs assigned to unique individuals in the same data set.
Customer profile details are pulled from the Customer_360 table, which represents each customer’s unified profile. This table contains common profile attributes, such as:
Names (first name, last name), email address, physical address, phone
Transaction details (first purchase, last purchase, total purchases, etc)
Other custom profile values that are unique to your company.
These details are summarized in the Customer Profile section of the Customer 360 tab.
Each customer profile is a collection of common attributes (first name, last name, email, phone, etc.), transaction attributes (first purchase, last purchase, total purchases, etc.), and other custom values that are unique to each customer’s data set. These details are summarized on the Customer 360 tab under Customer Profile.
About the data model¶
The data model represents the “out-of-the-box” tables that are available to every tenant. (AmpIQ tables are available only to tenants that have added AmpIQ to Amperity and have completed the process of enabling predictive attributes.)
Important
This data model represents the starting point for all tenants. It is common for a tenant to have additional tables that support specific data requirements and workflows.
Data tables¶
The following diagram shows the data model for core tables in Amperity. Color coded sections identify which groups of tables are associated with customer profiles, interactions records, Stitch QA, and AmpIQ.

Note
Click this diagram to open it in your full browser window. Click HERE to open this diagram in a new tab or right-click that link to save a copy to your computer.
There are four groups of tables in this diagram:
Data model indicators¶
This diagram uses the following indicators to highlight relationships between tables and to call out fields that are primary keys, establish links between tables, or associate this table back to a domain table in the Sources tab:
Spark SQL¶
Spark SQL is a high performance SQL query engine that is used by Amperity to ingest data, create domain tables, and extend the outcome of the Stitch process in your customer 360 database.
Queries¶
Queries enable you to discover lists of customers, get insight into their preferences and habits, identify properties and characteristcs of that list, and then use that list to initiate marketing actions, campaigns, and other downstream workflows.
Queries also enable you to write SQL that can be used to perform QA against various databases and tables in the customer 360 database.

The Queries tab provides a SQL interface for building queries. Use the visual editor to build queries with drop-downs and picklists. Use the SQL editor (and Presto SQL) to build more advanced queries. The Queries tab keeps a list of all queries, in both active and draft states.
Both editors can access all tables in the customer 360 database, which contains all of your important customer attributes, along with passthrough tables that bring data that was pulled to Amperity from the domain tables to the customer 360.
Query editor¶
The SQL Query Editor is the user interface for a full SQL query engine based on Presto SQL that interacts with customer database tables in Amperity. The SQL Query Editor relies primarily on using the SELECT statement, along with common table expressions, joins, functions, and other components of Presto SQL to build and design advanced queries.

Presto is a distributed SQL query engine that is designed to efficiently query vast amounts of data using distributed queries. Presto is used within the Queries and Segments pages in the Amperity user interface.
Because the SQL editor uses Presto SQL, you can also write any query directly as SQL.

Send to downstream workflows¶
You can send data from the customer 360 datasbase to any downstream location or workflow. There are two ways to do send data:
By using Presto SQL to send only data that is returned by a query to a configured destination
By exporting a database or a table
Export databases and tables¶
A database may be configured to export one (or more) tables or an entire database from Amperity. Each data export must be assigned a unique name. A data export must be associated with a configured destination and must be added to an orchestration.
Business Intelligence Connect¶
Business Intelligence Connect is an Amperity-managed cloud data warehouse that provides an easy-to-access location from which you can use any BI tool to access all of your Amperity data.
Business Intelligence Connect supports all of the leading BI tools, including Tableau, Looker, Domo, Qlik, Microsoft PowerBI, Amazon QuickSight, Oracle Business Analytics, and SAP Business Objects, along with any BI tool that can connect to a data warehouse using the Open Database Connectivity (ODBC) or Java Database Connectivity (JDBC) standards.
Business Intelligence Connect is available upon request for Amperity tenants who have licensed Amp360. After the data warehouse for Business Intelligence Connect is configured by Amperity for your tenant, you can send data from Amperity to the data warehouse, and then connect any of your BI tools to that data.