GA and BigQuery: Ecommerce metrics not aligning with product list names

Ecom
1

I’m trying to get product revenue per product list in BigQuery, but I’m running into some issues. The data doesn’t match what I see in Google Analytics UI.

Here’s what’s happening:

  • All product revenue is showing up as ‘(not set)’ in BigQuery
  • Only impressions and clicks are linked to product lists
  • Other actions like detail views, checkouts, and purchases aren’t connected to lists

I’ve tried this query:

SELECT
  product_list AS ListName,
  SUM(product_revenue) / 1000000 AS Revenue
FROM
  ecommerce_data
WHERE
  date BETWEEN '2023-01-01' AND '2023-01-31'
GROUP BY
  ListName
ORDER BY Revenue DESC

But it’s not giving me the results I want. Any ideas on how to fix this? I’m pretty stumped and could use some help!

2

Hey there! I’ve been working with GA and BigQuery for a while, and your issue sounds pretty familiar. Have you considered that maybe the product list data isn’t being passed correctly through the entire purchase funnel? :thinking:

It’s weird that you’re only seeing impressions and clicks linked to product lists. Maybe there’s a disconnect somewhere in your tracking setup?

What if you try to look at the raw event data in BigQuery? Sometimes that can give you clues about what’s actually being captured. You might find the list info hiding in a different field or something.

Also, just curious - have you made any recent changes to your site or tracking implementation? Sometimes little tweaks can cause unexpected issues like this.

Let me know if you find anything interesting in the raw data. I’d be super interested to hear what you discover!

3

I encountered a comparable issue when working with GA and BigQuery. The root cause was often related to how the enhanced ecommerce data layer was implemented. Have you verified that the product list information is being correctly passed through all stages of the purchase funnel? It’s crucial to ensure this data is consistently included in all relevant ecommerce events, not just impressions and clicks. Additionally, double-check your BigQuery schema to confirm that the product_list field is properly mapped. If the issue persists, you might need to investigate the raw event data for any discrepancies or consult with your development team to review the data layer implementation.

4

hey, i’ve had a simlar issue. check if ur ecommerce tracking isnt missing product list passing properly. also, look at raw event data to see if the list info is carried in there. could be join need with othr tables. hope it works!