MERCHANT AGGREGATION THROUGH CARDHOLDER BRAND LOYALTY

摘要

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.

主权项

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.