Web Analytics Hub

Analytics for Growing Companies

Pravin Singh

Tableau vs Looker vs Domo – The Top Enterprise Business Intelligence Tools

By Leave a Comment

The sale of Looker for $2.6 billion to Google and Tableau for $15 billion to Salesforce early this year is a clear indication of the power of data visualization in Enterprises and the need of packaged Cloud Business Intelligence (BI) services. 

It is a recognition that most people are often better able to process large amounts of data visually than in other ways, and that the insights from those visuals are worth serious money.

The competition in Enterprise Business Intelligence Tools just keeps evolving and that actually makes life difficult for Enterprise decision-makers in finalizing a tool.

[Read more…] about Tableau vs Looker vs Domo – The Top Enterprise Business Intelligence Tools

Why you should not focus on your Conversion Rate

By Leave a Comment

Finally, a video post here, where I explain some very basic pointers on why not to focus on conversion rate.

Yes, you heard that right. And I’m saying this knowing that a 0.01% increase in this metric can help you gain an extra million dollars or much more.

The main reason for this video is that I’ve had multiple E-commerce clients and potential clients of mine come to me with a Conversion rate obsessions and for CRO work (Conversion rate optimization) – now we don’t exactly help in CRO, but we definitely help in understanding your customers and your marketing process deeply via our Marketing and Customer analytics offerings, which eventually improves bottom line and has a long-term picture in mind.

 

[Read more…] about Why you should not focus on your Conversion Rate

Website Traffic Analysis Reports & Templates

By 14 Comments

Traffic.

The one word that every website needs, craves for, cannot live without at all times.

Over a billion websites and the number keeps growing exponentially daily. From personal branding to consulting to business to companies to every other thing, there is a website out there for almost everything now.

This post is mainly driven towards websites that have a good amount of traffic and there are multiple solid sources. This could be anything in and above the range of 10,000 – 30,000 monthly visitors approximately. Anyone in and above this range must perform traffic analysis and know their exact traffic sources, analyze them and use that to create business goals, traffic strategies for the future (many more reasons ahead on why to do this below)

Now if “traffic analysis” seems like a lot of work, we are here to break that myth and give you three awesome ready-made templates from Supermetrics that you can instantly plug and play!

Hold your horses before we jump to the templates now!

Before doing any type of analysis, we should be aware of the WHY behind it, so let’s dig into that quickly.

[Read more…] about Website Traffic Analysis Reports & Templates

How Website Speed Impacts Ecommerce Revenue and Analytics

By 2 Comments

E-commerce websites are one of the most popular forms of e-business. As online stores get three times the growth rate of their brick-and-mortar counterparts, many traditional retailers expand into online sales. This makes the competition nothing short of fierce.

How, you may ask, does one stand out among such competition?

This is where we talk about website speed. Speed might not be as important as content, but it is still one of the largest predictors of website success. More importantly, website speed is a factor few website owners are aware of.

And an important factor it is. If your store earns $100,000 a day, just one second of delay in page load times eats away $2.5 million in revenue over the course of a single year.

[Read more…] about How Website Speed Impacts Ecommerce Revenue and Analytics

Yaguara Product Review

By Leave a Comment

You are a data-driven E-commerce company working hard to scale with your Objectives.

Your data is scattered in multiple places and you are facing issues in integrating it all in one place so as to focus on your Key Results

You are not able to track your growth metrics as well as you’d like.

You are not able to communicate to your team on exact metrics/goals to follow daily/weekly/monthly along with their work so that they are aligned with the Objectives and Key Results.

You don’t have a clearly-defined strategy or approach in looking at your KPIs in connection with your Top Business Goals.

If the above statements describe you and your business, you are at the perfect place, read on to find a solution to your problems!

I’ve used a plethora of Data products and written about quite a few Dashboard tools on my blog by now. But, there was always a disconnect between graphs, visuals, reports, visualization to the Actual business outcomes.

There is a new tool in the market that I got to personally check out and play with a few data sources, the UI and much more that aims to solve this exact disconnect.


[Read more…] about Yaguara Product Review

My Personal Set of SQL Learnings & Toolbox

By Leave a Comment

SQL Learning

Structured Query Language

In most cases, this is the first thing that any person involved in the data world learns apart from the usual Excel & Spreadsheets.

Over the years, I’ve personally used SQL extensively and it’s the one language I truly understand and use almost every week in and out.

It’s used in ad-hoc analysis, reports, dashboards and any type of backend or database activity that I’m doing.

MySQL. PostgreSQL. Microsoft SQL. Amazon Redshift.

Almost used most of the forms out there including the most popular ones above, they all have similar syntax but differ in certain specifications across the board.

I realised there are many repetitions of code snippets or logic that’s happening and I was wasting time in the same over and over again. This made me start a simple note file called “SQL Learnings” so that I can go back and refer to it anytime I need it.

And now, that it has enough notes and learnings, I’ve decided to make it public on this page and

Keep updating it as soon as significant additions are made.

Some of my learnings are code-based/syntax based, some logic based and some on very basic stuff for my own reminders/mistakes done in the past.

Note: This whole set of learnings was made for one sole reason, to help yours truly here in repetitive work and to have one resource to go to.

I would highly recommend everyone to create their own lists so as to help them and reduce re-work every time they start working.

SQL Learning


[Read more…] about My Personal Set of SQL Learnings & Toolbox