Systems, methods, and apparatuses for implementing a consumer data aggregation platform for seamless product recall and consumer alert management

A system to execute at a consumer data aggregation platform to alert consumers of a product recall, wherein the system comprises:

• a memory to store instructions;
• a set of one or more processors;
• a non-transitory machine-readable storage medium that provides instructions that, when executed by the set of one or more processors, the instructions stored in the memory are configurable to cause the system to perform operations comprising:
• receiving product-related data collected at a database system communicatively interfaced with the consumer data aggregation platform;
• receiving sales data collected at the database system communicatively interfaced with the consumer data aggregation platform, wherein the sales data identifies a consumer via a unique UserID and includes a list of associated products purchased by the consumer;
• storing the product-related data and the sales data as distinct datasets in separate tables within a database system of the consumer data aggregation platform;
• receiving a recall notification request to issue a product recall for a specified consumer product represented within the datasets of the consumer data aggregation platform;
• querying the datasets of the consumer aggregation platform to identify records for each one of:
• (i) the specified consumer product, and (ii) consumers associated with transactions based on the specified consumer product;
• extracting records for the specified consumer product and contact information for consumers associated with transactions based on the specified consumer product across the distinct datasets of the consumer data aggregation platform;
• joining the extracted records for the specified consumer product and contact information for the consumers associated with transactions based on the specified consumer product into a single data set;
• and
• issuing the product recall by sending a push notification to consumers associated with transactions based on the specified consumer product.

Non-transitory computer readable storage media having instructions stored thereupon that, when executed by a consumer data aggregation platform having at least a processor and a memory therein to alert consumers affected by a product recall, the instructions cause the system to perform operations including:

• receiving product-related data collected at a database system communicatively interfaced with the consumer data aggregation platform;
• receiving sales data collected at the database system communicatively interfaced with the consumer data aggregation platform, wherein the sales data identifies a consumer via a unique UserID and includes a list of associated products purchased by the consumer;
• storing the product-related data and the sales data as distinct datasets in separate tables within a database system of the consumer data aggregation platform;
• receiving a recall notification request to issue a product recall for a specified consumer product represented within the datasets of the consumer data aggregation platform;
• querying the datasets of the consumer aggregation platform to identify records for each one of:
• (i) the specified consumer product, and (ii) consumers associated with transactions based on the specified consumer product;
• extracting records for the specified consumer product and contact information for consumers associated with transactions based on the specified consumer product across the distinct datasets of the consumer data aggregation platform;
• joining the extracted records for the specified consumer product and contact information for the consumers associated with transactions based on the specified consumer product into a single data set;
• and
• issuing the product recall by sending a push notification to consumers associated with transactions based on the specified consumer product.