Talk:Analytics/Wikistats/Database API

Previous page history was archived for backup purposes at Talk:Analytics/Wikistats/Database API/LQT Archive 1 on 2015-07-10.

comScore also has reach and unique visitor counts for many countries, in a different report. Their regional report only contains 3 major countries. We use data for India for current report card. Instead import all metrics per country? Erik Zachte 15:58, 24 May 2011 (UTC)

 (work in progress)
. "squid_pageviews" :  {
   data: [
       "time_series" : [14,16,72,9034] ,
       "pct_6_growth": 12,
       "pct_12_growth": 36
   ],
   "country_code" : "us",
   "language_code": "en",
   "normalized": "false",
   "modality": "indexed",
   "generated-by":"APICALL",
   "comments": "COMMENT STRING"
}
.
metric=squidpageviews
&month-range = 2008-4;2011-4
&language_code = en
.
metric:  
month range: 2008-4, 2011-4
.
filters:
   project:
   wiki_code: (top_10)
   * region:
   * web-properties:
     country:
     language:
     editors:
     mobile:
normalized:
modailty:
data: time series, pct_growth_series

action=analytics
&metric=[comscore_unique_visitors|comscore_reach_percentage]
&month_range=yyyy-mm;yyyy-mm
&filter=[ region_code=[aa,bb,..|*] | country_code=[aa,bb,..|*|top:10] | web_properties=top:10 ]
&data=[time_series,time_series_cumulative,percentage_growth_last_month,percentage_growth_last_year,percentage_growth_series]
[&lang=en]
&format=[csv,json,text,...]
&modality=[absolute|indexed]
.
action=analytics
&metric=squid_pageviews
&month_range=yyyy-mm;yyyy-mm
&filter=[ (none | ?) region_code=[aa,bb,..|*] | country_code=[aa,bb,..|*|top:10] ] | project_codes=[wb,wn,wk,,...|*] (| wiki_codes=wp:en,wp:de,..|top:10)]
&data=[time_series,percentage_growth_last_month,percentage_growth_last_year,percentage_growth_series]
&mobile=[Y|N|*]
&normalized=[Y|N]
[&lang=en]
&returntype=[csv,json,text,...]
&modality=[absolute|indexed]
.
action=analytics
&metric=[dump_article_count|dump_binary_count|dump_edits|dump_new_registered_editors|dump_active_editors_[5,100]]
&month_range=yyyy-mm;yyyy-mm
&filter=[project_codes=[wb,wn,wk,,...|*] | wiki_codes=wp:en,wp:de,..|top:10]
&data=[time_series(,percentage_growth_last_month,percentage_growth_last_year,percentage_growth_series(?))]
&normalized=[Y|N]
&edits=[[un]registered|*]
[&lang=en]
&returntype=[csv,json,text,...]
&modality=[absolute|indexed]