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

2 weeks into 2019, and a new world record has already been set - by an egg. Meanwhile, Gillette shaves away the weight of hyper-masculinity with its refreshing take on the "Me Too" conversation. We take a look at the unexpected newsfeed domination ...

Read More

Early 2019 Waves: Gillette Says #MeToo, and the Record-Breaking Egg

Sophia Ng
written by

Sophia Ng

17 January 2019

Marketers agree - the best way to improve customer lifetime value (CLV) is to make better use of data (Criteo). On the other hand, storytelling is now a fundamental part of brand communications and marketing. In a study by Origin/Hill Holliday, ...

Read More

Next in 2019: Data and Storytelling Converge

Jan Mascarina
written by

Jan Mascarina

15 January 2019

We look back at 2018 and go, what a year it's been for the digital landscape! From changed in the way technology helps us market to audiences, to volatility of users reacting to these changes, we take a look at the trends in 2018 that have had and ...

Read More

Important Digital Advertising Developments in 2018.

Mustaali Marvi
written by

Mustaali Marvi

02 January 2019