Hi everyone :slight_smile: We’d like to have these 2 reports set up, but I’d like to know if it’s possible, and if you can shed some light on how to better achieve them: A report with an explorer table listing all video names + click urls, ordered by number of unique plays, and counting how event…

As you showed the example in Google Spreadsheets, I realised that there is Piwik PRO Google Sheets integration that one could use. I made a video showing how to proceed, I hope it will be helpful for you :slight_smile: [How to create Video Events report from Piwik PRO raw data in Google She…

[image] Elena_Benito_Ruiz: click urls Hi @Elena_Benito_Ruiz , Could you elaborate on what you mean by click urls here?

Hi @Elena_Benito_Ruiz - I understand you’re looking for something like this? [CleanShot 2024-02-20 at 00.47.53] I don’t think it would be achievable in Piwik itself as basically only ways to get your “own columns” is to have additional counter as a goal, and then making it a calculated metric. Ap…

hi @anthonybartczak the page url actually, where the video is embedded and played :slight_smile:

@gonerator @anthonybartczak It would be great to have a report like this: THANK YOU

@gonerator sums it up pretty nicely, it’s not possible as of now unless you use one of the suggested solutions (additionally counting goals, using a BI tool or a different report structure). It’s pretty much the same case for: [image] Page scroll report: How to achieve this? Reports…

This is absolutely fantastic @gonerator :slight_smile: Thanks a lot I have a few questions for you or anyone who might want to answer :slight_smile: Can we leave the due date empty so it always picks data until today? or can this run automatically so it update data monthly, for instance? I’ve not…

@Elena_Benito_Ruiz please find my answers below :slight_smile: ad 1. Unfortunately the UI of GSheets integration doesn’t allow to leave field empty for such a purpose, nor relative date is implemented there HTTP API — Piwik PRO Analytics Suite 18.11 documentation Also, a new sheet in the spreadshe…

Hola @gonerator :slight_smile: dzien dobry! ad 1: it’s really a bummer there’s no way to keep such video report (or any report for this matter) refreshening automatically or something similar. So it’ll be manual input/action. OK. I used to have almost everything on Looker when I was on GA4, so GA…

edit @gonerator On piwik I do see we have progress 50, progress 75…and there are more plays than pauses/resumes [Captura de pantalla 2024-02-26 a las 16.52.13] [Captura de pantalla 2024-02-26 a las 16.55.31]

@anthonybartczak do you happen to know why when I use the piwik → sheets, I can only see data for Progress _25 for Video Youtube and rest of custom events are not appearing? however on Piwik’s tool I do? [Captura de pantalla 2024-02-26 a las 17.11.25]

Video plays: How would you create this report?

Reports and working with data

anthonybartczak February 19, 2024, 10:19am 2

Hi @Elena_Benito_Ruiz,

Could you elaborate on what you mean by click urls here?

Youtube Video Reports: Unique plays, sessions, click url

Topic		Replies	Views
Page scroll report: How to achieve this? Reports and working with data	7	305	February 23, 2024
Youtube Video Reports: Unique plays, sessions, click url Reports and working with data	4	1227	February 21, 2024
Questions about Piwik Pro analytics/report-query endpoint API & integrations	1	14	January 19, 2026
Querying Analytics Data API & integrations	3	740	April 25, 2023
Segments with "Sessions in which Page X was viewed" do not seem to be possible? Reports and working with data	20	1518	March 30, 2026

Video plays: How would you create this report?

Related topics