How to Use Looker for E-Commerce Sales Analytics

Using Looker for your e-commerce sales analytics can transform rows of raw data into a clear roadmap for growing your business. It allows you to move past the default dashboards in Shopify or Google Analytics and build a single source of truth for your entire operation. This article will guide you through connecting your data, identifying the right metrics, and building powerful sales dashboards in Looker to uncover actionable insights.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Use Looker for Your E-commerce Store?

While platform-specific analytics tools are useful, they only show a small piece of the puzzle. Shopify Analytics tells you about your store's performance, but it doesn't easily connect with your Google Ads cost data or your HubSpot CRM information. Looker excels at bringing all these disparate sources together.

At its core, Looker allows you to:

• Centralize Your Data: Combine data from your store platform (Shopify, Magento, etc.), advertising channels (Facebook Ads, Google Ads), marketing tools (Klaviyo, Mailchimp), and CRMs (Salesforce, HubSpot) into one place for a complete view of your business.
• Govern Your Metrics: Using its data modeling layer, LookML, you can define a metric like "Customer Lifetime Value" once. Afterward, everyone in your company who uses that metric gets the same, accurate number, eliminating confusion from inconsistent spreadsheet calculations.
• Empower Self-Service Analytics: Once set up, your entire team - from marketing to operations - can explore data, ask their own questions, and create reports without needing to write a single line of SQL.

Getting Started: Connecting Your E-commerce Data

Before you can visualize anything in Looker, you need to get your data into a place it can access. Looker isn’t a database itself, it’s a tool that sits on top of your data to help you explore it. This typically means you'll need a cloud data warehouse like Google BigQuery, Amazon Redshift, or Snowflake.

The standard process looks like this:

1. Choose a Data Warehouse: Pick a warehouse that fits your budget and technical needs. BigQuery is a popular choice for businesses already in the Google ecosystem.
2. Load Your Data: Use a data pipeline tool (like Fivetran or Stitch) to automate the process of pulling data from all your sources - Shopify, Google Analytics, Facebook Ads, etc. - and loading it into your data warehouse.
3. Connect Looker to Your Warehouse: In Looker, you'll set up a connection to your data warehouse. This process is well-documented and fairly straightforward, usually just requiring you to provide your sign-in credentials.

Once connected, Looker can "see" all the data you've consolidated, and you can start modeling it to make it useful for analysis.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Building Your Data Model with LookML

The real power of Looker comes from LookML, its data modeling language. Don't let the word "language" scare you off, it's less like a complex programming language and more like a way of defining a custom dictionary for your business data.

With LookML, you define all your business logic in one place. You create "views" that correspond to your data tables (e.g., an orders table, a customers table) and define "dimensions" (the things you group by, like City or Product Name) and "measures" (the things you count or aggregate, like Total Sales or Average Order Value).

For example, you could create a measure for Average Order Value (AOV) in your orders view like this:

measure: average_order_value {
  type: average
  sql: ${sale_price} ,,
  value_format_name: usd
}

Once you define this, anyone in your company can simply drag "Average Order Value" into a report, and Looker automatically knows how to calculate it correctly. This ensures consistency and saves everyone from having to remember complex formulas. You can use this same logic to accurately define Customer Acquisition Cost (CAC), Customer Lifetime Value (CLV), and other complex business metrics.

Key E-commerce Metrics to Track in Looker

Now that your data is connected and modeled, it's time to focus on what to track. A good e-commerce dashboard provides a mix of high-level performance indicators and more granular metrics that tell you why things are happening.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Sales Performance Metrics

• Total Revenue: The most fundamental sales metric. Looker lets you slice this by date, product category, channel, or customer segment to see what's driving growth.
• Average Order Value (AOV): This tells you how much customers spend on a typical purchase. Pushing AOV up is often easier than acquiring new customers. In Looker, you can analyze AOV by traffic source to see which channels bring in the big spenders.
• Total Orders: Useful for understanding overall transaction volume. A big gap between order growth and revenue growth could indicate a drop in AOV.
• Customer Lifetime Value (CLV): This metric estimates the total revenue you can expect from a single customer over their entire relationship with your brand. It's the ultimate measure of a healthy e-commerce business.

Marketing & Acquisition Metrics

• Customer Acquisition Cost (CAC): This is the total cost of your marketing and sales efforts divided by the number of new customers acquired. Centralizing your ad spend and sales data in Looker is the only way to calculate this accurately.
• Conversion Rate: What percentage of site visitors make a purchase? Looker lets you analyze this in detail: overall conversion rate, conversion rate by device, by marketing campaign, or for new vs. returning visitors.
• Return on Ad Spend (ROAS): For every dollar you spend on ads, how much revenue do you get back? By combining data from Facebook Ads, Google Ads, and your sales platform, Looker can provide an accurate, cross-channel view of ROAS.

Customer Behavior Metrics

• Top Performing Products: Track which products are selling the most, generating the most revenue, or have the highest profit margins. Use this to inform your inventory, marketing, and merchandising decisions.
• Purchase Frequency: How often do returning customers make a purchase? This is a key indicator of customer loyalty and retention.
• Purchase Latency: How long does it take for a new customer to make their second purchase? You can use this insight to time your email marketing win-back campaigns.

Building Your First E-commerce Sales Dashboard

Creating a dashboard in Looker is an iterative process. You start with a question, build a visualization to answer it, and then assemble those visualizations into a shareable dashboard.

Here’s the step-by-step flow:

1. Start with an "Explore": An Explore is a starting point for a query, built from the LookML models you defined earlier. To analyze sales, you might start with an "Orders" or "Sales" Explore.
2. Select Your Data: In the Explore view, you’ll see all your available Dimensions and Measures in a field picker on the left. To see revenue over time, you would select a date dimension (like "Order Date") and a sales measure (like "Total Revenue").
3. Choose a Visualization: Looker will initially show your data in a table. You can then choose from a wide array of chart types. For revenue over time, a line chart is perfect. For top-selling products, you’d use a bar chart. For a headline KPI like AOV, use a Single Value visualization.
4. Filter for Deeper Insights: Use filters to drill down. You can filter by date range, marketing channel, or customer segment. For example, you might create a chart of revenue over time, and then filter it to only show sales that came from your "Summer Sale" email campaign.
5. Save and Add to a Dashboard: Once a chart - called a "Look" in Looker's terms - answers a question, you can save it. From there, you can add it as a new tile to an existing dashboard or create a new one from scratch. Repeat this process until your dashboard provides a complete picture of your sales performance.

Example: A Daily Sales Snapshot Dashboard

A great starter dashboard could include these elements:

• A set of single value tiles at the top showing Revenue, AOV, and Orders for "Today" and "Month-to-Date."
• A line chart showing revenue trends over the last 30 days.
• A table view listing your top 10 selling products this week.
• A bar chart comparing revenue by marketing channel for the last 30 days.
• A map visualization showing where your orders are coming from geographically.

Advanced Tips for E-commerce Analysis

Once you’re comfortable with the basics, you can start using some of Looker’s advanced features to get even more sophisticated with your analysis.

Setting Up Alerts and Scheduling

Tired of constantly checking your dashboard? Set up an alert to get a Slack notification when daily sales drop below a certain threshold. You can also schedule key reports - like a weekly sales summary - to be automatically delivered to team members' email inboxes every Monday morning.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Cohort Analysis for Retention

Looker is exceptionally good at cohort analysis. You can create a chart that groups customers by the month they made their first purchase (their "cohort"). You can then track what percentage of each cohort returns to make a second, third, or fourth purchase over time. This is invaluable for understanding customer retention and the true impact of your marketing efforts.

Building Customer Segments

Use dimensions to create powerful customer segments for analysis. You can classify customers as "High-Spenders" (those with a lifetime value over $500) or "One-Time Shoppers" and then analyze their behavior separately to learn how to convert more apathetic shoppers into loyal fans.

Final Thoughts

Leveraging Looker for e-commerce sales analytics helps you build a robust, reliable, and holistic view of what drives your business. By centralizing your data and defining consistent metrics, you empower your entire team to make smarter, data-informed decisions that move beyond hunches and get right to what truly works.

Of course, setting up a data warehouse and learning the ins and outs of LookML can be a major project, often requiring dedicated technical resources. If you're a marketer, founder, or part of a leaner team that needs to get these insights quickly, setting up a complex BI tool can feel overwhelming. We built Graphed because we believe accessing your data shouldn't be that hard. You can connect your Shopify, ad platforms, and analytics tools in minutes, and then just ask questions in plain English to build real-time dashboards and reports instantly - no data analyst or coding skills required.