View data as a textual table

[yol]

Analytics data is often presented in different forms on the user side, e.g. for marketing purposes. For this, it would be quite useful to be able to get aggregated data out of GoatCounter in some fashion - basically this would mean an export of the dashboard (at least the pages section) to CSV or displaying it as plain HTML table, so you can easily copy it to a spreadsheet program.

I'm aware of the export functionality concerning the raw data, but I think it's not useful for marketing and the like because you'd have to recalculate all the numbers.

[arp242]

This is essentially the same as #233 (Feature: Dashboard API) with the same problem: providing a vaguely stable API/export is quite time-consuming and limits what I can change.

For exporting the pageviews that's worth it, as it's important that people are able to get at their data somehow, but for the aggregated data it's a bit less important.

Like the API, it's something that I'd like to do, but probably not in the coming weeks. Think months. I certainly want to do The Big Database Refactor™ first which will change quite a few things in the DB schema (which is how it should have been done in the first place in hindsight).

[KarellenX]

In Google Analytics, they used a simple list view, where I could highlight the rows on the page, copy and paste into excel spreadsheet. That worked quite well for my purposes. As I mentioned in another issue report, if a clean text list view was available, I would not mind the copy/paste method.

[arp242]

I rather like the idea of adding a simple tabular text view; it'll make it easier to copy text (in to e.g. Excel), improve things for people with screen readers, some people might prefer it, and it's not too hard to add. I've changed the issue and focus on that.

I made a quick test:

Still need to finish up various things; and I'll see if I can come up with a way to concisely represent the rough distribution of the pageviews in a simple text format (average pagevies? standard deviation? divided in top/mid/upper thirds? Some ASCII art? Not entirely sure yet)

I'm working on like 16 things right now, so I'll put this to the side a bit and finish up what I'm currently working on first 😅

[KarellenX]

Sounds good and I like the look of that layout. Thanks for your time :)

[arp242]

There's now a "view as text table" switch in the top-right; I only did the "Pages" overview as text for now, and will add the others some time later. Maybe I'll add some additional stuff like average pageviews/day or some such too. Let me know if you're missing anything in particular.

[KarellenX]

@arp242

That is perfect. Thank you!!

Right info, line numbers, and copies cleanly into Excel.

If it reduces load, the stats column could be removed as the graphs are not needed (for my use), but it causes no issue otherwise.

Thanks again.