IT博客汇
  • 首页
  • 精华
  • 技术
  • 设计
  • 资讯
  • 扯淡
  • 权利声明
  • 登录 注册

    通过API获取超过一万行数据

    肖庆的博客发表于 2011-03-30 00:00:00
    love 0

    通过API可以获取超过一万行数据,你知道吗?(译者注:自定义Google Analytics报告中导出数据的多少)
    以下来自谷歌分析官方博客,编程代码什么的,太专业了,不太懂,专业的谷歌分析师请点击查看相关代码吧。

    Auto-Pagination through the API
     

    通过API自动分页
    Here is a quick overview on how to do auto-pagination with our API. You might also follow along by checking the fully working sample code in Python which you can use in your own applications.

    The following sample query fetches the first 10,000 keywords by conversion rate for the month of February:

    https://www.google.com/analytics/feeds/data

    ?ids=ga:12345
    &dimensions;=ga:keywords
    &metrics;=ga:conversionRateAll
    &sort;=-ga:conversionRateAll
    &start-date;=2011-02-01
    &end-date;=2011-02-28
    &start-index;=1
    &max-results;=10000

    Notice how start-index is set to 1 and max-results is set to 10,000. When this query is issued to the API, the API will return up to 10,000 results. The API also returns the number rows found in Google Analytics in the openSearch:totalResult XML element

    14,654

    To get the total number of pages in this request, we can use the following python code:

    num_pages = math.ceil(total_results / 10000)

    Then getting the start-index for each additional page is trivial:

    for page_number in range(num_pages)[1:]: # skips the first page.
    start_index_for_page = page_number * 10000 + 1

    Thats it! If you want to start doing this today, or just see how it should work, we’ve included a fully working example. If you liked this, and want to see more example, let us know what we should do next in our comments.

    Posted by Nick Mihailovski, Google Analytics Team


沪ICP备19023445号-2号
友情链接