title: BigQuery and GA: Some ecom metrics like product revenue not assigned correctly to product list name
body: <p>Just as is shown in the Google Analytics User Interface, I'd like to get the product revenue per product list via the query as is seen below. However, all product revenue is assigned to '(not set)', while in the UI it's assigned to the product lists.</p>
  
  <p>Also, it looks like in BQ only product list impressions and product list clicks (BQ field hits.eCommerceAction.action_type) are assigned to product lists. Product detail views, checkouts, and unique purchases also do not seem to be assigned to product lists, while in the GA UI they do. The same issue as with the product revenue I guess.</p>
  
  <p>Does anyone know how to get the desired result?</p>
  
  <pre><code>SELECT
    prod.productListName AS ProdListName,
    SUM(prod.productRevenue)/1000000 AS PrRev
  FROM
    `[project id].[dataset id].ga_sessions_*` AS t, t.hits AS hits, hits.product AS prod
  WHERE
    _TABLE_SUFFIX BETWEEN '20181103'
    AND '20181103'
  GROUP BY
    ProdListName
  ORDER BY PrRev DESC
  </code></pre>