时间戳

首页 > 解决方案 > 如何将 Google Analytics api 响应放入工作表中？

javascript - 如何将 Google Analytics api 响应放入工作表中？

问题描述

我想将 Google Analytics（分析）再营销受众群体导入电子表格。我从 Google Analytics Management API 获得了响应，但我无法弄清楚如何解析它并将其放入电子表格中。

    function getlists() {
      var ss = SpreadsheetApp.getActiveSheet();
      var acc = XXX;
      var prop = "UA-XXX-1";
      var lists = Analytics.Management.RemarketingAudience.list(acc,prop)
      Logger.log(lists.items)
    }

响应如下：

{kind=analytics#remarketingAudience, created=2016-07-04T16:40:12.601Z, description=Transakcje > 0, webPropertyId=UA-XXX-1, AudienceDefinition={includeConditions={kind=analytics#includeConditions, segment=sessions: :condition::ga:transactions>0，membershipDurationDays=30，isSmartList=false}}，accountId=XXX，linkedViews=[XXX]，name=Google 购物 kupili，id=XXX，audienceType=SIMPLE，更新=2016-07- 04T16:40:49.145Z，internalWebPropertyId=XXX，linkedAdAccounts=[{remarketingAudienceId=XXX，qualifiedForSearch=true，accountId=XXX，linkedAccountId=DELETED，kind=analytics#linkedForeignAccount，id=XXX，type=ADWORDS_LINKS，internalWebPropertyId=XXX，webPropertyId =UA-XXX-1，状态=关闭}]}

我想将此响应放入电子表格中，并在其中进行概述：

Kind | Created | Description | etc.

A | B | C | D

我无法理解如何实现这一目标。

标签： javascriptgoogle-apps-scriptgoogle-sheetsgoogle-analytics-api

解决方案

解决了。

  var items = lists.items;
  var temp = [];
    temp.push(["id","name","kind","IncludeKind","IncludeIsSmart","IncludeSegment","membershipDurationDays"]);

  for(var i=0;i<items.length;i++){
    temp.push([items[i].id,items[i].name,items[i].kind,items[i].audienceDefinition.includeConditions.kind,items[i].audienceDefinition.includeConditions.isSmartList,items[i].audienceDefinition.includeConditions.segment,items[i].audienceDefinition.includeConditions.membershipDurationDays]);
  }

  ss.getRange(1, 1, temp.length, 7).setValues(temp);
`

推荐阅读