Google Studio中的平均滚动率 [英] Average scroll rate in Google Studio

问题描述

我想通过分析计算并显示Data Studio中的平均滚动深度.

我希望在Studio中获得平均滚动深度.我已经输入了10％，25％等滚动深度数据，但是现在我需要能够根据该数据计算平均滚动百分比.

要计算平均滚动深度，请执行以下操作:

将滚动阈值乘以事件数(10x500)+(20x400)+(30x475)+(40x300)+(50x200)+(60x100)+(70​​x75)+(80x60)+(90x20)+(100x10 )

然后，将总数除以事件总数. 500 + 400 + 475 ...等

因为我无法在Studio中引用单元格，所以无法使其正常工作.我还尝试了Google表格，该表格确实可以进行计算，但是随后我无法使用Data Studios过滤器来提供特定的页面路径吗?

我认为也许需要在数据源上进行计算，但是我不确定如何引用单元格"?

解决方案

Data Studio并非基于单元"的概念而工作，而是基于"计算出的字段 ".这些字段既可以在图表级别(一次性使用，但不需要修改数据源的权限)创建，也可以在数据源中创建(可在许多图表中重复使用，需要修改数据源的权限).大多数字段还具有汇总类型，该类型告诉报表默认情况下如何将其汇总到图表中(例如，总和或平均值).

当您编辑数据源并点击添加字段"或图表上添加指标"或添加维度"菜单下具有相同名称的选项时，系统会显示一个框，用于输入公式.要访问一个字段，只需键入其名称(如果您在数据源中，请从左侧列表中选择它的名称).编辑器通常还会根据您键入的内容在您的光标下方提供一个自动完成列表.输入的内容与字段匹配后，它将在其周围显示一个高亮框(颜色基于类型；绿色=尺寸/字符串，蓝色=度量标准/数字).可用的功能有点像您希望在Google表格和SQL查询之间进行的某种混搭，但是在允许您使用某些功能的时间上有更多的限制.

计算字段的文档非常简单，因此建议您从在尝试在Data Studio中进行过多繁琐的工作之前，您需要先进行修改.由于Data Studio数据模型的限制，您经常会发现需要为公式的不同部分创建单独的计算字段，然后将它们合并到一个新的计算字段中.我会警告您，有时字段编辑器中的错误消息并不是很有用，因此您可能需要重新阅读所使用的函数和字段类型的文档，以确保获得有效的结果. /p>

如果遇到问题，包括计算中所需的字段名称和值可能会有所帮助，包括数据源(这些GA事件是?).您提供的详细信息越多，包括您已经尝试过的内容，我们就会越有帮助.另外，请务必先阅读文档，以确保您对所使用的产品和社区最有可能理解的术语有所了解.

I want to calculate and display the average scroll depth in Data Studio from analytics.

I’m looking to get an average scroll depth in Studio. I’ve got the 10%,25%, etc scroll depth data coming in, but I now need to be able to calculate the average scroll % from this data.

To calculate the average scroll depth:

multiply the scrolled threshold by the number of events (10x500) + (20x400) + (30x475) +(40x300) + (50x200) + (60x100) +(70x75) +(80x60) + (90x20) + (100x10)

Then, take that total divided by the total number of events. 500 + 400 + 475... etc

Because I can’t reference cells in Studio I can’t get it to work. I’ve also tried Google Sheets, which does work to do the calculation, but then I can’t use Data Studios filter to provide a specific page path?

I'm thinking that perhaps the calculation will need to be done at data source, but I am not sure how to reference a 'cell'?

解决方案

Data Studio doesn't work based on a concept of "cells", it works based on a concept of "fields"—which are basically properties of the data source. Similarly, you don't have "formulas" per se, but rather "calculated fields". These fields can be created either at the chart-level (single-use, but doesn't require permissions to modify the data source) or in the data source (reusable across many charts, requires permissions to modify the data source). Most fields also have an aggregation type, which tells the report how to aggregate it in charts by default (e.g. Sum or Average).

When you either edit your data source and hit "Add Field" or the option with the same name under the "Add metric" or "Add dimension" menus on a chart, you'll be presented with a box to input the formula. To access a field, just type its name (of if you're in the data source, select it from the list on the left). The editor will also typically give you an auto-complete list below your cursor based on what you're typing. Once your entry matches a field, it will get a highlight box around it (the color is based on the type; green = dimension/string,blue = metric/number). The functions available are sort of a mash-up of something between what you'd expect in Google Sheets and in a SQL query, but with more constraints on when you're allowed to use certain functions.

The documentation for calculated fields is pretty simple, so I'd recommend starting there before you try to do too much heavy-lifting in Data Studio. Because of constraints in Data Studio's data model, you'll often find that you need to create separate calculated fields for different parts of the formula, and then combine them in a new calculated field. I'll warn you that the error messages in the field editor aren't super helpful sometimes, so you may need to re-read the documentation for the functions and field types you're working with to ensure you get a valid result.

If you're running into problems, including the field names and values that you need in your calculation may help, including the source of the data (are these GA events?). The more details you give, including what you've already tried, the more helpful we can be. Also, make sure to read the docs first to make sure you have a good handle on the product you're using and the terminology the community is most likely to understand.

这篇关于Google Studio中的平均滚动率的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！