Maniphest T170792

Please Check Pivot Data on Campaign Banners
Closed, ResolvedPublic
Actions

Assigned To

GoranSMilovanovic

Authored By

	GoranSMilovanovic
	Jul 17 2017, 8:54 AM

Tags

Referenced Files

None

Subscribers

GoranSMilovanovic

• Stefan_Schneider_WMDE

Description

On 07/17/2017, Pivot reports no data points for 07/15/2017 for the following parameter setup:

Filter Date range: from 07/10/2017 to 07/17/2017
Filter Campaign: WMDE_Editor_Summer_2017
Split Banner
Split Date, daily

A reproducible report on this can be obtained from Pivot:

https://pivot.wikimedia.org/#banner_activity_minutely/table/2/EQUQLgxg9AqgKgYWAGgN7APYAdgC5gQAWAhgJYB2KwApgB5YBO1Azs6RpbutnsEwGZVyxALbVeAfQlhSY4AF9kwYhBkdmeANroVazsApU6jFmw55uOfABtSYag2LWqANycBXcV2DMwxBmC8AEwADACMAOwAtCHRYSFwISG4SSkhAHRJIQBaRuQAJsHh0bFRYQAcicmpSZlJuYrAYACeWF7AcACSALIgEgBKAIIAcgDiIAqKOqrs+sQFRvRMrLMWmFYEJIZKxstmnJa8AkKi7RCiWGQA5pSNuqve9+b4GC4O1sQ4O0umD4c2dgcTlcHi86GY1DAcFa7QAynB+p0xkZrNQxOQwBpcJpgAB1boAET6IHydgwDAksPcIjEFNCkWAAF1Gi02rxYSA4JN5PJmchtDQfitnv8+NRBEphHJ8AAjebkBwKJTMclgQYzEXKDX6FUBRYmYUHdZHcUnaXAcjkkROUgAL2o+QkTAAjp5fBIIBh3BilcBSUxtbx8iwINQChQrr7bCI7Oq9Gsnvpo3YqMnArgAKwhHloQUG/ZrHj4Y6S06SaSycSNGXuCAAa0hcb+Wvj+BkYgAQrWG4ElPl3I5W8AAAphAm+3VqwOPac+VX6vbNotiiUWsv4S0Ma22e2Ol1usAer0+xr+6iz4PMUPh8iRxpppuaxO8NOp2QpzM8xnIcjuazWSUrRtXcnWoV0WEPT1vV7HFN23O0HVA8D3Sgn0lH3CCj2gpl+W/X9/yAA===

Also, could you explain the presence of the null value in the Banner split?

Please advise. Thank you.

Regards,

Goran S. Milovanović
Data Analyst, WMDE

Event Timeline

GoranSMilovanovic created this task.Jul 17 2017, 8:54 AM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJul 17 2017, 8:54 AM

• Nuria added a project: Analytics-Data-Quality.Jul 17 2017, 3:49 PM

• Nuria moved this task from Incoming to Dashiki on the Analytics board.

Addendum: as of 07/18/2017, two data points, for 07/15 (already reported here) and 07/16 (reporting on this now) are missing:

https://pivot.wikimedia.org/#banner_activity_minutely/table/2/EQUQLgxg9AqgKgYWAGgN7APYAdgC5gQAWAhgJYB2KwApgB5YBO1Azs6RpbutnsEwGZVyxALbVeAfQlhSY4AF9kwYhBkdmeANroVazsApU6jFmw55uOfABtSYag2LWqANycBXcV2DMwxBmC8AEwADACMAOwAtCHRYSFwISG4SSkhAHRJIQBaRuQAJsHh0bFRYQCcicmpSZlJuYrAYACeWF7AcACSALIgEgBKAIIAcgDiIAqKOqrs+sQFRvRMrLMWmFYEJIZKxstmnJa8AkKi7RCiWGQA5pSNuqve9+b4GC4O1sQ4O0umD4c2dgcTlcHi86GY1DAcFa7QAynB+p0xkZrNQxOQwBpcJpgAB1boAET6IHydgwDAksPcIjEFNCkWAAF1Gi02rxYSA4JN5PJmchtDQfitnv8+NRBEphHJ8AAjebkBwKJTMclgQYzEXKDX6FUBRYmYUHdZHcUnaXAcjkkROUgAL2o+QkTAAjp5fBIIBh3BilcBSUxtbx8iwINQChQrr7bCI7Oq9Gsnvpo3YqMnArgAKwhHloQUG/ZrHj4Y6S06SaSycSNGXuCAAa0hcb+Wvj+BkYgAQrWG4ElPl3I5W8AAAphAm+3VqwOPac+VX6vbNotiiUWsv4S0Ma22e2Ol1usAer0+xr+6iz4PMUPh8iRxpppuaxO8NOp2QpzM8xnIcjuazWSUrRtXcnWoV0WEPT1vV7HFN23O0HVA8D3Sgn0lH3CCj2gpl+W/X9/yAA===

Regards,
Goran

Disregard the task; a constraint was not used properly in my data selection on Pivot.

GoranSMilovanovic closed this task as Resolved.Jul 18 2017, 10:01 PM

GoranSMilovanovic claimed this task.