Overview: Query Builder for HubSpot Marketing (Active Lists)

如何访问查询构建器进行集线器营销（活动列表）

导航指标>查询构建器to access the查询建筑商用于HubSpot营销。Click the green+ Create Custom Metricbutton and select your connected HubSpot Marketing Account from the数据源下拉列表。选择活动列表button.

HubSpot的新创建的活动列表account will not be recognized in Databox until the next day after larger data sync to identify new Active Lists in the HubSpot account is performed in the middle of the night.

如何将查询构建器用于集线器营销（活动列表）

设置主动列表以跟踪净新活动列表联系人时的最佳实践

可以从HubSpot的API访问活动列表中的联系人数量的每日数据跟踪。与活动列表中的联系人相关的特定联系人属性无法从HubSpot的API访问。因此，即使联系人在较早的日期有资格获得列表的资格，也无法在活动列表的创建日期之前访问数据。

because of this, you may want to consider creating Active Lists that only have Contacts added to them, and setting a start date for when Contacts qualify for the Active List.

如何创建活动列表以跟踪符合指定活动列表过滤器的新联系人

净新的主动列表联系人are calculated by performing the following backend calculation:

（在日期范围的最后一天的活动列表中的联系人＃） - （日期范围第一天的活动列表中的联系人＃）=日期范围内的净新活动列表联系人

因此，如果您想跟踪New接触s that are added to the Active List rather than净新从活动列表中添加或删除的联系人，您需要确保您的活动列表过滤器不会从活动列表中删除联系人。这将确保仅接触仅输入活动列表，而净新的活动列表接触值不会偏斜。

How to create Active Lists with an open Start Date to qualify for the Active List [Example]

Let's say you create an Active List to track CTA Clicks to a specific CTA on May 7th and 150 Contacts were added to the Active List. HubSpot is only sending Databox the number of Contacts in the Active List, not any specific Contact Properties associated with the Contacts in the Active List. So, all 150 Contacts that entered the Active List on May 7th are considered New Active List Contacts (or CTA Clicks) on May 7th.

在Dabeplay体育appiostabox中，您在5月8日创建一个自定义指标，然后选择净新的主动列表联系人作为数据选择。

On May 31st, there are 1000 Contacts in the Active List.

• If the跳过了活动列表中的联系人复选框is not选择，以下方程式将在一个月的后端上执行：
  
  1000（5月31日活动列表中的联系人＃）-0(# of Contacts in the Active List on May 1st)=1000（5月的净新活动列表联系人）
• If the跳过了活动列表中的联系人复选框is选择，以下方程式将在一个月的后端上执行：
  
  850（5月31日在活动列表中的联系人＃[1000] - 创建活动列表的活动列表中的联系人＃[150]）-0(# of Contacts in the Active List on May 1st)=850（5月的净新活动列表联系人）

Since this is a rolling list, moving forward, no changes need to be made. In June, the number of Net New Contacts in the Active List (or Contacts who clicked the CTA) will not be skewed, because there weren't any old Contacts that were added to the Active List during this time. However, the "Year to Date" Value for CTA Clicks will not be accurate until the following year, because the Active List is not set to include Contacts who clicked the CTA throughout the full year.

如何使用设定的启动日期创建活动列表以获取活动列表的资格[示例]

Let's say you create an Active List to track CTA Clicks to a specific CTA on May 7th and you are primarily interested in Monthly reporting. Therefore, you add a condition to the Active List so only Contacts who clicked on the CTA on May 1st and on are added to the Active List. Because of this criteria, 25 Contacts are added to the Active List on May 7th to account for all CTA Clicks in May.

在Dabeplay体育appiostabox中，您在5月8日创建一个自定义指标，然后选择净新的主动列表联系人作为数据选择。

On May 31st, there are 1000 Contacts in the Active List. You will not want to select the跳过了活动列表中的联系人复选框，因为故意添加了所有添加到活动列表中的联系人。将在5月和所有未来日期范围内准确计算出新的活动列表联系人的净数量。beplay体育appios但是，CTA点击的“迄今为止”的“迄今为止”值要到第二年才能准确，因为活动列表不设置为包括在整整一年中点击CTA的联系人。

How to verify a Custom Active List Metric in HubSpot vs Databox [Example]

Let's walk through an example to verify Net New Active List Members for an Active List that is tracking Contacts who sign up for our AM Demo. We're interested in viewing data for This Month.