How to get sales territory data in GA

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
  • London
  • South West England
  • Scotland
  • Wales

The process I used is a long one but involves:

  1. Download data of top 500 city visits for a period up to six months
  2. Make a comprehensive list of the cities and their respective categories – a good use of juniors or interns.
  3. Create a custom report for each sales territory using explorer type
  4. Decide the metrics, dimensions and drill downs you want in the report as the field and
  5. 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!

 

Analytics Regex Testing


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.

Why Some SEO Recommendations Are Never Implemented

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.

Bureaucracy

Depending on the size of the organisation, the internal red tape can be the main bottle neck

Staff Changes

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.

Overwhelming proposal

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.

read more

Google Analytics-top Q&A’s video

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