Digital consumer data model and customer analytic record

摘要

As a company expands its businesses to include digital products and services in addition to more traditional telecommunications and media offerings, digital consumption data may be used along with telecommunications consumption data and other customer-centric information in order to create a more comprehensive data model and make better predictions. A customer-centric data model identifies entities with data from diverse locations and product sectors associated with a single customer. Customer analytic records aggregate existing data into base variables and store it for each customer along with additional variables generated by performing calculations on exiting data. Both the data model and the customer analytic records can be used by the company to make more accurate business and marketing decisions.

主权项

1. A method for generating and implementing a data model, comprising:
identifying a plurality of entities, each entity having one or more metrics defining data related to a customer, the plurality of entities including at least
a customer entity, anda digital consumption entity; defining relationships between entities among the plurality of entities; for each entity, selecting an electronic data source storing data compatible with the one or more metrics of that entity; implementing data flow and control processes on the selected electronic data sources consistent with the relationships identified between the entities; extracting data, related to a customer entity's digital consumption, from each of the selected electronic data sources by an analytical transformation engine in accordance with the implemented data flow and control processes, the extracting data including:
determining, by the analytical transformation engine, a first portion of the data from crawling unstructured data obtained by a web crawler engine from web resources for keywords;converting, by the analytical transformation engine, a second portion of the data according to a mapping defined by a template; anddiscarding, by the analytical transformation engine, by portions of the first portion of data and the second portion of data that are determined to be of insufficient data quality; and for each of the customer entities:
identifying, by the analytical transformation engine, the extracted data related to the customer entity;aggregating, by the analytical transformation engine, the identified extracted data into a customer-centric data structure for the customer entity, wherein the customer-centric data structure for the customer entity includes at least a digital consumption field, a customer demographic field, and a telecommunications field; andstoring, by the analytical transformation engine, the customer-centric data structure in the electronic data source selected for the customer entity; and presenting, by the analytical transformation engine, a report based on the stored customer-centric data structures for the customer entities.