Marketing

I'm trying to get some stats, but Matomo is unusably slow... I've spoken to Guilhem who says:

I believe the current slowness is caused by historic download logs imports. The database has grown a lot, and I temporarily deactivated removal/archival of log data, so it has to navigate through a gigantic table when you query aggregated metrics. Sorry for the inconvenience. I believe it'll be back to normal once the (veeery slow) old log import process is over and the `log_visit` table has been purged.

Is Matomo more responsive again? :)

Florian Effenberger wrote:

Is Matomo more responsive again? :)

Nope, it still won't load. Guilhem says there's no ETA for the log import process.

Florian Effenberger wrote:

Any update on the situation?

Unfortunately not -- Matomo is still unusably slow. I've been trying to generate one week of statistics for over 10 minutes now, and nothing. I'll ping Guilhem again to see if there's anything coming in the future, but otherwise this is stuck.

So it's still hard to get long-term data from Matomo, but I can look at individual days. Let's take one example: the "Get involved" page at https://www.libreoffice.org/community/get-involved/

Visits on Monday 23 September from the infobar in LibreOffice: 1126

And where do people go?

Internal pages

• 26% to download
• 25% to the front page
• 16% to the developer page
• 7% to the localisation page
• 5% to the donate page
• 19% elsewhere

External pages

• 33% to Ask LibreOffice
• 18% to the design page on the wiki
• 12% to "What can I do for LibreOffice" site
• 6% to the FAQ on the wiki
• 6% to https://documentation.libreoffice.org/en/english-documentation/

So we can see that the "Get involved" infobar in the app is having some effect, bringing over 1000 people a day to the page, and then some people are going on to look in more detail at the development, localisation, design and documentation projects.

Meanwhile, there's also a "Donate" infobar in LibreOffice 6.2, which shows six months after installation (so for those who installed it in February, they're seeing it now). We get around 40 - 50 visits to our donate page from that infobar, which isn't huge, but we can assume those people are more likely to donate, given that:

1. they've already clicked on the Donate button in the app
2. they've already been using LibreOffice for six months, so they should see the value in it (as opposed to first-time downloaders)

I'll share the "Get involved" stats with the marketing list now, and we can present an updated version of these stats to the Board at FOSDEM. Otherwise, should we close the ticket?