Site index

Amperity Bridge

About Amperity Bridge Outbound shares

Campaigns

About campaigns About the Campaigns page

Campaign features

Attributes Audiences Control groups Destinations Exclusion lists Treatment groups Sub-audiences Timing and launch dates

Campaign types

One-time campaigns Recurring campaigns Multi-channel campaigns

How-tos

Add a sub-audience Apply exclusion list Archive campaign Build audience Choose campaign type Configure a multichannel campaign Configure a one-time campaign Configure a recurring campaign Copy campaign ID Delete campaign Discard campaign Duplicate campaign Edit attribute Edit campaign Edit sub-audience Enable Campaign Recipients table Remove sub-audience Schedule campaign Select destinations Send campaign metadata to destination Set campaign launch date Set delivery schedule Search campaigns View campaign View campaign history View delivery summary View notifications View workflow

Courier groups

About courier groups Schedules Wait times Offsets Time zones

How-tos

Add courier group Copy courier group Delete courier group Load data only for past day 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 Wildcards within archives Literal strings Date components File compression / archive 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 and only load files Run for a specific day Run for a time period Run, but skip missing files 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 Customer 360 Customer Attributes Detailed Examples Email Engagement Attributes Email Engagement Summary Merged Customers Predicted Affinity Predicted CLV Attributes Stitch Blocking Keys Stitch Scores Transaction Attributes Transaction Attributes Extended 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 page 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

Domain SQL examples

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

How-tos

Add domain table Add custom domain table Delete domain table Delete records Edit domain table Explore domain table View sample data View schema Purge domain table Rename domain table Search domain tables View domain table View domain table history

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 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 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 Run after courier group Run on a schedule Run manually

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 Administrator DataGrid Operator

Policy options

Allow API key administration Allow Profile API administration Allow sandbox administration Allow source data deletion Allow user administration Restrict data exports Restrict download access Restrict PII access Restrict upload access

Read-only policies

Amp360 User AmpIQ User DataGrid Operator

Allowed actions

Sources Stitch Customer 360 Queries Segments Campaigns Destinations Workflows Users & Activity Credentials Data Explorer Sandboxes

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 page

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

Recent activity

About notifications

Sandboxes

About sandboxes Allow sandbox administration About sandbox workflows

Best practices

Continuous validation Data across environments Run partial workflows Short-lived sandboxes

How-tos

Access a sandbox Add a sandbox Delete a sandbox Edit sandbox details Open a sandbox Pull updates from production Promote changes Resolve validation issues Review changes View sandbox details View validation details

Segments

About segments Segments page Recommended segments Summary page Customers page How segments work Segment overview

Segments editor

Segment names Attributes Operators Segment insights Databases and tables AND vs. OR SQL editor

How-tos: * Add attribute Add attribute from query Add attribute from table Browse tables and columns Add a query output to a segment Add a query output to a segment Add segment Add section Add condition Add an uploaded file to a segment Browse tables and columns Bulk delete segments Change insight date range Comment on a query Compare segment insights Configure recommended segments Copy a segment ID Copy a SQL Query Customize insights charts Delete a segment Discard segment Download segment Duplicate segment Edit segment from the Segments page Edit segment from Segment Editor Expand a graph Format a segment Open data explorer Organize segments Rename a segment Rerun a segment Search segments Select database Select multiple values Set default charts Show columns Switch to SQL segment Use relative dates View a segment View matching records from a table View uploaded files

Semantic tags

About semantic tags Blocklist Compliance Custom Database Email events Email opt-in status Email summary Keys Loyalty programs Profile (PII) SMS opt-in status 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

Stitch results

About Stitch results 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 Allowed 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 About the Workflows page About workflow alerts

Common resolutions

Ignore missing file Restart workflow Retry task Skip a task Update credentials Update error threshold

Context-specific resolutions

for campaigns for courier groups for databases for destinations for scheduled orchestration groups for sources for Stitch

How-tos

Configure duration alerts Filter workflows Hide skipped tasks Resolve workflows Search workflows Send alerts to email addresses Send alerts to Slack channels View all workflows View details View resolutions View workflow graphs

Open workflow alerts

from email alerts from Recent activity pane from Slack alerts from Workflow page