Remote Segmentation System for Marketing Data
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Businesses face challenges in maintaining a working relationship between transactional and marketing data, particularly in custom data warehouses that require on-demand querying, and there is a need for more efficient and flexible data collection from third-party sources to support email marketing campaigns without overloading the system.
Innovation Solution
A remote segmentation system that allows users to request and segment customer data from third-party databases without storing the segment, using a flexible user interface to define parameters and formats, such as XML, and enabling email campaign functionality, while ensuring data security through encryption and authentication methods.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Speed
If segmentation data is collected and stored locally in a centralized database, then data accessibility and query speed are improved, but system complexity and infrastructure costs increase
Solution Approach 1:
The patent introduces a segmentation data collection system that acts as an intermediary between the centralized database and remote segmentation requests. This mediator collects segmentation data on-demand from the centralized database, processes it locally, and provides it to marketers without requiring them to directly access or store the full database, thus improving accessibility while managing system complexity
Solution Approach 2:
The patent enables local segmentation capabilities by collecting and processing segmentation data at distributed locations (marketer systems) rather than requiring all operations at the centralized database location. This allows local autonomy and reduced complexity at each node while maintaining centralized data as the source of truth
2Adaptability or versatility
If marketers have direct access to transactional data warehouses, then segmentation flexibility is improved, but IT security concerns and system load increase
Solution Approach 1:
The segmentation data collection system serves as a secure intermediary layer between marketers and the centralized transactional database. It provides marketers with flexible segmentation capabilities by collecting and processing data locally, while maintaining security by preventing direct marketer access to the core transactional systems and sensitive data warehouses
Solution Approach 2:
The patent segments the data access architecture into distinct layers: the centralized transactional database remains secure and centralized, while segmentation operations are distributed to local systems. This segmentation allows flexible marketing operations without compromising the security and integrity of the core transactional data warehouse
3Productivity
If remote database fragments are distributed across multiple locations, then system availability and performance are improved, but infrastructure costs and security requirements increase
Solution Approach 1:
The patent implements local segmentation data collection capabilities at distributed locations, allowing each remote system to collect and process segmentation data locally based on its specific needs. This provides local autonomy and improved performance for local operations without requiring full replication of the entire centralized database at each location, thus optimizing resource utilization
4Loss of information
If segmentation data is collected on-demand from third-party sources, then data freshness is improved, but system load and processing time increase
Solution Approach 1:
The patent implements preliminary action by collecting segmentation data on-demand from third-party sources and caching it locally before it is needed for marketing campaigns. This advance data collection ensures data freshness is maintained while reducing processing time during actual campaign execution, as the data is already prepared and available locally rather than requiring real-time queries during campaign deployment
Data Source
AI summary
Remote segmentation is a process by which segmentation data is collected from a third party and applied to an existing database. In a preferred embodiment of remote segmentation, a definition is added that makes the local system aware of all the possible segmentation dimensions in a way that is presentable to the user as well as transmittable to a third party (in house or other company) which processes the segment and returns the result.