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.

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

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.
You may also enjoy:
Product Updates
Shaping the Future: Unveiling Our Brand Refresh
Visible started as a way for founders to update their investors but has since transformed into a purpose-built platform for both founders and investors. Since 2014, we’ve powered over 3M interactions between founders and investors. Our brand refresh represents our commitment to equip founders and the investors who back them. Founders can now manage their investor relationships and capital raises from start to finish. Investors can centralize data, uncover insights, and report to their LPs and stakeholders—all from one place. We are excited to unveil our refreshed brand, marking the beginning of the next decade in our dedication and commitment to founders and investors. Equipping Founders and Investors for Growth Raising capital is fundamentally about building relationships. Founders and investors spend months forging connections that, once solidified by a term sheet, can evolve into partnerships lasting 8 to 10 years and beyond. We set out to highlight the people behind the investments, not just the companies or firms they represent. As we continue to grow, you'll notice more familiar faces from different startups and venture funds featured on our site (👋 Hi Lacey!). Shaping Our Future Across our website and marketing assets, you’ll see 3D shapes floating in the background. While they add aesthetic appeal, they also carry a deeper meaning. For example: We believe raising capital from VCs or LPs closely resembles a fundraising funnel, a concept brought to life through the funnel shape that appears across various pages and assets. Sphere, torus, and pill shapes symbolize the connections between VCs, founders, and stakeholders, reflecting the interwoven nature of these relationships. These forms also symbolize forward momentum and the continuous progression within the venture ecosystem. As our product has evolved to offer greater flexibility in moving data into and out of Visible, you'll notice pipes integrated into the design, visually representing the seamless flow of data through our platform. Logo and Wordmark To maintain and perpetuate our brand equity, we opted to anchor our brand to our current logo and wordmark. The Visible logomark is made from three overlapping, equilateral triangles. Each triangle is slightly transparent, allowing the mark to interact with other design elements. These triangles represent human relationships and the connection between founders and investors, which is core to our mission and vision for our company. Color Palette Our signature black primary color remains, but we've refined our palette for a fresh look. We've transitioned from a complex, rich color scheme to a more cohesive and defined palette, creating a unified and bold approach to color across our brand. Introducing the new Visible color palette: Product Guided by our core values of trust and transparency, we designed our product to embody these principles. Our product visuals across the site are predominantly high-fidelity for the first time, highlighting its capabilities visually rather than relying solely on words. The updated typography and refined color palette are seamlessly integrated into our product screens, further enhancing the overall brand experience. Voice & Tone A brand is more than just its visual identity; it requires a voice and tone that harmonizes with its design. We aimed for our voice to be authentic, credible, and consistent, supporting both investors and founders alike. This commitment led us to define key principles for our voice and tone: Be a guide Less is more Recognize that different users face different challenges As you explore our marketing site, we hope Visible reflects these values and resonates with you. Transparency = Trust As we noted earlier, raising capital is fundamentally about relationships. Trust and transparency form the foundation of any strong connection. Throughout our website, you'll notice subtle transparency elements that embody this core principle. This new iteration of our brand is built to scale, but that doesn’t mean we won’t continue to evolve and elevate the experience for the betterment of our prospects and customers. Here's to shaping the next 10 years! Up and to the right,  The Visible Team
Product Updates
Product Update: Turn Emails Into Insights With Visible AI Inbox
Customer Stories
Case Study: Airtree Venture's Transformation with Visible
Fundraising
9 Tips for Effective Investor Networking