The Construct Way: How We Use Data To Drive Insights.

Our data team shares their methodology from a recent campaign.

You've probably seen us talking a great deal about how our data analytics services can help you, but you may not know that we use our own services as well! On a regular basis, our analytics team brainstorms and experiments on Construct’s data, and if it works well, we bring it to our clients.

Today, we will cover how we turned parts of Google Analytics data into actionable market intelligence for our internal marketing team.

What is Google Analytics?

Google Analytics, known in the industry as GA, is a free “service that provides statistics and basic analytical tools for search engine optimisation and marketing purposes” (source). There is a wealth of information within GA; with tabs that lead into menus that lead into sub-menus, this can feel overwhelming.

Since we deal mostly with customer analytics, we get most of our data from the “Audience” and “Behaviour” tabs. Using this data, we can help our clients identify and segment their customers, figure out where their leads come from, and build propensity models based on behaviour (among many other things).

For this internal campaign, we wanted to explore mobile device data in particular, so we analysed data from the Audience -> Mobile menu.

 

Mobile Device Intelligence

Before we dove into the data, we had a few questions we wanted to answer:

  1.  Which mobile device companies hold the largest market-share in Singapore?
  2.  How much are Singaporeans investing on their mobile devices?
  3.  What screen resolution is most prevalent? What screen size?

So, what? You can train anyone that knows their way around a keyboard and the internet how to get this information; the real value comes from the time we save through automating the process and knowing what information and intelligence you can derive from the information.

Using this information, here are some examples of the intelligence we can gather:

  1.  If Apple is market leader, optimising for Safari’s HTML5 should be a priority over Flash or JavaScript
  2.  As an app developer with the bandwidth to only design for one app market, should you design for the App Store or Google Play Store?
  3. For a long time, 1024 x 768 was the gold standard for basic website design (source 1, source 2). Is this still the case? Does this hold for Singapore?
  4.  The smartphone industry continues to produce larger phones each year. Is there truly a demand for this? Are people opting for these large phones?

construct digital data

Our Data Methodology

In order to ensure we could generalise any conclusions we made to the population, we needed as many data points as possible. To accomplish this, we pulled numbers across a 6-month timeframe from our data, giving us millions of sample points and hundreds of mobile devices.

In addition to the GA data, we needed to supplement this data with details about phone screen size, screen resolution, and retail prices. We got this information from the mobile devices from industry leader GSMArena. Recall from our last blog post on ethical web scraping that we should check if we are allowed to scrape this pricing information. After verifying from their robots.txt page that we could mine their site data, we ran a Python script to obtain the prices we needed.

Once we had enriched this information, we needed to assign weights to balance out differences in quantity between sources and devices. After detailed research, we utilised a technique called stratified sampling to achieve this. For a thorough explanation of how we did this as well as a copy of our Python script, please refer to our GitHub page.

With the weighted numbers, we visualised everything on a downloadable infographic content and an online Tableau, which you can view in our downloadable content here.

 

Data @ Construct

This is just a small glimpse into the types of analysis and insights we can derive from Google Analytics. As we mentioned earlier, we can combine this data with other data from GA or other sources and derive further insights or build predictive models that can help improve campaign performance and increase revenue.

To find out more about other ways GA can help your business, or how we can help you solve some of your other problems (such as creating and managing your data pipeline, deriving insights from customer data, and predicting sales decisions from your sales data), drop us a line for a chat. We’re friendly. Promise.

Singapore Mobile Browsing Statistics


Additional Reading:
  1. https://marketingplatform.google.com/about/analytics/

  2. https://medium.com/analytics-for-humans/what-is-google-analytics-and-why-is-it-important-to-my-business-8c083a9f81be

  3. https://www.surveygizmo.com/resources/blog/what-is-stratified-sampling-when-is-it-used/

  4. https://onlinecourses.science.psu.edu/stat506/node/27/

Posts by topics

Related Content

PREVIEW

Digital marketing is set to be the new standard for marketing, and with that comes the perks of a never-ending stream of new tools and technologies to constantly optimise marketing processes and performance. That said, not every tool needs to come ...

Read more
PREVIEW

The good marketers would know that Call-To-Actions (CTAs) should come in the form of buttons. But the even better marketers know that simple buttons just don’t cut it in some use cases. Here are some of the different formats CTAs and their ...

Read more
PREVIEW

We cannot emphasise enough on testing your Call-to-Actions (CTAs). As well-crafted your CTAs may be, only real world testing can determine the actual performance of your CTAs, based on how your audience reacts to them.

Read more
PREVIEW

You must have heard some cardinal rules for crafting killer call-to-actions (CTAs), like ‘Don’t dilly-dally’, or ‘Be direct with your offer’. Sound advice, especially when you’re dealing with readers with little time to spare for reading, right?

Read more