使用 Google Analytics 管理 API 和应用脚本提取 GA4 媒体资源列表

Question

想知道是否有人使用新的Analytics Admin API将GA帐户和属性列表导出到电子表格中。

过去，我已经将管理API用于此目的，但这将我们限制在UA属性上，我希望在这里还包括GA4属性。

我已经拍摄了将旧脚本转换为新API的镜头，但是我什至没有成功地提取帐户名称。

function listGA4Accounts() {
  var createss = SpreadsheetApp.create("Google Analytics Accounts");
  var ssid = createss.getId();
  var openss = SpreadsheetApp.openById(ssid);
  var insertsheet = openss.insertSheet('Google Analytics Schema');
  insertsheet.setFrozenRows(1);
  insertsheet.getRange("A1:D1").setValues([['displayName', 'Account ID', 'Property Name', 'Property ID']]);
  var sheet = SpreadsheetApp.openById(createss.getId()).getSheetByName("Google Analytics Schema")
  var accounts = AnalyticsAdmin.Accounts.list();
  if (accounts && !accounts.error) {
    accounts = accounts.accounts;
  //  Logger.log(accounts[0]);
    for (var i = 0, account; account = accounts[i]; i++) {
       sheet.appendRow([accounts.accounts[i].displayName]);
    }
  }
}

Answer 1

我也一直在为此苦苦挣扎。以下是我经过大量尝试和错误后得出的结论：

function listAccounts() {
  try {
    accounts = AnalyticsAdmin.AccountSummaries.list();
    //Logger.log(accounts);
    if (!accounts.accountSummaries || !accounts.accountSummaries.length) {
      Logger.log('No accounts found.');
      return;
    }

    Logger.log(accounts.accountSummaries.length + ' accounts found');
    for (let i = 0; i < accounts.accountSummaries.length; i++) {
      const account = accounts.accountSummaries[i];
      Logger.log('** Account: name "%s", displayName "%s".', account.name, account.displayName);

      if (account.propertySummaries) {
        properties = AnalyticsAdmin.Properties.list({filter: 'parent:' + account.account});
        if (properties.properties !== null) {
          for (let j = 0 ; j < properties.properties.length ; j++) {
            var propertyID = properties.properties[j].name.replace('properties/','');
            Logger.log("GA4 Property: " + properties.properties[j].displayName + '(' + propertyID + ')')
          }
        }
      } else {
        var accountID = account.account.replace('accounts/','');
        var webProperties = Analytics.Management.Webproperties.list(accountID);
        for (var j = 0; j < webProperties.items.length; j++) {
          Logger.log("UA Property: " + webProperties.items[j].name + '(' + webProperties.items[j].id  + ')');
          var profiles = Analytics.Management.Profiles.list(accountID, webProperties.items[j].id);
          for (var k = 0; k < profiles.items.length; k++) {
            Logger.log('Profile:' + profiles.items[k].name);
          }
        }
      }
    }
  } catch (e) {
    // TODO (Developer) - Handle exception
    Logger.log('Failed with error: %s', e.error);
  }
}

并不是说这是正确的方法...但它似乎确实能够提取我的所有 UA 和 GA4 属性。

如果您只需要 GA4 媒体资源，则可以省略“if (account.propertySummaries)”上的 else。