Data Operations

Posts about data operations, analytics, and organizational data management

187 posts

Adding time travel to your GTM analysis

A key problem in every GTM organization is understanding: “what’s happening right now?” Once the team gets that answer, they want to know what will happen next. The best information you have to answer that question is to look at…

Estimate your pipeline with Google Sheets

It’s the beginning of the month, and the same conversation happens at the beginning of every month, quarter, or year: “how’s the pipeline?” Pipeline is a tricky thing. I’ve heard it described persuasively as a bathtub where the level of…

3 Quick Ways to use Pivot Tables

Photo by Edgar Chaparro on Unsplash One of the fastest and best ways to start understanding a dataset is to look at it using a pivot table. Pivot tables are a feature in most spreadsheet applications that summarize data, analyze…

Preparing for growth before it happens

Photo by Daniel Öberg on Unsplash One of the most challenging things thinking about scale in a 0-1m company (or a 1-10m, or a 10-100m) is the difference between where you are right now and the place you’d like to…

Salesforce reports are a major headache 🙈

Photo by Anne Nygård on Unsplash Ask almost anyone who uses Salesforce (or administers it) how they use reports. The answer usually includes some combination of the following: “Ugh. That’s hard. We do simple reporting in SFDC and more complicated…

Handshakes between teams are state machines

Photo by Simon Kadula on Unsplash “Can you create that report for me?” “Is that data loaded yet?” “Do you know what went wrong?” These are all simple (or not so simple) examples of interactions between team members that can…