如何在Google Analytics（分析）数据API中使用Google Apps脚本中的滤波器表达

Question

我正在尝试使用新的Google Analytics Data API从GA4属性中获取一些非常简单的数据并进入电子表格。

这一切都很好。

但是，我现在想应用一些尺寸过滤器，以便它仅返回那些匹配过滤器的行。

这是我添加的代码，但我认为格式是错误的。

const dimensionfilter = AnalyticsData.newFilterExpression();
dimensionfilter.filter.fieldName = 'pageTitle';
dimensionfilter.filter.stringFilter.value = 'MYPAGETITLETEXT';

应用程序脚本中没有添加DimensionFilter等的示例，

有人做到了吗？有人有任何非常简单的例子吗？

非常感谢。

这是我的完整代码

   function runReport() {
  const propertyId = '29045017783';

  try {
    const metric = AnalyticsData.newMetric();
    metric.name = 'screenPageViews';


    const pagetitle = AnalyticsData.newDimension();
    pagetitle.name = 'pageTitle';

    const pagepath = AnalyticsData.newDimension();
    pagepath.name = 'pagePath';

    const dateRange = AnalyticsData.newDateRange();
    dateRange.startDate = '2022-05-01';
    dateRange.endDate = 'today';


    const dimensionfilter = AnalyticsData.newFilterExpression();
    dimensionfilter.filter.fieldName = 'pageTitle';
    dimensionfilter.filter.stringFilter.value = 'MYPAGETITLETEXT';


   

    const request = AnalyticsData.newRunReportRequest();
    request.dimensions = [pagetitle, pagepath];
    request.metrics = [metric];
    request.dateRanges = dateRange;
    request.limit=10;
    request.dimensionFilter = dimensionfilter;

    const report = AnalyticsData.Properties.runReport(request,'properties/' + propertyId);

    if (!report.rows) {
      Logger.log('No rows returned.');
      return;
    }

    const spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
    const sheet = spreadsheet.getActiveSheet();

    // Append the headers.
    const dimensionHeaders = report.dimensionHeaders.map(
        (dimensionHeader) => {
          return dimensionHeader.name;
        });
    const metricHeaders = report.metricHeaders.map(
        (metricHeader) => {
          return metricHeader.name;
        });
    const headers = [...dimensionHeaders, ...metricHeaders];

    sheet.appendRow(headers);

    // Append the results.
    const rows = report.rows.map((row) => {
      const dimensionValues = row.dimensionValues.map(
          (dimensionValue) => {
            return dimensionValue.value;
          });
      const metricValues = row.metricValues.map(
          (metricValues) => {
            return metricValues.value;
          });
      return [...dimensionValues, ...metricValues];
    });

    sheet.getRange(2, 1, report.rows.length, headers.length)
        .setValues(rows);

    Logger.log('Report spreadsheet created: %s',
        spreadsheet.getUrl());
  } catch (e) {
    // TODO (Developer) - Handle exception
    Logger.log('Failed with error: %s', e.error);
  }
}

Answer 1

这是您可以应用维度过滤器

const dimensionfilter = AnalyticsData.newFilterExpression()
dimensionfilter.filter = AnalyticsData.newFilter()
dimensionfilter.filter.fieldName = 'pageTitle'
dimensionfilter.filter.stringFilter = AnalyticsData.newStringFilter()
dimensionfilter.filter.stringFilter.value = 'MYPAGETITLETEXT'

编辑的方式：对于多个过滤器，

将多个过滤器与或条件相结合，

const pageTitles = [
  'MYPAGETITLETEXT1',
  'MYPAGETITLETEXT2'
]

const dimensionfilter = AnalyticsData.newFilterExpression()
dimensionfilter.orGroup = AnalyticsData.newFilterExpressionList()
dimensionfilter.orGroup.expressions = []

for (const pageTitle of pageTitles) {
  const filterExpression = AnalyticsData.newFilterExpression()
  filterExpression.filter = AnalyticsData.newFilter()
  filterExpression.filter.fieldName = 'pageTitle'
  filterExpression.filter.stringFilter = AnalyticsData.newStringFilter()
  filterExpression.filter.stringFilter.value = pageTitle
  dimensionfilter.orGroup.expressions.push(filterExpression)
}

您可以参考此文档以了解如何确定方法签名

Answer 2

我一直在努力算出如何添加过滤器，所以感谢此。我想添加一个排除过滤器，以过滤一些国家垃圾邮件！我以为使用GA4，我们过去是分析中的垃圾邮件。

const dimensionfilter = AnalyticsData.newFilterExpression()
dimensionfilter.notExpression = AnalyticsData.newFilterExpressionList()
const filterExpression = AnalyticsData.newFilterExpression()
filterExpression.filter = AnalyticsData.newFilter()
filterExpression.filter.fieldName = 'country'
filterExpression.filter.stringFilter = AnalyticsData.newStringFilter()
filterExpression.filter.stringFilter.value = 'Germany';
dimensionfilter.notExpression = filterExpression;