Site index¶
About sandboxes¶
About sandboxes ● Allow sandbox administration ● About sandbox workflows ● Best practices ● Common tasks
Sync data with Amperity¶
Manage sources¶
- Sync data
- Pull data
Any SFTP site ● Acxiom ● Adobe Analytics ● Adobe Campaign ● Adobe Commerce ● Adobe Customer Attributes ● Amazon Kinesis Data Firehose ● Amazon S3 ● Attentive Mobile ● Azure Blob Storage ● BazaarVoice ● Bluecore ● Braze ● Camelot SMM ● Cheetah Digital ● Cordial ● Cross Country Computer ● Dynamic Yield ● Emarsys ● Epsilon Abacus ● Epsilon Conversant ● Epsilon Targeting ● Experian ● Google Analytics ● Google Cloud Storage ● Heap ● HubSpot ● Infutor ● Koupon Media ● Klaviyo ● Kustomer ● Listrak ● Microsoft Dataverse ● Monetate ● Neustar ● Optimizely ● Oracle Data Cloud ● Oracle Opera ● Oracle Responsys ● PowerReviews ● PebblePost ● Quad ● RR Donnelly ● Sailthru ● Salesforce Commerce Cloud ● Salesforce Marketing Cloud ● Salesforce Pardot ● Salesforce Sales Cloud ● SFTP (in Amperity) ● Shopify ● SMG ● Snowflake (on Amazon AWS) ● Snowflake (on Microsoft Azure) ● SoundCommerce ● 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
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¶
Build databases¶
Add customer profiles ● Add transactions ● Enable segments and campaigns ● Enable predicted modeling
Validate results¶
Review Stitch results ● About Stitch QA ● About transactions QA
- Define blocklists
Blocklist bad-values ● Apply Stitch labels ● Manage nicknames
- Configure Stitch
Select stitched tables ● One-to-one Stitch ● Stitch reports Clustering and fine-tuning Blocking strategy ● Case-sensitive foreign keys ● Matching strategy ● Matching thresholds Performance Allowed empty tables ● Days of recorded history Stitch processing Force Stitch to run ● Ignore jitter alerts ● Skip unified changes ● Skip unified scores Stable IDs ● Advanced settings Automatic bad value detection ● Clustering algorithm ● Pre-processing profiles Pre-processing profiles Australian phone numbers ● Clean foreign keys ● Email addresses ● Multiple preprocessing profiles ● Normalize gender ● Supersized clusters ● Trivial duplicates ● Semantic exclusions
Manage databases¶
About databases ● About Spark SQL ● Define customer profile ● Export databases and tables
- Table types
- 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
Customer 360 ● Customer Attributes ● Email Engagement Attributes ● Email Opt Status ● Merged Customers ● SMS Opt Status ● Transaction Attributes ● Unified Coalesced ● Unified Customer ● Unified Itemized Transactions ● Unified Scores ● 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 creation date ● 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¶
- File systems
Any SFTP site ● Amazon S3 ● Azure Blob Storage ● Google Cloud Storage
- Paid media
Amazon Ads ● Criteo Audience API ● Criteo Retail Audience API ● DV360 ● Facebook Ads ● Facebook Messenger ● Google Ads ● Instagram ● Microsoft Advertising ● Pinterest ● Snapchat ● The Trade Desk ● TikTok ● Walmart DSP ● WhatsApp ● YouTube ● Yahoo DSP
- Customer engagement
Active Campaign ● Adobe Campaign ● Airship ● Amazon Pinpoint ● Braze ● Cheetah Digital ● Cordial ● Dynamic Yield ● HubSpot ● Klaviyo ● Listrak ● LiveRamp ● Mailchimp ● PebblePost ● Sailthru ● Salesforce Marketing Cloud
- Business operations
Acxiom ● Adobe Customer Attributes ● Adobe Experience Platform ● Adobe Marketo ● AWS Connect ● Attentive ● BazaarVoice ● Bluecore ● Dynamics 365 Marketing ● Evocalize ● Experian ● Infutor ● Koupon Media ● Monetate ● Neustar ● Optimizely ● Oracle Data Cloud ● Oracle Responsys ● Persado ● PowerReviews ● Salesforce Sales Cloud ● Throtle ● Tulip ● Vibes ● Zendesk
- Analytics
BI Connect ● Domo ● Microsoft Dynamics ● Microsoft Power BI ● Tableau
- Cloud data
Amazon Redshift ● Azure Synapse ● Google BigQuery ● Microsoft Dataverse ● Snowflake (on Amazon AWS) ● Snowflake (on Azure)
- Custom
Automate workflows¶
- Courier groups
- Orchestration groups
About orchestration groups ● Run after courier group ● Run on a schedule