Site Index

About sandboxes

About sandboxes About sandbox workflows Request a sandbox Access your sandbox Review updates Pull updates Resolve conflicts Make configuration changes Request to promote Review changes Promote to production

Manage sources

Any SFTP site Acxiom Adobe Analytics Amazon Kinesis Data Firehose Amazon S3 Attentive Mobile Azure Blob Storage BazaarVoice Bluecore Braze Brightloom Campaign Monitor Cheetah Digital Cordial Dynamic Yield Experian Google Analytics Google Cloud Storage HubSpot Klaviyo Kustomer Listrak Monetate Optimizely Oracle Responsys Sailthru Salesforce Commerce Cloud Salesforce Marketing Cloud Salesforce Pardot Salesforce Sales Cloud SFTP (in Amperity) Shopify Snowflake (on Amazon AWS) Snowflake (on Microsoft Azure) Square Vibes Zendesk

Recommendations for sending data to Amperity

Reshape data on ingest

About ingest queries About Spark SQL About load operations for ingest queries Add ingest query Add load operation

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

Apply semantic tags

About feeds About semantic tags

Configure feeds: Set the primary key Apply semantic tags Select last updated field Make available to Stitch

Customer profiles: About customer profiles Address groups Email addresses Loyalty programs Names Phone numbers

Customer interactions: About customer interactions Apply to feeds or use domain SQL? Associate to Amperity IDs

Keys: About keys Blocking keys (bk) Customer keys (ck) Foreign keys (fk) Primary keys (pk) Separation keys (sk)

Product catalogs: About product catalogs Define product catalogs

Review domain data

Review domain data: Review domain data Amperity-added columns Column types Record types

Reshape domain data: Reshape domain data About domain SQL Build birthdates Combine postal codes Extract names Hash profile data Parse multiple separators Set non-USA email to NULL Standardize phone numbers Standardize USA states

Run Stitch

Add tables to Stitch run Run Stitch Configure Stitch

Build databases

Add customer records Add interactions records Enable AmpIQ Enable predicted modeling

Validate results

Review Stitch results About Stitch QA About transactions QA

Define blocklists: Blocklist 360 values Blocklist bad-values Apply Stitch labels

Configure Stitch: Blocking strategies Case-sensitive foreign keys Clustering algorithm Email addresses patterns Empty tables Matching strategy Matching thresholds Preprocessing profiles Record history days Stable ID assignment Stitch reports Supersized clusters Trivial duplicates

Manage databases

About databases About Spark SQL Define customer profile Export databases and tables

Table types: Standard tables Source and custom tables QA tables

Manage databases: About databases Add empty database Add database from template Customer 360 template Passthrough template Stitch QA template Use multiple databases Apply flexible merge rules

Manage tables: About tables Add as passthrough Add as SQL Add from table template

Standard table templates: Customer360 Customer_Attributes Lifecycle_Events Email_Engagement_Attributes Merged_Customers Transaction_Attributes Unified_Coalesced Unified_Customer Unified_Itemized_Transactions Unified_Scores Unified_Transactions

Multibrand table templates: About multi-brand templates Customer360 Transaction_Attributes Transaction_Attributes_Extended Unified_Itemized_Transactions Unified_Transactions

Validation alerts: About validation alerts Implicit CROSS JOIN OVER without PARTITION BY Unescaped backslashes Unintentional broadcast joins

Query historical data: About querying historical data Available versions Return versions by datetime Return versions by offset View all versioned tables

Extend databases: Add a graph database Add a PII table Add householding Calculate nearest store Predict gender Support CCPA and GDPR workflows Use first-party data Use third-party data

Configure destinations

Any SFTP site Active Campaign Acxiom Adobe Campaign Adobe Customer Attributes Adobe Experience Platform Adobe Marketo Amazon Redshift Amazon S3 Attentive Mobile Azure Blob Storage Azure Synapse BazaarVoice Bluecore Braze Brightloom BI Connect Campaign Monitor Cheetah Digital Cordial Criteo Databricks Domo Dynamic Yield Evocalize Experian Facebook Ads Google Ads Google Audience Partner API Google BigQuery Google Cloud Storage HubSpot Infutor Kibo Klaviyo Koupon Media Listrak LiveRamp Mailchimp Microsoft Ads Microsoft Dynamics Monetate Neustar Optimizely Oracle Data Cloud Oracle DMP Oracle Responsys PebblePost Persado Microsoft Power BI PowerReviews Sailthru Salesforce Marketing Cloud Salesforce Sales Cloud Snapchat Snowflake (on Amazon AWS) Snowflake (on Microsoft Azure) Tableau Throtle Vibes Zendesk

Automate workflows

About workflows

Courier groups: About courier groups Add courier group Apply constraints Specify wait times Define offsets Run courier group

Orchestration groups: About orchestration groups Add orchestration group Apply courier offsets Define schedules Specify time zones Run orchestration group