How to Get Into Big Data Analytics

by Eric Tsai

How to Get into Big Data Analytics

Albert Einstein once said “information is not knowledge” and data without context is just organized information.

In essence, data is just people doing stuff.

The true value of data is far beyond obsessions with key performance metrics.

For most businesses, it’s about extracting insights to create value that has the potential to drive innovation to improve products and services.

In fact, more companies are shifting their focus from traditional business intelligence (BI) to predictive analytics – using historical data to predict future events.

Understand the World of Big Data

To put things in perspective, according to IBMwe create 2.5 quintillion bytes of data – so much that 90% of the data in the world today has been created in the last 2 years alone.”

There is so much data coming in at such a high velocity in all types of complexity that this phenomenal we called big data is now a problem for most businesses.

In fact, there are so many challenges in dealing with big data that it’s often hard to process let alone understand.

This is especially true for any business that engages with digital advertising or online marketing.

This is why it’s important to maintain focus on business objectives in addition to all the online marketing tactics because like the author of the book Antifragile, Nassim Taleb wrote, “We’re more fooled by noise than ever before, and it’s because of a nasty phenomenon called “big data.” With big data, researchers have brought cherry-picking to an industrial level. Modernity provides too many variables, but too little data per variable. So the spurious relationships grow much, much faster than real information. In other words: Big data may mean more information, but it also means more false information.”

It’s meaningless if we have the means to analyze the data but the data is wrong to start with.

And of course we also need reliable data which is exactly why Samuel Arbesman, the author of The Half-Life of Facts, encourages us to start thinking about long data.

The point is that whether you’re doing marketing or product development, we need reliable data to help us make better decisions.

How to Get Into Big Data Analytics in Online Marketing

Just like you wouldn’t expect a musician to compose a song without a tune, or a restaurant to open without a menu, you can’t expect to develop a strategy or execute a tactic using data without knowing what you want to achieve.

This is at the core of any data-driven performance marketing – makes decision based on analysis to prove or disprove hypothesis.

It’s about running tests, collecting data, analyzing results to find the story the data seeks to tell.

If we’re going to become better in performance marketing, we also need better tools and processes transform big data into smart data.

Here are 7 ways you can get into big data analytics.

1) Focus on Business Objectives

Don’t collect data because you can, collect data because it’s necessary. Identify the core problems that have to do with meeting business objectives.

Speak the right language to the right people as different stakeholders in business have different goals that they focus on.

If you’re focusing on impressions, clicks, CTRs, and CR, and the person you’re dealing with only cares about ROI, CPL, and CPA you’re going to have a hard time communicating your value.

Learn to translate your data into terms that’s tailored for your audience.

2) Understand Business Infrastructure

Realize that you will need to understand technical infrastructure such as web hosting, data warehousing, and how data flows in and out of business infrastructure.

In addition, recognize that every business utilizes a variety of applications behind the technical infrastructure.

So make sure that you have some basic knowledge of how each of those applications work and what other tools are available to help you integrate more useful t data.

3) Take the Data Science Approach

You need a multitude of skills to stay at the top of your game, but most importantly you need to become a data scientist. This means investing in learning more about statics, analysis, experimentation, and data visualization.

These skill sets are now in high demand as big data proliferates.

Data scientist is about performance marketing, you need to be the one leading the charge in research and delivery of business intelligence.
Ensure your data integrity will be tremendous for segmentation and optimization.

4) Integrate the Entire Conversion Journey

In the search engine marketing world, a conversion means either a sale or a lead. KPIs such as CPL (cost-per-lead), CPO (cost-per-sale), AOV (average order value), or even ROI are typically what SEMs deliver on the frontend.

However; few SEMs talks about lifetime value or backend conversion metrics that enables you to get a clear picture on the full conversion funnel.

For example: if your frontend click-to-lead CR (conversion rate) is 10% at a $30 CPA (cost-per-acquisition) but your backend lead-to-sale CR is 20%, your actual click-to-sale CR is actually just 2% which means your CPA is actually $150.

All businesses want to know their true return on their marketing dollars; this is why if you don’t have the backend data integration, the frontend data can be very misleading.

And if you have the right data integration, you can proceed to optimize towards the most important KPI, which often times is NOT the frontend metrics.

This applies to offline data as well since TV, radio, print, or even billboards can drive traffic to your website, it’s important to take those media cost into consideration. And don’t forget about other cost of sales attributes such as call center or cost from other channels.

5) Leverage Web Analytics

web analytics is a great place to start your data journey. It tells you where people came from, where they clicked, how long they stayed, what pages were visited, and a whole lot more.

Web analytics puts context to your visitors to your site by adding behavioral data that reveals intent. Someone that searched on a branded term will most likely act differently than those that did not. The same applies to the length of the query.

In fact, even Google uses real human raters in addition to its algorithm to rate content because real human experience is what Google’s search engine tries to mimic.

6) Tell a Story via Data Visualization

Human beings are hardwired to pay attention and remember stories more than anything else. And we all know that a picture is worth a thousand words.

So what’s better than translating your data into graphs or diagrams to help you narrate your story?

The idea of you presenting the data is not to confuse your audience but to communicate fully the integrity and the meaning of your analytics so they can understand it, and take action against it.

Storytelling in the context of data visualization depends on how you balance the visual narrative against your target audience’s ability to discover and interpret.

If you’re to produce great data visualization, I highly recommend that you take a look at Edward Segel and Jeffrey Heer’s paper called “Narrative Visualization“, in which they’ve identified three distinct genres of narrative visualization.

7) Start Predictive Analytics

A great example of predictive analytics being deployed can be seen in Google’s Instant Search. It predicts what you’re trying to search before you finish typing to save you 2-5 seconds per search, guide your search, and load search results instantly as you type.

In fact, predictive analytics are what’s powering recommendation engines of companies such as Netflix, Facebook, Amazon, LinkedIn, Match.com, and more!

These predictive analytics are often utilized as conversion optimizing features inside products, such as ad targeting, recommendations, personalizations, and more.

It may sound far beyond our ability to predict the future, but the truth is that predictive analytics is about identifying and exploiting patterns.

The first step is to understand how to leverage techniques in statistics, modeling, and programming.

However; you can start by doing simple projections or forecasting then gradually move into more sophisticated techniques.

You don’t even need anything fancy, just some basic Excel skills will do to get started.

The Take Away: Big data analytics is here to stay.

One of the most fascinating things I get to do at work is to look at data from SMBs to Fortune 50s.

We try prioritize our decisions to spend our client’s investment based on data because it’s what we do – performance marketing.

I can’t stress enough the importance of statistics and its supersets econometrics and data science in solving real life problems.

Great online marketing strategies aren’t just about the tactics on traffic acquisition or conversion rate optimization (CRO); it’s about getting the most out of your marketing dollars.

It requires you to understand the connection between your marketing activities and the broader business objectives.

By integrating rich, relevant business data and powerful analytics, big data allows businesses to quickly assess emerging trends, identify correlations, and take meaningful actions.

How to Find Customers Online Using Google and Twitter

by Eric Tsai

The three most important elements when starting out with marketing on the internet is to 1) define success and 2) know your target audience 3) listen to your customers.

Once you form a foundation for your web strategy, the execution becomes easy. The goal is to constantly test and use different campaigns from Search Engine Optimization (SEO) to email marketing in an attempt to achieve business objectives.

I often hear business owners talk about wanting to increase sales and generate leads but fail to define what success look like to them. In order to define success, you must first realize your current state of business from an analytical and financial perspective.

Do you have any existing data to help you take the pulse of the business? What kind of financial (Return on Investment or ROI) and non-financial (business impact) objectives and metrics are available?

Without real knowledge of your true costs, you run into a potential misconception of what your real ROI is.

Understand that ROI includes not just how much you pay for web hosting or your overheads, but also other costs associated with running the entire campaign such as, cost of time working on the campaign (broken down into average hourly wages), amount of labor burden costs (cost consisting of all indirect labor costs incidental to operations), SEO costs (monthly or accordance with your budget), email marketing costs, technology infrastructure costs etc.

Understand Your Costs and Metric

Once you have a true total cost of you running the campaign, you can run those numbers against your traffic and sales conversion rates to identify your ROI.  Here is an example of how you can create a simple metric chart:

sample social media metric

Assuming I get those numbers, with a quick glance the data shows that by spending 3 times amount of money on this campaign, the result returns 8 times more sales with the cost per sale reduced by more than half. This is a high level overview to help you define your goals for each metrics. Again, watching your real cost of the campaign will bring clarity to your true profitability.

Using Google and Twitter to Identify Your Customers Online

Once you define your goals and know what success looks like, the next step is defining your customer profiles then search for them online.

For starters, you should at least know the age demographic, income level or occupation. After you know who your typical customer looks like, you need to find where they are online and what they’re talking about to get a step closer to engage them.

This is where you should be looking at using some free online tools to help you gather useful data.

Let’s look at using a combination of Google and Twitter to find your customers. As an example, I’m going to assume that you own a local retail apparel store and you want to drive traffic to your store.

First you should come up with a list of keywords that people are searching on Google.  The simple and fast way to do it is to use Google Keyword Tool and Google Insights for Search.

Google Keyword Tool

Google offers the keyword tool so you can search and find what popular keywords people are searching around your products or services.  I’ve used the keyword “evening wear” and as you can see, it returned all relevant keywords and the volume of searches for the past 12 months.

Feel free to make adjustments to show the data in different ways (I’ve sorted the list by Local search volume) and how much people are paying for those keywords.

Google KeyWorld Tool

There is no doubt that “evening wear” is the most popular keyword locally. This indicates that most people simply put in the keyword “evening wear” so if you want to target a narrower range like “evening wear tops” you will have less competition for the same keyword.

Click on Add and you can create your list (will be displayed on the right) and when you’re done adding, you can export the entire list in text or excel format.

Google Insights for Search

Once you have a basic list of keywords, head over to Google Insights for Search to compare search volume patterns across specific regions, categories, time frames and properties.

Now you can take popular keywords you’ve found and insert them into the search term area, and you’ll find more information about your keywords.

Unquestionably the keyword “dress” out paced all other keywords I’ve insert (evening wear, women’s shoes, handbags).

And you’ll also find that New York is the place where people search most for dresses.

Google Insights for Search

Play around with the different settings and you can also export the results in excel format.

Google Wonder Wheel

The Google Wonder Wheel was introduced to simplify and arrange search results. It’s basically a pre-defined mind mapper which helps the user get all the related search results in a wheel shaped like display.

Simply go to Google.com and input your search term, click on the “show options” link and find the “Wonder Wheel” link on the bottom left to get your search terms mind-mapped.

Google Wonder Wheel

Google Wonder Wheel

Once you get to the Wonder wheel, you can explore around the related keywords and it’ll expand into another wheel.

Google Wonder Wheel

I went ahead and clicked on the “discount evening wear” and the most popular and relevant keywords associated with discount evening wear shows up.

This is another great way to narrow your search term down to what your customers may be looking for in order to personalize the message.

Google Wonder Wheel

So if I’m running a promotional campaign or sending out newsletters, I could use content such as:

“Discount designer evening gowns perfect for cocktail parties or formal events!”

Or combine with my findings from Google Insights,

“A night out in New York? Checkout our discounted cocktail dresses from BCBG! Available in plus size directly from Macy’s.”

Combining Google with Twitter

Since Google have no problem indexing Twitter’s data, you can now use Twitter’s search engine to find you target customers using keywords as well as conversational phrases.

First go to search.twitter.com and click on advanced search and start looking for conversations phrases around what people would say when they’re looking for clothing.

The example below shows a search for people saying “what should I wear” within 100 miles of Los Angeles, CA.

You can also leave it blank for broad search to view everything around the world, perhaps you have an online store so tracking both local, geo-targeted search and broad search make sense.

Twitter Search

As you can see, the search result would return a stream of conversations with people saying “what should I wear.” You can take a moment to scan over the conversation, perhaps follow those individuals, checkout their profile and “listen” in on their dialogues.

However, you don’t want to spend all day reading people’s conversations, and searching for the same phrases every time.  This is where Google Reader comes in handy. Google Reader is a great tool to aggregate all your RSS feeds into one place and it also has some analytical capabilities.

On your Twitter search results page, find the RSS feed icon on the top right hand corner, right click on it and copy the link address of the feed.

Twitter Search

Then open your Google Reader and click on “Add a subscriber” and paste the link into your Google Reader to start building a collection of feeds around your target search phrases.

Google Reader

Once you’ve added the feed into your Google Reader, wait for a couple of days for the data to aggregate before you can start analyzing it (ideally you want to have at least 30 days).

You can start checking the data by clicking on “show detail” on the top right hand corner.

Google Reader

You’ll see data for the last 30 days, time of day and day of the week.  Depending on how you look at it, you can see which day of the month people start talking about your search term.

Maybe it’s the end of the month, everyone got paid so a discussion about shopping starts; or perhaps everyone goes out on Thursday evening in LA so on Wednesday people are talking about what to wear for Thursday.

The time of the day is a good area to gauge when these people log on to Twitter to talk about your search term.

Google Reader

Another good use of these data is to figure out when to send out your coupons, promotions and newsletters so your message arrives when people’s minds are on your product or service.

Remember, personalized messages delivered at the right place at the right time are key ingredients to conversion.

Search Twitter Profile Using Google

Another method to find your target customer on Twitter is to search through people’s Twitter profile using Google.  Go to Google.com click on advanced search and put in

intext:”bio*love shopping”

and you’ll find a list of people that indicated they “love shopping” in their bio on Twitter.

Basically intext:”bio*xxxx” tells Google to search for text within the Twitter bio section. So replace xxxx with whatever you like that matches to what your target customer may put in their Twitter bio.

Search Twitter using Google

Now that you know from your Google Insights that shoppers in New York have the most interest in searching for dresses, how do we target people who loves to shop and lives in New York?

This is what you put in

intext:bio-*-love shopping intext:location-*-NY

Search Twitter using Google

Notice that there is a minor tweak to the search input. You will need to add – in between the * mark.  So intext:bio-*-xxxx intext:location-*-xx where the xx is now searches within that state.  Give it a try and you’ll find extremely targeted individuals

I don’t usually do detailed step by step posts, but I had repeatedly explain this to many business owners and marketers so I  thought to share some of my tips to help you find your customers online.

I hope you find the above information helpful and it’s a very useful way to build your customer segmentation list.

I hope this helps you to set up your social media “listening station.”

And if you like to learn more tips like this, sign up for Profitable Knowledge FREE course below!