Learn how to grow your business with your data and Power BI
Do you want to follow the Olympics on your mobile and set alerts that will notify you when important things happen?
Scroll down to view a live explanation of the video as well as download the power bi file.
If you would like to see a live version of the dashboard, you can watch it in our YouTube Channel, but if you prefer text, continue reading.
In this tutorial I will show you how to track your AdWords performance using the data available in Google Analytics.
To be able to recreate this dashboard you need:
This dashboard is the first part of a series of blog posts on how to track and improve AdWords performance.
In Part 1, we will start tracking our Ads to understand which ones are performing well and which ones we need to: either cancel or modify.
On coming series, once we have identified which Ads are underperforming, we will learn how to modify them to increase their performance.
There are a lot of blog posts aiding people to get rid of referrer spam in Google Analytics and although they are effective, the spammers are usually one step ahead of you, and spam will find its way in your data.
It varies depending if you have a lot or a little traffic and whether spammers are targeting your site or if it is a random attack.
I wanted to find out how serious the problem was for some of the sites I manage, and here is what I found out using our growth dashboard:
Before removing the spam:
After removing Spam:
So, for this site 1% of the monthly growth is caused by spam…Not good right?
Ok, so how did I do that? Lets go through the steps and the new dashboard.
Did you know that when Bill Gates enters a bar, the average customer becomes a billionaire? That is what I call the Bill Gates Effect. (Many thanks to Introductory Statistics)
Pss! There is a Power BI dashboard at the end of the blog post, don’t miss it!
A business owner is trying to understand the average income of the clients in the bar next door so he hires a student to interview the customers.
When the student had finished the interviews and the analysis, the person with the highest income leaves the bar and Bill Gates comes in. Frustrated, he re-runs the analysis this time with Bill Gates data instead.
The student comes back to the business owner and reports that the average customer in the next door bar is a billionaire!!
Average income= $ 7 900 042 500
The business owner ask the student to show the calculations and after reviewing the data understands the ”mistake”.
If you are like me, you have probably stared at a white page wondering what your next topic should be on your blog. You have written about everything, what else could be said?
With our new dashboard, you will get help from your site visitors to get ideas on new topics. For creating this you need to have site search set up in your site.
Don’t, worry it is very easy to do.
Measuring content engagement is probably one of the most common actions performed by website owners.
There are a lot of indicators that can help you understand how engaged your readers are with your content, but I will show in this post, the power BI dashboard with the ones I use the most: scroll tracking and content grouping.
To be able to to build this website you need to: [Read more…]
If you want to reuse a power bi file you downloaded form Curbal.com, here are the steps to make it your own, depending on the source you have used.
If you prefer, you can watch our demo in YouTube, otherwise you can follow a step by step guide below. Let’s start.
Download the Power BI file and open it.
When you open the file, you will see a yellow ribbon letting you know that you have pending changes. Ignore it, it is only trying to refresh the sources.
Most businesses nowadays run blogs on their websites to attract customers that are searching for related information. Do you know how your blog pages are performing against your business pages?
In this post, I am going to show you how to categorize your content based on your Blog Pages and your Business Pages. I will add a third category as this site has also a Google Analytics Glossary, and I want to understand how that is performing against the other pages/categories.
I have been using Google Analytics for a few years now and it has been really useful to modify my websites so they are more useful to my readers.
Google Analytics helps you with the technical details, (screen size, speed, etc) with the behavioral details (pageviews, time on page, etc) and even with your traffic sources (social, organic, etc). Everything is geared so you can grow your site, but to see how much growth you are getting on a daily/ weekly/monthly or year basis, you need to do it manually.
I want to find out in one single click, how much my sites are growing, and I can finally do it using Power BI. My site growth in one click. Excellent! I will show you what you will create, so you can decide right now if this for you or not already now.
Here is the dashboard (see picture below):
NOTE: Why I am using Yesterday’s date instead of Today’s? Check the end of the post for the answer.
Do you want to see your AdWord’s stats in Google Analytics? How much traffic comes from AdWords? How to optimize your Ads based on how they perform once they land on your site?
To link your AdWords account with Google Analytics is very easy and can be done in a few steps: