shopifyQL use product_title in a query or report like 'sessions by landing page'

Hi

All I want is a report like ‘sessions by landing page’ but for product or pages viewed in a session.

Every time I try a report the product_title is greyed out.

I want to see sessions (unique visitors)

Viewed Page … added to cart … started checkout … completed checkout.

One thing I’m trying to identify is pages that have an add to cart but a large proportion of users are not taking the next step.

To see if there is anything ‘wrong’ with the page/product.

Other than a 3rd party app, is there any ‘FROM’ that I can use that will not have the product_title greyed out in the dimensions?

It doesn’t have to be product_title I am open to others, just not landing_page as it doesn’t show other pages that a user may have viewed

Many thanks

Amanda

1 Like

You’ll need enhanced e-commerce tracking for that. Try using the “Product” dimension with event tracking, or set up custom reports/segments. Google Tag Manager can also help if you’re not using a third-party app.

Hi, Thanks, I don’t have that option in my reports, it may be in the next
tier up, I’m on ‘grow’

Amanda