As soon as the Consumer Financial Protection Bureau (CFPB) opened its doors in 2011, it began accepting complaints from consumers facing problems in the financial marketplace — and often helping those consumers fix their problems or get financial relief.
But the CFPB didn’t stop at just accepting complaints. In 2012, it began making complaint data available to the public through the Consumer Complaint Database. Over the years, the database has become a treasure trove of information on consumer experiences in the financial marketplace, offering critical insights for consumers, researchers, CFPB watchdogs and the private sector. And the two-way flow of information it provides is a demonstration of what 21st century responsive government can look like.
The information in the database can be incredibly powerful, and it has served as an important data source for dozens of pieces of research by Frontier Group and our partners at U.S. PIRG Education Fund. It can also present challenges for new users. So, as an author of some of our most recent research analyzing complaint data, I’ve compiled some information and tips for getting the most out of the database, and also built a new tool for downloading data.
Tips for complaint filtering:
- Be wary of database changes in April 2017. Because of the CFPB’s changes to product and issue names, data from time periods including that month will include conflicting names for products and issues. As a result, it’s usually a good idea to restrict searches to either before or after — but not including — April 2017.
- Complaints are generally listed with their parent company name, which may be different from the company name that you know. So if you don’t see any complaints involving your first company search, try looking for a parent company name through an internet search or using the search bar to turn up complaint narratives containing the company name.
- Try using the “tags” to filter for complaints from military servicemembers (and their spouses or dependents), and from older Americans (people 62 or older).
- Once you have created the data filter you want, save the URL for later use — the URL will always return the filter you created. However, be aware that as the CFPB publishes new complaints following its review process, complaint volumes may change, particularly for recent months.
Tips for finding and reading consumer narratives:
- Remember to check the box marked “Only show complaints with narratives” when looking for consumer stories.
- Use the search bar to find consumer complaint narratives that mention a specific word. When using the search bar, try using the “advanced search tips” dialog to use “fuzzy” word searches and proximity word searches, which will return results with different spellings or phrasings.
- When reading a narrative, consider the context. Are there other complaints like it for that company? What was the “company public response” to a complaint, and was the complaint closed with either monetary or non-monetary relief?
2. Download complaint data
To dive deeper into complaint trends and get complete control over aggregating and charting complaints — including by company — you’ll need to download complaint data, and then perform analysis using software like Excel. Performing queries on downloaded complaint data is the best way to answer complex questions, and offline analysis has been the basis both for our own research, as well as for academic studies using advanced statistics methods.
To download complaint data, start by filtering data as needed, and then click “export data” near the top of the screen. This will create a pop-up dialog box asking if you’d like to download only those complaints for which you have filtered, or download the entire dataset of complaints. It’s often better to download a subset of complaints, as the full dataset is a large file size, and as previously noted contains conflicting category names resulting from changes made in April 2017.
3. Use Frontier Group’s CFPB data tool
Finally, you can view and download aggregated complaint data through Frontier Group’s new CFPB trend data online tool.
This tool was built using the Consumer Complaint Database API, which taps directly into the CFPB’s database and allows anyone with some programming know-how to build applications that can go beyond the capabilities of the official database website and provide users with new ways to access complaint data. Unfortunately, the API also lacks some important options, like the ability to aggregate complaints by company.
The data tool is a work in progress, so please let us know if you have feedback, either by creating an issue on the project’s GitHub page or by sending an email. The CFPB’s API itself is also under active development and you can provide the CFPB with feedback, too.
Tips for looking for complaint trends:
- When aggregating and comparing complaints by state, consider looking at per capita complaints.
- Aggregating complaints by zip code can be a powerful tool for spotting geographic trends. However, note that for privacy purposes many complaint zip codes are only available with the first three digits, depending on zip code population and whether the complaint includes a published narrative. For GIS mapping purposes, a shapefile of 3-digit zip codes is available here.
- Consider combining keyword searches and trend analysis. For example, in one recent blog post we looked only at complaints containing key words related to COVID-19.
The CFPB’s Consumer Complaint Database is a powerful tool for understanding the problems consumers face in the financial marketplace. But it’s also both ripe for improvement and frequently threatened with removal from public view. The more people that use it — and the more people that publicize the tool’s utility and write to the CFPB with suggestions — the better off we will all be.