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


Fatal error: Allowed memory size of 41943040 bytes exhausted (tried to allocate 40961 bytes) in D:\Hosting\3029771\html\gapremium\wp-content\themes\genesis\lib\shortcodes\post.php on line 416