概述：Google Analytics的查询构建器（报告）

使用Google Analytics的查询构建器，您可以使用指标，尺寸，段和过滤器的组合创建自定义Google Analytics指标。

Some popular use cases for the Query Builder for Google Analytics include creating content-specific Metrics, reporting on custom Goal Conversions, etc.

HOW TO

如何访问Google Analytics的查询构建器

Navigate to指标>查询生成器to access the Query Builder. Click the green+ New Custom Metric按钮，然后从中选择连接的Google Analytics帐户数据源下拉列表。

    Query Builder可在表演者和专业计划中获得。请通过以下请求查询生成器的试用这些步骤。

如何使用谷歌分析的查询构建器

A
数据源：这是自定义度量的Google Analytics数据源从中同步数据。
B
公制：从连接的Google Analytics数据源中选择度量标准，例如会话，PageViews或页面/会话。某些指标，如目标2完成，允许您报告在Google Analytics帐户中设置的自定义目标。
C
Dimension(Optional)：尺寸参数根据公共条件重新分类返回的度量值。尺寸的示例是默认通道分组，页面和设备类别。如果没有选择维度，则自定义度量标准将为每个日期范围存储1个聚合度量标准值。
专家提示： Add the word "by" in between the Metric and Dimension in order to determine an appropriate Custom Metric Name. From the Metric and Dimension examples outlined above, we could create the Custom Metrics "Sessions by Default Channel Grouping," "Pageviews by Page," or "Pages / Session by Device Category."

Most tables in Google Analytics organize Dimensions into rows and Metrics into columns. In order to replicate the Google Analytics table below in Databox, you would need to create 6 Custom Metrics: "Users by User Type," "New Users by User Type," "Sessions by User Type," "Bounce Rate by User Type," "Pages / Session by User Type," and "Avg Session Duration by User Type."

add_user_popup@2x

D

Invert Metric (Optional): By default, the percentage change value displayed on Datablocks is green when the Metric value has increased, and red when the Metric value has decreased. If the Custom Metric you created has opposite trends, select this option. Learn more这里。

E
部分(Optional) :段是分析数据的子集。例如，在跟踪的整个用户组中，一个段可能是来自特定国家/地区的用户。另一个部分可能是购买特定产品行的用户，或从有机来源来到您网站的用户。
Learn more about creating Segments in Google Analytics这里。
F
公制Sort Order：为返回的自定义度量标准值选择“升序”或“降序”排序顺序。应选择“降序”对于所需的任何度量标准（如“会话”和“PageViews”）。应选择“升序”排序订单，以便需要较低的度量值（如“跳动率”和“每次点击成本”）。
了解度量标准排序顺序的重要性这里。
G
Filter by(Optional) :过滤器限制自定义度量标准中包含的数据。返回的所有数据都针对过滤器测试。可以使用和/或布尔逻辑组合多个过滤器。
如果来自来自度量标准和维度字段的数据符合过滤器规范，则保留数据并包含在自定义度量值中。如果从度量标准和维度字段同步的数据不符合过滤器规范，则数据将从自定义度量标准值中排除。
专家提示 : If you don't know which Filters to put in place for your use case, use the Dimension + Data Preview to troubleshoot and get more insight into the data that is returned from your Google Analytics Account for each field. Learn more 这里 。
H
Preview data：点击后Preview data，将显示自定义度量标准的数据预览。每日度量标准值显示在本节中，以及底部粗体中的日期范围的总度量值。您可以通过单击数据预览顶部的下拉列表查看不同日期范围的数据预览。
I
自定义度量名称：输入自定义度量标准的名称。保存后，设计人员将在设计器中使用此自定义度量标准名称。
J
保存: Save your Custom Metric.

如何创建一个定制的谷歌分析指标(交货吗ample]

In this example, we'll create a Custom Metric to report on New Users tracked in the Google Analytics Account split up based on the Country where the User accessed the website. We only want to view this data for New Users that found the website through Organic Search.

1
Navigate to公制s > Query Builder
2
点击绿色+ New query按钮
3
Select the appropriate Google Analytics Data Source
4
SelectNew Usersfrom the公制下拉列表
5
Next, we'll selectCountryfrom theDimensions下拉列表so that the New Users values returned are split up based on the Country where the site was accessed.
6
Organic Traffic是每个Google Analytics帐户中的标准段，所以我们将从中选择此项部分下拉列表to focus on the Organic subset of New Users.
7
自从New Usersis a Metric where higher values indicate success, we don't need to select a公制Sort Orderand can rely on the default setting, which is下降。
8
We don't need to further filter the data, so we will leave the Filter section blank as well.
9
In order to accurately explain what this Custom Metric is reporting on, we'll name the Custom Metric "New Organic Users by Country"
10
ClickPreview Datato generate a Data Preview of the Custom Metric.
11
Once we confirm that these are the results we're looking for, we'll click保存保存自定义度量标准。

How to add a Custom Google Analytics Metric to a Databoard

1
在DataBox Designer中打开所选数据库，或创建新数据软件。beplay体育appios
2
Drag and drop a blank Datablock onto the Databoard from the Visualization Library.
3
在Righthand Property Manager中选择相应的Google Analytics数据源。这必须是在创建自定义度量标准时选择的相同Google Analytics帐户。
4
Select theCustomtab at the top of the公制下拉列表。
5
选择自定义度量标准名称以填充Datablock。

附加信息

  • TheData Previewis limited to display a maximum of 20 Dimensions per Date Range forAttributed Metrics。尺寸将按降序排序，因此将显示最高总值的20个维度Data Previewfor each Date Range.
  • （未设置）是Google Analytics在尚未接收到所选维度的任何信息时使用的占位符。
    • 对于通过与Google广告的外部集成与Google Analytics与Google Analys联系的活动，Google搜索控制台等，Google的API显示（未设置）。对于Google Analytics广告系列，将显示活动的实际名称。Learn more about the (not set) behavior in Google here.

    To clean up your reports in Databox, you can exclude or rename the (not set) Dimension for Custom Metrics by following这些步骤。

  • When a Metric contains "Age", "Gender", or "Interest Category" as a Dimension or Segment, a threshold may be applied in Google Analytics and some data may be withheld from the report.

    This happens when your website has low traffic and, as a result,thresholds are applied to your report by Google Analyticsto prevent anyone viewing a report from inferring the demographics or interests of individual users.

    这是Google Analytics侧的限制，并且没有解决DataBox中的解决方案。beplay体育appios

    In Google Analytics, when a threshold is applied to a report a yellow icon is displayed at the top of the report, along with a notice below the report title. If no threshold is applied, a green icon is displayed.
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

还需要帮助吗？联系我们联系我们

相关文章

Baidu