Re: [Analytics] measuring traffic on mobile web beta

[Jon Katz]

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;

_______________________________________________
Analytics mailing list
Analytics@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/analytics