August 20, 2026
Scaling a Shopify brand requires more than just tracking top-level sales; it requires a deep understanding of where customers drop off in the journey. Most operators struggle with fragmented data across multiple platforms, making it difficult to see how specific content, like video, impacts the bottom line. This is where a Looker conversion funnel becomes essential. By centralizing your data in a business intelligence tool, you can move beyond the surface-level metrics provided by standard dashboards.
At Videowise, we focus on turning video into a measurable revenue driver, and that starts with having a clear view of your funnel. This guide will walk you through building a robust conversion funnel in Looker, integrating advanced data points like video influence, and using those insights to drive higher Revenue Per Session (RPS). We will cover the technical setup, the strategic application of funnel data, and how to optimize each stage for maximum growth.
Standard analytics tools often provide a "black box" view of the customer journey. You see the entrance and the exit, but the nuances of user behavior in the middle are often lost. For a high-growth brand, understanding these nuances is the difference between a profitable quarter and a stagnant one.
A Looker conversion funnel allows you to stitch together disparate data sources—Shopify order data, Google Analytics events, and video performance metrics—into a single, cohesive narrative. This level of granularity is necessary for calculating Conversion Rate (CVR) across specific segments and understanding how different touchpoints influence the Average Order Value (AOV). For additional context, review this guide to optimizing an ecommerce conversion funnel.
Most platforms default to last-click attribution, which overvalues the final step and ignores the upper-funnel interactions that built the intent. Looker allows you to build multi-touch models that account for the entire journey. When you can see that a customer watched a shoppable video experience on a Product Detail Page (PDP) before adding to cart, you can accurately attribute revenue to that content asset.
A well-constructed funnel highlights exactly where you are losing money. If your "Add to Cart" to "Initiate Checkout" rate is high, but "Initiate Checkout" to "Purchase" is low, you likely have a friction point in your shipping costs or payment options. Looker makes these bottlenecks visible so you can prioritize your development and merchandising efforts.
Key Takeaway: A Looker conversion funnel transforms raw event data into a strategic roadmap, allowing operators to identify specific friction points and move beyond the limitations of standard last-click attribution.
Before you can build a funnel in Looker, you need a solid data foundation. Most Shopify brands use a data warehouse like BigQuery or Snowflake to store their raw event data. This data usually comes from a combination of server-side tracking and client-side events.
A standard ecommerce funnel typically consists of the following stages:
To make this funnel more sophisticated, we recommend adding a "Content Interaction" stage. This tracks when a user engages with a shoppable video or a UGC gallery. This allows you to measure the Revenue Per Session (RPS) of users who interact with video versus those who do not.
To build this in Looker, you need:
view_item, add_to_cart).Building a conversion funnel in Looker involves writing LookML (Looker Modeling Language) to define how your data is aggregated and visualized.
First, you need to group individual events into sessions. This is often done using a Persistent Derived Table (PDT) that calculates the session start and end times for each user.
Action: Define a table that assigns a session_id to every event based on a 30-minute window of inactivity.
In your view file, you will create dimensions that act as "flags" for each stage of the funnel. These flags return a 1 if the user completed the step during their session and a 0 if they did not.
Action: Create a dimension for each step:
has_viewed_producthas_added_to_carthas_purchasedNext, you need to count how many unique sessions reached each stage. Use the count_distinct measure type in LookML, targeting the session_id.
Action: Create measures like count_product_views and count_purchases. These will form the basis of your visualization.
To see the drop-off, create "calculated measures" that divide one stage by the previous one.
Action: Define a measure for cart_to_purchase_rate by dividing count_purchases by count_add_to_carts.
Quick Answer: A Looker conversion funnel is built by defining sequential event flags in LookML and then creating distinct counts of sessions that triggered those flags. This allows you to visualize the percentage of users moving from one stage to the next.
Video is no longer just a brand awareness tool; it is a direct driver of conversion. To get a complete picture of your funnel, you must integrate video performance data.
We provide Content Performance Analytics that can be exported or synced with your data warehouse. By bringing this data into Looker, you can see how shoppable video impacts the funnel in real-time. For example, you can compare the "Add to Cart" rate of users who watched an AI Clip versus those who only looked at static images. Explore video commerce performance tracking for more ideas on structuring these measurements.
One of the most important metrics to track in your Looker funnel is influenced revenue. This identifies sessions where a user interacted with a video and subsequently made a purchase.
By including these segments in your Looker funnel, you can justify further investment in UGC and shoppable video content. We've seen that brands using our platform often find that video-influenced sessions have a significantly higher AOV because video does a better job of explaining product value and building trust.
| Funnel Stage | Standard Session CVR | Video-Influenced CVR | Improvement Opportunity |
|---|---|---|---|
| Product View | 100% | 100% | Baseline |
| Add to Cart | 5.2% | 8.4% | High: Video reduces uncertainty |
| Checkout Start | 3.1% | 5.1% | Medium: Video builds intent |
| Purchase | 1.8% | 3.2% | High: Direct path to purchase |
Once your Looker funnel is live, the work of optimization begins. You should look for outliers and patterns that indicate where your store is underperforming.
Not all traffic is created equal. A funnel for TikTok traffic will look very different from a funnel for search engine traffic. Use Looker's filtering capabilities to see which channels bring in users who drop off at the "Add to Cart" stage. If TikTok users are dropping off quickly, you might need more engaging, short-form video content on your landing pages to match the experience they just came from.
Mobile conversion rates typically lag behind desktop. However, if the gap is too wide in your Looker funnel, it indicates a technical or UX issue. Since we use a performance-first infrastructure, our video components are optimized for mobile viewport loading. This ensures that video content doesn't slow down the page or hurt your Core Web Vitals (CWV), which are critical for both SEO and user experience.
Core Web Vitals are a set of metrics that Google uses to measure the speed and stability of a page. Specifically, Largest Contentful Paint (LCP) measures how fast the main content loads. If your video player is heavy, it will tank your LCP and hurt your funnel. Our infrastructure is designed to keep LCP low, ensuring that the funnel remains fluid on mobile devices.
Looker allows you to break down your funnel by landing_page_path. This helps you identify specific PDPs or collection pages that are underperforming. If a specific product has a high view rate but an unusually low add-to-cart rate, it may need better social proof, more UGC, or a clearer explanation of its features through video. See how Legends improved conversion with a shoppable video homepage carousel while protecting page speed.
Bottom line: Optimization is a continuous process of segmenting funnel data by channel, device, and page to find and fix specific conversion leaks.
As your data maturity grows, you can move away from simple session-based funnels to more advanced attribution models in Looker. This video commerce ROI measurement guide provides additional guidance on connecting video activity to revenue.
First-touch attribution helps you understand which top-of-funnel content is actually introducing new customers to your brand. In Looker, you can look back at the very first event associated with a user_id. Often, you will find that a live shopping experience or a viral UGC video was the initial catalyst, even if the purchase happened weeks later via a direct search.
Looker is excellent for cohort analysis. You can group users by the month they first visited your site and track their conversion funnel over time. This is essential for understanding Customer Lifetime Value (LTV). A customer who engages with video content early in their journey is often more likely to become a repeat purchaser, as they have a deeper connection to the brand story.
Myth: "Video is only for top-of-funnel awareness." Fact: Shoppable video and AI-powered product tags are high-intent tools that directly drive "Add to Cart" and "Purchase" events, often seeing higher CVR than static elements.
For brands managing hundreds or thousands of SKUs, manually optimizing every funnel is impossible. You need tools that allow for scale without heavy developer dependency.
Our platform supports bulk publishing and multi-store support, allowing you to deploy video content across your entire catalog and track the results in Looker without writing custom code for every page. This automation is key for lean ecommerce teams who need to move fast.
Looker tells you what is happening, but it doesn't always tell you why. By using AI Studio and AI Clips, you can iterate on your content based on the data you see in your funnel. If the Looker data shows that long videos are causing drop-offs, you can use AI to automatically create shorter, punchier clips that are better suited for mobile shoppers.
While CVR is the most discussed metric, Revenue Per Session (RPS) is often more important for overall profitability. RPS is calculated by dividing total revenue by the number of sessions.
A Looker conversion funnel allows you to calculate RPS for specific segments. For example:
In our experience, users who interact with interactive video elements have a much higher RPS because they are more likely to add multiple items to their cart, increasing the Average Order Value (AOV). See how Little Ranch Family increased revenue and RPS with shoppable video for an example of measuring video against commercial outcomes.
Building a Looker conversion funnel is one of the most impactful steps a Shopify operator can take to professionalize their data strategy. It provides the visibility needed to identify friction, attribute revenue correctly, and optimize the customer journey at scale. By integrating video performance data into your Looker environment, you gain a competitive edge, seeing exactly how visual commerce influences every step of the path to purchase.
At Videowise, we are committed to helping brands treat video as a high-performance revenue channel rather than a vanity metric. Our platform provides the data and the infrastructure needed to ensure your video strategy is both measurable and effective.
Key Takeaway: The goal of a conversion funnel is not just to see the data, but to act on it. Use Looker to identify the "why" behind your drop-offs and use high-impact content to bridge those gaps.
Ready to see how shoppable video can improve your funnel? Book a personalized demo or install Videowise from the Shopify App Store today.
To track video engagement, you must send custom events from your video player—such as "Video Play," "Product Click," or "Video Completed"—to your data warehouse. These events can then be used as specific steps or segments within your Looker funnel to measure how video interaction influences purchase behavior.
Conversion Rate (CVR) measures the percentage of users who complete a specific action, like a purchase. Revenue Per Session (RPS) takes the total revenue and divides it by the total number of sessions, providing a more comprehensive view of how much each visitor is worth to your business, accounting for both conversion and order value.
Yes, by segmenting your funnel by device, you can see exactly where mobile users drop off compared to desktop users. If the drop-off occurs during page load or early browsing, it often points to page speed issues or poor Core Web Vitals, which can be fixed by using performance-optimized content delivery.
Shoppable video typically reduces drop-off at the "Add to Cart" stage by providing a more immersive and informative product experience. By answering customer questions and showing the product in use, video builds the confidence necessary for a user to move from browsing to intent, ultimately smoothing the path to purchase.
