Interactive campaign management using player insights
Data associated a plurality of user interface elements may be retrieved from at least one database associated with a service business, such as a casino. At a first time, a first indication to turn on a first subset of the plurality of user interface elements may be received. The user interface elements may include content management, task management, property management, action management, player profiling, comp management, player development, asset tagging and flagging, profitability and comparative analysis, player insights, floor mapping, campaign management, etc. Each of the first subset of user interface elements may be populated with the respective data associated that user interface element.
1. A system comprising:
at least one database storing data related to customer interactions with a service business; and
at least one computing device in communication with the at least one database, the at least one computing device configured to:
extract, from the at least one database, data associated with a set of customer interactions between an individual asset associated with the service business and the service business, wherein the data is in disparate formats, and wherein the data is extracted using at least one of Change Data Capture (CDC) or slowly changing dimensions (SCD);
stage the data in disparate formats in a staging database, the staging database separated from the database associated with the service business by a protective firewall;
write integration jobs, the integration jobs configured to convert the data staged in the staging database into a single format;
receive, at a first time and from at least one client device associated with the service business, a first indication to turn on at least a first user interface element among a plurality of user interface elements, but not a second user interface element among the plurality of user interface elements, the at least one client device located remote to the at least one computing device;
in response to receiving the first indication, generate a performance metric visualization based on aggregated data associated with a performance metric and the set of customer interactions with the service business, and populate the first user interface element with at least a first portion of the performance metric visualization;
determine a target performance level based on the performance metric and a set of criteria;
identify a set of customers associated with the set of criteria;
determine, based on a machine learning algorithm utilizing data related to customer interactions with the service business, at least one selected action to achieve the target performance level, wherein the selected action comprises at least one personalized contact to a customer among the set of customers;
receive, at a second time occurring after the first time, a second indication to turn on the second user interface element among the plurality of user interface elements;
in response to receiving the second indication and without retrieving additional data from the at least one database, populate the second user interface element with at least a second portion of the data in the single format; and
execute the selected action via one or more targeted communications.
2. The system of claim 1 , wherein the set of criteria comprise one or more of: a profitability metric, a game metric, an individual attribute, and a player tag.
3. The system of claim 2 , wherein the player tag is indicative of a gameplay trend for the customer over a period of time.
4. The system of claim 1 , wherein the personalized contact comprises an offer generated for the customer, a comp for an individual asset associated with the service business, and a code for the individual asset.
5. The system of claim 1 , wherein the targeted communications comprise at least one of an initiation of a text message, an initiation of a phone call, and initiation of an email to a customer.
6. The system of claim 1 , wherein the selected action is at least one of a promotion, an offer, and a comp based on a customer status.
7. The system of claim 1 , wherein the at least one computing device is further configured to store a record of the executed selected action in the at least one database.
8. A method, executed by at least one computing device, comprising:
extracting, from the at least one database, data associated with a set of customer interactions between an individual asset associated with the service business and the service business, wherein the data is in disparate formats, and wherein the data is extracted using at least one of Change Data Capture (CDC) or slowly changing dimensions (SCD);
staging the data in disparate formats in a staging database, the staging database separated from the database associated with the service business by a protective firewall;
writing integration jobs, the integration jobs configured to convert the data staged in the staging database into a single format;
receiving, at a first time and from at least one client device associated with the service business, a first indication to turn on at least a first user interface element among a plurality of user interface elements, but not a second user interface element among the plurality of user interface elements, the at least one client device located remote to the at least one computing device;
in response to receiving the first indication, generating a performance metric visualization based on aggregated data associated with a performance metric and the set of customer interactions with a service business, and populating the first user interface element with at least a first portion of the performance metric visualization;
determining a target performance level based on the performance metric and a set of criteria;
identifying a set of customers associated with the set of criteria;
determining, based on a machine learning algorithm utilizing data related to customer interactions with the service business, at least one selected action to achieve the target performance level, wherein the selected action comprises at least one personalized contact to a customer among the set of customers;
receiving, at a second time occurring after the first time, a second indication to turn on the second user interface element among the plurality of user interface elements;
in response to receiving the second indication and without retrieving additional data from the at least one database, populating the second user interface element with at least a second portion of the data in the single format; and
executing the selected action via one or more targeted communications.
9. The method of claim 8 , wherein the set of criteria comprise one or more of: a profitability metric, a gameplay metric, an individual attribute, and a player tag.
10. The method of claim 9 , wherein the individual attribute comprises at least one of a city, a state, a zip code, a market, a birthday month, a trait, a game preference, a gender, a player tag, a host name, and a current tier.
11. The method of claim 8 , wherein the gameplay metric is determined from at least one of a game handle, a game theoretical profit (THEO), a game actual, a gross game win, a game worth, games played, time of play, an average bet, total THEO, total actual win, total game worth, total days played, a THEO profit, an actual profit, a margin percent, and a reinvestment percent.
12. The method of claim 8 , wherein the personalized contact comprises an offer generated for the customer, a comp for an individual asset associated with the service business, and a code for the individual asset.
13. The method of claim 8 , wherein the targeted communications comprise at least one of an initiation of a text message, an initiation of a phone call, and initiation of an email to the customer.
14. The method of claim 8 , further comprising, storing a record of the executed selected action in a database associated with the service business and the customer interactions.
15. A computer-readable storage medium storing instructions that, when executed by at least one computing device, cause the at least one computing system to:
extract, from the at least one database, data associated with a set of customer interactions between an individual asset associated with the service business and the service business, wherein the data is in disparate formats, and wherein the data is extracted using at least one of Change Data Capture (CDC) or slowly changing dimensions (SCD);
stage the data in disparate formats in a staging database, the staging database separated from the database associated with the service business by a protective firewall;
write integration jobs, the integration jobs configured to convert the data staged in the staging database into a single format;
receive, at a first time and from at least one client device associated with the service business, a first indication to turn on at least a first user interface element among a plurality of user interface elements, but not a second user interface element among the plurality of user interface elements, the at least one client device located remote to the at least one computing device;
in response to receiving the first indication, generate a performance metric visualization based on aggregated data associated with a performance metric and the set of customer interactions with a service business, and populate the first user interface element with at least a first portion of the performance metric visualization;
determine a target performance level based on the performance metric and a set of criteria;
identify a set of customers associated with the set of criteria;
determine, based on a machine learning algorithm utilizing data related to customer interactions with the service business, at least one selected action to achieve the target performance level, wherein the selected action comprises at least one personalized contact to a customer among the set of customers;
receive, at a second time occurring after the first time, a second indication to turn on the second user interface element among the plurality of user interface elements;
in response to receiving the second indication and without retrieving additional data from the at least one database, populate the second user interface element with at least a second portion of the data in the single format; and
execute the selected action via one or more targeted communications.
16. The computer-readable storage medium of claim 15 , wherein the performance metric visualization is indicative of at least one of key-performance indicators (KPIs) associated with a game of the service business and at least one customer among the set of customers.
17. The computer-readable storage medium of claim 15 , wherein the set of criteria comprise one or more of: a profitability metric, a game metric, an individual attribute, and a player tag.
18. The computer-readable storage medium of claim 15 , wherein the personalized contact comprises an offer generated for the customer, a comp for an individual asset associated with the service business, and a code for the individual asset.
19. The computer-readable storage medium of claim 15 , wherein the targeted communications comprise at least one of an initiation of a text message, an initiation of a phone call, and initiation of an email to the customer.
20. The computer-readable storage medium of claim 15 , storing a record of the executed selected action in a database associated with the service business and the customer interactions.