错误:未知字段metrics.conversions - Google广告脚本帐户汇总报告-添加新列

Question

我想向帐户摘要报告中添加新列：https://developers.google.com/google-ads/scripts/docs/solutions/account-summary

但我搞错了。

'report_fields': [
{'columnName': 'metrics.cost_micros', 'displayName': 'Cost'},
{'columnName': 'metrics.average_cpc', 'displayName': 'Avg. CPC'},
{'columnName': 'metrics.ctr', 'displayName': 'CTR'},
{'columnName': 'metrics.search_impression_share', 'displayName': 'Search Impr. share'},
{'columnName': 'metrics.impressions', 'displayName': 'Impressions'},
{'columnName': 'metrics.clicks', 'displayName': 'Clicks'},
{'columnName': 'metrics.conversions', 'displayName': 'Conversions'},
{'columnName': 'metrics.conversions_value', 'displayName': 'Revenue'},
{'columnName': 'metrics.cost_per_conversion', 'displayName': 'CPA'},
{'columnName': 'metrics.conversions_from_interactions_rate', 'displayName': 'CVR'}

-错误

Error: Unknown field metrics.conversions
    at format (Code:174:13)
    at Code:97:33
    at Array.map (<anonymous>)
    at main (Code:96:55)

Answer 1

链接到的Ads脚本代码包含正确格式化正在下载的不同指标的函数：

function format(column, value) {
  switch (column) {
    case 'metrics.clicks':
    case 'metrics.impressions':
      return value;
    case 'metrics.ctr':
      return formatPercentage(value);
    case 'metrics.average_cpc':
    case 'metrics.cost_micros':
      return formatMicros(value);
    case 'metrics.search_impression_share':
      return formatImpressionShare(value);
    default:
      throw new Error(`Unknown field ${column}`);
  }
}

您会注意到，每个度量都是单独列出的。如果将metrics.conversions添加到正在下载的字段集中，则还需要调整format函数--否则将遇到在default情况下抛出的"Error: Unknown metrics.conversions“异常。

由于metrics.conversions是一个常规数字，所以您只需在顶部添加一个大小写：

function format(column, value) {
  switch (column) {
    case 'metrics.clicks':
    case 'metrics.impressions':
    case 'metrics.conversions':
      return value;
    case 'metrics.ctr':
      return formatPercentage(value);
    case 'metrics.average_cpc':
    case 'metrics.cost_micros':
      return formatMicros(value);
    case 'metrics.search_impression_share':
      return formatImpressionShare(value);
    default:
      throw new Error(`Unknown field ${column}`);
  }
}