如何获得维度（自定义变量）的结果，其中没有设置值？ [英] How can I get results for a dimension (custom variables), where the value is not set?

问题描述

我使用自定义变量来跟踪订单ID。为了将分析数据汇总到数据仓库中，我想选择一些以自定义变量作为维度的指标。但是，如果我这样做了，我将不会获得未设置变量的条目（例如，未导致销售的会话）。我还需要获得这些信息。

我可以写一个过滤器或片段，只选择没有特定自定义变量的条目吗？我试过：

  segment = dynamic :: ga：customVarValue1 == 
  

但这似乎不起作用（它没有给出结果）。

基本上我'寻找相当于其中ga：customVarValue1为空在sql中。

解决方案

简而言之，无法获得空值数据，正如Google代表所说：

对于某些维度，GA使用默认值（未设置）。
自定义变量没有默认值，因此如果某个匹配没有与其关联的
自定义变量，则查询
中的所有其他维都不会添加到报表中。

原始答案有点令人困惑，但是当您在各行之间阅读时，表明他们会在这些空他们运行他们的聚合。

正如他解释的那样，正确的方法是为您想要报告的行设置一个默认值：

如果您需要查看（未设置）值，则可以尝试为自定义变量发送默认的
值。

例如，如果您使用访客级自定义变量来跟踪成员vs
非成员，则应始终将非成员设置为每个人的默认成员;
然后在注册后修改成员。

详细信息如下： http://groups.google.com/group/google-analytics-data-export-api/browse_thread/thread/cd078ddb26ca18d5?pli= 1

I am using custom variables to track order ids. In order to aggregate analytics data into out data warehouse, I want to select a number of metrics with the custom variable as a dimension. However, if I do so, I will not get the entries where the variable is not set (E.g. sessions that didn't result in a sale). I need to get these as well.

Can I write a filter or segment that selects only the entries that doesn't have a particular custom variable? I have tried:

segment=dynamic::ga:customVarValue1==

But that doesn't seem to work (It gives no results back).

Basically I'm looking for the equivalent to where ga:customVarValue1 is null in sql.

解决方案

In short, it's not possible to get the nullset data, as explained by a Google rep:

For some dimensions, GA uses the default value of (not set). Custom Variable do not have a default value, so if a hit does not have a custom variable associated with it, all the other dimensions in the query are not added to the reports.

The original answer is a little confusing, but when you read between the lines it suggests that they throw out these "empty" values when they run their aggregates.

The "correct" approach, as he explains, is to set a default value for any row you want reported:

If you need to see the (not set) value, you could try sending a default value for custom variables.

For example if you use visitor level custom vars to track member vs non-member, you should always set non-member as a default for everybody; then modify to member once they register.

Details are here: http://groups.google.com/group/google-analytics-data-export-api/browse_thread/thread/cd078ddb26ca18d5?pli=1

这篇关于如何获得维度（自定义变量）的结果，其中没有设置值？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！