Goal Tracking: New Report "Days to conversion/purchase" #2031

It would be interesting to know, when a conversion occurs, how many days ago the visitor landed on the website for the first time.

For example:

• 1000 visitors converted to 'Checkout'
• 500 visitors, 0 days to purchase (bought on the first day!)
• 100 visitors, 1 day to purchase (10% took one day to decide)
• 400 visitors, 7 days to purchase (all others took their time, maybe this is something worth money, requires research, etc.)

See comment

see also #583

This is not trivial as "Days since last visit", because we don't know when a conversion last occured on the client side, and this would require a new lookup on the server side, to select the time of last conversion for this visitor.

This would maybe require to implement the 'persistent visitor table' discussed in #1434

Proposed day breakdown similar to GA (which I think is relevant here):

Number of days until conversion
0
1
2
3
4
5
6
7
8-14
15-30
31-60
60-120
121-365
365+

(In [5378]) Fixes #584, #536, #2031 - Kuddos to Benaka akka capedfuzz for this great patch!!! I did a few minor modifications in wording and metadata output

• Add Report "Visits by visit number" under Visitors > Engagement
• Add Report for all Goals (including ecommerce): "Visit until Conversion": number of visits until the conversion occured
• Add Report for all Goals (including ecommerce): "Days until Conversion": days since the first visit

Notes

• These new reports are also in the Metadata API so should be displayed in Piwik Mobile, and can be exported in the Scheduled reports.
• filter_only_idgoal now renamed as idGoal for consistency
• refactored the "Beautify labels" for ranges in generic filters
• refactored archiving code to process multiple reports in one generic SQL query

(In [5428]) Refs #583, #584, #2031

Fixed bug with ranges that, for some new range reports, caused certain visits to not be counted. This fix will cause a cosmetic change in the two older reports in the VisitorInterest plugin (the 'visits per duration' & 'visits per actions' reports).

(In [5509]) Refs #584, #2031. Fixed small bug that caused the 'days to conversion' and 'visits to conversion' reports not to show for the Goals Overview.

Milestone 1.8.x Piwik 1.8.x deleted