google-analytics - BigQuery UDF是否有某种开放的JavaScript库(用于Google Analytics(分析)数据)？

Question

如主题。可能有些人偶然发现了公开提供的javascript库或示例列表，这些示例库在将BigQuery与Google Analytics（分析）数据结合使用时特别有用吗？有趣的博客文章也很重要:)

Answer 1

您真正需要的是BigQuery Analytics Cookbook
它具有大量有用的用例/示例

Query optimization
Tips and best practices
    •   Query multiple tables
    •   3 Days using comma separated table names
    •   Last 7 Days using TABLE_DATE_RANGE
    •   Last 3 Months using TABLE_DATE_RANGE
    •   Last 1 Year using TABLE_DATE_RANGE
    •   Specific Date Range
    •   Last 6 Days plus Today’s data (intraday) using multiple TABLE_DATE_RANGE
Basic query examples
•   Total [metric] per [dimension]
•   Average bounce rate per [dimension]
•   Average number of product pageviews by purchaser type
•   Average number of transactions per purchaser
•   Average amount of money spent per session
•   Sequence of hits (pathing analysis)
•   Multiple custom dimensions at hit or session level
Advanced query examples
•   Products purchased by customers who purchased Product A (Classic Ecommerce)
•   Products purchased by customers who purchased product A (Enhanced Ecommerce)
•   Average number of user interactions before purchase
•   Percentage of stock sold per product
•   Profitability of each product
•   Real profitability of each product

注意：使用JS UDF可以是 expensive，也可以是 limitations-因此，如果确实需要，则应使用它们。在大多数（如果不是全部）合理可行的情况下-使用纯BigQuery标准SQL绰绰有余