Site Index

Campaigns

About campaigns About the Campaigns tab One-time campaigns Recurring campaigns Audiences Exclusion lists Control groups Recipient groups Sub-audiences

Courier groups

About courier groups Schedules Wait times Offsets Time zones

How-tos: Add courier group Delete courier group Automatically For a date range For a specific day For all data Manually

Couriers

About couriers

File couriers: About file couriers Load settings File patterns Wildcards Literal strings Date components File compression / archive Pretty Good Privacy (PGP) Input examples for single files for multiple files

API couriers: About API couriers

Snowflake couriers: About Snowflake couriers Table lists Stage names Load operations

Load operation types: Empty Incorrect feed ID Load files Load ingest query Truncate, then load

Examples: Apache Avro Apache Parquet Campaign Monitor CBOR CSV JSON NDJSON PSV Salesforce Commerce Cloud Salesforce Sales Cloud Snowflake TSV XML

How-tos: Add courier Add courier as copy Add to courier group Delete courier Edit courier Load data only Run couriers for date range for all data without load operations Restart job View courier

Data exports

About data exports

How-tos: Add data export Add table export Add to orchestration Delete data export Discard data export Switch database Remove table View data exports

Data tables

About data tables About the data model

The core data model for Amperity.

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.

Data tables: Campaign_Recipients Customer360 Customer_Attributes Detailed_Examples Email_Engagement_Attributes Email_Engagement_Summary Lifecycle_Events Merged_Customers Predicted_Affinity Predicted_CLV_Attributes Stitch_Blocking_Keys Stitch_Scores Transaction_Attributes Transaction_Attributes_Extended Unified_Changes Unified_Changes_Clusters Unified_Changes_PKS Unified_Coalesced Unified_Customer Unified_Email_Events Unified_Itemized_Transactions Unified_Preprocessed_Raw Unified_Product_Catalog Unified_Scores Unified_Transactions

Data templates

About data templates File templates

Common settings: .DONE files Encoding methods Escape characters File formats Filename templates Header rows Line endings Quote modes

Specific settings: Amazon S3 Azure Blob Storage Google Cloud Storage SFTP API templates Snowflake templates

How-tos: Add data template Allow to send queries Allow to send PII Delete data template Edit data template Enable success file Map to external schemas Make available to campaigns

Databases

About databases Customer 360 tab Customer profiles All databases Customer 360 database Multiple databases Flexible merge rules

Table groups: Standard Source and custom QA

How-tos: Activate database Add database Add database from template Add table Configure database Configure table Delete database Delete table Discard drafts Edit database Edit table Enforce static schemas Explore customer profile Explore database Export databases and tables Run databases View all databases View database View notifications View statistics

Domain tables

About domain tables Column types Customer records Interaction records Custom domain tables Domain SQL

How-tos: Combine day, month, year as birthdate Combine five- and four-digit postal codes Extract first and last names Hash PII data that has been resent to Amperity Parse fields with multiple separators Set non-US-ASCII email addresses to NULL Standardize values for USA states

Feeds

About feeds Feed Editor Apply semantic tags

Field types: Boolean Date Datetime Decimal Float Integer String

How-tos: Activate feed Add column Add feeds from new sources Add feeds from existing sources Add field Add foreign key Apply custom semantic tags Apply customer profile (PII) semantic tags Apply itemized transaction semantic tags Apply transaction semantic tags Edit primary key Delete columns Delete fields Edit domain table name Generate combined keys Generate customer keys Generate foreign keys Incoming field names Load data upon activation Load new data Make available to Stitch Rename fields Replace data source Resolve name conflicts Set error thresholds Set last updated field Set error thresholds Truncate feed View sample data

File formats

About file formats Apache Avro Apache Parquet CBOR CSV DAT JSON NDJSON PSV Streaming JSON TSV XML

Ingest queries

About ingest queries Spark SQL

Example courier load operations: Apache Avro Apache Parquet CBOR CSV JSON NDJSON PSV Streaming JSON TSV XML

Example ingest queries: Build birthdate Concatenate columns Explode transactions Find records Flatten with identifiers Import billing as address JOIN datasets Parse nested records Remove field Select all fields

How-tos: Add ingest query Add to courier as load operation Delete ingest query Edit ingest query

Orchestration groups

About orchestration groups Schedules Time zones Courier group constraints Offsets

How-tos: Add orchestration group Run orchestration group Schedule orchestration group

Orchestrations

About orchestrations

How-tos: Add orchestration Assign database export Assign query Delete orchestration Edit orchestration Manually Scheduled, always run Scheduled, wait for changes Wait for changes

Policies

About policies How policies work

Standard policies: Amp360 User AmpIQ User DataGrid Operator

Administrator policies: DataGrid Administrator Sandbox Administrator SLA Administrator

Read-only policies: Amp360 User AmpIQ User DataGrid Operator

Policy options: Restrict Download Access Restrict PII Access User Administrator

predictive models

Churn propensity Predicted CLV Product affinity

Presto SQL

About Presto SQL

General recommendations: General recommendations Commas Indentation Naming conventions NULL values Reserved words One-way SHA-256 hashes Whitespace

SELECT statements, operators, and clauses: WITH clause SELECT statement SELECT DISTINCT statement FROM clause LEFT JOIN clause WHERE clause CASE expression GROUP BY clause HAVING clause UNION clause UNNEST clause VALUES clause Window functions ORDER BY clause LIMIT clause Operators PIVOT operator

Functions: ARRAY_AGG() ARRAY_JOIN() AVG() CAST() CHR() COALESCE() CONCAT() COUNT() CURRENT_DATE CURRENT_TIMESTAMP DATE_DIFF() DATE_FORMAT() DATE_TRUNC() DAY(), MONTH(), YEAR() DENSE_RANK() FROM_UNIXTIME() GREATEST() IF() LEAST() LENGTH() LOWER() MAX() MEDIAN() MIN() NOW() NTILE() PERCENT_RANK() PERCENTILE() RANK() REGEXP_EXTRACT() REGEXP_LIKE() REGEXP_REPLACE() REPLACE() ROUND() SPLIT() SPLIT_PART() SUBSTR() SUM() TO_HEX() TO_UNIXTIME() TRIM() TRY_CAST() UPPER()

Queries

About queries Queries tab

Data explorer: About the data explorer Docked mode Full screen mode Table schema Completion Cardinality vs. uniqueness Table examples Table details

Query editor: Query editor About Presto SQL Validate queries

How-tos: Add comment to query Add as SQL query Add as visual query Add to orchestration Autocomplete table names Browse tables and columns Comment lines Copy column names Add as copy Copy SELECT statement Delete query Discard a draft query Download query Edit query Enable query alerts Format SQL Open query Organize queries Add folder Add subfolder Move query Preview results Refresh query automatically Rename query Run query Run selection Select database Uncomment lines Use keyboard shortcuts View notifications View recently edited queries View related orchestrations View query View query details

Segments

About segments Segments tab Recommended segments Summary page Customers page

Segments editor: Segment names Database tables Attribute groups AND vs. OR Segment insights SQL editor

How-tos: Browse tables and columns Discard segment Download segment Organize segments Select database Show columns Switch to SQL segment

Semantic tags

About semantic tags Blocklist Compliance Custom Database Email events Email summary Itemized transactions Keys Loyalty Product catalog Profile (PII) Stitch labels Transactions

Single sign-on (SSO)

About single sign-on (SSO) How SSO works (with Amperity) Use cases Request to enable

Spark SQL

About Spark SQL

General recommendations: General recommendations Add comments Avoid low cardinality Avoid multiple passes Commas Escape characters Daisy-chain LEFT JOINs Faster operations are better Filter, then combine Identifiers Indentation Limit expensive operations Limit extra work Limit tables Load sizes Naming conventions NULL values One-way SHA-256 hashes Reserved words Subqueries Temporary tables Whitespace

SELECT statements, operators, and clauses: WITH clause LATERAL VIEW clause SELECT statement SELECT DISTINCT statement FROM clause JOIN clauses WHERE clause CASE expression GROUP BY clause HAVING clause Window functions ORDER BY clause LIMIT clause Operators PIVOT operator

Functions: ABS() AVG() CAST() COALESCE() COLLECT_LIST() CONCAT() COUNT() COUNT(DISTINCT) CURRENT_DATE() CURRENT_TIMESTAMP() DATE() DATE_ADD() DATE_TRUNC() DATEDIFF() DECODE() DENSE_RANK() EXPLODE() FIRST_VALUE() IF() ISNOTNULL() ISNULL() LAST() LEAST() LEFT() LENGTH() LOCATE LOWER() MAX() MIN() MONTHS_BETWEEN() NOW() NTILE() NULLIF() RAND() RANK() REGEXP_EXTRACT() REGEXP_REPLACE() RLIKE() ROUND() ROW_NUMBER() SHA2() SPLIT() STRPOS() SUBSTR() SUBSTRING() SUM() TO_DATE() TO_TIMESTAMP() TRANSLATE() TRIM() UPPER()

Stitch

About Stitch Run Stitch Select domain tables

Explore Stitch results Explore by Amperity ID Explore by data source Explore previous Stitch results Explore semantics View cluster graph View deduplication rate View pairwise connections View Stitch metrics View stitched records

Users

About users About user activity Activity downloads

Manage users: About managing users Add users Delete users Edit users Revoke tenant access Allowlist domains

Resource groups: About resource groups “All resource groups” Custom resource groups Assign users to resource groups Database permissions Multi-brand tenants

Workflows

About workflows Resolve errors Resolution categories Available resolutions