Page MenuHomePhabricator

chelsyx (Chelsy Xie)
User

Today

  • Clear sailing ahead.

Tomorrow

  • Clear sailing ahead.

Wednesday

  • Clear sailing ahead.

User Details

User Since
Aug 9 2016, 7:00 PM (140 w, 5 d)
Availability
Available
LDAP User
Unknown
MediaWiki User
CXie (WMF) [ Global Accounts ]

Recent Activity

Wed, Apr 17

chelsyx closed T218838: Add ExternalGuidance event logging table to whitelist as Resolved.

Thanks everyone!

Wed, Apr 17, 4:56 PM · Patch-For-Review, Analytics, Product-Analytics
chelsyx closed T218838: Add ExternalGuidance event logging table to whitelist, a subtask of T212414: Measure the impact of externally-originated contributions, as Resolved.
Wed, Apr 17, 4:56 PM · MW-1.33-notes (1.33.0-wmf.18; 2019-02-19), Analytics, Patch-For-Review, Product-Analytics, ExternalGuidance
chelsyx closed T203723: As a product analyst I would like to know how people are using the Wikidata Descriptions editing features, a subtask of T193691: As a user of the Wikipedia app, I would like to be able to add or edit title descriptions from the app (eg. Wikidata descriptions), as Resolved.
Wed, Apr 17, 12:53 AM · Wikidata, Audiences-QA, iOS-app-v6.1-Narwhal-On-A-Bumper-Car, Epic, Wikipedia-iOS-App-Backlog
chelsyx closed T203723: As a product analyst I would like to know how people are using the Wikidata Descriptions editing features as Resolved.

T210970 is resolved and here is the answer for these questions:

Wed, Apr 17, 12:53 AM · Product-Analytics, Wikipedia-iOS-App-Backlog
chelsyx added a comment to T218169: Measure the impact of the wikitext editing tools on the iOS app.

Done. Please see the results at: https://docs.google.com/presentation/d/1JBs_XyGKdYERpYR0BjMOEjf6N_WINh2pUTJtHcn6L6c/edit?usp=sharing

Wed, Apr 17, 12:39 AM · Wikipedia-iOS-App-Backlog, Product-Analytics

Tue, Apr 16

chelsyx added a comment to T220236: [REQUEST] Top 150 pageviews in India.

Glad to hear that @AMuigai !

Tue, Apr 16, 8:55 PM · Product-Analytics
chelsyx closed T220236: [REQUEST] Top 150 pageviews in India as Resolved.
Tue, Apr 16, 8:54 PM · Product-Analytics

Fri, Apr 12

chelsyx triaged T220837: Prepare presentation for the Wiki workshop at the Web Conference 2019 as Normal priority.
Fri, Apr 12, 4:49 PM · Product-Analytics
chelsyx created T220837: Prepare presentation for the Wiki workshop at the Web Conference 2019.
Fri, Apr 12, 4:48 PM · Product-Analytics

Tue, Apr 9

chelsyx moved T220236: [REQUEST] Top 150 pageviews in India from Triage to Doing on the Product-Analytics board.

Hi @AMuigai , I put all the page ID, title, and pageviews in this google sheet: https://docs.google.com/spreadsheets/d/1keehVBs8Z3tyHfRn_N7ocdsl3Me5FaB6-OaT-tMy31g/edit?usp=sharing
Please let me know if you have any questions.

Tue, Apr 9, 4:27 AM · Product-Analytics

Fri, Apr 5

chelsyx raised the priority of T219660: Figure out the topic of articles translated automatically by external translation service from Low to Normal.
Fri, Apr 5, 7:10 PM · ExternalGuidance, Product-Analytics

Thu, Apr 4

chelsyx moved T203723: As a product analyst I would like to know how people are using the Wikidata Descriptions editing features from Next Up to Doing on the Product-Analytics board.
Thu, Apr 4, 5:07 PM · Product-Analytics, Wikipedia-iOS-App-Backlog
chelsyx moved T218169: Measure the impact of the wikitext editing tools on the iOS app from Next Up to Doing on the Product-Analytics board.
Thu, Apr 4, 5:07 PM · Wikipedia-iOS-App-Backlog, Product-Analytics
chelsyx moved T218931: Tack usage of editing toolbar elements from Triage to Backlog on the Product-Analytics board.
Thu, Apr 4, 5:07 PM · Product-Analytics, Wikipedia-iOS-App-Backlog, iOS-app-v6.3-Lobster-On-A-Motorcycle

Wed, Apr 3

chelsyx added a comment to T215995: Analysis of long term impact of Mexico campaign to eswiki traffic.

Hi @atgo , the report is uploaded on https://wikimedia-research.github.io/Audiences-New_Readers-Spanish_Video_Campaign-Nov_2018/
Please let me know if you have any question, and feel free to schedule a meeting if you want me to walk you through it.

Wed, Apr 3, 10:43 PM · New-Readers, Product-Analytics

Tue, Apr 2

chelsyx added a comment to T215995: Analysis of long term impact of Mexico campaign to eswiki traffic.

@atgo Sorry for the delay! I'm wrapping up the report today.

Tue, Apr 2, 4:57 PM · New-Readers, Product-Analytics

Mon, Apr 1

chelsyx renamed T219660: Figure out the topic of articles translated automatically by external translation service from Model the topic of articles translated automatically by external translation service to Figure out the topic of articles translated automatically by external translation service.
Mon, Apr 1, 5:06 PM · ExternalGuidance, Product-Analytics

Fri, Mar 29

chelsyx triaged T219660: Figure out the topic of articles translated automatically by external translation service as Low priority.
Fri, Mar 29, 6:00 PM · ExternalGuidance, Product-Analytics
chelsyx created T219660: Figure out the topic of articles translated automatically by external translation service.
Fri, Mar 29, 6:00 PM · ExternalGuidance, Product-Analytics
chelsyx moved T218933: Track usage of the "open here to edit" feature from Triage to Next Up on the Product-Analytics board.
Fri, Mar 29, 12:56 AM · Product-Analytics, Wikipedia-iOS-App-Backlog, iOS-app-v6.3-Lobster-On-A-Motorcycle
chelsyx claimed T218931: Tack usage of editing toolbar elements.
Fri, Mar 29, 12:56 AM · Product-Analytics, Wikipedia-iOS-App-Backlog, iOS-app-v6.3-Lobster-On-A-Motorcycle
chelsyx claimed T218933: Track usage of the "open here to edit" feature.
Fri, Mar 29, 12:55 AM · Product-Analytics, Wikipedia-iOS-App-Backlog, iOS-app-v6.3-Lobster-On-A-Motorcycle
chelsyx added a project to T218931: Tack usage of editing toolbar elements: Product-Analytics.
Fri, Mar 29, 12:54 AM · Product-Analytics, Wikipedia-iOS-App-Backlog, iOS-app-v6.3-Lobster-On-A-Motorcycle
chelsyx added a project to T218933: Track usage of the "open here to edit" feature: Product-Analytics.
Fri, Mar 29, 12:54 AM · Product-Analytics, Wikipedia-iOS-App-Backlog, iOS-app-v6.3-Lobster-On-A-Motorcycle

Thu, Mar 28

chelsyx updated the task description for T218931: Tack usage of editing toolbar elements.
Thu, Mar 28, 9:09 PM · Product-Analytics, Wikipedia-iOS-App-Backlog, iOS-app-v6.3-Lobster-On-A-Motorcycle
chelsyx updated the task description for T218933: Track usage of the "open here to edit" feature.
Thu, Mar 28, 9:08 PM · Product-Analytics, Wikipedia-iOS-App-Backlog, iOS-app-v6.3-Lobster-On-A-Motorcycle
chelsyx updated the task description for T218933: Track usage of the "open here to edit" feature.
Thu, Mar 28, 9:05 PM · Product-Analytics, Wikipedia-iOS-App-Backlog, iOS-app-v6.3-Lobster-On-A-Motorcycle
chelsyx updated the task description for T218931: Tack usage of editing toolbar elements.
Thu, Mar 28, 8:56 PM · Product-Analytics, Wikipedia-iOS-App-Backlog, iOS-app-v6.3-Lobster-On-A-Motorcycle

Tue, Mar 26

chelsyx triaged T218838: Add ExternalGuidance event logging table to whitelist as Normal priority.
Tue, Mar 26, 6:02 PM · Patch-For-Review, Analytics, Product-Analytics
chelsyx added a comment to T218838: Add ExternalGuidance event logging table to whitelist.

Thanks @Nuria ! @santhosh Could you please review the patch as well? Thanks!

Tue, Mar 26, 6:02 PM · Patch-For-Review, Analytics, Product-Analytics
chelsyx updated subscribers of T218933: Track usage of the "open here to edit" feature.

Edit/Save completion rates for users/events where they got to the editor via this affordance

Hi @cmadeo, Josh and I want to compare the drop-off rate of users from start edit to save for different channels, i.e. start from the pencil sign, start from "open here to edit" feature, and others (if any). I'm wondering if you have flow charts for these different channels. And can I schedule a meeting with you to talk about it? Thanks!

Tue, Mar 26, 5:41 PM · Product-Analytics, Wikipedia-iOS-App-Backlog, iOS-app-v6.3-Lobster-On-A-Motorcycle

Sun, Mar 24

chelsyx added a comment to T212414: Measure the impact of externally-originated contributions.

Thanks @chelsyx, this looks good!
I went through the report in more detail and wanted to share my initial interpretations to make sure I'm reading the report as intended. Please confirm this is a valid interpretation or correct any aspect if needed:

  • Based on 1A, the volume of visits coming from integrated translated results in Google search is similar to the visits explicitly requesting a translation (e.g., by going to Google Translate or clicking the "translate this age" option in the search results).

Correct. And note that this graph only shows the traffic when the translation target language is Indonesian. You may also notice that from January to February, visits from integrated translated results is much higher, then it drop since March. I asked @dr0ptp4kt and he thinks Google probably change their algorithm.

Sun, Mar 24, 4:09 AM · MW-1.33-notes (1.33.0-wmf.18; 2019-02-19), Analytics, Patch-For-Review, Product-Analytics, ExternalGuidance

Mar 22 2019

chelsyx moved T218617: Fix EventLogging schemas that use array for items type from Doing to Tracking on the Product-Analytics board.

Sorry to hear that @Ottomata :( Let me know when you need any changes on my side.

Mar 22 2019, 11:45 PM · Analytics-EventLogging, Analytics-Kanban, Patch-For-Review, Fundraising-Backlog, Product-Analytics, Analytics
chelsyx moved T218617: Fix EventLogging schemas that use array for items type from Next Up to Doing on the Product-Analytics board.
Mar 22 2019, 12:35 AM · Analytics-EventLogging, Analytics-Kanban, Patch-For-Review, Fundraising-Backlog, Product-Analytics, Analytics
chelsyx moved T218838: Add ExternalGuidance event logging table to whitelist from Next Up to Doing on the Product-Analytics board.
Mar 22 2019, 12:35 AM · Patch-For-Review, Analytics, Product-Analytics

Mar 21 2019

chelsyx added a comment to T218617: Fix EventLogging schemas that use array for items type.

@Ottomata I was trying to change the schema on meta wiki, but got this error message:

Error: Invalid node: expecting "array", got "object". Path: "Schema -> Properties (properties) -> feed_enabled_list -> Properties (properties) -> fa -> Properties (properties) -> on -> Items (items)"

Mar 21 2019, 9:25 PM · Analytics-EventLogging, Analytics-Kanban, Patch-For-Review, Fundraising-Backlog, Product-Analytics, Analytics
chelsyx added a comment to T218617: Fix EventLogging schemas that use array for items type.

Hi @Ottomata , IIUC this only requires changes on the schema on meta wiki (MobileWikiAppiOSUserHistory), no change is needed on the app side, correct? Of course we will need to change to the updated revision number of the schema in the app, but since this should be compatible with existing events and there will always be some users never update their app, it seems changes on the app is not really needed. If this is the case, I can change the schema today; if changes on the client side is required, we have to wait till the next app release (a few weeks I guess).

Mar 21 2019, 6:50 PM · Analytics-EventLogging, Analytics-Kanban, Patch-For-Review, Fundraising-Backlog, Product-Analytics, Analytics

Mar 20 2019

chelsyx triaged T218617: Fix EventLogging schemas that use array for items type as Normal priority.
Mar 20 2019, 11:47 PM · Analytics-EventLogging, Analytics-Kanban, Patch-For-Review, Fundraising-Backlog, Product-Analytics, Analytics
chelsyx triaged T215995: Analysis of long term impact of Mexico campaign to eswiki traffic as Normal priority.
Mar 20 2019, 11:46 PM · New-Readers, Product-Analytics
chelsyx moved T215995: Analysis of long term impact of Mexico campaign to eswiki traffic from Next Up to Doing on the Product-Analytics board.
Mar 20 2019, 11:46 PM · New-Readers, Product-Analytics
chelsyx moved T218838: Add ExternalGuidance event logging table to whitelist from Triage to Next Up on the Product-Analytics board.
Mar 20 2019, 11:42 PM · Patch-For-Review, Analytics, Product-Analytics
chelsyx added a parent task for T218838: Add ExternalGuidance event logging table to whitelist: T212414: Measure the impact of externally-originated contributions.
Mar 20 2019, 11:41 PM · Patch-For-Review, Analytics, Product-Analytics
chelsyx added a subtask for T212414: Measure the impact of externally-originated contributions: T218838: Add ExternalGuidance event logging table to whitelist.
Mar 20 2019, 11:41 PM · MW-1.33-notes (1.33.0-wmf.18; 2019-02-19), Analytics, Patch-For-Review, Product-Analytics, ExternalGuidance
chelsyx created T218838: Add ExternalGuidance event logging table to whitelist.
Mar 20 2019, 11:41 PM · Patch-For-Review, Analytics, Product-Analytics
chelsyx added a comment to T212414: Measure the impact of externally-originated contributions.

Done. @Pginer-WMF can you review the report and close this ticket if everything we want is the report?

Mar 20 2019, 11:26 PM · MW-1.33-notes (1.33.0-wmf.18; 2019-02-19), Analytics, Patch-For-Review, Product-Analytics, ExternalGuidance

Mar 19 2019

chelsyx added a comment to T218274: `rev_parent_id` and `rev_content_changed` are missing in event.mediawiki_revision_tags_change.

Thanks all!

Mar 19 2019, 6:43 PM · Core Platform Team Kanban (Done with CPT), Services (done), MW-1.33-notes (1.33.0-wmf.22; 2019-03-19), Product-Analytics, Analytics
chelsyx moved T218617: Fix EventLogging schemas that use array for items type from Triage to Next Up on the Product-Analytics board.
Mar 19 2019, 5:59 PM · Analytics-EventLogging, Analytics-Kanban, Patch-For-Review, Fundraising-Backlog, Product-Analytics, Analytics

Mar 14 2019

chelsyx added a comment to T218169: Measure the impact of the wikitext editing tools on the iOS app.

That should work! So we can extrapolate who dropped off in the Preview and Edit summary screens by looking at the difference between who dropped after preview but before saving?

We know who reach the the preview screen and then who try to save the edit. Taking the difference of them would tell us who drop between preview and save, but users can drop after seeing the preview, or after seeing the edit summary screen -- we can't tell these two apart.

Mar 14 2019, 7:31 PM · Wikipedia-iOS-App-Backlog, Product-Analytics
chelsyx added a comment to T218169: Measure the impact of the wikitext editing tools on the iOS app.

@chelsyx, would it be possible to also track where in the editing funnel we're potentially seeing drop off? Eg. Would it be possible to track how many people open the editor and drop off on the first Edit screen, or drop off at the Preview screen, or drop off at the Edit summary screen?

@cmadeo With MobileWikiAppEdit table, we can calculate how many people open the editor, drop off before preview, drop off before trying to save, and save successfully. But we can't know how many drop off at the Edit summary screen. Would that work?

Mar 14 2019, 5:57 PM · Wikipedia-iOS-App-Backlog, Product-Analytics
chelsyx moved T218274: `rev_parent_id` and `rev_content_changed` are missing in event.mediawiki_revision_tags_change from Triage to Tracking on the Product-Analytics board.
Mar 14 2019, 1:22 AM · Core Platform Team Kanban (Done with CPT), Services (done), MW-1.33-notes (1.33.0-wmf.22; 2019-03-19), Product-Analytics, Analytics
chelsyx created T218274: `rev_parent_id` and `rev_content_changed` are missing in event.mediawiki_revision_tags_change.
Mar 14 2019, 1:22 AM · Core Platform Team Kanban (Done with CPT), Services (done), MW-1.33-notes (1.33.0-wmf.22; 2019-03-19), Product-Analytics, Analytics

Mar 13 2019

chelsyx moved T218246: Eventbus revisions are duplicated in event.mediawiki_revision_tags_change from Triage to Tracking on the Product-Analytics board.
Mar 13 2019, 7:15 PM · Product-Analytics, Analytics
chelsyx created T218246: Eventbus revisions are duplicated in event.mediawiki_revision_tags_change.
Mar 13 2019, 7:14 PM · Product-Analytics, Analytics
chelsyx added a comment to T215289: Update reportupdater to be able to query the new db cluster that will substitute 1002.

@chelsyx, Nuria told me you're working on a project named Toledo, that she thinks might provide similar stats that this data set was providing, is that right?

Mar 13 2019, 5:12 AM · Patch-For-Review, Analytics-Kanban, Analytics
chelsyx added a comment to T209132: Add ability to set a revision tag by passing a URL parameter to the Visual Editor.

@chelsyx may need to be aware of the current situation of the content tags or any possible changes since this can affect the analytics she is working on.

Mar 13 2019, 4:18 AM · ExternalGuidance, MW-1.33-notes (1.33.0-wmf.9; 2018-12-18), VisualEditor (Current work)
chelsyx updated subscribers of T215995: Analysis of long term impact of Mexico campaign to eswiki traffic.

@atgo, @kzimmerman and I talked about my priorities today. I should be able to start working on this analysis next week (the week of Mar 18), which means I should be able to finish it before the end of this Q. I will let you know if things change.

Mar 13 2019, 12:49 AM · New-Readers, Product-Analytics
chelsyx updated the task description for T218169: Measure the impact of the wikitext editing tools on the iOS app.
Mar 13 2019, 12:46 AM · Wikipedia-iOS-App-Backlog, Product-Analytics

Mar 12 2019

chelsyx updated the task description for T218169: Measure the impact of the wikitext editing tools on the iOS app.
Mar 12 2019, 10:45 PM · Wikipedia-iOS-App-Backlog, Product-Analytics
chelsyx moved T218169: Measure the impact of the wikitext editing tools on the iOS app from Triage to Next Up on the Product-Analytics board.
Mar 12 2019, 10:43 PM · Wikipedia-iOS-App-Backlog, Product-Analytics
chelsyx created T218169: Measure the impact of the wikitext editing tools on the iOS app.
Mar 12 2019, 10:42 PM · Wikipedia-iOS-App-Backlog, Product-Analytics
chelsyx moved T203723: As a product analyst I would like to know how people are using the Wikidata Descriptions editing features from Blocked to Next Up on the Product-Analytics board.
Mar 12 2019, 10:24 PM · Product-Analytics, Wikipedia-iOS-App-Backlog
chelsyx added a comment to T217619: Publishing html files generated on notebook hosts.

Got it. Thanks @Ottomata !

Mar 12 2019, 10:07 PM · Patch-For-Review, Analytics-Kanban, Product-Analytics, Analytics-SWAP, Analytics
chelsyx added a comment to T217619: Publishing html files generated on notebook hosts.

Hi @Ottomata , published-datasets-sync works well when I (user chelsyx) execute it. But when I execute it via a cron job, I will see published-datasets-sync: command not found. Do you have any idea why this is happening?

Mar 12 2019, 10:05 PM · Patch-For-Review, Analytics-Kanban, Product-Analytics, Analytics-SWAP, Analytics

Mar 7 2019

chelsyx added a comment to T210813: Analysis of short term impact of Mexico campaign to site and landing page traffic.

Hey @chelsyx did you look into traffic overall (not just direct links) for this analysis before/during/after the campaign? If not, could you please include in T215995?

Mar 7 2019, 4:57 AM · Product-Analytics, New-Readers
chelsyx added a comment to T215995: Analysis of long term impact of Mexico campaign to eswiki traffic.

@atgo We haven't prioritize this work yet. When do you need it?

Mar 7 2019, 4:56 AM · New-Readers, Product-Analytics
chelsyx added a comment to T217619: Publishing html files generated on notebook hosts.

Hi @Nuria, @Tbayer already documented it. :)

Mar 7 2019, 12:43 AM · Patch-For-Review, Analytics-Kanban, Product-Analytics, Analytics-SWAP, Analytics
chelsyx added a comment to T212414: Measure the impact of externally-originated contributions.

Update: The url to the report is now changed to https://analytics.wikimedia.org/datasets/external-automatic-translation/impact%20of%20external%20automatic%20translation%20services.html for easier publishing. It is updating daily at 2AM UTC (the page will get updated with a few minutes delay).

Mar 7 2019, 12:22 AM · MW-1.33-notes (1.33.0-wmf.18; 2019-02-19), Analytics, Patch-For-Review, Product-Analytics, ExternalGuidance
chelsyx awarded T217619: Publishing html files generated on notebook hosts a 100 token.
Mar 7 2019, 12:08 AM · Patch-For-Review, Analytics-Kanban, Product-Analytics, Analytics-SWAP, Analytics
chelsyx added a comment to T217619: Publishing html files generated on notebook hosts.

Thank you so much @Ottomata ! Works like a charm!

Mar 7 2019, 12:08 AM · Patch-For-Review, Analytics-Kanban, Product-Analytics, Analytics-SWAP, Analytics

Mar 6 2019

chelsyx added a comment to P8156 Referer source ratio.

Thanks @dr0ptp4kt !

Mar 6 2019, 4:14 AM

Mar 5 2019

chelsyx added a comment to T217554: Unify event logging error reporting to always report unlocalized codes.

Sounds good! Thank you @JoeWalsh !

Mar 5 2019, 5:53 PM · Product-Analytics, Wikipedia-iOS-App-Backlog
chelsyx added a project to T217554: Unify event logging error reporting to always report unlocalized codes: Product-Analytics.

Thanks @JoeWalsh for creating this ticket!

Mar 5 2019, 6:37 AM · Product-Analytics, Wikipedia-iOS-App-Backlog
chelsyx added a comment to T212414: Measure the impact of externally-originated contributions.

If I understand this correctly, the proposal is to be able to distinguish between (a) the users that access an automatic translation that was directly exposed in search results, and (b) the users that access a translation they explicitly requested by going to Google Translate and pasting a Wikipedia link there.

That's correct.

Mar 5 2019, 3:23 AM · MW-1.33-notes (1.33.0-wmf.18; 2019-02-19), Analytics, Patch-For-Review, Product-Analytics, ExternalGuidance
Tbayer awarded T217619: Publishing html files generated on notebook hosts a Mountain of Wealth token.
Mar 5 2019, 2:22 AM · Patch-For-Review, Analytics-Kanban, Product-Analytics, Analytics-SWAP, Analytics
chelsyx moved T217619: Publishing html files generated on notebook hosts from Triage to Tracking on the Product-Analytics board.
Mar 5 2019, 2:08 AM · Patch-For-Review, Analytics-Kanban, Product-Analytics, Analytics-SWAP, Analytics
chelsyx created T217619: Publishing html files generated on notebook hosts.
Mar 5 2019, 2:07 AM · Patch-For-Review, Analytics-Kanban, Product-Analytics, Analytics-SWAP, Analytics

Mar 4 2019

chelsyx added a comment to T212414: Measure the impact of externally-originated contributions.

@chelsyx I'm thinking specifically about our traffic from Google search. So search results > clicks > impact on overall traffic. In particular, does Toledo traffic cannibalize other results?

Mar 4 2019, 11:13 PM · MW-1.33-notes (1.33.0-wmf.18; 2019-02-19), Analytics, Patch-For-Review, Product-Analytics, ExternalGuidance
chelsyx added a comment to T212414: Measure the impact of externally-originated contributions.

@chelsyx As it is the "Access the translated funnel" line makes the other parts of the funnel look compressed in the "Number of events when target language is Indonesian, by action type" graph. It's a true representation of the magnitude, of course, but I was wondering if you had an approach that might aid visual interpretation of the data (e.g., two y-axes, non-constant scale, percentile fluctuation, etc.).

Mar 4 2019, 10:59 PM · MW-1.33-notes (1.33.0-wmf.18; 2019-02-19), Analytics, Patch-For-Review, Product-Analytics, ExternalGuidance
chelsyx added a comment to T212414: Measure the impact of externally-originated contributions.

@dr0ptp4kt and @atgo , regarding T212414#4956321, you want to track the impact of this project on google search, i.e. how often our pages show up in google search results, their average position, etc, not the impact on the internal search on wikipedia, correct?

Mar 4 2019, 8:25 PM · MW-1.33-notes (1.33.0-wmf.18; 2019-02-19), Analytics, Patch-For-Review, Product-Analytics, ExternalGuidance
chelsyx added a comment to T212414: Measure the impact of externally-originated contributions.

Hello @santhosh , I think it would be helpful if we can add a field (invoke_source) to the ExternalGuidance schema, to distinguish whether a user came from the automatic translation on search result page (the query string of the referrer url contains client=srp). Is this doable? And how long will it take to deploy this change? If it delays the deploy on enwiki too much, let's leave it for the future.
Also @Pginer-WMF , do you think this is necessary?

Mar 4 2019, 6:26 AM · MW-1.33-notes (1.33.0-wmf.18; 2019-02-19), Analytics, Patch-For-Review, Product-Analytics, ExternalGuidance
chelsyx added a comment to T212414: Measure the impact of externally-originated contributions.

Here is the link to the temporary dashboard/report: https://analytics.wikimedia.org/datasets/external-automatic-translation/impact%20of%20external%20automatic%20translation%20services.html
I'm planning to update it daily. It's not a finished work, but I think it may be helpful to you. Please let me know if you have any comments/suggestions, or any privacy concern since this is a public page.

Mar 4 2019, 6:02 AM · MW-1.33-notes (1.33.0-wmf.18; 2019-02-19), Analytics, Patch-For-Review, Product-Analytics, ExternalGuidance

Mar 3 2019

chelsyx added a comment to T215093: Aggregate and save the Google Translate Pageview count temporarily.

@dr0ptp4kt About the difference between home_language and to_language, I did some investigation and found that home_language controls the translation engine language (google translate toolbar, etc), while to_language is the translation target languages. Only when to_language is missing, pages will be translated to home_language.

Mar 3 2019, 5:06 AM · Product-Analytics
chelsyx updated the task description for T215093: Aggregate and save the Google Translate Pageview count temporarily.
Mar 3 2019, 5:00 AM · Product-Analytics
chelsyx added a comment to T215093: Aggregate and save the Google Translate Pageview count temporarily.

Will it be possible later to backfill/update/extend either virtualpageview_hourly or pageview_hourly with data derived from this table? (cf. T212414#4864672)

virtualpageview_hourly doesn't seem suitable in this case. As to pageview_hourly, it would be awesome if we can add a field for all the keys in x_analytics_map. I will open another ticket for this and let's discuss about it there.

Mar 3 2019, 4:59 AM · Product-Analytics

Mar 2 2019

chelsyx added a comment to T216123: Tag is not added when new page is created through External Guidance.

Hi @Pginer-WMF , I think we also need tags when users edit an existing page in their local language, or when they edit the original page in English. Hopefully this fix them all.

Mar 2 2019, 4:37 AM · Patch-For-Review, ExternalGuidance

Feb 27 2019

chelsyx added a comment to T212414: Measure the impact of externally-originated contributions.

I did another round of test and confirm that the eventlogging works as we expected. Thanks @santhosh !

Feb 27 2019, 4:14 AM · MW-1.33-notes (1.33.0-wmf.18; 2019-02-19), Analytics, Patch-For-Review, Product-Analytics, ExternalGuidance

Feb 26 2019

chelsyx moved T214628: As a PM I'd like to know how many iOS app user are blocked from editing and registration from Doing to Tracking on the Product-Analytics board.

I deleted the previous comment and redo the analysis. I get the counts from table MobileWikiAppEdit and MobileWikiAppCreateAccount, then join the IP addresses from these eventlogging table with the ipblocks table to make sure they really are IP block. See the full analysis here: https://people.wikimedia.org/~chelsyx/iOS%20app%20edit%20and%20registration%20block.html. The summary of it is shown below:

Feb 26 2019, 8:39 PM · Wikipedia-iOS-App-Backlog, Product-Analytics

Feb 25 2019

chelsyx added a comment to T214628: As a PM I'd like to know how many iOS app user are blocked from editing and registration.

The large number of IP block looks very suspicious to me. It's not even IP range block if my interpretation is correct...

I'm not surprised by that difference between ID and IP. It seems within a realistic realm of possibility to me. But if you're not confident, more logging/data could be useful.

Feb 25 2019, 10:55 PM · Wikipedia-iOS-App-Backlog, Product-Analytics
chelsyx added a comment to T209087: [EventLogging Sanitization] Update EL sanitization white-list for field renames in EL schemas.

I just checked event_sanitized.MobileWikiAppShareAFact, and it looks good to me. Thanks @mforns !

Feb 25 2019, 8:42 PM · Analytics-Kanban, Patch-For-Review, Product-Analytics, Reading-analysis, Analytics
chelsyx added a comment to T211842: Update Audiences page and Key Product Metrics deck with January 2019 Readers data.

Done.

Feb 25 2019, 8:07 PM · Product-Analytics
chelsyx updated the task description for T211842: Update Audiences page and Key Product Metrics deck with January 2019 Readers data.
Feb 25 2019, 8:06 PM · Product-Analytics
chelsyx added a comment to T214628: As a PM I'd like to know how many iOS app user are blocked from editing and registration.
Feb 25 2019, 6:56 AM · Wikipedia-iOS-App-Backlog, Product-Analytics

Feb 22 2019

chelsyx added a comment to T214628: As a PM I'd like to know how many iOS app user are blocked from editing and registration.

@JoeWalsh I assume the errorText here in MobileWikiAppCreateAccount is localized, correct?

@chelsyx correct, that one looks to be localized. I can update it to match the unlocalized behavior we implemented for https://phabricator.wikimedia.org/T210970#4934751 if you like.

Feb 22 2019, 6:50 PM · Wikipedia-iOS-App-Backlog, Product-Analytics
chelsyx added a comment to T214628: As a PM I'd like to know how many iOS app user are blocked from editing and registration.

Test case 4: As a ID-blocked user, I logged out and try to register a new account on testwiki via the iOS app
Outcome: I'm able to register a new account but cannot log in on the app. I can log in this account and make edit on desktop (see user log). However, after the block is expired, I still can't log in this account on the app. Additionally, I saw two different behaviors when I tried to log in on my phone and on Xcode simulator:

Feb 22 2019, 3:34 AM · Wikipedia-iOS-App-Backlog, Product-Analytics

Feb 21 2019

chelsyx added a comment to T214628: As a PM I'd like to know how many iOS app user are blocked from editing and registration.

Test case 3: As a IP-blocked user (logged out), I'm trying to register a new account on testwiki via the iOS app
Outcome: Error message shown on the screen:


Our existing MobileWikiAppCreateAccount captured the error as below:

{
    event =     {
        action = error;
        appInstallID = "ED0D972D-9F7E-44CB-97FF-E073C1331F6E";
        errorText = "Account creation from this IP address (<strong>198.73.209.241</strong>) has been blocked by [[User:TBolliger (WMF)|TBolliger (WMF)]].\n\nThe reason given by TBolliger (WMF) is <em>Testing block notices on iOS app</em>";
        sessionToken = "87F7FF16-79AC-4EFF-B3C4-54A9B6415E00";
        ts = "2019-02-21T14:34:24-08:00";
    };
    revision = 17836914;
    schema = MobileWikiAppCreateAccount;
    wiki = testwiki;
}

@JoeWalsh I assume the errorText here in MobileWikiAppCreateAccount is localized, correct?

Feb 21 2019, 10:44 PM · Wikipedia-iOS-App-Backlog, Product-Analytics
chelsyx added a comment to T214628: As a PM I'd like to know how many iOS app user are blocked from editing and registration.

Test case 2: As a IP-blocked user (logged out), I'm trying to edit a page on testwiki via the iOS app
Outcome: Error message shown on the screen:
ID block but user is logged out:


IP block:

Feb 21 2019, 10:21 PM · Wikipedia-iOS-App-Backlog, Product-Analytics
chelsyx added a comment to T214628: As a PM I'd like to know how many iOS app user are blocked from editing and registration.

Test case 1: As a ID-blocked logged in user, I'm trying to edit a page on testwiki via the iOS app
Outcome: Error message shown on the screen:

Feb 21 2019, 9:45 PM · Wikipedia-iOS-App-Backlog, Product-Analytics
chelsyx moved T214628: As a PM I'd like to know how many iOS app user are blocked from editing and registration from Next Up to Doing on the Product-Analytics board.

Thanks @TBolliger for the information and helping me creating a blocked account for test!

Feb 21 2019, 9:34 PM · Wikipedia-iOS-App-Backlog, Product-Analytics
chelsyx added a comment to T212414: Measure the impact of externally-originated contributions.

Update: I checked the table in hadoop again and found all of my testing events in there, but some of them doesn't show up in the Grafana dashboard. (To be more specific, I got all of my testing events using the query below and tried to find matched events in Grafana through the timestamp, language, and action type.) Also based on what Nuria said in T212414#4967609, I think we should trust the eventlogging table more than the Grafana dashboard.

select dt
from event.externalguidance
where year=2019 and month=2 and day>=19
and event.title="Powderfinger"
order by dt
limit 1000;
-----------
dt
2019-02-20T04:31:58Z
2019-02-20T04:33:24Z
2019-02-20T04:33:35Z
2019-02-20T04:46:15Z
2019-02-20T04:46:21Z
2019-02-20T07:04:06Z
2019-02-20T07:04:08Z
2019-02-20T07:04:33Z
2019-02-20T07:04:44Z
2019-02-20T07:07:21Z
2019-02-20T07:08:58Z
2019-02-20T07:09:11Z
2019-02-20T07:14:29Z

@santhosh If you can help change the schema revision from 18870832 to 18873656, and fix the events when action is specialpage, createpage, editpage, or edit-original--currently these events didn't get sent when corresponding actions were triggered, I think we are good to go! Thanks!

Feb 21 2019, 1:28 AM · MW-1.33-notes (1.33.0-wmf.18; 2019-02-19), Analytics, Patch-For-Review, Product-Analytics, ExternalGuidance

Feb 20 2019

chelsyx added a comment to T212414: Measure the impact of externally-originated contributions.

You are testing it in correct way. Perhaps there is delay in getting that data in to tables?

Hmm... I will check again tomorrow.

Feb 20 2019, 7:34 AM · MW-1.33-notes (1.33.0-wmf.18; 2019-02-19), Analytics, Patch-For-Review, Product-Analytics, ExternalGuidance