Skip to main content

Business

National Day of Civic Hacking: Exploring Consumer Financial Protection Bureau Data

This weekend I participated in the National Day of Civic Hacking.

The project I decided to work on was working with the CFPB data (and also used some census data).

Background

The CFPB released a large complaints database that contained information about what type of financial products people are complaining about. It also gave information about where the complaints came from, what they were complaining about and resolution information. Some of the data was released literally a day earlier. So I was given a chance to take a look at, analyze and visualize information that nobody has really seen yet.

It was an exciting and interesting opportunity. Since it was very fresh data with little to no previous work, much of what I got to do was more general analysis. I created a handful of graphics (click them to see full size) and maps (click to use the map) which I have included below:

What products are people complaining about the most?

The biggest product people are complaining about is mortgage related products. There is a category for other mortgages that people can choose and it seems most people seem to select that. I wasn't sure why until I looked at the issues people were having.

What are the most common issues people have?

Foreclosure, Loan Modification and Collection. Intuitively, this makes a lot of sense. I probably don't care what type of mortgage it is when they are trying to take my house away. This particular issue dwarfed everything else, so I had to use a log scale to even see what the other issues people were facing.

What are the most common issues people have? (log scaled)

This gives a more in-depth picture of the issues, but the first graphic really shows you the most common and/or pressing financial issue for people.

Which companies had the most complaints?

Then I explored which companies were receiving the most complaints. This data is NOT normalized. That means that just because a company has more complaints doesn't make it worse than one with less. For example, if company A had 10 complaints and 100 customers and company B had 5 complaints and 20 customers, company B would be worse (if we measured complaints as a % of customers). I didn't have easy access to a database with any dataset that would normalize these banks, so this is for curiosity more than any meaningful insight. It probably is a proxy for the largest players in consumer finance though.

[MAP] Where are the complaints coming from in the US? (Normalized for state population)

This map shows where people are complaining the most. DC won that dubious honor. Maryland, Delaware, New Hampshire, California and Florida were also high on the list. All the numbers were adjusted to reflect complaints relative to population of a state. So we can clearly see there are differences and we can probably make educated guesses for some of them. DC for example is probably the highest because of the highest awareness of CFPB (since it's based in DC). Maryland probably has a high awareness too. Florida and California had big real estate bubbles and perhaps were hit especially hard. New Hampshire and Delaware are a mystery to me, although a woman from New Hampshire at my event told me that she complained to the CFPB and told all her friends as well. Perhaps an above-average awareness of the CFPB caused the higher complaint rate.

Top 10 Companies by Complaints and their Disputed Resolution Rates

Next I explored disputed resolutions. Companies alert the CFPB when the matter is resolved and consumers are allowed to tell the CFPB they were not satisfied with the resolution. I graphed the top 10 companies by complaint volume and what their disputed resolution rates looked like. It's interesting to see such big differences between companies but without further information about how they handle disputes, it's impossible to say anything confidently comparing one company to another.

[MAP] Disputed Resolutions by State

Finally, I created a map graphing disputed resolutions by state. There was a surprisingly large variation between states. Alaska, for instance, had a disputed resolution rate of over 26% while Wyoming had a measly 16%. I have no idea why, but it's interesting and worth looking into further.

Conclusion

I had a lot of fun exploring this fresh set of data and there is a lot more to be learned from it. I want to give a big thanks to Ana from the CFPB and Logan from the Census Bureau who attended the event and helped participants navigate the data provided their respective organizations.

Facebook's New Monetization Strategy - Best News for Domain Owners in Years?

Guest Post I wrote for DomainNameNews

I was reading Mark Cuban's thoughts about Facebook trying to get him to pay to reach his fans. It's an interesting opinion and one I can empathize with. The crux of it is this picture:

Brands have spent millions of dollars getting people to 'Like' their brands. Now, Facebook is asking them to pay more to reach the audience they already paid to build. It feels fundamentally unfair because Facebook has changed the rules of the game half way through.

Of course, there is another perspective to consider: the users. They probably don't want every brand spamming them. There is some ambiguity to the word 'Like'. Some would argue it's not a laissez faire situation where brands are free to advertise to every user as much as they want. Facebook's EdgeRank is supposed to improve the user's experience by curating what users see in their feed (and it just so happens that more money greases the EdgeRank wheels).

That's a quick synopsis of the article. Let's get back on topic.

Why is this important to domainers?

Mark Cuban is advocating for brands to maintain more control over the way they communicate with their audience. He's promoting Twitter, Tumblr, Instagram and MySpace (no joke!). It's not mentioned in the article, but there is still only one place that the brand still maintains full control: their domain name(s).

I've argued in the past that domains are becoming less necessary as brands opt to use social networks for their primary web presence. Facebook has about one sixth of the world's population as users. It's easier to manage, easier to share content and easier to reach your audience (assuming you have money to spend).

This is a real kick back from brands. Maybe it's just one guy. Maybe not. But it should be a good reminder that when you buy into these social networks, you're potentially making a deal with the devil. They control the rules and you are beholden to them and the changes they decide to make in the future. Your relationship with your fans is moderated by someone else.

In the developer community we worry a lot about building our software on top of someone else's platform. We've seen Twitter take out competitors it didn't like and restricting their API to control what developers can do. Perhaps it's reckoning time for brands. Maybe they will experience the risk they've put themselves at by investing into social media on platforms they don't control and that don't have an established business model.

Let me be clear: I don't think this will stop brands from using social media. However, it may be the first of many tiny cuts in Facebook's business model which moderates how it will deal with brands. Some brands may decide to try to control their fans' experience more and invest in their own domains. At the margin, there may be some increased demand for domain names. Which is good news for domainers and the first good news I've seen in a while for the industry. I think the longer term outlook is still fairly grim for most of the industry, but end user demand is the only bright spot in my mind.

Potentially Malicious Fake Advertiser using Wordpress Plugin (adv.zip)

It starts with an innocuous email:

Hi,

I am sorry I have to write you to e-mail from whois information of the domain. But I could not find contact e-mail or feedback form on your site.
We are looking for new advertisement platforms and we are interested in your site %DOMAIN%
Is it possible to place banner on your site on a fee basis?

Best regards,
Nicolas Gauthier

But it quickly turned strange:

Hi!

Thanks for reply to our proposal!
We like your price.We would like to place 160x600 banner.

To pass to the banner control system follow the link http://webmaster.burgoni.com
To enter use the following data:

login: %DOMAIN%
password: %PASSWORD%

One of the scummiest link building strategies I've ever seen

Posted in

From: Ryan F (ryanf@ggadget.org)
Date: Thu, Feb 16, 2012 at 11:40 AM
Subject: Featured Tech Site Award
To: -------------

My name is Ryan, and I work at Green Gadget -- a PR6 technology and gadget review site located in Austin, Texas.
The reason I'm emailing you today is because we’ve selected you as an exceptional technology site. We would like to highlight you on our site and present you with an official sidebar badge for your site that will distinguish you as a Featured Tech Site.

Our selection criteria are based on several factors that we feel defines a great tech site. We selected you because we feel your website is a great resource that offers exceptional information on technology.

Attached is the html code to insert the badge. We are very excited to have you as a Featured Tech Site and I look forward to hearing back from you.

Best Regards,

Ryan

First off, who mentions their Page Rank (PR6) in a legitimate award?

There is no mention of what my site even is or any indication that it was viewed. It's all probably automated anyway (or should be considering the lack of anything requiring a human to do since nothing is tailored or personalized in any way).

You want to see the 'award'? It's pathetic.

I hope nobody falls for this bullshit but sadly I am sure some people will. This one should go straight to the spam bin.

144 of the Largest Companies Using Godaddy

I took the top 1500 sites from Alexa.com and checked their registrar. Some companies have already said they were moving (Hi StackOverflow!). Huge thanks goes to Mike St John for his help in querying the registry.

Here are the 144 companies using Godaddy as a Registrar :

woothemes.com
proboards.com
stackoverflow.com
alot.com
wowhead.com
xkcd.com
seriesyonkis.com
exoclick.com
flipkart.com
goodreads.com
twitpic.com
babylon.com
bytes.com
opera.com
foursquare.com
r7.com
thechive.com
realclearpolitics.com
yousendit.com
dreamstime.com
justdial.com
ilivid.com
github.com
multiply.com
imesh.com
optmd.com
wimp.com
youm7.com
urbandictionary.com
amung.us
informer.com
pingomatic.com
networkedblogs.com
histats.com
chicagotribune.com
grooveshark.com
infusionsoft.com
buzzfeed.com
trulia.com
yoo7.com
hawaaworld.com
bearshare.com
slutload.com
piriform.com
incredimail.com
noticias24.com
ioffer.com
buysellads.com

Social media, the reshaping of communication and who controls how we talk to one another

The term Social Media refers to the use of web-based and mobile technologies to turn communication into an interactive dialogue. Andreas Kaplan and Michael Haenlein define social media as "a group of Internet-based applications that build on the ideological and technological foundations of Web 2.0, and that allow the creation and exchange of user-generated content." Social media are media for social interaction, as a superset beyond social communication. Enabled by ubiquitously accessible and scalable communication techniques, social media substantially change the way of communication between organizations, communities, as well as individuals.

-Wikipedia

WTF does that even mean? The term social media with this definition is truly focused on media - how we are communicated to and are suddenly empowered to communicate back to the powers which use the media.

Liberal Paradox and Domain Names

I was recently introduced to Amartya Sen's Liberal Paradox and found it quite interesting. The Wikipedia page does an ok job explaining it, I liked this article more.

Sen’s liberal paradox is meant to demonstrate that when autonomous agents act with complete freedom, it is impossible for the agents to produce an outcome that is a net improvement to everyone. While this is not to argue for government intervention, it is to say that a pareto optimal improvement and libertarianism cannot coexist. In other words, the paradox shows us that the invisible hand of the marketplace is incapable of producing net improvements in welfare for a given society.

When you think about the domain industry in the context of the liberal paradox it makes sense why everyone is so unhappy.

Should I really listen to this advice?

Posted in

One thing that constantly bothers me is how we give advice to other people and how people listen to our advice. I think we are generally predisposed to give our opinions and advice to others; whether it be for our own ego, genuine desire to help others, a social obligation or whatever else may drive us. The underlying reason is somewhat irrelevant to the point of this post.

The thing that bothers me most is when people give unqualified advice, which could vary from simply time wasting to harmful in terms of content.

Why I won't be an affiliate for your company

Posted in

I receive a few advertising offers on my websites every month and most simply want to buy a banner/link for whatever reason - traffic, sales, branding, seo, etc. Honestly I don't care about their intention as long as it doesn't ruin my user experience.

The worst offers are people trying to get me to signup for their affiliate program.

Here is an example:

Hi,

I am Harish from Allo.com; we develop cost-effective next generation high quality VOIP products, such as Digital Telephony Cards, PBX Systems, Next Generation IP Phones and Analog Telephone Adapters…

We are interested in advertising our products on [my site redacted].

Please let me know who I should talk to.

Regards,

What's wrong with this offer?

It's deceitful.

This looks like a normal advertising request to buy a banner/link. It's not. How do I know it's an affiliate offer?

Microsoft Office: Now with ads and reduced functionality?

Posted in

Seriously? Now my downloaded software is going to spew ads at me and provide a crappier product?

Thank god for Libre Office.

Syndicate content