Home »
Home > Tutorial
New Google Analytics SEO Reports
For some time now webmasters have been able to access data from Google Analytics via their Webmaster Tools accounts – for example the Search Queries report in Webmaster Tools has the ability to pull in Google Analytics data and graphs.
Now Google has merged Google Analytics with Webmaster Tools even further – so this works the other way too.
Even more Google Changes – First Look at Google Analytics Real-Time Reporting
Google Analytics users can access data from Webmaster Tools – including number of impressions, average position and clickthrough rate (CTR) – the result of which is some pretty nifty reports that will be of enormous benefit to SEOs.
For some advanced SEOs some of this was already possible through hacks using very clever custom filters – but providing this data as part of standard reports will open this up to non boffins and allow for more powerful and flexible data analysis.
This post provides a step by step tutorial on the new SEO Queries report (which we think is by far the most useful). We’ll be updating our Google Analytics and Advanced Google Analytics courses to include all of the new SEO reports by the way!
How to Link Google Analytics with Webmaster Tools to Access SEO Reports
Before we look at the new reports – we’ll need to link Webmaster Tools and Google Analytics so that the data can be shared.
If you don’t already have Webmaster Tools AND Google Analytics – read our guides on how to create accounts:
OK – so assuming you have your site set up with both Google Analytics and Webmaster Tools – here’s how to link them together:
1) Log in to your Webmaster Tools account – you’ll see a list of the sites you have Webmaster Tools installed on (or just one – if you only have one site)
2) In the Manage Site drop down next to the site you’re interested in, select Google Analytics Property
3) You”ll now see a list of all of the sites you have Google Analytics installed on (or again just one – if you only have one) – so select the correct site from the list and then Save at the bottom
Done! Now you should be ready to start seeing the new reports…
New SEO Reports in Google Analytics
OK – so we’re all linked up and ready to rock. Let’s find the new SEO reports…
It’s worth mentioning at this stage that you’ll only see the SEO reports in the new version of Google Analytics – so if you haven’t already – hit the New Version button in the top menu bar
Now you’ll see the new interface, with the new SEO reports included. You will find these under Traffic Sources > Search Engine Optimisation
So – let’s have a look at the new SEO Queries report, what we can learn from it, and how we can make the data useful to us.
How to use the New Google Analytics SEO Reports: Queries Report Tutorial
We’ve always been able to see data on the number of visits particular keywords generate, how many pages people visited, how long they stayed, bounce rate etc…
By adding the Impressions, Average Position and Click-through Rate data from Webmaster tools – we can now also tell how many people saw your site appear in the SERPs for each keyword, where it was appearing (on average), and what percentage of people clicked on the link (Click Through Rate).
Read the rest of "Google Analytics linked to Webmaster Tools for SEO Reports – Queries Report Tutorial"
Read more
Posted by Aaron Charlie in Google Analytics Training on October 6th, 2011 | 2 Comments »
Part 2.2: Adding Other Images to your Web Page
To add images into the main body of your web page you should use the same technique described above. All this is covered in our comprehensive Dreamweaver training course in Brighton, Sussex.
Place the text cursor where you wish to insert the image and select ‘Insert > Image’ from the menu. The same adjustments to the ‘H Space’ and ‘V Space’ can be made by adjusting the values in the ‘Properties’ panel.
You can also align your images to the right or left of your text. When you insert an image into the text it will probably similar to the image below:
You can align your images so the text flows all around them. To do this, select the image by left clicking it once. In the ‘Properties’ panel you should see a drop down menu entitled ‘Align’, it should be set to ‘Default’. Click the drop down menu and select ‘Left’.
The image should be aligned to the left with the text flowing around it like the image below:
To align the image on the right, select ‘Right’ from the ‘Align’ drop down menu in the ‘Properties’ panel.
Adjust the ‘H Space’ and ‘V Space’ values until you are happy with how the image displays.
When you are happy with the images you have added, save and publish your web page.
You should always test the changes you have made by pointing a browser at your site. Different browsers (Internet Explorer, Firefox & Opera are a few examples) sometimes display the same web page slightly differently. You should test your web page in as many browsers as possible to ensure that it displays correctly in all of them
Read more
Posted by Aaron Charlie in Dreamweaver Tutorial on March 16th, 2009 | No Comments »
Microsoft Excel Workbooks are made up of Spreadsheets. A Spreadsheet is organised into rows and columns of cells. The columns lettered and the rows are numbered. These numbers and letters combine to give each cell an address (e.g A1). All of this is covered in our Beginners Excel Training Course in Brighton, Sussex.
The contents of each cell can be entered via the formula bar. This is divided into two parts: the left side of the formula bar shows the cell address, and the right side shows the information that the cell is holding. If you can’t see the formula bar, select the “view” tab in the top menu and click the formula button in the show/hide section.
You can also see the total, mean, maximum or minimum of any numbers or cells by highlighting them and looking at your status bar. This is located at the very bottom of your excel window. If you wish you can also change the information the status bar gives by right clicking on the status bar and choosing its options in the Customise Status Bar Menu.
Excel Status Bar
Read more
Posted by Alistair Wylie in Excel Training on May 1st, 2009 | No Comments »
The first thing that you will need to learn is how to move around a Spreadsheet. One way of doing this is to use the arrow keys on your keyboard to highlight a particular cell. The highlighted cell has a thicker black border than the others. Using the arrow keys you can move the selected cell up, down, left or right one cell at a time. You can also use the page up or page down keys to move a whole page at a time. All of this is covered in our Beginners Excel Course in Brighton, Sussex.
It’s easy to lose track of where you are in a spreadsheet – at any time you can hold the “Ctrl” key the “Home” keys together to return the selected cell to the top left of the sheet (cell A1). If you are new at this then it is worthwhile practicing this for a few minutes before continuing so as to get a better feel for moving around.
For a quick and easy way to locate a cell press the F5 key. This will open the “go to” box, where in you can enter the address of the cell that you want to go to, and be taken there immediately. Alternatively, you may find it easier to use the left part of the Formula bar at the top of your spreadsheet. Just type the address of the cell (e.g A1 or C4 etc…) and press enter
Read more
Posted by Alistair Wylie in Excel Training on May 1st, 2009 | No Comments »
Most spreadheets have some sort of formatting applied to them to make them easier to read and understand. Often you will want to create a border around a group of cells to differentiate them from others, or to put them in to a table.
There are two main ways that you can create a border in Excel.
The first is to draw the border using your mouse. You can draw a border along any cells you wish either horizontally or vertically. To do this: select the “Border options” button from the ribbon; this is the small arrow to the right of the actual “Border” button. This will display a list of options – click on the “Draw Border Line” option in the lower section of the list under the heading “Drawing Borders.”
With this option selected, your mouse cursor will become a pencil. You can now create borders by pressing and holding the left mouse button from where you want to start and dragging it to where you want it to end. You can either create a straight line or drag around a group of cells to draw a box around them.
If you want to draw a grid within your box use the “Draw Border Grid” button beneath the “Draw Border Line” option you used before.
All of this is covered in our Beginners Excel Training Course. Once you have mastered these skills you will be ready to attend our Advanced Excel Training Course, and really advanced might want to try VBA for Excel in Brighton, Sussex.
Read more
Posted by Alistair Wylie in Excel Training on May 6th, 2009 | No Comments »
As with all Microsoft Office products, Excel 2007 has a range of keyboard shortcuts to make a lot of the tasks you will undertake regularly quicker and easier.
As a little bonus – here’s a list of some of the most common ones:
General
Open a Workbook Ctrl + O
Create New Ctrl + N
Save a Workbook Ctrl + S
Print a Workbook Ctrl + P
Close a Workbook Ctrl + W
Help F1
Run Spelling Check F7
Editing
Cut Ctrl + X
Copy Ctrl + C
Paste Ctrl + V
Undo Ctrl + Z
Find Ctrl + F
Replace Ctrl + H
Select All Ctrl + A
Formatting
Bold Ctrl + B
Italics Ctrl + I
Underline Ctrl + U
Open Format Cells Dialog Box Ctrl + E
Read more
Posted by Alistair Wylie in Excel Training on July 27th, 2009 | No Comments »
