Skip to main content
E
Contributor I
Emily.C
Contributor I
May 22, 2025
Solved

Custom Report based on highly clicked but not purchased items

  • May 22, 2025
  • 3 replies
  • 168 views

Is there a way to create a custom report that shows items that are highly clicked on in an email, but with low placed order numbers? A report would tell me which products people are interested in but for some reason are not purchasing. Does such a report exist? If so, could you instruct how to build it? Thank you!

      Best answer by zacfromson

      Hi ​@Emily.C 

      Yes — while Klaviyo doesn’t have a pre-built report for this exact use case, you can absolutely create a workaround using custom analytics and the Product Performance data from email campaigns. Here’s how to build insight into which items are getting high clicks but low purchases:

      1. Go to Campaign Performance Report

      • Navigate to Campaigns > [Select Campaign] > View Report
      • Scroll to the “Link Activity” or “Product Performance” section (if using product feeds or dynamic blocks)

      2. Export Link Click Data

      • Export the report to see which product URLs were clicked the most
      • Identify SKUs or product URLs with high click-through rates

      3. Compare to Purchase Data

      • Go to Analytics > Product Performance
      • Filter by the same date range and compare the clicked products with those that had low or no sales
      • Products with high clicks but low orders are your low-converting opportunities

      Additional Tips:

      • Set up a segment for users who clicked a product but didn’t purchase (use Clicked Email and exclude Placed Order)
      • Use this to build a targeted follow-up flow or A/B test different offers or messaging on those products
      • If using UTM tags or Google Analytics, you can also refine this with enhanced ecommerce reports

      3 replies

      zach.scheimer
      Problem Solver III
      zach.scheimer
      2025 Champion
      May 22, 2025

      Hi ​@Emily.C - this is a great question. I currently do something similar but do it outside of the Klaviyo platform. The way that I would set his up is by utilizing the UTM Term (image of where you can add that in the campaign editor is below). You can make you alt text the product title. You can then use Google Analytics or the web analytics platform you use and track clicks and orders for that campaign based on the UTM Term which would be the product title.
       

      Let me know if you have any more questions on this.

       

      Thanks,

      Zach

        M
        Problem Solver IV
        mike digital101
        Problem Solver IV
        May 22, 2025

        Hi ​@Emily.C ,

        Klaviyo doesn’t have this exact report built-in, but you can get this info in two ways:

        1. Use UTM tags + Google Analytics

        Add a UTM tag (like the product name) to your email links. Then use Google Analytics to see which products got lots of clicks but few purchases.

        2. Use Klaviyo data manually

        If you're tracking “Viewed Product” and “Placed Order” in Klaviyo, you can:

        • Check which products got clicks in emails.

        • Compare that to products with low or no orders.

        It’s a bit manual, but doable. Let me know if you want help setting it up.

        +2348087340172 (Whatsapp number)
          zacfromson
          Expert Problem Solver III
          zacfromsonAnswer
          2025 Champion
          May 23, 2025

          Hi ​@Emily.C 

          Yes — while Klaviyo doesn’t have a pre-built report for this exact use case, you can absolutely create a workaround using custom analytics and the Product Performance data from email campaigns. Here’s how to build insight into which items are getting high clicks but low purchases:

          1. Go to Campaign Performance Report

          • Navigate to Campaigns > [Select Campaign] > View Report
          • Scroll to the “Link Activity” or “Product Performance” section (if using product feeds or dynamic blocks)

          2. Export Link Click Data

          • Export the report to see which product URLs were clicked the most
          • Identify SKUs or product URLs with high click-through rates

          3. Compare to Purchase Data

          • Go to Analytics > Product Performance
          • Filter by the same date range and compare the clicked products with those that had low or no sales
          • Products with high clicks but low orders are your low-converting opportunities

          Additional Tips:

          • Set up a segment for users who clicked a product but didn’t purchase (use Clicked Email and exclude Placed Order)
          • Use this to build a targeted follow-up flow or A/B test different offers or messaging on those products
          • If using UTM tags or Google Analytics, you can also refine this with enhanced ecommerce reports
          Zac Fromson | Co Founder @ Lilo Social - a full-funnel ecommerce growth agency | lilosocial.com | 2026 Klaviyo Champion
          Terms & ConditionsAccessibility statement

          Links & Resources

          Platforms

          Partners

          Useful Things

          About

          • Terms and Privacy |
            © 2026 Klaviyo All rights reserved. Klaviyo and the Klaviyo logo are trademarks or registered trademarks of Klaviyo, Inc. or its affiliates.