Tools for managing data - user summary activity
Posted: 08 Jan 2019, 13:55
Is there any way to pull out summary activity by user/device for a domain?
Specifically for marketing analysis I would like to know for a specific time period (1 month, 1 year etc.):
(a) how much time and data has been consumed by each user
(b) how many different MAC addresses have been connected by each user
(c) How many users for each product
At the moment it appears that all this information can only be obtained at the individual user level by downloading the connection log to Excel and summarising. However with more than 1000 users per domain it is not practical to download on a per user basis and consolidate.
Specifically for marketing analysis I would like to know for a specific time period (1 month, 1 year etc.):
(a) how much time and data has been consumed by each user
(b) how many different MAC addresses have been connected by each user
(c) How many users for each product
At the moment it appears that all this information can only be obtained at the individual user level by downloading the connection log to Excel and summarising. However with more than 1000 users per domain it is not practical to download on a per user basis and consolidate.