AmpIQ
Amp360
DataGrid & AmpID
Amperity A-Z
|
Get Support

Amperity A-Z
Attributes
- Days since latest order
- Early repeat purchaser?
- One and done?
- Predicted CLV
- Product affinity
  - Audience sizes
  - Ranking
- Purchase behaviors
- RFM scores
Campaigns
- About campaigns
- About the Campaigns tab
- How campaigns work
- Campaign workflows
- Audiences
- Attributes
- Campaign results
- Control groups
- Exclusion lists
- Recipient groups
- Sub-audiences
- How-tos
Courier groups
- About courier groups
- Schedules
- Wait times
- Offsets
- Time zones
- How-tos
  - Add courier group
  - Delete courier group
  - Run courier groups
Couriers
- About couriers
- File couriers
  - About file couriers
  - Load settings
  - File patterns
  - File compression / archive
    - GZIP
    - TAR
    - ZIP
  - Pretty Good Privacy (PGP)
- API couriers
- Snowflake couriers
- Load operation types
- Examples by file format
  - Apache Avro
  - Apache Parquet
  - Campaign Monitor
  - CBOR
  - CSV
  - JSON
  - NDJSON
  - PSV
  - Salesforce Commerce Cloud
  - Salesforce Sales Cloud
  - Snowflake
  - TSV
  - XML
- How-tos
Data exports
- About data exports
- How-tos
Data tables
- About data tables
- AmpIQ predictions
  - Customer lifetime value
  - Product affinity
- Campaign recipients
- Customer 360
- Customer attributes
- Email engagement
  - Attributes
  - Summary
- Lifecycle events
- Merged customers
- QA
- Transaction attributes
- Transaction attributes, extended
- Unified coalesced
- Unified compliance
- Unified customer
- Unified email events
- Unified itemized transactions
- Unified product catalog
- Unified scores
- Unified transactions
Data templates
- About data templates
- Campaign templates
  - About campaign templates
  - Recommended patterns
  - Campaign variables
    - Campaign names
    - Group names
  - Campaign examples
- File templates
  - About file templates
  - .DONE files
  - Encoding methods
  - Escape characters
  - File formats
  - Filename templates
  - Header rows
  - Line endings
  - Quote modes
- API templates
- Snowflake templates
  - About Snowflake templates
  - Location
  - Table actions
    - Create
    - Drop
    - Truncate
- How-tos
Databases
- About databases
- About the Customer 360 tab
- All databases
  - View all databases
  - Customer 360 database
  - Multiple databases
  - Flexible merge rules
  - Table groups
- How-tos
  - Activate database
  - Add database
  - Add with 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 data
  - Profile icons
    - Apply icons
    - Refresh icons
  - Run databases
  - View all databases
  - View database
  - View notifications
  - View statistics
Domain tables
- About domain tables
- Column types
- Record types
- Custom domain tables
- How-tos
Feeds
- About feeds
- About the Feed Editor
- Field types
  - About field types
  - Boolean
  - Date
  - Datetime
  - Decimal
  - Float
  - Integer
  - String
- About semantic tags
- How-tos
  - Activate feed
  - Add feeds
    - For new sources
    - For existing sources
  - Apply semantic tags
  - Configure feed schema
  - Delete feeds
  - Edit feeds
  - Generate fields
  - Load data upon activation
  - Make available to Stitch
  - Replace data source
  - Resolve name conflicts
  - Set error thresholds
  - Truncate feed
  - View sample data
File formats
- About file formats
- Format types
  - Apache Avro
  - Apache Parquet
  - CBOR
  - CSV
  - DAT
  - JSON
  - NDJSON
  - PSV
  - Streaming JSON
  - TSV
  - XML
File uploads
- File upload use cases
- Query output
- How-tos
Ingest queries
- About ingest queries
- Spark SQL docs
- Courier load operations
Notifications
- About notifications
- Notification types
  - Running
  - Completed
  - Warnings
  - Errors
- Notification for
- How-tos
  - Open Workflow tab
  - Resolve workflow errors
Orchestration groups
Orchestrations
- About orchestrations
- How-tos
  - Add orchestration
  - Assign database export
  - Assign query
  - Delete orchestration
  - Edit orchestration
  - Run orchestration
  - View notifications
Policies
- About policies
- How policies work
- Standard policies
- Administrator policies
- Read-only options
- Policy options
  - Restrict Download Access
  - Restrict PII Access
  - User Administrator
- Allowed actions
Predictive models
Presto SQL
- About Presto SQL
- Why this reference?
- AWS vs. Azure
- Recommendations
- WITH clause
- SELECT statement
- SELECT DISTINCT statement
- FROM clause
- LEFT JOIN clause
- WHERE
- CASE
- GROUP BY
- HAVING clause
- UNION clause
- UNNEST clause
- VALUES clause
- Window functions
- ORDER BY clause
- LIMIT clause
- Operators
  - About operators
  - ALL
  - ANY
  - BETWEEN
  - IS NOT NULL
  - IS NULL
  - SOME
- 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()
  - IF()
  - LEAST()
  - LENGTH()
  - LOWER()
  - MAX()
  - MEDIAN()
  - MIN()
  - NOW()
  - NTILE()
  - NULLIF()
  - 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
- Explore data
- Queries editor
- How-tos
Segments
- About segments
- Segments tab
- Segment editor
- Segment insights
- SQL editor
- How-tos
Semantic tags
- About semantic tags
- Semantic tag types
  - Blocklist
  - Compliance
  - Custom
  - Database
  - Keys
  - Email engagement
  - Loyalty
  - Product catalog
  - Profile (PII)
  - Stitch labels
  - Transactions
    - Items
    - Orders
Single sign-on (SSO)
- About SSO
- How SSO works
- Use cases
- Request to enable
Spark SQL
- About Spark SQL
- Why this reference?
- Recommendations
- WITH clause
- LATERAL VIEW clause
- SELECT statement
- SELECT DISTINCT statement
- FROM clause
- JOINs
- WHERE clause
- CASE expression
- GROUP BY clause
- HAVING clause
- Window functions
- ORDER BY clause
- LIMIT clause
- Operators
  - About operators
  - ALL
  - ANY
  - BETWEEN
  - IS NOT NULL
  - IS NULL
  - SOME
- PIVOT operator
- Functions
  - ABS()
  - AVG()
  - CAST()
  - COALESCE()
  - COLLECT_LIST()
  - CONCAT()
  - CONCAT_WS()
  - 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()
  - LPAD()
  - 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()
  - UNIX_TIMESTAMP()
  - UPPER()
Stitch
- About Stitch
- How Stitch works
- About the Stitch tab
- Run Stitch
- Expore Stitch results
Users
- About users and activity
- Manage users
- SSO group mappings
- Resource groups
- User activity
  - About user activity
  - Activity downloads
Workflows
- About workflows
- About the Workflows page
- Workflow alerts
- Resolution categories
- Resolution types

Destinations¶

TBD