Ghost/ghost/tinybird/tests/all_top_sources.test.result
Hannah Wolfe 4b1ce62ca9
Fix origin attribution in Tinybird analytics hits (#21187)
closes 
https://linear.app/tryghost/issue/ANAL-96/data-discrepancy-between-charts-when-filtering

- Atttribute the referral of the first hits to the whole session in `analytics_sources_mv`, while keeping the raw hits in `analytics_hits`
- Updated tests accordingly
- This is a rebased / reordered version of https://github.com/TryGhost/Ghost/pull/21166

Co-authored-by: alejandromav <hi@alejandromav.com>
Co-authored-by: Alejandro Martin <alejandromav@tinybird.co>
2024-10-02 17:27:43 +01:00

10 lines
174 B
Plaintext

"source","visits","pageviews"
"",6,12
"bing.com",2,5
"search.yahoo.com",2,3
"google.com",1,3
"baidu.com",1,3
"wilted-tick.com",1,1
"duckduckgo.com",1,2
"petty-queen.com",1,1