The Role of the Modern Day Web Analyst

Gordon Choi breaks down web analytics and tips for data capture, extraction, manipulation and presentation.

Author
Date published
September 01, 2015 Categories

As a web analyst, your role requires you to perform four major tasks:

Let’s go through the three phases for the modern day web analyst:

Phase #1: Data Capture 

Assuming your online business mostly happens on your company’s websites, most of the online marketing, search marketing and user behavior activities can be captured with:

Web Log Files – You must be very familiar with the principles of how web log files capture data and what data is available. Web 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.

Web Analytics – Most websites globally use some analytics tools. A typical web analytics tool provides graphical user interfaces (GUI) and allows you to quickly see the data trends of your users. Reports can be downloaded as spreadsheets, text files or sometimes even as PDF files.

Before a web analytics tool can capture users’ data, you are responsible for implementing the required tracking setup. This normally requires inserting some JavaScript tracking scripts or some 1×1 pixel scripts onto all HTML pages of your websites. If the objectives include capturing more than the default amount of user data, then you are required to implement some advanced tracking scripts on top of the regular tracking scripts.

These include:

Search Marketing Platforms – Some websites make use of third-party search marketing management and tracking platforms such as Kenshoo, Marin Software, or Adobe AdLens (formerly called Efficient Frontier). You are required to implement the platform’s tracking scripts onto your websites in order for the data capture to work.

Phase #2: Data Extraction

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:

The business intelligence (BI) team may already have processed the raw data and have it converted into reports which are readable. The reports can be obtained under some BI data warehousing systems, for example Cognos or other similar data cubes. These reports can form a large part of the regular reports to a company. Ad hoc reports often require quicker turnaround time.

It is time for you to utilize your SQL query ability in order to extract data directly from the databases whether they are MYSQL databases, Oracle databases, or other databases. Not all the raw data you have captured goes straight into your databases or data warehouses. For this reason, a large of amount of time goes into then working on post data manipulation. For example:

Phase #3: Data Manipulation & Presentation

Excel – Before you can present pretty graphical reports, the data extracted through ad hoc SQL queries will need to be manipulated. Creating pretty reports through Excel can take a lot of time, therefore, having expert knowledge on how to get the most out of Excel features and formulas will only improve efficiency. These could include: aggregating data with Pivot tables, merging data with Vlookup, manipulating dates with functions like “day”, “month”, etc.

*Image via Shutterstock

Exit mobile version