MERCHANT AGGREGATION THROUGH CARDHOLDER BRAND LOYALTY
First Claim
1. A method of aggregating merchant data from transaction data, the method comprising:
- retrieving a transaction data set from a data warehouse, the transaction data set including a merchant location identifier and the corresponding merchant'"'"'s Doing Business As (DBA) name and address data;
forming a data set having therein merchant locations exhibiting at least a threshold level of common cardholder patronage;
calculating a metric related to the textual similarity between a merchant location'"'"'s DBA name for each pair of merchant locations within the data set;
responsive to each pair of merchant locations having a metric related to the textual similarity between the merchant locations'"'"' DBA names exceeding a predetermined threshold, aggregating the merchant locations making up the pair with each other where the merchant locations making up the pair do not share an address; and
recording the aggregation between merchant locations in the data warehouse.
1 Assignment
0 Petitions
Accused Products
Abstract
A system and method of aggregating merchant data from transaction data, including retrieving a transaction data set from a data warehouse. The transaction data set includes a merchant location identifier and the corresponding merchant'"'"'s Doing Business As (DBA) name and address data. A data set is then formed from the transaction data, having merchant locations exhibiting at least a threshold level of common cardholder patronage. A metric is calculated related to the textual similarity between a merchant location'"'"'s DBA name for each pair of merchant locations within the data set. Each pair of merchant locations having a metric related to the textual similarity between the merchant locations'"'"' DBA names that exceeds a predetermined threshold are aggregated with each other, where the merchant locations making up the pair do not share an address. The aggregation between merchant locations is recorded in the data warehouse.
81 Citations
24 Claims
-
1. A method of aggregating merchant data from transaction data, the method comprising:
-
retrieving a transaction data set from a data warehouse, the transaction data set including a merchant location identifier and the corresponding merchant'"'"'s Doing Business As (DBA) name and address data; forming a data set having therein merchant locations exhibiting at least a threshold level of common cardholder patronage; calculating a metric related to the textual similarity between a merchant location'"'"'s DBA name for each pair of merchant locations within the data set; responsive to each pair of merchant locations having a metric related to the textual similarity between the merchant locations'"'"' DBA names exceeding a predetermined threshold, aggregating the merchant locations making up the pair with each other where the merchant locations making up the pair do not share an address; and recording the aggregation between merchant locations in the data warehouse. - View Dependent Claims (2, 3, 4, 5, 6, 7, 8)
-
-
9. A system for aggregating merchant data from transaction data, the system comprising:
-
a processor; a non-transitory machine-readable storage medium, storing thereon a program of instruction that, when executed by the processor, causes the processor to carry out a method including retrieving transaction data set from a data warehouse, the transaction data set including a merchant location identifier and the corresponding merchant'"'"'s Doing Business As (DBA) name and address data; forming a data set having therein merchant locations exhibiting at least a threshold level of common cardholder patronage; calculating a metric related to the textual similarity between a merchant location'"'"'s DBA name for each pair of merchant locations within the data set; responsive to each pair of merchant locations having a metric related to the textual similarity between the merchant locations'"'"' DBA names exceeding a predetermined threshold, aggregating the merchant locations making up the pair with each other where the merchant locations making up the pair do not share an address; and recording the aggregation between merchant locations in the data warehouse. - View Dependent Claims (10, 11, 12, 13, 14, 15, 16)
-
-
17. A non-transitory machine-readable storage medium, storing thereon a program of instruction that, when executed by a processor, causes the processor to carry out a method including
retrieving transaction data set from a data warehouse, the transaction data set including a merchant location identifier and the corresponding merchant'"'"'s Doing Business As (DBA) name and address data; -
forming a data set having therein merchant locations exhibiting at least a threshold level of common cardholder patronage; calculating a metric related to the textual similarity between a merchant location'"'"'s DBA name for each pair of merchant locations within the data set; responsive to each pair of merchant locations having a metric related to the textual similarity between the merchant locations'"'"' DBA names exceeding a predetermined threshold, aggregating the merchant locations making up the pair with each other where the merchant locations making up the pair do not share an address; and recording the aggregation between merchant locations in the data warehouse. - View Dependent Claims (18, 19, 20, 21, 22, 23, 24)
-
Specification