过滤自定义指标中的数据? [英] Filtering data in a custom metric?

问题描述

在特定类型的页面上，每当有人注册产品时，我都会触发一个事件.该事件是:

On a particular type of page, I have an event that fires every time someone enrolls in a product. The event is:

类别 :注册
操作 :<产品名称>
标签 :注册

Category: Enroll
Action: < Name of Product >
Label: enroll

我能够使用总事件的度量标准并通过标签 enroll 进行过滤，从而创建一个列出事件在Pages上触发次数的报告.给出触发它的页面以及事件的计数.

I am able to create a report that lists the number of times the event was fired on Pages by using the metric of total events and filtering by the label enroll This gives the page that it was fired on and the count of the event.

我现在正在尝试转换率.所以，我想得到

I'm now trying to do conversion rate. So, I'd want to get

(Total Events on the page (filtered by Event Label="enroll")) / Unique Pageviews

我不知道如何使用计算出的指标在Data Studio中过滤所有事件.有什么好方法吗?

I can't figure out how to do the total events filtered in Data Studio using a calculated metric. Is there a good way to do this?

推荐答案

尝试在案例语句的总和中使用REGEXP_MATCH来实现所需的功能.

Try using REGEXP_MATCH in the sum of a case statement to achieve what you need.

按以下步骤创建指标，然后将唯一身份浏览量除以第二指标.

Creating a metrics as follows and then do the division by unique pageviews as a second metric.

 SUM(case when REGEXP_MATCH(Event Label, "enroll") then 1 else 0 end)

这篇关于过滤自定义指标中的数据?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！