As a web analyst and/or a mobile app analyst, your role requires you to perform four major tasks.
In order to accomplish the four major tasks, the web analysts and/or mobile app analysts will actually have to go through three phases.
The three phases are traditional phases in analytics (for websites’ and mobile apps’ data). Let’s examine each phase.
Your website’s data can be captured through web server log files and/or web analytics tools.
Web server log analytics captures and stores raw data in log files.
Before using log file data as your analytics data, your first set as a web analyst is to ensure your website is correctly configured to capture and store log files.
Most websites use at least one or sometimes multiple web analytics tools.
When additional user behavior data is required, you will have to implement some advanced/customized tracking setup.
Most mobile app analytics tools provide SDKs (i.e. SDK for iOS app & SDK for Android app). To enable the mobile app analytics to collect data from your apps, your first step is to install the SDKs onto the mobile apps.
Once the data is collected, the next phase is to extract the data for the end users. Raw data collected in phase #1 should be converted into reports that are for two major purposes:
These reports need to be received on a regular basis which may be once per day, per week, or per month. These reports are categorized into different levels depending on who the receivers are. An executive (e.g. company CEO) will need high-level reports showing key revenue figures for each major division of the company. Operational managers will need mid-level data reports which allow them to track “potential issues” of the products that individual teams are responsible for.
These reports won’t be processed regularly with any fixed intervals. Normally, ad hoc reports are required for review purposes for any once-off online campaigns. Ad hoc reports are also required when deep diving into data to figure out issues. Issues may be certain KPI numbers have decreased over the past two weeks, and operational managers will need to go through ad hoc data reports in details to figure out the reasons behind the decrease.
Typical web analytics tools and/or mobile app analytics tools provide many basic data reports in user-friendly graphical user interfaces (GUI), and usually the reports can be downloaded as spreadsheets. The pre-built reports allows you to quickly see high-level data trends.
Whether you can perform advanced segmentation and/or compile custom reports, it depends on the specific web / mobile app analytics tool you use. Performing advanced segmentation and/or compiling custom reports allow you to go one (or several) levels deeper into figuring out some real business issues.
With web server log analytics, log files usually are very large files that can be very difficult to process. A mid-size website’s daily log file can easily exceed 25 gigabytes in size. You may have to use a third-party log analyzing tool to compile the data into reports.
You must be very familiar with the principles of how web server log files capture data and what data is available. Web server log files give you the ability to “record” all the files that were loaded by the user when they accessed your websites, and you can easily see which “components” of your websites aren’t responding to user requests.
Your business intelligence (BI) team may already have captured transaction data and/or customer data and have them stored in a data warehouse software (or multiple databases) e.g. Cognos, Microsoft Reporting Services, etc. At this stage, the transaction data and/or customer data should already been processed into human readable reports.
The next immediate step is to connect the transaction data to your web analytics data and mobile app analytics data. Only after this data connection is established, then your reports will show close to full pictures of your users from how they interact with your website (or mobile apps) to what they have transacted (i.e. purchased).
To build the connection, you may have to use your SQL query writing ability to extract the data directly from the databases (or data warehouse).
If you use one or some of the third-party platforms (e.g. Kenshoo, Marin Software, etc) to track advertising campaigns’ performance, then you will have to extract the data and connect it to your web / mobile app analytics data and transaction data.
For data analysis, tools such as Excel, and some third-party Visualization reporting tools (e.g. Tableau) are essential.
As an analyst for websites’ and mobile apps’ data, spending 80% of your time solely on Excel as a tool may be normal. Being able to use the two Excel feature Pivot tables and Vlookup will be important.
Tools with steeper learning curves include R, Matlab, and even Python. You may need one or some of them to help you build data models when sophisticated analysis is required.
Content on Gordon Choi’s Analytics Book is licensed under the CC Attribution-Noncommercial 4.0 International license.