Google Analytics in VAL!

June 12, 2020

As part of our recent blog on Increasing Traffic with Google Analytics, we will like to share with you how we use VAL to dashboard the data that we ingest from Google Analytics.

We utilize the integration API from google analytics to load the data into VAL.

Specifically we create two tables in VAL.

GA - Source: store the data with dimension as source, country and the metric as users

GA - Medium: store the data with dimension as medium, country and the metric as users

These two tables contain the daily statistics of the metrics, in order to prevent duplicates, we capture the id based on a concatenation of the date, dimension and country. The reason we pull in the daily movement is to ensure we are able to identify the traffic to our website on a day to day basis so that in future we can relate it to specific activity we had performed.

On the back of the data, we created a dashboard to visualize the data. Below is an explanation of each of the widget defined.

Google Analytics in VAL

General website traffic widgets

Google Analytics in VAL

Title: Inception till Date Users Traffic

  • Widget Type: Big Number
  • Period: Inception till date
  • Purpose: Shows the numbers of users that have visited our website inception till date

Title: Month till Date Users Traffic

  • Widget Type: Big Number
  • Period: Inception till date
  • Purpose: Shows the numbers of users that have visited our website month till date

Title: Weekly Trend of User Traffic

  • Widget Type: Line
  • Period: Inception till date
  • Purpose: Shows the number of users visiting our website on a weekly basis

Website traffic in relation to medium widgets

Google Analytics in VAL

Title: Website Traffic by Medium

  • Widget Type: Bar chart
  • Period: Inception till date
  • Purpose: Shows the number of users visiting our website by medium. This tells us how our users are coming to our website.

Some possible values for medium

  • organic search via Google search
  • ad click via Google ads aka cpc
  • referral via one of the many sources that have links to our website (eg. facebook, linkedin, etc)
  • email that we have sent to them

Title: Website Weekly Traffic by Medium

  • Widget Type: Line chart
  • Period: Inception till date
  • Purpose: Shows the number of weekly users visiting our website by medium. This tells us how our users are coming to our website over a period of time. The values of medium is similar to the above.

Title: Website Traffic by Medium by Country

  • Widget Type: Grouped Bar chart
  • Period: Inception till date
  • Purpose: Shows the number of users visiting our website by medium and for each medium which country are our users coming from.
💡 The country dimension would have to be limited given the large number of countries. If users would like to get the full list of country by medium, they should do so in the table view where the data is stored and easily do a pivot to get a full list of the sources in relation to users

Website traffic in relation to source widgets

Google Analytics in VAL

💡 For source, we typically will restrict the widgets to just the top 5 or specific sources we are interested in. The reason behind this is that the list could get very long. If users would like to get the full list of sources, they should do so in the table view where the data is stored and easily do a pivot to get a full list of the sources in relation to user traffic.

Title: Website Traffic by Source (top 5)

  • Widget Type: Pie chart
  • Period: Inception till date
  • Purpose: Shows the number of users visiting our website by Source. This tells us how our users are coming to our website, is it through a specific site such as linkedin or twitter, etc.

Title: Website Weekly Traffic by Source (linkedin, facebook, google ads)

  • Widget Type: Area chart
  • Period: Inception till date
  • Purpose: Shows the number of weekly users visiting our website by source. This tells us how our users are coming to our website over a period of time.

Title: Website Traffic by Source by Country

  • Widget Type: Grouped Bar chart
  • Period: Inception till date
  • Purpose: Shows the number of users visiting our website by source and for each source which country are our users coming from.
💡 The country dimension would have to be limited given the large number of countries. If users would like to get the full list of country by medium, they should do so in the table view where the data is stored and easily do a pivot to get a full list of the sources in relation to users

Top 5 traffic widgets

Google Analytics in VAL

Title: Top 5 days with highest website traffic

  • Widget Type: Table
  • Period: Inception till date
  • Purpose: Shows the top 5 days that have the most website traffic

Title: Top 5 sources driving website traffic

  • Widget Type: Table
  • Period: Inception till date
  • Purpose: Shows the top 5 sources that have directed website traffic to us

Title: Top 5 countries with highest website traffic

  • Widget Type: Table
  • Period: Inception till date
  • Purpose: Shows the top 5 countries where users are from

Derived Insight

So what does all these different visualization tells me?

All of the above quantifies the traffic you are attracting and also where these users are coming from. A couple of questions and actions might arise from here:

Are the top sources and medium expected?

  • If not could there be a potential new source and medium that might become a new target?
  • If not, are we doing enough or being effective in the source and medium to draw attention to our site

Are the countries, whom we are targeting?

  • Are there any anomalies that can indicate both an opportunity or a lack of marketing attention.

This is a very basic step on how basic traffic data can help with assessing marketing initiatives effectiveness. As we progress through the next few blogs we will touch upon more metrics in google analytics and how we can mesh the data with other analytics sources and calculate metrics that help us.

In our next post, we would be looking into the (data analytics from the sources)[https://www.thinkval.com/MARCON-104/] and give you a basic run thru of the analytics involve with attracting and increasing traffic.

Till then have a 🎉 good weekend!

With regards on how to perform the pivot, check out the video on how to perform the pivot in VAL.

If you will like to get your hands on the above data and dashboard, signup for VAL and we send you an invite to your email to join the demo environment. So signup now

If you want us to help you create the base to get started, fill up our short questionaire or reach out to us at friends@thinkval.com. We would do that for you at no extra cost.


About the author

Melvin is the founder of ThinkVAL. He believes that everything has to be done with a purpose and an intent, thats the only way to create true value.