{bear} Last Access Counts
Closed, ResolvedPublic
Actions

Assigned To

None

Authored By

	• kevinator
	Feb 5 2015, 2:12 AM

Description

Objective: Implement a means to count unique clients using a last-access cookie
Key Result: Validated and up-to-date data is available internally

Per our 2015 Jan-March goal https://www.mediawiki.org/wiki/Wikimedia_Engineering/2014-15_Goals#Analytics

Implement using "Last Access" time stamp on client side and count in Varnish. Unique identifiers will not be used for this report.

Related Objects
Search...

Status	Assigned	Task
Resolved	None	T88647 {bear} Last Access Counts
Resolved	• Nuria	T88812 WMF has technical documentation on UC by last visited date [5 pts] {bear}
Declined	• kevinator	T88813 Implement Last-Access cookie [34 pts] {bear}
Resolved	• kevinator	T92435 Code changes in VCL to add a Last-Access cookie to track "top domain" uniques [13 pts] {bear}
Resolved	• madhuvishy	T92977 Implement Unique Devices report on cluster using x-analytics header & last access date {bear} [13 pts]
Resolved	JAllemandou	T89396 Add x_analytics map to refined tables {hawk}
Resolved	JAllemandou	T91793 Add user_agent map to refined tables {hawk}
Duplicate	None	T88814 WMF has report of monthly UCs by project [13 pts] {bear}
Resolved	• madhuvishy	T101465 Validate Uniques using Last Access cookie {bear} [89 pts]
Resolved	None	T103376 Deploy oozie reporting of last-access counts {bear}
Resolved	• madhuvishy	T112010 Document work so far on Last access uniques and validating the numbers {bear} [8 pts]
Resolved	• Nuria	T115350 Research whether no cookie header numbers improve Last access uniques {bear} [13 pts]
Resolved	• Nuria	T119653 Estimate number of users (or requests) that have cookies off (due to fresh session or incognito mode) [3 pts]
Resolved	• Nuria	T121534 Peer review (with research) of methodology of last access calculations

Event Timeline

• kevinator created this task.Feb 5 2015, 2:12 AM

• kevinator raised the priority of this task from to High.

• kevinator updated the task description. (Show Details)

• kevinator added projects: Analytics-Kanban, Analytics-Clusters.

• kevinator subscribed.

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptFeb 5 2015, 2:12 AM

• kevinator added subtasks: T88812: WMF has technical documentation on UC by last visited date [5 pts] {bear}, T88813: Implement Last-Access cookie [34 pts] {bear}, T88814: WMF has report of monthly UCs by project [13 pts] {bear}.Feb 6 2015, 7:16 PM

• tstarling mentioned this in T88813: Implement Last-Access cookie [34 pts] {bear}.Feb 13 2015, 1:12 AM

Eloquence added a project: Epic.Feb 18 2015, 8:05 AM

Eloquence set Security to None.

• Nuria closed subtask T88812: WMF has technical documentation on UC by last visited date [5 pts] {bear} as Resolved.Mar 2 2015, 4:44 PM

Not that we are just going to try to implement "monthly" cookies on 1st phase, not daily.

• kevinator added a subtask: T92977: Implement Unique Devices report on cluster using x-analytics header & last access date {bear} [13 pts].Mar 19 2015, 6:31 PM

• kevinator updated the task description. (Show Details)Mar 19 2015, 9:41 PM

Update: since Nuria's last comment: we found a way to count both monthly and daily uniques by putting year-month-day in the cookie, sending that in the x-analytics header. see details here: https://wikitech.wikimedia.org/wiki/Analytics/Unique_clients/Last_access_solution

• kevinator closed subtask T88813: Implement Last-Access cookie [34 pts] {bear} as Declined.Apr 27 2015, 4:47 PM

• kevinator added a subtask: T101465: Validate Uniques using Last Access cookie {bear} [89 pts].Jun 4 2015, 11:31 PM

• kevinator moved this task from Next Up to Parent Tasks on the Analytics-Kanban board.Jun 12 2015, 5:44 AM

• kevinator renamed this task from {epic} WMF has UC report per project per month & day {bear} to {bear} Last Access Counts.Jun 12 2015, 6:13 AM

• kevinator updated the task description. (Show Details)

• MZMcBride subscribed.Jun 15 2015, 2:33 PM

• kevinator closed subtask T92977: Implement Unique Devices report on cluster using x-analytics header & last access date {bear} [13 pts] as Resolved.Jun 23 2015, 3:42 PM

• kevinator added a subtask: T112010: Document work so far on Last access uniques and validating the numbers {bear} [8 pts].Sep 17 2015, 2:53 PM

• kevinator closed subtask T112010: Document work so far on Last access uniques and validating the numbers {bear} [8 pts] as Resolved.

• kevinator closed subtask T101465: Validate Uniques using Last Access cookie {bear} [89 pts] as Resolved.Sep 25 2015, 3:33 PM

• kevinator added a subtask: T115350: Research whether no cookie header numbers improve Last access uniques {bear} [13 pts].Oct 29 2015, 9:00 PM

• Nuria closed subtask T115350: Research whether no cookie header numbers improve Last access uniques {bear} [13 pts] as Resolved.Jan 11 2016, 5:20 PM