google-analytics - 如何减少 API 调用次数(Google Analytics API)

Question

我正在创建一个网站仪表板供我公司内部使用。我们办公室有一个电视屏幕，我想显示我们最受欢迎的 8 个网站的一些统计数据。它应该包含每个站点上周用户/ session 的 8 个图表。我还想显示每个站点的事件用户。

我设法想出了一个脚本并(在一些帮助下)编写了一个函数，因此我可以通过更改相应属性的 View ID 轻松调用不同的站点，而不是复制相同的代码八次。

我面临的问题是“配额错误:超出用户速率限制”。由于 8 个站点，控制台出现错误。使用 2 或 3 可以正常工作，但 8 似乎太多了。我已经提高了每位用户每 100 秒的请求数。也1000。

有什么办法可以通过重写我的一些代码来减少 API 调用的数量？还是有另一种方法来实现这种仪表板之类的东西？

`

   <div class="container-fluid">
    <div class="row">
        <div id="auth-button"></div>
        <div class="col-lg-4 dashitem">
            <h1>name</h1>
            <figure class="Chartjs-figure" id="-container"></figure>
            <ol class="Chartjs-legend" id="legend-1-container"></ol>
            <div id="active-users-container1"></div>
        </div>
        <div class="col-lg-4 dashitem">
            <h1>name</h1>
            <figure class="Chartjs-figure" id="[name]-container"></figure>
            <ol class="Chartjs-legend" id="legend-2-container"></ol>
            <div id="active-users-container2"></div>
        </div>
        <div class="col-lg-4 dashitem">
            <h1>name</h1>
            <figure class="Chartjs-figure" id="[name]-container"></figure>
            <ol class="Chartjs-legend" id="legend-3-container"></ol>
            <div id="active-users-container3"></div>
        </div>
        <div class="col-lg-4 dashitem">
            <h1>name</h1>
            <figure class="Chartjs-figure" id="[name]-container"></figure>
            <ol class="Chartjs-legend" id="legend-4-container"></ol>
            <div id="active-users-container4"></div>
        </div>
        <div class="col-lg-4 dashitem">
            <h1>name</h1>
            <figure class="Chartjs-figure" id="[name]-container"></figure>
            <ol class="Chartjs-legend" id="legend-5-container"></ol>
            <div id="active-users-container5"></div>
        </div>
        <div class="col-lg-4 dashitem">
            <h1>name</h1>
            <figure class="Chartjs-figure" id="[name]-container"></figure>
            <ol class="Chartjs-legend" id="legend-6-container"></ol>
            <div id="active-users-container6"></div>
        </div>
        <div class="col-lg-4 dashitem">
            <h1>name</h1>
            <figure class="Chartjs-figure" id="[name]-container"></figure>
            <ol class="Chartjs-legend" id="legend-7-container"></ol>
            <div id="active-users-container7"></div>
        </div>
        <div class="col-lg-4 dashitem">
            <h1>name</h1>
            <figure class="Chartjs-figure" id="[name]-container"></figure>
            <ol class="Chartjs-legend" id="legend-8-container"></ol>
            <div id="active-users-container8"></div>
        </div>
    </div>

</div>


{literal}

<script>
gapi.analytics.ready(function() {

  var CLIENT_ID = '[client-id]';

  gapi.analytics.auth.authorize({
    container: 'auth-button',
    clientid: CLIENT_ID,
    userInfoLabel:""
  });


  gapi.analytics.auth.on('success', function(response) {
    //hide the auth-button
    document.querySelector("#auth-button").style.display='none';
  });

  function renderIndividualChart(id, chartId, legendId, activeUsersId) {

    // Adjust `now` to experiment with different days, for testing only...
    var now = moment(); // .subtract(3, 'day');

    var thisWeek = query({
      'ids': "ga:" + id,
      'dimensions': 'ga:date,ga:nthDay',
      'metrics': 'ga:users',
      'start-date': moment(now).subtract(1, 'day').day(0).format('YYYY-MM-DD'),
      'end-date': moment(now).format('YYYY-MM-DD')
    });

    var lastWeek = query({
      'ids': "ga:" + id,
      'dimensions': 'ga:date,ga:nthDay',
      'metrics': 'ga:users',
      'start-date': moment(now).subtract(1, 'day').day(0).subtract(1, 'week')
          .format('YYYY-MM-DD'),
      'end-date': moment(now).subtract(1, 'day').day(6).subtract(1, 'week')
          .format('YYYY-MM-DD')
    });

    Promise.all([thisWeek, lastWeek]).then(function(results) {

      var data1 = results[0].rows.map(function(row) { return +row[2]; });
      var data2 = results[1].rows.map(function(row) { return +row[2]; });
      var labels = results[1].rows.map(function(row) { return +row[0]; });

      labels = labels.map(function(label) {
        return moment(label, 'YYYYMMDD').format('ddd');
      });

      var data = {
        labels : labels,
        datasets : [
          {
            label: 'Vorige Week',
            fillColor : 'rgba(220,220,220,0.5)',
            strokeColor : 'rgba(220,220,220,1)',
            pointColor : 'rgba(220,220,220,1)',
            pointStrokeColor : '#fff',
            data : data2
          },
          {
            label: 'Deze Week',
            fillColor : 'rgba(151,187,205,0.5)',
            strokeColor : 'rgba(151,187,205,1)',
            pointColor : 'rgba(151,187,205,1)',
            pointStrokeColor : '#fff',
            data : data1
          }
        ]
      };

      new Chart(makeCanvas(chartId)).Line(data);
      generateLegend(legendId, data.datasets);
    });

    var activeUsers = new gapi.analytics.ext.ActiveUsers({
      ids: "ga:" + id,
      container: activeUsersId,
      pollingInterval: 5
    });

    //activeUsers.execute();
  }

  function query(params) {
    return new Promise(function(resolve, reject) {
      var data = new gapi.analytics.report.Data({query: params});
      data.once('success', function(response) { resolve(response); })
          .once('error', function(response) { reject(response); })
          .execute();
    });
  }

  function makeCanvas(id) {
    var container = document.getElementById(id);
    var canvas = document.createElement('canvas');
    var ctx = canvas.getContext('2d');

    container.innerHTML = '';
    canvas.width = container.offsetWidth;
    canvas.height = container.offsetHeight;
    container.appendChild(canvas);

    return ctx;
  }

  function generateLegend(id, items) {
    var legend = document.getElementById(id);
    legend.innerHTML = items.map(function(item) {
      var color = item.color || item.fillColor;
      var label = item.label;
      return '<li><i style="background:' + color + '"></i>' +
          escapeHtml(label) + '</li>';
    }).join('');
  }

  // Set some global Chart.js defaults.
  Chart.defaults.global.animationSteps = 60;
  Chart.defaults.global.animationEasing = 'easeInOutQuart';
  Chart.defaults.global.responsive = true;
  Chart.defaults.global.maintainAspectRatio = false;

  function escapeHtml(str) {
    var div = document.createElement('div');
    div.appendChild(document.createTextNode(str));
    return div.innerHTML;
  }


renderIndividualChart(xxx9412, '[name]-container', 'legend-1-container', 'active-users-container1');
renderIndividualChart(xxx11510, '[name]-container', 'legend-2-container', 'active-users-container2');
renderIndividualChart(xxx8011, '[name]-container', 'legend-3-container', 'active-users-container3');
renderIndividualChart(xxx4711, '[name]-container', 'legend-4-container', 'active-users-container4');
renderIndividualChart(xxx4009, '[name]-container', 'legend-5-container', 'active-users-container5');
renderIndividualChart(xxx61037, '[name]-container', 'legend-6-container', 'active-users-container6');
renderIndividualChart(xxx0969, '[name]-container', 'legend-7-container', 'active-users-container7');
renderIndividualChart(xxx5362, '[name]-container', 'legend-8-container', 'active-users-container8');

});
</script>

`

Answer 1

我猜你超过了每个 IP 地址的 10QPS 限制。由于您一次发送大约 16 (8 * 2) 个调用，请参阅 General Quota limits .

请注意，每天的调用次数 (50,000) 和每个 Analytics View (10,000) 以及每个 View 的并发请求数 (10) 也有限制。

我认为最简单的做法是一个接一个地链接调用，而不是一次触发所有调用。根据 RPC 的速度，您可能仍会遇到 qps 限制。更好的做法是对 GA 数据调用添加速率限制，并使用 exponential backoff 添加一些重试逻辑。关于配额错误。