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.