Systems and Methods for Providing Real-Time Values Determined Based on Aggregated Data From Disparate Systems
In accordance with embodiments of the present disclosure, each third party system of multiple of third party systems is configured to store files including datasets of different types, associated with one or more campaigns. Each dataset can be associated with a unique transaction ID. A computing system can be in communication with the third party systems and include a first database and a second database. The computing system can be configured to receive a selection of one or more third-party systems. The computing system can aggregate each of the datasets from the one or more files into one or more groups based on the unique transaction ID associated with each of the datasets, calculate one or more values associated with the at least one campaign, and generate a report including the one or more values.
1 . A system to provide real-time values determined based on aggregated data from disparate systems, the system comprising:
a plurality of third-party systems, each third party system of the plurality of third party systems configured to store a plurality of files including datasets of different types, associated with one or more campaigns, wherein each dataset can be associated with a unique transaction ID;
a computing system, in communication with the plurality of third party systems and including a first database and a second database, the computing system is configured to:
receive a selection of one or more third-party systems of the plurality of third party systems, each of the one more third-party systems configured to store one or more files of the plurality of files, including datasets associated with at least one campaign of the one or more campaigns,
stream the one or more files including the datasets associated with the at least one campaign from each of the one or more third party systems,
aggregate each of the datasets from the one or more files, into one or more groups based on the unique transaction ID associated with each of the datasets;
store the one or more groups of the datasets in the first database,
retrieve information associated with the at least one campaign and a user of the user device from the second database;
calculate one or more values associated with the at least one campaign based on the one or more groups of datasets and the information associated with the at least one campaign and a user; and
generate a report including the one or more values.
2 . The system of claim 1 , further comprising a user device associated with the user and in communication with the computing system, the user device configured to transmit the selection of one or more third party systems.
3 . The system of claim 1 , further comprising a streaming platform residing on the computing system, the streaming platform configured to stream each of the one or more files of the plurality of files to at least one topic of a plurality of topics based on the types of the datasets included in the one or more files.
4 . The system of claim 1 , wherein the computing system is further configured to:
breakdown the datasets from the one or more files;
filter the datasets; and
normalize the datasets.
5 . The system of claim 4 , wherein the computing system is further configured to:
apply one or more tags to each of the plurality of third-party systems; and
generate the unique transaction IDs associated with each of the datasets based on the one or more tags applied to each of the plurality of third-party systems.
6 . The system of claim 5 , wherein filtering the datasets includes removing at least one dataset associated with an invalid transaction ID.
7 . The system of claim 5 , further comprising a third database in communication with the computing system configured to store metadata associated with the at least one campaign.
8 . The system of claim 1 , wherein at least one of the one or more files includes datasets associated with events.
9 . The system of claim 8 , wherein the computing system is configured to:
capture a URL associated with the events of the datasets from the at least one of the one or more files;
determine device and browser information associated with the events; and
determine a geographic location associated with the events.
10 . The system of claim 1 , wherein the user devices includes a display configured to render the generated report.
11 . A method to provide real-time values determined based on aggregated data from disparate systems, the method comprising:
storing, via each of a plurality of third-party systems, a plurality of files including datasets of different types, associated with one or more campaigns, wherein each dataset can be associated with a unique transaction ID;
receiving, via a computing system, in communication with the plurality of third party systems and including a first database and a second database, a selection of one or more third-party systems of the plurality of third party systems, each of the one more third-party systems configured to store one or more files of the plurality of files, including datasets associated with at least one campaign of the one or more campaigns,
streaming, via the computing system, the one or more files including the datasets associated with the at least one campaign from each of the one or more third party systems,
aggregating, via the computing system, each of the datasets from the one or more files, into one or more groups based on the unique transaction ID associated with each of the datasets;
storing, via the computing system, the one or more groups of the datasets in the first database,
retrieving, via the computing system, information associated with the at least one campaign and a user of the user device from the second database;
calculating, via the computing system, one or more values associated with the at least one campaign based on the one or more groups of datasets and the information associated with the at least one campaign and a user; and
generating, via the computing system, a report including the one or more values.
12 . The method of claim 11 , further comprising transmitting, via a user device associated with the user and in communication with the computing system, the selection of one or more third party systems.
13 . The method of claim 11 , further comprising streaming, via a streaming platform residing on the computing system, each of the one or more files of the plurality of files to at least one topic of a plurality of topics based on the types of the datasets included in the one or more files.
14 . The method of claim 11 , further comprising:
breaking down, via the computing system, the datasets from the one or more files;
filtering, via the computing system, the datasets; and
normalizing, via the computing system, the datasets.
15 . The method of claim 14 , further comprising:
applying, via the computing system, one or more tags to each of the plurality of third-party systems; and
generating, via the computing system, the unique transaction IDs associated with each of the datasets based on the one or more tags applied to each of the plurality of third-party systems.
16 . The method of claim 15 , wherein filtering the datasets includes removing at least one dataset associated with an invalid transaction ID.
17 . The method of claim 15 , further comprising storing, via a third database in communication with the computing system, store metadata associated with the at least one campaign.
18 . The method of claim 11 , wherein at least one of the one or more files includes datasets associated with events.
19 . The method of claim 18 , further comprising:
capturing, via the computing system, a URL associated with the events of the datasets from the at least one of the one or more files;
determining, via the computing system, device and browser information associated with the events; and
determining, via the computing system, a geographic location associated with the events.
20 . A non-transitory computer readable medium to provide real-time values determined based on aggregated data from disparate systems, wherein the instructions are executable by a processor to:
store, via each of a plurality of third-party systems, a plurality of files including datasets of different types, associated with one or more campaigns, wherein each dataset can be associated with a unique transaction ID;
receive, via a computing system, in communication with the plurality of third party systems and including a first database and a second database, a selection of one or more third-party systems of the plurality of third party systems, each of the one more third-party systems configured to store one or more files of the plurality of files, including datasets associated with at least one campaign of the one or more campaigns,
stream, via the computing system, the one or more files including the datasets associated with the at least one campaign from each of the one or more third party systems,
aggregate, via the computing system, each of the datasets from the one or more files, into one or more groups based on the unique transaction ID associated with each of the datasets;
store, via the computing system, the one or more groups of the datasets in the first database,
retrieve, via the computing system, information associated with the at least one campaign and a user of the user device from the second database;
calculate, via the computing system, one or more values associated with the at least one campaign based on the one or more groups of datasets and the information associated with the at least one campaign and a user; and
generating, via the computing system, a report including the one or more values.