BigQuery：识别事务之前的所有匹配

作者: 庸人自扰
发布时间: 2024-12-30 12:56:40 (4天前)
转自：

2 条回复

0#
回复此人
日耀九洲 | 2019-08-31 10-32

<div class =“post-text”itemprop =“text”> <P> 以下是BigQuery Standard SQL </p> <pre> <code> #standardSQL SELECT *, 1 + (COUNT(Rev) OVER(PARTITION BY CustVisitId ORDER BY HitNr ROWS BETWEEN UNBOUNDED PRECEDING AND 1 PRECEDING)) `New` FROM ( SELECT CONCAT(CAST(fullVisitorId AS STRING), CAST(visitId AS STRING)) AS CustVisitId, hits.hitnumber AS HitNr, hits.transaction.transactionRevenue/1000000 AS Rev FROM `[projectid].[dataset].ga_sessions_*` AS t, t.hits AS hits WHERE _TABLE_SUFFIX BETWEEN '20190120' AND '20190120' ORDER BY HitNr) WHERE CustVisitId = '49889154628941922861547956449' </code> </pre> <P> 如您所见，我保持您的查询不变，只添加了一行 <code> New </code> </p> </DIV>

编辑

登录后才能参与评论