GA provides very useful GEO data in its demographic reports category. You can find traffic behaviour and conversion reports for continent, country and city based on ip addresses. However, what if you want to produce data for specific sales target territories like:
- North East England
- North West England
- Yorkshire and the Humber England
- East Midlands England
- West Midlands England
- East of England
- South East England
- South West England
The process I used is a long one but involves:
- Download data of top 500 city visits for a period up to six months
- Make a comprehensive list of the cities and their respective categories – a good use of juniors or interns.
- Create a custom report for each sales territory using explorer type
- Decide the metrics, dimensions and drill downs you want in the report as the field and
- Choose filter and enter the towns as regex (regular expression) with pipe symbol (|) to signify “or”
Now when you run the report only designated towns for the region will show and be counted. Phew!
The VLOOKUP function is a very useful excel technique to do a vertical “v” lookup in an array table and output the results next to the table you want. In Keyword research it can be used to look up a keyword rankings list and output result in a keywords search data table. The technique is explained by Richard Baxter at SEO gadget which also provides the enclosed example excel worksheet.
The trouble with setting REGEX in analytics is that you never quite know it’s working until you start receiving data. This can take 24 hours after which you may need to change the REGEX again remembering settings each time. Another issue is that there are only so many goals you can set per each profile so too many trials and errors may may make you run out.
Analytics Content Advanced Search
One useful way to test REGEX is in analytics itself. If you paste the term in advanced search in content it should show the required data you want to isolate. If appropriate pages are shown then you can be sure the REGEX term will give required data.
With all the best intentions and will in the world clients come to SEO’s for assistance in improving their website goals. As an SEO we draw up wonderful documents with website audit and SEO strategy that we are proud to present to the client…. then nothing happens. What are reasons for clients failing to implement the very thing they sought from the consultant? Apparently main reasons include:
Lack of support from top management
Yeah we are dealing with middle management who has the desire and all the will in the world but guys at the top are not sold into the idea or the priorities are elsewhere.
Depending on the size of the organisation, the internal red tape can be the main bottle neck
It can be quite disruptive when a crucial clog in the proposed strategy suddenly moves either internally or out of the company and the SEO consultant has to sell the idea again to their replacement.
Weighty documents might look good as justification for a substantial spend but can be counterproductive if no one gets the time to read them thoroughly.
In an action-packed episode Avinash Kaushik and Nick Mihailovski discuss:
- How you can see the top landing page report by keyword.
- Calculating Avg Time to complete a goal.
- The recommended way to do internal campaign tracking.
- Creating funnel reports for different user types.
- How page title and URL are used in unique pageview calculations.
- Why you see google as a referral in Google Analytics.
- Can you use GA to track social networking links without link shorteners?
- Using canonical URLs to differentiate multiple links on a page.
- Calculating bounce rate for AJAX sites.
- Getting campaign data into Google Analytics without using URL parameters.
- Google Analytics campaign attribution and direct traffic.
- Working with Custom Variables in website templates.
- Using Ecommerce tracking for tracking conversions.
- Is there a way to see data broken down by day of the week?
- How tabbed navigation effects funnel abandonment.
- How to track various form selections.
- Fnding Average number of items per order in Google Analytics.
Click below to see the answers:
Google Analytics Blog: Last Web Analytics TV For 2010 – Out With A Bang