How to Create a Sales Report in Google Analytics

Cody Schneider8 min read

Getting a clear picture of your sales performance directly from Google Analytics can feel like a hunt for buried treasure. You know the data is in there - which channels drive revenue, which products are bestsellers, where your most valuable customers come from - but finding and assembling it into an actionable report isn't always straightforward. This guide will walk you through exactly how to create and customize sales reports in Google Analytics 4 so you can stop guessing and start making data-driven decisions.

GraphedGraphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch Graphed demo video

The Undisputed First Step: Set Up Ecommerce Tracking

Before you can report on anything, Google Analytics needs to receive the data. Unlike older versions of Universal Analytics, GA4 uses an event-based model. This means you need to specifically configure your website to send ecommerce events to GA. If this step is missed, your sales reports will be empty.

The good news is that many modern ecommerce platforms have built-in integrations or plugins that handle this for you with just a few clicks. If you're using a platform like Shopify, WooCommerce, or BigCommerce, their native GA4 integrations are typically the easiest way to get started.

If you're using a custom setup, you or your developer will need to implement the tracking, most likely via Google Tag Manager (GTM). The key events you need to track for a complete sales picture are:

  • view_item: When a user views a specific product page.
  • add_to_cart: When a user adds a product to their shopping cart.
  • begin_checkout: When a user starts the checkout process.
  • purchase: The most important one! This event fires when a user completes a transaction. It should include data like transaction ID, value, tax, shipping, and a list of items purchased.

Once you've confirmed that ecommerce events (especially the purchase event) are being sent to your GA4 property, you’re ready to start building reports.

GraphedGraphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch Graphed demo video

Finding Your Core Sales Data: The Standard Monetization Reports

GA4 comes with a set of pre-built reports that give you a great starting point for analyzing sales. You can find these by navigating to Reports > Monetization in the left-hand menu.

Monetization overview

Think of this as your executive summary dashboard. It provides a high-level view of your business's financial performance at a glance. You'll find key cards showing:

  • Total revenue: The overall revenue from purchases.
  • Ecommerce revenue: Revenue specifically from the sale of items (excluding tax and shipping).
  • Total purchasers: The unique number of users who have made a purchase.
  • Average purchase revenue per user: A simple metric to gauge customer value.

This report is perfect for quick check-ins and spotting major trends, like a sudden spike or dip in daily revenue.

Ecommerce purchases

This is arguably the most valuable standard report for understanding what people are buying. It breaks down your sales on a product-by-product basis. The table shows metrics like:

  • Items viewed: How many times a specific product was seen.
  • Items added to cart: The number of times a product was added to a cart.
  • Items purchased: Total units sold for each product.
  • Item revenue: Total revenue generated by each product.

This report is a goldmine for inventory planning, marketing promotions, and product strategy. You can instantly see your bestsellers and identify underperforming products that might need a marketing boost or a content refresh.

Purchase journey

Ever wonder where potential customers are dropping off in the buying process? This report visualizes your sales funnel, answering that exact question. The funnel typically shows the flow of users through these steps:

  1. Session start
  2. View item
  3. Add to cart
  4. Begin checkout
  5. Purchase

It calculates the completion and abandonment rate for each step. For example, if you see a huge drop-off between "Begin checkout" and "Purchase," it could signal an issue with your payment process, unexpected shipping costs, or a confusing form. It helps you focus your optimization efforts where they'll have the biggest impact.

GraphedGraphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch Graphed demo video

How to Build a Custom Sales Report in GA4 Explorations

While standard reports are useful, the real power of GA4 lies in its Explorations tool. This is where you can build completely custom reports to answer specific business questions, like "Which marketing campaigns are driving the most revenue?" or "How does sales performance differ between mobile and desktop users?"

Let's build a popular and highly useful report: Sales Revenue by Marketing Channel.

Navigate to Explore in the left-hand menu and create a new Free form exploration.

Step 1: Set Your Date Range

In the upper left of the exploration interface, set the date range for your analysis. You can choose from presets like "Last 30 days" or set a custom range.

Step 2: Import Your Dimensions

Dimensions are the qualitative attributes of your data - the "who," "what," and "where." Think of them as the categories you want to organize your report by.

In the "Variables" column on the left, click the "+" next to Dimensions. Find and import the following:

  • Session source / medium
  • Campaign
  • Device category

Pro Tip: Use the search bar to find them quickly rather than scrolling through the entire list.

Step 3: Import Your Metrics

Metrics are the quantitative numbers you want to measure. These are the values that will fill your report's columns.

In the "Variables" column, click the "+" next to Metrics. Find and import these key sales metrics:

  • Total revenue
  • Ecommerce purchases
  • Average purchase revenue
  • Transactions

Step 4: Build the Report Canvas

Now you're ready to assemble your report. The "Tab Settings" column is your canvas. Simply drag your imported dimensions and metrics from the "Variables" column into the appropriate slots:

  1. Drag Session source / medium from Dimensions into the Rows section.
  2. Drag Total revenue, Ecommerce purchases, and Average purchase revenue from Metrics into the Values section.

Instantly, a table will appear on the right side of the screen. It will show you a clean breakdown of your total revenue, number of purchases, and average order value for each marketing channel (e.g., google / organic, google / cpc, facebook / cpc, direct / (none)).

GraphedGraphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch Graphed demo video

Step 5: Add a Visualization and Filter

To make the report even easier to digest, you can change the visualization at the top of the "Tab Settings" column from a table to a bar chart or line chart to spot trends more easily.

Want to drill down further? Drag Device category from Dimensions into the Columns box. Now your report will show you the performance of each marketing channel broken down an additional step for desktop, mobile, and tablet users.

Practical Tips for Interpreting Your Sales Reports

Creating the report is only half the battle. The next step is turning that data into actionable insights.

  • Look for the 80/20 Rule: In your channel and campaign reports, you'll often find that a small number of sources (20%) are driving the vast majority of your revenue (80%). This helps you decide where to double down on your advertising budget.
  • Connect Revenue to Behavior: Compare your top revenue-generating channels against engagement metrics like "Average engagement time." If a channel drives a lot of low-value sales but has low engagement, it might be attracting bargain hunters. If another has high engagement and high average purchase value, it's likely attracting your ideal customers.
  • Segment Your Audience: Use the "Segments" feature in Explorations to isolate specific user groups. For example, create a segment for "Purchasers" and one for "Non-Purchasers." Then compare their behavior, traffic sources, and demographics to understand what sets your customers apart.
  • Don't Forget About Attribution: Navigate to Advertising > Attribution > Model comparison to understand how different attribution models (e.g., last click vs. data-driven) credit sales to your marketing channels. This gives you a more nuanced view of the customer journey and helps you value the channels that assist in a conversion, not just the ones that close it.

Final Thoughts

By properly setting up ecommerce tracking and mastering both the standard Monetization reports and the custom Explorations tool, you can transform Google Analytics into a powerful engine for sales analysis. This move from reviewing basic traffic metrics to analyzing revenue and purchase behavior is what distinguishes successful, data-informed businesses from the rest.

While building these reports manually in Google Analytics is a massive step forward, we know it can still feel like a chore that requires clicking through menus and piecing together dimensions and metrics. That's why we built Graphed. Instead of navigating the GA4 interface, you can simply ask in plain English, "Show me my top-selling products by revenue this month" or "Compare revenue from Google Ads vs. Facebook Ads for the last 90 days." We link directly to your tools, crunch the numbers, and build a live dashboard for you in seconds, freeing you up to focus on strategy instead of report-building.

Related Articles

How to Enable Data Analysis in Excel

Enable Excel's hidden data analysis tools with our step-by-step guide. Uncover trends, make forecasts, and turn raw numbers into actionable insights today!