Hi,
Just following up to thank you guys.
Kevin and Ottomoata guided me through getting set up on hive and I made the
first queries I needed to! Here were the results (if you're interested)
Best,
J
4/12 full day
*mobile_site* *Pageviews* *% of stable* a 8,578 0.004% b 46,705
0.019% stable 244,816,000
Strangely, the event-logs for specific actions showed much higher traffic
for beta but this is likely due to different user groups?
(multiple days)
*mobile_site* * search events* *% of stable* alpha 18,768 0.01%
beta 153,617
0.09% stable 178,118,332
queries:
for alpha beta
SELECT
x_analytics_map['mf-m'] AS mobile_site, count(*)
FROM
wmf.webrequest
WHERE
access_method = "mobile web"
AND YEAR = 2015
AND MONTH = 4
AND DAY = 12
AND user_agent_map['device_family'] <> "Spider"
AND is_pageview = TRUE
AND x_analytics_map['mf-m'] IS NOT NULL
GROUP BY
x_analytics_map['mf-m']
LIMIT 50;
For stable:
SELECT
count(*)
FROM
wmf.webrequest
tablesample(BUCKET 1 OUT OF 1000 ON rand())
WHERE
access_method = "mobile web"
AND YEAR = 2015
AND MONTH = 4
AND DAY = 12
AND is_pageview = TRUE
AND user_agent_map['device_family'] <> "Spider"
AND x_analytics_map['mf-m'] IS NULL
LIMIT 50;
For events:
SELECT count(uuid), event_name, event_mobileMode FROM
MobileWebUIClickTracking_10742159 GROUP BY event_name, event_mobileMode;