Opened 2 years ago

Last modified 13 days ago

#3014 new New feature

Scheduled report: "Referrer Type" could have a graph plotting each referrer type evolution

Reported by: matt Owned by:
Priority: normal Milestone: 2.x - The Great Piwik 2.x Backlog
Component: Core Keywords:
Cc: Sensitive: no

Description

To assess whether a SEO or Social network marketing strategy is working, it would be nice to be able to visualize in the Scheduled Report the Evolution graph plotting the number of visits from Search Engines, Campaigns, direct Websites.

It requires #3013 (Static graphs to support multiple metrics)
But also another feature to plot a same metric from different rows (in the case of Referrer Type, we want to plot nb_visits for each Row of the table, which we know has maximum 4 rows: search,websites,campaigns,direct)

We might be able to re-use the Row evolution API from: #534

Change History (12)

comment:1 Changed 23 months ago by JulienM (JulienMoumne)

  • Owner set to JulienM
  • Status changed from new to assigned

comment:2 Changed 22 months ago by JulienM (JulienMoumne)

Should row evolutions be displayed :

  • only for Referrer Types
  • for all reports with dimensions, or
  • for a specific set of reports. This set could be
    • hard-coded, or
    • defined by the user when creating the scheduled report

comment:3 follow-up: Changed 22 months ago by matt (mattab)

I think we could maybe have a new field in the metadata output "imageGraphShowEvolution" ?

This flag could be set for:

  • Referrer types
  • Mobile vs Desktop
  • Operating system family
  • Browsers by family
  • All Websites dashboard

For these (and maybe others we could add later), the row evolution could be displayed for the top 5 rows?

What do you think?

Alternatively we could also add a new SELECT entry "Display a historical graph for each report" ?

comment:4 in reply to: ↑ 3 ; follow-up: Changed 22 months ago by JulienM (JulienMoumne)

Replying to matt:

I think we could maybe have a new field in the metadata output "imageGraphShowEvolution" ?


I don't think introducing this field adds that much value. We could simply store the list of reports around http://dev.piwik.org/trac/browser/trunk/plugins/ImageGraph/ImageGraph.php#L44. This is the method constructing the imageGraphUrl metadata field.

Adding "imageGraphShowEvolution" would make sense if two modules need it. We can introduce this field when that happens.

If I am missing something please enlighten me.


Alternatively we could also add a new SELECT entry "Display a historical graph for each report" ?


Do you mean a UI element in the report creation form? Would this be a SELECT or a checkbox input?

comment:5 in reply to: ↑ 4 ; follow-up: Changed 22 months ago by matt (mattab)

Replying to JulienM:

Adding "imageGraphShowEvolution" would make sense if two modules need it. We can introduce this field when that happens.

OK

Do you mean a UI element in the report creation form? Would this be a SELECT or a checkbox input?

below the SELECT in (optional) Display options, we could have a radio button

Graphs style: (X) (default) Show Horizontal Bar Graphs
              ( ) Show Historical Graphs for the top 5 values 

what do you think?

comment:6 in reply to: ↑ 5 Changed 22 months ago by JulienM (JulienMoumne)

Replying to matt:

( ) Show Historical Graphs for the top 5 values


For all reports or only for those mentioned in comment:3 ?

comment:7 Changed 22 months ago by matt (mattab)

For all reports that would otherwise have a Horizontal Bar Graph above (depending on what options are selected in the SELECT), when the radio "Historical graph" is selected then there will be ONLY historical graphs

  • (unchanged graphs) the 1 dataset graph for example plotting last visits, or last ecommerce conversions is not changed by this radio button
  • top browsers, keywords, custom var, pages titles, etc. all reports that would normally have had a horizontal bar graph, would then get a historical lines graph for the top 5 values

does it sound like a good idea?

comment:8 Changed 20 months ago by JulienM (JulienMoumne)

(In [6918]) refs #3013

  • plot multiple metrics using $columns (renamed from $column)
  • plot row evolutions using optional $labels, will plot top 5 labels when omitted
  • imageGraphEvolutionUrl added to report metadata (only for reports without constant row count and Referers.getRefererType)
  • $showMetricTitle renamed to $showLegend

refs #3014

  • new report parameter 'Show Historical Graphs for the top 5 values'
  • better looking evolution graph on landcape pages

refs #3158

  • $label is now optional, will return top N=filter_limit row evolutions sorted with filter_sort_column when omitted
  • support for $idGoal
  • integration tests updated

constantRowsCount set on

  • Goals_getDaysToConversion
  • Goals_getVisitsUntilConversion
  • Referers_getRefererType

merges

IDEA

  • in Piwik UI, add a link 'display top 10 row evolutions' using API.getRowEvolution &label=false&filter_sort_column=xyz&filter_limit=10


TODO

  • fix scheduled report integration tests
  • review @reviews

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

  • Milestone changed from Feature requests to 1.9.2 - Piwik 1.9.2
  • Status changed from assigned to new

Julien has done most work on this already, it's going to be awesome. We also should include this graph in Piwik Mobile of course.

comment:10 Changed 13 months ago by matt (mattab)

  • Milestone changed from 1.12 - The Great 1.x Backlog to 2.x - Piwik 2.x

comment:11 Changed 2 months ago by matt (mattab)

  • Owner JulienM deleted

Removing owner from tickets. from now on, I suggest we assign tickets to ourselves for cases when we we plan to actively work on them in the coming days/weeks. let's discuss if needed during our team call.

comment:12 Changed 13 days ago by matt (mattab)

  • Priority changed from major to normal
Note: See TracTickets for help on using tickets.