System and method for transforming source-dependent data into source-agnostic data

A non-transitory computer-readable media comprising computer-readable instructions retrievably stored thereon that when executed by a processing unit associated with a data transformation application causes the processing unit to:

• receive advertising impression data;
• based on the advertising impression data, determine platform information, comprising parsing a plurality of URL strings from the advertising impression data, the plurality of URL strings comprising a first URL string, a second URL string, and a third URL string;
• extract relevant data regarding each of the plurality of URL strings from the advertising impression data received from a data source to obtain extracted data, the relevant data comprising a first set of relevant data corresponding to the first URL string, a second set of relevant data corresponding to the second URL string, and a third set of relevant data corresponding to the third URL string, the first set of relevant data, the second set of relevant data, and the third set of relevant data each comprising at least the platform information indicated by each of the first URL string, the second URL string, and the third URL string;
• parse the relevant data for data labels identifying attribute categories regarding the relevant data and corresponding to values of the relevant data, the data labels comprising a first data label identifying a first attribute category;
• categorize the relevant data according to the first attribute category;
• cleanse the relevant data, at least by:
• filtering the relevant data for incomplete relevant data, wherein filtering the relevant data for incomplete data comprises extracting the first URL string, a first value of the first set of relevant data, the second URL string, and a second value of the second set of URL data based on a determination that each of the first value and second value correspond to the first data label identifying the first attribute category;
• filtering the relevant data for duplicative relevant data, wherein filtering the relevant data for duplicative relevant data comprises extracting the first URL string and the first value based on a determination that the first URL string and the first value match the second URL string and the second value;
• and
• identifying the first URL string and the first value as cleansed data;
• convert the cleansed data into source-agnostic data, comprising re-categorizing at least some of the cleansed data;
• retrievably store the source-agnostic data as persisted data into a memory associated with the data transformation application;
• receive a query via a dashboard associated with the data transformation application to retrieve the persisted data;
• and
• display a portion of the persisted data that satisfies the query on the dashboard.

A system comprising:

• a data transformation application comprising:
• a repository;
• a processing unit structured to:
• receive advertising impression data;
• based on the advertising impression data, determine platform information, comprising parsing a plurality of URL strings from the advertising impression data, the plurality of URL strings comprising a first URL string, a second URL string, and a third URL string;
• extract relevant data regarding each of the plurality of URL strings from the advertising impression data received from a data source to obtain extracted data, the relevant data comprising a first set of relevant data corresponding to the first URL string, a second set of relevant data corresponding to the second URL string, and a third set of relevant data corresponding to the third URL string, the first set of relevant data, the second set of relevant data, and the third set of relevant data each comprising at least the platform information indicated by each of the first URL string, the second URL string, and the third URL string;
• parse the relevant data for data labels identifying attribute categories regarding the relevant data and corresponding to values of the relevant data, the data labels comprising a first data label identifying a first attribute category;
• categorize the relevant data according to the first attribute;
• cleanse the relevant data, at least by:
• filtering the relevant data for incomplete relevant data, wherein filtering the relevant data for incomplete data comprises extracting the first URL string, a first value of the first set of relevant data, the second URL string, and a second value of the second set of URL data based on a determination that each of the first value and second value correspond to the first data label identifying the first attribute category;
• filtering the relevant data for duplicative relevant data, wherein filtering the relevant data for duplicative relevant data comprises extracting the first URL string and the first value based on a determination that the first URL string and the first value match the second URL string and the second value;
• and
• identifying the first URL string and the first value as cleansed data;
• convert the cleansed data into source-agnostic data, comprising re-categorizing at least some of the cleansed data;
• and
• retrievably store the source-agnostic data as persisted data into the repository;
• and
• a dashboard to:
• receive a query to retrieve the persisted data;
• and
• display a portion of the persisted data that satisfies the query.