Our Guide to E-Commerce Metrics (with Google Sheet Template)

Matt Preuss
Marketing Manager

A few years back Dave Ambrose, Managing Partner at Steadfast Ventures, shared a template full of KPIs for ecommerce startups and founders. Since Dave’s original template, we’ve surveyed a few of our customers and friends to make some tweaks and add in new metrics. Special thanks to Dave and the team at Italic for allowing us to share their key KPIs. Italic is an ecommerce company that sells “unbranded luxury goods straight from the source.” With $13M in venture funding and customers across the globe it is vital for Italic to keep a tab on their metrics across the funnel.

Related Resource: 10+ VCs Investing in E-commerce and Consumer Products

Using the E-commerce Metric Template

Related Resource: Key Metrics to Track and Measure In the eCommerce World

The setup of the template should be simple and ready to use and customize to your own liking out of the box. We’ve set the data to monthly but feel free to change to weekly, quarterly, etc. From here the template is broken down into 4 major metric categories — Customer Breakdown, Acquisition, Behavioral, and Operational.

Start Your Free Trial
Try Visible for Free for 14 Days.
Start Your Free Trial
14-Day Free Trial - No CC Required

Customer Breakdown Metrics

This is a simple breakdown of where your new customers are coming from. For the template, we’ve included the following channels:These channels can vary from business to business to make any changes to the names/sources.

Acquisition Metrics

Acquisition metrics are particularly important when it comes to monitoring an ecommerce business. Our friends over at Italic like to break down their acquisition costs by paid and blended. This allows them to analyze how their paid channels are performing to the rest of the business. To learn more about customer acquisition costs, check out our guide here.

Jeremy Cai, CEO of Italic, explains LTV tracking and benchmarking:

“Typically it’s the amount of spend a customer has by a certain point (i.e. 6 month LTV, 12 month LTV, 2 yr LTV, etc) and people hope to see growth in this over time. For most higher ticket items, frequency will be close to 1 so they don’t expect LTV to grow very much but for subscription (toothpaste, razors) or higher replenishment items (consumables, beauty) then LTV growth is critical.”

Behavioral Metrics

These are the metrics that can help measure how customers are behaving and moving through the funnel once they have started the purchasing process. Put simply, Jeremy explains it as, “Basically it’s Add to Cart > Checkout Started > Checkout Completed, with a general 50% falloff between each step.”

Operational Metrics

These are the financial and operational metrics that make sure your business is healthy and running as expected. These metrics show how efficient your marketing and go-to-market efforts have been. Dave Ambrose keeps an eye on these metrics as an indicator to what ecommerce companies “are taking off.”

Use Template Now

Start Your Free Trial
Try Visible for Free for 14 Days.
Start Your Free Trial
14-Day Free Trial - No CC Required

Connecting the E-commerce Metric Template with Visible

Naturally, the template connects to Visible in a few quick steps. Once you have the template added to your Google account head over to Visible. From here, you’ll want to make your way to the “Metrics” section and select “Add a new data source” –> “Google Sheet.”

After you’ve authenticated your Google account you’ll see the ecommerce template. Select the sheet and the correct tab from the sheet. As the sheet is setup with the date in row 1 and metrics in column A there is no need to make any further changes.

Click “save” and your new metrics will be brought into Visible. You can easily chart and share these metrics using Dashboards and Updates.

Raise capital, update investors and engage your team from a single platform. Try Visible free for 14 days.
Start Your Free Trial
Try Visible for Free for 14 Days.
Start Your Free Trial
14-Day Free Trial - No CC Required
You may also enjoy:
Fundraising
Exploring Founder <> Investor Relationships with the Thrive Through Connection Podcast
Beyond pitch decks, valuations, term sheets, and growth rates, fundraising is about relationships. Behind every round of capital is a series of conversations, introductions, and partnerships that result from human-to-human connection. That’s why we’re excited to announce the launch of our new podcast season, Thrive Through Connection, a series dedicated to exploring the human side of fundraising. Why Thrive Through Connection We’ve seen firsthand that at the center of successful startups, good old-fashioned relationship building consistently shows up, because founders don’t raise capital in a vacuum. They rely on their teams, peers, and investors to navigate the ups and downs of building something from nothing. Thrive Through Connection highlights the relationships that fuel the growth of both founders and investors. We candidly discuss what it really takes to raise venture capital, including the setbacks, tactics, and stories you won’t hear anywhere else. What to Expect Each episode features real stories and actionable insights from founders and investors, from first-time founders reflecting on closing their first round to seasoned investors sharing what they look for in a deal. Every conversation is packed with lessons you can apply to your fundraising journey. The First Episodes We’ve got three episodes to get things started, and we’re excited to continue recording and publishing new episodes throughout the year. Check out the first three below: Finding the Right Investors with Laurel Hess On the first episode of the Thrive Through Connection Podcast, we welcome Laurel Hess, the CEO and Founder of hampr. Laurel has raised over $10M for hampr across multiple rounds. She joins us to share her journey and the importance of building genuine relationships with investors. Navigating Investor Relationships with Brett Brohl On the second episode of the Thrive Through Connection Podcast, we welcome Brett Brohl, Managing Partner at Bread & Butter Ventures. Brett joins us to dive deep into all things founder fundraising, sharing tactical advice on everything from cold outreach to evaluating if an investor is a true culture fit. Going From Operator to Funder with Leo Polovets On the third episode of the Thrive Through Connection Podcast, we welcome Leo Polovets, the General Partner at Humba Ventures and Co-founder of Susa Ventures. Leo joins us to talk about his journey from operator to supporting over 100 companies as an investor at both Humba and Susa. The first three episodes are live now on Spotify, Apple Podcasts, and most places you get your podcasts. Subscribe to the Thrive Through Connection Podcast to stay in the loop as more episodes are published.
Fundraising
Finding the Right Investors with Laurel Hess
Reporting
Navigating Investor Relationships with Brett Brohl
Fundraising
Going From Operator to Funder with Leo Polovets