Site index¶
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
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
- 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¶
Data tables¶
About data tables About the data model
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
- 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
- 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¶
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
- Allowed actions
Sources Stitch Customer 360 Queries Segments Campaigns Destinations Workflows Users & Activity Credentials Data Explorer Sandboxes
Predictive models¶
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¶
- Data explorer
About the data explorer Docked mode Full screen mode Table schema Completion Cardinality vs. uniqueness Table examples Table details
- Query editor
- 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¶
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
Single sign-on (SSO)¶
About single sign-on (SSO) How SSO works (with Amperity) Use cases Request to enable
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¶
Users¶
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