Custom queries for segmentation
View Patent ↗Methods, systems, and data structure custom queries for segmentation. Queries are imported into a segmentation tool and modified. The queries are associated with data sources that are not mapped within the segmentation tool. Parts of the queries are manually supplied or imported into the segmentation tool and parts of the queries are automatically generated based table and key selections associated with a customer hierarchy. When the custom queries are executed the query results provide customer segmentations for desired marketing campaigns.
1. A method for custom query generation implemented in a computer-readable storage medium and processed by a computer, comprising:
receiving, by the computer, a query within a segmentation tool, wherein the query is directed to one or more data sources that are not mapped in the segmentation tool, and wherein metadata and data elements of data tables associated with the one or more data sources are unknown to the segmentation tool, unavailable, and unrecognized by query interfaces used by the segmentation tool, and wherein the query is received via an option of the segmentation tool;
receiving, by the computer, a key selection and a table selection for the query, wherein the key and table selections are associated with data elements of a customer hierarchy that is mapped within the segmentation tool to different data sources, the key selection and table selection received from the segmentation tool via selections made by a business analyst within the segmentation tool;
modifying, by the computer, the query using the key and table selections, the query modified to include an additional portion to the query, the addition portion including wrapping Structured Query Language (SQL) WHERE clause statements used to make a modified query and the modified query now identified as a custom query, the additional portion permits the results from the query when executed, as part of the custom query, to be integrated with the customer hierarchy via the SQL WHERE clause statements that execute as a wrapper within the custom query; and
generating, by the computer, the custom query as the wrapper that includes the query before it was modified and the additional portion having the SQL WHERE clause statements, wherein when the custom query is executed within the segmentation tool to generate a customer segment for a marketing campaign and when the query as part of the custom query is executed the unmapped data sources are queried to get the results and then when the additional portion of the custom query is executed against the results from the unmapped data sources the SQL WHERE clause statements are executed by using the key and table selections, to acquire selective data elements from the customer hierarchy in order to produce the customer segment.
2. The method of claim 1 wherein receiving the query further includes importing a file that includes at least a portion of the query into a segmentation query-build interface.
3. The method of claim 1 wherein the receiving the query further includes interactively receiving at least some portions of the query from a user interacting with a segmentation query-build interface.
4. The method of claim 1 wherein the receiving the query further includes receiving at least a portion of the query from a paste operation into a segmentation query-build interface.
5. The method of claim 1 further comprising associating a unique identifier with the custom query, wherein the unique identifier is used to save and recall the custom query for subsequent use.
6. The method of claim 1 further comprising receiving a command to execute the custom query from within the segmentation tool.
7. The method of claim 1 further comprising mapping data elements associated with the custom query to the segmentation tool for subsequent uses.