Opened 3 years ago

Closed 2 years ago

Last modified 16 months ago

#2031 closed New feature (fixed)

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

Reported by: matt Owned by:
Priority: major Milestone: 1.12.x - Piwik 1.12.x
Component: Core Keywords:
Cc: Sensitive: no

Description

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

Change History (9)

comment:1 Changed 3 years ago by matt (mattab)

see also #583

comment:2 Changed 3 years ago by matt (mattab)

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 http://dev.piwik.org/trac/ticket/1434#comment:11

comment:3 Changed 3 years ago by matt (mattab)

  • Milestone changed from 1.x - Piwik 1.x to 1.3 - Piwik 1.3

comment:4 Changed 3 years ago by matt (mattab)

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+

comment:5 Changed 3 years ago by matt (mattab)

  • Priority changed from normal to major

comment:6 Changed 2 years ago by matt (mattab)

  • Resolution set to fixed
  • Status changed from new to closed

(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

comment:7 Changed 2 years ago by capedfuzz (diosmosis)

(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).

comment:8 Changed 2 years ago by capedfuzz (diosmosis)

(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.

comment:9 Changed 16 months ago by matt (mattab)

  • Milestone changed from 1.8.x Piwik 1.8.x to 1.9.x - Piwik 1.9.x

Milestone 1.8.x Piwik 1.8.x deleted

Note: See TracTickets for help on using tickets.