GAQL 指标。X 受分段影响。Y？

Question

我有这个 GAQL：

  var query = 'SELECT \
    customer.id,\
    customer.descriptive_name,\
    group_placement_view.placement_type,\
    group_placement_view.display_name,\
    metrics.average_cpm\
 FROM group_placement_view\
 WHERE\
    group_placement_view.placement_type IN ("YOUTUBE_CHANNEL")\
    AND campaign.advertising_channel_type = "VIDEO"\
    AND segments.date BETWEEN "'+ fromDate.query_date + '" AND "' + toDate.query_date + '"\
    AND metrics.impressions >= 100\
    AND metrics.average_cpm > 1000000'

IIUC 它按天对数据进行分段。正确的？ segments.date

但 metrics.impressions >= 100 涉及整个时段的聚合数据。正确的？

Answer 1

不，metrics.impressions >= 100 与每个单独的行相关，而不是聚合数据。