Here's where that [[ https://wikitech.wikimedia.org/wiki/Analytics/Data_Lake/Edits/Mediawiki_history | mediawiki_history ]] dataset is helpful:

SELECT
  COUNT(1) AS n_caption_translations
FROM `wmf`.`mediawiki_history`
WHERE `snapshot` = '2019-12'
  AND wiki_db = 'commonswiki'
  AND event_entity = 'revision'
  AND ARRAY_CONTAINS(revision_tags, 'android app edit')
  AND INSTR(event_comment, '#suggestededit-translate') > 0
  -- Revisions that haven't been reverted as of the snapshot:
  AND NOT revision_is_identity_reverted
  AND NOT revision_is_deleted_by_page_deletion

At the end of 2019, we had 9848 image captions which have been translated via Suggested Edits (and not reverted).

@Abit as with T242816, we plan to prioritize this at our next board review meeting (this Fri, 17 Jan).

In T242771#5804087, @mpopov wrote:

Here's where that [[ https://wikitech.wikimedia.org/wiki/Analytics/Data_Lake/Edits/Mediawiki_history | mediawiki_history ]] dataset is helpful:

SELECT
  COUNT(1) AS n_caption_translations
FROM `wmf`.`mediawiki_history`
WHERE `snapshot` = '2019-12'
  AND wiki_db = 'commonswiki'
  AND event_entity = 'revision'
  AND ARRAY_CONTAINS(revision_tags, 'android app edit')
  AND INSTR(event_comment, '#suggestededit-translate') > 0
  -- Revisions that haven't been reverted as of the snapshot:
  AND NOT revision_is_identity_reverted
  AND NOT revision_is_deleted_by_page_deletion

At the end of 2019, we had 9848 image captions which have been translated via Suggested Edits (and not reverted).

Thanks @mpopov - great stuff. What % of image caption translations does that represent between image caption translation feature go-live on Android, and whenever the dataset you've got ends?

In T242771#5805091, @Charlotte wrote:

In T242771#5804087, @mpopov wrote:

At the end of 2019, we had 9848 image captions which have been translated via Suggested Edits (and not reverted).

Thanks @mpopov - great stuff. What % of image caption translations does that represent between image caption translation feature go-live on Android, and whenever the dataset you've got ends?

Just to clarify, 9848 is the total ever from the very first one made during development to the last one made on New Year's Eve. (The "2019-12" in the query refers to the latest available snapshot of mediawiki history, and there will be a new snapshot in February which include image caption translations made this month.)

Noice. Thanks!