Page MenuHomePhabricator

iOS Data validation source = 'history' in `ios_article_link_interaction` data
Closed, ResolvedPublic

Description

Check data after release that clicks from History in Search are logged as source = 'history' in ios_article_link_interaction data

Event Timeline

validated we are seeing source = 4 (History) events in event.ios_article_link_interaction

SELECT 
COUNT(*) AS n_events,
CASE source
        WHEN 1 THEN 'SEARCH'
        WHEN 2 THEN 'INTERNAL_LINK'
        WHEN 3 THEN 'EXTERNAL_LINK'
        WHEN 4 THEN 'HISTORY'
        WHEN 6 THEN 'LANGUAGE_LINK'
        WHEN 7 THEN 'RANDOM'
        WHEN 8 THEN 'MAIN_PAGE'
        WHEN 9 THEN 'PLACES'
        ELSE 'NOT LABELLED'
    END as source_name
FROM event.ios_article_link_interaction 
WHERE YEAR = 2025 AND MONTH >= 05 AND DAY >= 01
GROUP BY 2