How Alt data provider Fable Data matches transaction strings to merchants using LDC data

Case Study

Introduction


Fable Data is an Alt data provider which uses anonymised transaction data from banks, credit card providers and fintechs to deliver insight used by investors for decision making and strategic planning. Their mission is to aggregate ethically sourced, real-time data on the consumer economy, supporting their hedge-fund clients to adopt data-driven strategies and find investment ‘signals’ in the market.

transaction data v2

The challenge: matching transaction strings to merchants

Fable Data approached the Local Data Company as they required high-quality, robust and legitimate data to validate merchant information against transaction data which can often be difficult code to crack. Merchant transaction strings (the information on each transaction on bank or card statements) can be a series of letters and numbers and can vary widely across each brand or vendor.

card transaction data

Examples of transaction data strings for a Premier convenience store (source Fabledata.com)

In order to match transactions to vendors, Fable Data required comprehensive data on all the merchants trading in the UK including lists of stores for brands. Avoiding web-scraped data was important in order to protect the integrity, reliability and accuracy of their insight product. Fable Data uses Local Data Company records to match transaction strings against known merchants to build a what is known as a ‘training set’ which helps analysts identify a list of transaction strings which are a true match for a vendor, including all sites across a store estate. This work also helps Fable to determine whether spending was within retail stores, cashback services, at ATMs or online and helps them to reduce the prevalence of ‘false positives’ for transactions.

Matching against Local Data Company data on 5,000 multiple brands, Fable Data has been able to match transaction strings to vendors and organise volumes of spending into retail categories such as grocery, clothing and home & garden, boosting the insight available from the transaction data. This data forms a critical part of Fable Data’s offer and provides relevant, impactful and timely evidence for hedge funds making investment decisions.

 

COVID MARKET RECOVERY TRACKING

During the COVID-19 pandemic, Fable Data was able to provide real-time evidence on the recovery of the consumer economy in the UK, using the powerful combination of Local Data Company data and transaction data. They measured the daily, weekly and monthly recovery of different corners of the market to evidence the real-time trends as they happened. The data was so strong it was featured in the Financial Times eight times within a two-month period as an indication of the speed of recovery following lockdown.

“We needed reliable reference data on all the shops trading in the UK. LDC gave us the names of the businesses operating in the country, including those that had gone bust during the historical time period that the Fable Data panel covers. Fable used the LDC file to seed our search for merchant names within our anonymised transaction data. We now have data set with millions of rows, covering thousands of merchants use to train and tune neural networks and support vector machines that identify merchants in consumer spend data for our clients. LDC saved us time and also helps us to identify the names of new merchants that start to trade and grow their store estate.”

Mark Howland, Chief Data Scientist


Join Fable Data

Are you an Alt Data provider? Get in touch to find out how our data can support your work with investors and hedge funds.