Redpoint + Snowflake + AEP
Architecture summary
In this reference solution architecture document, we present a strategic framework for integrating Redpoint Global's Customer Data Platform (CDP) with Snowflake's cloud-based data warehousing and analytics platform along with Adobe's customer engagement platform, Adobe Experience Platform (AEP). This integration is designed to leverage the strengths of each platform, facilitating a seamless flow of unified customer data from Redpoint CDP using Snowflake’s data warehousing and integrating AEP for targeted and personalized customer engagement.
By outlining the technical and strategic considerations, this document serves as a comprehensive guide for our internal users, partners, and clients, empowering them to effectively unify customer data, derive actionable insights, and make data-driven decisions with unparalleled speed and accuracy. The architecture aims to optimize data utilization across platforms, enhance data governance and security, and provide a single source of truth for customer data to the Adobe platform ecosystem.
With Snowflake's scalable and high-performance data warehousing capabilities, organizations can efficiently store, manage, and analyze massive volumes of customer data, enabling real-time insights and personalized customer experiences. By integrating Redpoint CDP with Snowflake, businesses can unlock the full potential of their customer data, drive innovation, and gain a competitive edge in today's data-driven landscape. Additionally, by working in tandem with AEP, businesses can enhance interactions across multiple channels, including web, mobile, email, SMS, and mobile apps, further enriching the customer experience.
Example use cases
Unified customer view for personalized campaigns and experiences across multiple channels
Advanced customer segmentation for targeted outreach
Real-time customer insights for immediate action
Predictive analytics to forecast customer behavior
Simplified data governance and compliance management
Enhanced data security and privacy controls
Scalable data storage for growing customer data volumes
Personalized customer journeys
Real-time triggered campaigns
Experience optimization
Customer lifecycle management
Logical diagram
![snow-aep.png](../__attachments/3993370636/snow-aep.png?inst-v=c3007bf4-8f91-43d3-9633-90859273c945)
Key components and roles
Redpoint CDP
Unified profile of individuals
Identity resolution with key persistence
API-accessible single customer views
Audience definition / segmentation
Snowflake
Data warehouse and storage
Secure data sharing
Data governance
Data modeling
Scalable point of data integration
Adobe Experience Platform
Audience definition / segmentation
Orchestration
Personalized messaging
Real-time engagement - triggered messages
Real-time engagement - on-site personalization
Data flows
Source system | Target system | Representative data | Transfer mechanism | Cadence | Notes |
---|---|---|---|---|---|
Redpoint | Snowflake | Demographic | ODBC/JDBC | Seconds | |
Website | Redpoint | Web Events | Realtime Services | Milliseconds | If using Adobe Analytics, web events collected there are passed into Redpoint via Realtime Services or alternatively via message queue. |
Redpoint | Website | Real-time decisions | API | Milliseconds | Or Adobe Target (if applicable). |
Transactional Systems | Redpoint | Transactions/Behaviors | API/Batch/Queue | Seconds | |
Snowpark | Redpoint | Model Scores | ODBC/JDBC | Seconds | |
Redpoint | Snowpark | Offer History | ODBC/JDBC | Seconds | |
Redpoint | AEP/Adobe Campaign | Demographic | Snowflake (batch) | Scheduled via AEP | Setup performed in AEP to connect to Redpoint tables in Snowflake. |
Flow Service API | On-demand | Requires subscription with Adobe. | |||
Snowflake Federated Data Access Connector | Direct, real-time access to Redpoint in Snowflake for Adobe Campaign | ||||
AEP/Adobe Campaign | Redpoint | Events | API/Batch | Milliseconds when using the API | Requires I/O subscription with Adobe. |
Data Science | Redpoint | Model Scores Next Best… | API/Batch |
|
|
Redpoint | Data Science | Offer History | API/Batch |
|
|
Why does this architecture/solution make sense?
In this architecture, Redpoint CDP acts as the central hub for customer data collection, unification, and enrichment, serving as the single source of truth for customer data, both consuming data from and persisting data within Snowflake. Snowflake functions as the robust and scalable data storage and processing powerhouse, enabling efficient data warehousing, advanced analytics, and secure data sharing. By integrating these two platforms, organizations can create a seamless data pipeline that leverages the strengths of each system.
Redpoint CDP's ability to collect and refine customer data from various sources, coupled with its advanced identity resolution and data quality management capabilities, ensures that high-quality, unified customer profiles are readily available. Snowflake's cloud-based architecture and near-infinite scalability allow for the storage and processing of massive volumes of customer data, enabling real-time analytics and insights.
This integration empowers organizations to break down data silos, achieve a holistic view of their customers, and make data-driven decisions with unparalleled speed and accuracy. By leveraging Snowflake's data sharing capabilities, organizations can securely share customer insights across departments and with external partners, fostering collaboration and innovation. Moreover, the combined solution helps organizations maintain data governance and compliance with global data privacy regulations, as both platforms prioritize data security and privacy.
The Redpoint CDP + Snowflake architecture creates a powerful, end-to-end customer data management and analytics solution that drives personalized customer experiences, optimizes marketing strategies, and fuels business growth in today's data-driven landscape.
Furthermore, integrating AEP streamlines outbound communications by supporting robust marketing campaigns, personalized customer journeys, and uniform messaging across diverse channels. This approach ensures all communications are cohesive, enhancing customer engagement. Moreover, AEP captures essential marketing disposition data during these interactions and relays it to Redpoint CDP via Snowflake. This process enriches the CDP, offering a holistic view of customer behaviors and enabling more precise adjustments to engagement strategies. Collectively, Snowflake, AEP, and Redpoint CDP forge a seamless, data-driven communication ecosystem that meets the demands of contemporary marketing.
Business benefits
360-Degree Customer View: By integrating Redpoint CDP, Snowflake, and AEP, organizations can achieve a comprehensive, unified view of their customers, enabling them to deliver highly personalized experiences, improve customer satisfaction, and increase customer lifetime value.
Enhanced Data-Driven Decision Making: The combination of Redpoint CDP's data unification and enrichment capabilities with Snowflake's advanced analytics and real-time data processing, along with AEP’s outbound multi-channel execution and disposition data feedback, empowers businesses to make informed, data-driven decisions that drive growth, optimize marketing strategies, and improve operational efficiency.
Scalability and Performance: Snowflake's cloud-based architecture and near-infinite scalability, coupled with Redpoint CDP's robust data management capabilities, allow organizations to efficiently store, process, and analyze massive volumes of customer data, ensuring optimal performance and the ability to grow with the business. Integrating AEP for outbound delivery and personalized experiences further increases the resources of the platform and by proxy extending the scalability and performance.
Secure Data Sharing and Collaboration: Snowflake's secure data sharing features, combined with Redpoint CDP's data governance and compliance capabilities, enable organizations to safely share customer insights across departments and with external partners (such as AEP), fostering collaboration, innovation, and data-driven decision-making.
Reduced Data Silos and Improved Efficiency: By integrating Redpoint CDP, Snowflake, and AEP, businesses can break down data silos, streamline data management processes, and reduce the time and effort required to derive valuable customer insights, ultimately improving operational efficiency and reducing costs.
Technical benefits
Unified and Enriched Customer Data: Redpoint CDP's advanced data unification and enrichment capabilities consolidate customer data from various sources, creating a single, comprehensive view of each customer and enhancing data quality for accurate analysis and targeting.
Scalable and High-Performance Data Warehousing: Snowflake's cloud-based architecture and near-infinite scalability enable organizations to store, manage, and process massive volumes of customer data efficiently, ensuring optimal performance and the ability to handle growing data needs.
Real-Time Data Processing and Analytics: Snowflake's real-time data processing capabilities, combined with Redpoint CDP's data streaming features, allow organizations to analyze customer data and derive actionable insights in real-time, enabling faster decision-making and more responsive customer engagement.
Seamless Data Integration and Connectivity: The integration between Redpoint CDP and Snowflake is streamlined, leveraging Snowflake's ODBC and JDBC drivers for efficient querying and data transfer. AEP offers various connectivity approaches, including API’s and direction connection methods, further supporting the goal of providing seamless data integrations. This simplifies the process of connecting the platforms and reduces the complexity of managing data pipelines, saving time and resources.
Robust Data Security and Compliance: Both Redpoint CDP and Snowflake prioritize data security and privacy, offering advanced security features such as encryption, access controls, and data governance tools to protect sensitive customer data and ensure compliance with global data privacy regulations.
Collaborative Data Sharing and Accessibility: Snowflake's secure data sharing capabilities allow organizations to easily share customer data and insights across departments and with external partners, such as AEP.
Simplified Data Governance and Lineage: The combined solution simplifies data governance by providing tools for data lineage tracking, data cataloging, and metadata management. This ensures that data is consistently and accurately defined, making it easier to maintain data quality, comply with regulations, and track data usage across the organization.
Overall architectural considerations
The Adobe stack is vast, and AEP contains a fundamental set of tools that populates its data layer that supports its marketing applications. The integration patterns for Snowflake are well known and very straightforward to set up and maintain. As Redpoint CDP is completely present in Snowflake, using this data to hydrate Adobe and fuel Adobe-powered CX provides a robust combined ecosystem.