Marketing Project Filter Search Tool for Database Query Optimization

Resolve Bottlenecks,
Find Innovative SolutionsGenerate Solutions

Solution Overview

Problem

Existing marketing search systems require prior knowledge of search parameters, making them cumbersome and time-consuming, and they often present unnecessary information that clutters the screen and slows performance.

Innovation Solution

A filter search tool that scans a marketing system database to provide selectable search attributes, allowing users to easily find marketing projects without prior knowledge, with results displayed in a list or Gantt chart format, including options for additional date ranges, KPIs, and trade spends.

Engineering Contradictions & Design Principles

VSEngineering Contradiction Analysis

1Ease of operation

If existing search systems require prior knowledge of search parameters, then search precision can be maintained, but ease of operation deteriorates and time consumption increases

Engineering Contradiction:

Improveease of search operationVSAvoidtime to retrieve marketing campaign information

Core Design Contradiction:

Ease of operationVSLoss of time

Solution Approach 1:

The system pre-generates and stores multiple possible search results for different search criteria combinations before the user actually performs the search. When a user initiates a search, the pre-computed results are quickly retrieved and presented, eliminating the need for real-time complex querying while maintaining accurate filtering capabilities.

Inventive Principle:

Principle #10Preliminary action

Solution Approach 2:

A search intermediary component is introduced that sits between the user interface and the database. This intermediary pre-processes and caches search results for common search patterns, translating complex database queries into pre-computed result sets that can be rapidly delivered to users without requiring them to understand underlying search parameters.

Inventive Principle:

Principle #24Intermediary (Mediator)

2Loss of information

If all marketing campaign information is presented to users, then information completeness is improved, but device complexity increases and processing time increases

Engineering Contradiction:

Improvecompleteness of marketing campaign informationVSAvoidcomplexity of information presentation system

Core Design Contradiction:

Loss of informationVSDevice complexity

Solution Approach 1:

Different users receive different subsets of marketing campaign information based on their roles, permissions, and preferences. The system applies local quality by customizing the information presentation for each user context - executives see high-level summaries, while campaign managers see detailed operational data - thereby maintaining information completeness for each user's needs while reducing overall system complexity.

Inventive Principle:

Principle #3Local quality

Solution Approach 2:

Marketing campaign information is segmented into multiple hierarchical levels and categories. The system divides comprehensive campaign data into structured segments (e.g., strategic level, tactical level, operational level) that can be selectively presented based on user requirements, reducing the apparent complexity while preserving access to complete information when needed.

Inventive Principle:

Principle #1Segmentation

3Loss of information

If all marketing campaign phases information is displayed, then information completeness is improved, but ease of operation deteriorates due to screen clutter

Engineering Contradiction:

Improvecompleteness of campaign phase informationVSAvoidease of reviewing campaign information

Core Design Contradiction:

Loss of informationVSEase of operation

Solution Approach 1:

The information display is made dynamic and adaptive rather than static. The system automatically adjusts the level of detail presented based on user interactions, campaign phase relevance, and current context. Users can dynamically expand or collapse different campaign phase sections, and the system reorganizes information presentation based on what is most relevant at each moment, maintaining completeness while improving reviewability.

Inventive Principle:

Principle #15Dynamics

Solution Approach 2:

Campaign information is organized across multiple dimensional layers (time dimension, hierarchical dimension, relevance dimension) rather than a single flat structure. The system presents information in prioritized layers, with key campaign phases prominently displayed and secondary phases accessible through organized groupings, transforming the overwhelming two-dimensional screen clutter into a multi-dimensional navigable information space.

Inventive Principle:

Principle #17Another dimension (Dimensionality change)

Data Source

PatentUS8332405B2Marketing project filter search tools

Publication Date: 2012.12.11 SAP SE

AI summary

Systems and methods are provided to enable filtered searches of marketing-related data by extracting marketing project information, including marketing activities, promotions, and campaigns information from an existing marketing system database and restructuring the extracted information in a hierarchical series of selectable nodes. In an embodiment, some of the nodes may be grouped into time, accounts, products, agreements, or marketing plan tabs. In an embodiment, once one or more nodes are selected and a search is activated, the results may be presented in a list or Gantt chart. In an embodiment, the Gantt chart may be supplemented with additional information including additional date ranges, key performance indicators (KPIs), and/or trade spends. In an embodiment, this additional information may vary according to a user role and the nodes selected.