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:

• A google Analytics account
• AdWords account
• Connect your Google analytics account with your AdWords account

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.

What insights can we get with this dashboard?

[Read more…]

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.

What insights can we get with this dashboard?

[Read more…]

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.

Watch it on YouTube

If you prefer, you can watch our demo in YouTube, otherwise you can follow a step by step guide below. Let’s start.

Access source file in Power BI

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.

[Read more…]

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.

So, all my efforts modifying my sites, are they paying off? Do I get new readers? Is my site growing?

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):

• The  column to the left represents the actual number of sessions this year, month, week  up to yesterday’s date, yesterday and today’s date
• The middle column represents the number of sessions last year at the exact same Week Day. For example, if today is 2015-12-02, this column will give the number of sessions up to 2014-12-01 (the day before)
• The column to the right represents the growth in percent.

NOTE: Why I am using Yesterday’s date instead of Today’s? Check the end of the post for the answer.

What insights can I get from the dashboard?

[Read more…]