BigQuery问题-我无法提取产品列表中添加到购物车的数量和产品（GoogleAnalytics-UA）
- 首先，在BigQuery中获取原始数据源（即Google Analytics - UA）。确保数据集中包含“产品列表视图-> 添加到购物车”，并将其导入到BigQuery表中。
示例代码：
SELECT
hits.transaction.transactionId AS transaction_id,
hits.eCommerceAction.action_type AS action_type,
hits.product.productSKU AS product_sku,
hits.product.v2ProductName AS product_name,
hits.product.productQuantity AS product_quantity,
FROM
project_id.dataset_id.ga_sessions_*,
UNNEST(hits) AS hits
WHERE
hits.eCommerceAction.action_type = '2'
- 使用以下代码获取每个产品id的总数：
示例代码：
SELECT
hits.product.productSKU AS product_sku,
SUM(CAST(hits.product.productQuantity AS INT64)) AS total_quantity
FROM
project_id.dataset_id.ga_sessions_*,
UNNEST(hits) AS hits
WHERE
hits.product.productSKU IS NOT NULL
AND hits.eCommerceAction.action_type = '2'
GROUP BY
product_sku
- 使用以下代码获取每个产品名称和id的总数：
示例代码：
SELECT
hits.product.productSKU AS product_sku,
hits.product.v2ProductName AS product_name,
SUM(CAST(hits.product.productQuantity AS INT64)) AS total_quantity
FROM
project_id.dataset_id.ga_sessions_*,
UNNEST(hits) AS hits
WHERE
hits.product.productSKU IS NOT NULL
AND hits.eCommerceAction.action_type = '2'
GROUP BY
product_sku,
product_name
通过以上步骤，您将能够在BigQuery中提取产品列表中添加到购物车的数量和产品。