Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add Loyalty report "Visitors who visited the website 1 time, 2 times, etc." #536

Closed
mattab opened this issue Feb 3, 2009 · 8 comments
Closed
Labels
Enhancement For new feature suggestions that enhance Matomo's capabilities or add a new report, new API etc. Major Indicates the severity or impact or benefit of an issue is much higher than normal but not critical.
Milestone

Comments

@mattab
Copy link
Member

mattab commented Feb 3, 2009

- Loyalty: M people visited N times

See
- [Recency Frequency Monetary](http://en.wikipedia.org/wiki/RFM)
- [I Got No Ecommerce. How Do I Measure Success?](http://www.kaushik.net/avinash/2007/07/i-got-no-ecommerce-how-do-i-measure-success.html)

We probably need to keep track of the count of visits for each visitor in a new table, to be able to tell this stat on more than 1 day range.

@mattab
Copy link
Member Author

mattab commented Jan 17, 2011

Moved Recency report requirement in #583

@mattab
Copy link
Member Author

mattab commented Mar 18, 2011

This is also easy to implement now, because log_visit contains the field piwik_log_visit.visitor_count_visits which is the count of visits. This is set using the first party cookies counter. We can therefore query GROUP by this field and get the report.

The GA breakdown is as follows:

Count of visits from this visitor including current Visits that were the visitor's nth visit Percentage of all visits

Count of visits from this visitor including current     Visits that were the visitor's nth visit
1 times     179,528.00  
2 times     16,412.00   
3 times     6,006.00    
4 times     3,389.00    
5 times     2,371.00    
6 times     1,819.00    
7 times     1,469.00    
8 times     1,236.00    
9-14 times  4,590.00    
15-25 times     3,997.00    
26-50 times     3,880.00    
51-100 times    2,665.00    
101-200 times   958.00  
201+ times  1,481.00    

We can reuse the same breakdown as it is relevant and consistent. See also similar #584, #2031

@diosmosis
Copy link
Member

Got a question about this issue: where would this specific report be placed? Thanks in advance.

@mattab
Copy link
Member Author

mattab commented Sep 25, 2011

where would this specific report be placed?
I would say Visitor > Engagement report page (already built using 2 plugins outputs).

@mattab
Copy link
Member Author

mattab commented Oct 27, 2011

(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

@julienmoumne
Copy link
Member

It seems Visitors > Engagement > "Visits by visit number" column titles are not clickable/sortable, is it by design ?

The other two reports are ok.

@diosmosis
Copy link
Member

I disabled sorting for that report since the other two VisitorInterest reports also disable it. I don't know if this is the desired behavior, but I could make some changes when I submit a patch for #583 (shouldn't be too long now...).

@mattab
Copy link
Member Author

mattab commented Dec 16, 2012

Milestone 1.8.x Piwik 1.8.x deleted

This issue was closed.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Enhancement For new feature suggestions that enhance Matomo's capabilities or add a new report, new API etc. Major Indicates the severity or impact or benefit of an issue is much higher than normal but not critical.
Projects
None yet
Development

No branches or pull requests

3 participants