Where is the Old Version of Google Analytics Reports?

Google Analytics recently switched all accounts to the new reporting interface. Earlier there used to be a link on top right hand corner to switch between old version and new version but that link is no longer there. Don’t worry the old version is still there but the link has now been moved to the bottom of the page. Not sure how long the old version will live but for now it is there. I suggest you get used to the new version as quickly as you can.

Tracking Campaigns in both Google Analytics and Omniture Site Catalyst

If you are using both Google Analytics and Omniture Site Catalyst then you know that both these tools require different campaign variables to track campaigns. So what are the ways you can satisfy the requirements of both the tools so that you can see campaign performance in both of them.

Option 1 (Best Option): Use multiple query parameters

For GA you should use utm_campaign, utm_source, utm_medium

For Omniture add another parameter say ocid

Example: http://gapremium.com?ocid=123&utm_campaign=spring&utm_source=msn&utm_medium=banner

Option 2: Use one set of variables for one tools and convert them for other tool

For example: If you have GA enabled campaigns with only utm_campaign, utm_source and utm_medium already running then you can campture google campaign variables in javascript code , concatenate them to create a single value and then set that value in Omniture s.campaign variable.

Example:

http://gapremium.com?ocid=123&utm_campaign=spring&utm_source=msn&utm_medium=banner

Capture all the Google Analytics campaign variables in a JavaScript code as

campaignvalue = ‘spring : msn : banner’

The set this as the value for s.campaign value in Omniture

s.campaign = campaignvalue;

Get Google Analytics Help When You Need It

GAPremium is a Google Analytics expert consulting company.  We know Google Analytics in and out and that’s what we focus on.  If you need help with Google Analytics then we have the resources for you.

How is GAPremium Different from other Analytics Consulting Companies?

  1. We only focus on Google Analytics and related technologies only.
  2. We offer support for Google Analytics when you need and never lock you in for a long term contract
  3. Even if you need someone for few hours then we have the resources for you.
  4. We support your business 7 days a week

For Companies

  1. Get help when you need and as much you need. Minimum 1 hour commitment
  2. Get you internal technical teams trained in Google Analytics
  3. Get your business users trained in using Google Analytics to make data driven decisions

For Agencies

  1. White label our services and solutions
  2. Build you internal competency and internal team with help of our experts
  3. Tap into our resources as needed

Contact us today at support@gapremium.com for a no obligation initial consultation.

Google Analytics Event Tracking Builder Sheet V1

Event Tracking gets compiles when you have to track multiple events on a site. Not only you have to know the right syntax but also you have to keep track of all the values you are using for Category, Actions and Labels. To make your life easy we are releasing the V1 of Event Tracking Builder Sheet. This sheet will help you in getting organized and also provide you a code that you can copy and paste on the actions that you want to track as events.

 

Download Your Event Tracking Builder Sheet

 

Also, see Tracking Non Google Analytics Campaign Parameters in Google Analytics

Other Downloads:
Download your copy of the Google Analytics Campaign Tracking Sheet

Google Analytics Campaign Tracking Made Easy

We have just released V1 of Google Analytics Campaign Tracking Sheet. This sheet makes it easy for you to keep track of the campaign your are running and also allows you to easily build a tracking URL that you can copy and paste.

Please send us your feedback so that we can improve this sheet. Feel free to tweet about this and share the love.

V2 is already in works and will be released shortly.

Download your copy of the Google Analytics Campaign Tracking Sheet

Also see How to Track Campaigns in Google Analytics

How to Change the Default Row Limit in Exporting Google Analytics Data

When you use the “Export” functionality in Google Analytics, you are able to export the data that from the report that is currently showing on your screen. Since most of the reports have a 500 row limit you can only export up to 500 rows by default. However there is a workaround for that.

Changing the Number of Rows Exported

As explained in article “How to Change the 500 Row Limit in Google Analytic Reports”  you can change the view on your screen to show more than 500 rows.  If you use this hack to change the data displayed on your screen and then use “Export” functionality then you will be able export more than 500 rows.  For example, if you want to export 2500 rows then

  1. Change the number of rows in the URL of the report see belowhttps://www.google.com/analytics/web/#report/content-pages/a26989140w6400164p6618633/%3Fexplorer-table.rowStart%3D0%26explorer-table.rowCount%3D500%26_.advseg%3Duser2093821913/

    to

    https://www.google.com/analytics/web/#report/content-pages/a26989140w6400164p6618633/%3Fexplorer-table.rowStart%3D0%26explorer-table.rowCount%3D2500%26_.advseg%3Duser2093821913/

  2. Now you should see 2500 rows in your report
  3. Click on Export Button
  4. Your export with 2500 rows should be ready in few seconds

How to Export and Share Google Analytics Reports

Google Analytics has a very easy interface to export data out of Google Analytics and/or share your data with others.

In the top section you will see a menu for “Email” and “Export” functionality.

Export

The drop down has 4 options

  1. CSV – CSV means Comma Separated Values . The output you will get is all you data separated by a comma. You can open this file using whatever editor you prefer e.g. notepad, excel.  This can also be imported into a database.
  2. TSV – TSV means Tab Separated Value.  The output is just like CSV except that there is a tab between each data field instead of a comma. The data can be opened with notepad, excel or can be imported into a database.
  3. TSV for Excel – Is very similar to TSV
  4. PDF – The output in this case is a PDF file. Use this option if you want a static snapshot and don’t want anyone to mess with the data

For Exporting,  choose the format you want from the drop down box and you will see the report in the format you chose.

 Email

With the email option you can set the email to be a onetime event or a recurring email that goes out Daily, Weekly, Monthly or Quarterly.  Just like Export function it also allows you to email the data in 4 formats, CSV,TSV, TSV for Excel and PDF.

 

Note: When you use these options, the reports that will be exported or emailed will have the same settings e.g. row count, filters etc. that you see on your screen.

 

Tracking Non Google Analytics Campaign Parameters in Google Analytics

Google Analytics can track up to 5 campaign variable of which 3 are required.  Generally, the campaign variables are passed via URL of the campaign landing page.   For example, if you  want to send users to http://www.GAPremium.com via a campaign then you might use something like

http://www.gapremium.com? utm_campaign=Feb2012bannercampaign&utm_medium=bannerad&utm_source = yahoo&utm_content = 300X250&utm_term=training

In the above URL, all the query parameters are the campaign parameter that Google Analytics needs to track and attribute the click to the campaign. (See How to Track Campaigns in Google Analytics for more details)

In some case you might not have the campaign parameters as formatted above, maybe because you were using some other web analytics tool that required different parameters or somebody made a mistake and the parameters are messed up. Whatever the reason ; you just don’t have the right parameters.

Let’s assume that instead of the URL above, your URL looks like following

http://www.gapremium.com? campaign=Feb2012bannercampaign& medium=bannerad& source = yahoo& content = 300X250&term=training

(Note that none of the parameters contain utm_, e.g. instead of “utm_campaign”, the URL only has “campaign”)

So Google Analytics won’t recognize these parameters as valid campaign parameters and will ignore them.  However you can fix the problem by forcing Google Analytics to recognize these variable as valid campaign variable by using few lines of codes. The way you fix them is by calling a function that sets the new campaign parameter

_gaq.push([‘_setCampNameKey’, ‘campaign’]); 

The above code tells Google Analytics to use ‘campaign’ as the CampaignName parameter instead of the ‘utm_campaign’ parameter

Similarly set other parameters as follows

_gaq.push([‘_setCampMediumKey’, ‘medium’]);

_gaq.push([‘_setCampSourceKey’, ‘source’]);

_gaq.push([‘_setCampContentKey’, ‘content’]);

_gaq.push([‘_setCampTermKey’, ‘term’]);

Using Google Analytics to Detremine Who Visited the Site

Customer and visitors alike visit your site but your Google Analytics reports show you aggregate numbers to show how many visits came, from what sources, how many of the viewed a certain page etc.   But these reports don’t tell who visited your site, weather that is an existing customer or someone who has not purchased anything yet etc.

However, there is a way in Google Analytics that allows you to know “Who” visited the site, what sources they used, what pages they saw etc.

Setting Customer ID in Google Analytics

If you store your customer records in a database or CRM solution then you assign each customer and ID that identifies each individual customer.  Assuming you this ID for individual available either in a cookie or in the web session when that individual comes to your site.  You can extract that ID from the cookie or session and pass it to Google Analytics using visitor level custom variable as shown below to get individual level reporting.

_gaq.push([‘_setCustomVar’,index, name, value, opt_scope]);

(Note: You can get more information about Custom Variable at http://code.google.com/apis/analytics/docs/tracking/gaTrackingCustomVariables.html)

Example

Let’s assume that we have that we have a customer “John Doe” identified by customer id 21590 in the database. Let’s further assume that this value is available to us in the visitors online session.

Let’s use the name “UserID” for this custom variable. The slot we will use to store this variable is 3 (You can use whatever slot is available but I decided to store it in slot number 3). The opt_scope is 1 for a Visitor Level custom variable

So the values that we need to set are

index = 1

name = UserID

value = 21590

opt_scope = 1

The way you will set is

_gaq.push([‘_setCustomVar’,1, “UserID”, “21590”, 1]);

Once Google Analytics collects the data you can start to see this data in your Google Analytics reports.

 

Note: Google Analytics does not allow you to pass in PII (Personally Identifiable Information) data but an id, which on its own does not tell you anything about the person is not PII in my opinion. Google Analytic does not clarify if you can use it or not so use it at your own discretion or consult Google Analytics, if they respond.

 

 

What are Filters in Google Analytics

Filters are a way to transform or manipulate the data that shows up in Google Analytics reports. Filters are applied on the data collected by Google Analytics and what you see in your reports is the final outcome after the filter has been applied to your data.

For example if you want to exclude traffic from an internal IPs then you setup an Exclude IP filter and apply it to the profile that you want to exclude the traffic from.  The final reports that you will see in that profile won’t include any traffic from those IPs.

Note: Once the filter is applied then you won’t see the original data in your reports, you will only see the transformed data.  So always apply a filter on a test profile before applying it to your main file so that you don’t accidentally mess up your reports in your main profile.

Google Analytics provides three predefined filters. If those are not the ones that you need then you also have an option to create custom filters.

Predefined filters:

  • Traffic from the domains: This filter allows you to exclude or include only the traffic from a specific domain.
  • Traffic from the IP addresses: This filter allows you exclude or include only the traffic from specified IPs.
  • Traffic to the subdirectories: This filer allows you exclude or include only the traffic to particular subdirectory on your site.

Example of a Predefined Filter

How to Exclude Internal Traffic from Google Analytics when Internal IP Address is Dynamic

Custom filters:

  • Exclude Pattern:  Allows you to exclude traffic that matches the pattern that you specify.
  • Include Pattern: This filter allows you to include only the traffic that matches the patter you specify.
  • Uppercase: Allows you to convert a given data into uppercase.
  • Lowercase: Allows you to convert a given data into lowercase.
  • Search & Replace: This allows you to manipulate the information you see in your reports by searching a value and replacing with something else. Say you have called your campaign source as Gogle instead of Google in your campaign URL. You can change it back to Google in this filter.
  • Advanced: This filter allows you to build a new data field from one or two other data fields. Some examples will be covered in future articles.

 

Examples of Custom Filters:

Regular Expressions and Google Analytics

How to Exclude Internal Traffic from Google Analytics when Internal IP Address is Dynamic

Note: Filters are applied in the Rank order, the rank 1 is applied first and then 2 and so on. To change the order use the Assign Filter Order button (see below).  Having the wrong order on filter will lead to unexpected results so make sure you have assigned the right order.