Creating a Simple Analytics Dashboard – Part 2

In Part One of the two part series on how to create a simple analytics dashboard we discussed retrieving the overall site traffic.  In part two and final part, we are going to show you how to pull keyword level data and page level data.

We will go into depth in another post about how to analyze the data that is now in your simple analytics dashboard.

Part Two – Keyword, Referral, Page Level Data

1. In Google Analytics click on:
   1. Traffic Sources => Sources => Search => Organic
   2. Create a new tab in your Excel sheet that is title “Keywords”.  These are the keywords that you want to list in the Keyword Excel tab.
   3. You will need to export this data into Excel.  At the very least, you will want to include the keyword and visits for this basic dashboard.
2. In the Excel Sheet, Create a new tab called “Referrers”
3. In Google Analytics click on:
   1. Traffic Sources => Referrals
   2. These are the referrers that go into the Excel Sheet.
   3. You will need to export this data into Excel.  At the very least, you will want to include the referrer and visits for this basic dashboard.
4. In the Excel Sheet, create a new tab called “Pages Viewed”
5. In Google Analytics click on:
   1. Content => Site Content => All Pages
   2. These are the pages that are listed in the Excel Sheet
   3. You will need to export this data into Excel.  At the very least, you will want to include the pages and visits for this basic dashboard.

See how simple that was?  Now with part one and part two, you have your own simple analytics dashboard.