How Looker saved our fundraising process šŸ“ˆšŸ’°

Luke Chesser
Unsplash Blog
Published in
4 min readMay 14, 2018

Thereā€™s few things I hate more than fundraising. It combines all of my least favourite things: meetings, pitches, and high pressure follow-ups for data.

When we set out to fundraise last summer, we thought we were well-prepared. We had all of our main metrics ready and memorized, multiple versions of our deck prepared, and weā€™d already practiced our pitch on a few investors in the previous months with good success.

Having raised multiple rounds of investment for our previous company, Crew, this was the most ready weā€™d ever been.

Then came the meetings.

With Crew weā€™d get a few meetings for every handful of intros, but with Unsplash, it seemed everyone wanted to meet. Not only did they want to meet but they also wanted to dive deep into the community to understand the magic disrupting the 800 pound gorillas of Getty, Shutterstock, and Adobe.

First meetings turned to deep dives, and deep dives turned into frequent data requestsā€”day and night.

Most of all, no two investors seemed to be interested in the same slices of data. One investor would want one cohort in one way and another would want it with slightly different attributes over a completely different timeline.

Had we not had Looker, our data tool, things likely wouldnā€™t have turned out so well.

The past

When raising our first rounds of funding, our data process for investors would be to group all of the questions at once, call up our best engineer, and ask them to manually query the database in SQL.

Problems quickly arose as the burden of investor requests would always fall to the same teammate and inevitably mistakes would happen. With no one being able to check the work, we were never sure if what we were sending was 100% accurate.

Even simple requests would often take hours, if not days, to prepare, given the overhead in communication and our teamā€™s differing timezones relative to San Francisco.

Worse yet, as the queries got more complex, the lack of exploration in the returned data meant that we never seemed to be presenting our business in the best light. Due to data requests taking so long to prepare, the idea of exploring to find a better representation of the data seemed crazy.

How we did it this time

While the team continued growing Unsplash back at home, Steph, Mikael, and I, equipped with all of our companyā€™s data in Looker, traveled weekly between New York and San Francisco to meet with investors.

Our two most used tools quickly became email and Looker, as weā€™d work to answer investor follow-ups as quickly as possible.

We had a goal of replying to every investor email within a few hours to keep the momentum going.

Neither Steph nor Mikael are particularly technical, and I, despite being an engineer, can barely write SQL (hello ActiveRecord āœŒļø). Despite this, we were able to answer almost every investor question within our target reply time and without disturbing our team.

Better yet, in meetings, as Mikael would bring up a slide with one of our growth charts, investors would often inquire about a particular segment or cohort. Steph or I would quickly bring up the chart in Looker with the answer to the investorā€™s question and send it back to Mikael to show on the keynote.

An example of how easy it was to take a standard metric like photo views and cut it up in many different ways with just a few clicks in Looker. From left to right: photo views per month segmented by submission traits; photo views per photographer cohort per month; photo views per submission cohort per month.

Having quick access to customize the charts in realtime not only helped the conversation, but allowed us to answer questions that we could never have prepared for.

Most of all though, being able to access and manipulate our data without a lot of overhead meant that we had one less thing to worry about during a difficult time. Raising money can be incredibly stressful, as you have a lot of internal and external pressure to succeed, so youā€™re usually moving from emotional highs and lows multiple times a day.

Keeping those stresses away from your team and your cofounders is crucial so that you stay positive. Feeling in control of as many things as you can, even for something as seemingly small as your data can keep you sane when the end goal feels out of your control.

Looker is one of the few tools that I recommend every company, regardless of their size, should use. Weā€™ve found that it has completely changed not only our fundraising experience, but our teamā€™s understanding and curiosity around our community.

In the same way that every developer should be able to deploy a change to your site quickly and easily, data should be accessible to everyone in your company, regardless of their knowledge of SQL or traditional data concepts.

Most of all, if three fairly data-illiterate founders can use it live in high-pressure meetings to raise with success, you should be able to too.

If you have any questions or want to dive deeper into our experience fundraising, give me a shout on twitter @lukechesser. If you liked reading this, you might like hearing about How we scaled Unsplash with a small team.

--

--

Luke Chesser
Unsplash Blog

Cofounder of @unsplash, building the internetā€™s visual library šŸ‡ØšŸ‡¦