Topic on User talk:Mattflaschen-WMF

Hi Matthew,

I see that you did some work with the Growth team (https://www.mediawiki.org/wiki/Growth), specifically: https://github.com/wikimedia/mediawiki-extensions-GuidedTour/blob/master/extension.json#L4

Here's the thing: I need to reach some data on guided tours for a recent campaign that we've run in WMDE. However, I can't figure out where to look for the data that I need, so I thought it would be the best to reach someone from the Growth team and ask for advise.

Please advise.Regards,

Goran S. Milovanović, PhD

Data Analyst, Software Department

Wikimedia Deutschland

@GoranSM Sure. Basically, you need to set shouldLog to true in the tour (if this is false or omitted, no data will be recorded; example with true is here), then you can get data from the relevant EventLogging schemas. See the list of schemas.

If you're not familiar with accessing EventLogging, you can start here.

The tables have names that are the schema, plus underscore, then the ID. E.g. GuidedTourGuiderImpression_8694395 . So basically:

1. ssh stat1006.eqiad.wmnet
2. mysql --defaults-file=/etc/mysql/conf.d/research-client.cnf -hanalytics-store.eqiad.wmnet log
3. SELECT * FROM GuidedTourGuiderImpression_8694395 LIMIT 1;

If one of the first 2 steps fails, you will need to request access on Phabricator. If you have issues, you can ask here, or in #wikimedia-collaboration (if more GuidedTour-focused) or #wikimedia-analytics (if more EventLogging-focused) on Freenode.

@Mattflaschen-WMFThank you so much. I have access to production and routinely use MariaDB replicas - I work as contractor Data Analyst for WMDE. Your suggestion on how to track the guided tours data:

"... you need to set shouldLog to true in the tour (if this is false or omitted, no data will be recorded; example with true is here)..."

is exactly what I was looking for.

Again: thank you very much!