Results 1 to 2 of 2
  1. 30 December 2011, 7:45 pm #1
    lunaraurora's Avatar
    lunaraurora is offline Private Member
    Join Date
    March 2007
    Location
    Italy
    Posts
    215
    Thanks
    22
    Thanked 55 Times in 33 Posts

    Default How to clean your google analitycs reports

    I found a very fast and easy method to turn a keywords reports exported from google analitycs into a clean report with your listed keywords clean from punctuation and annoying characters.
    Save somewhere your report, right click and open it with Microsoft Office Front Page. From the top drop-down menu click edit and then replace.. leave blank the "Find what" box and in the "Replace with" box enter the first character you want to delete, then push the "Replace all" button. Repeat the procedure with all the other characters you want to delete until you see your reports perfectly clean. Save the work. This method saved me very much time ..maybe could be useful for you too.

  2. The Following 2 Users Say Thank You to lunaraurora For This Useful Post:

    davemerry (18 January 2012), Lucky Bob (19 January 2012)
  3. 17 January 2012, 2:27 pm #2
    Lucky Bob's Avatar
    Lucky Bob is offline Private Member
    Join Date
    October 2011
    Location
    Niagara Falls area - Canada
    Posts
    153
    Thanks
    44
    Thanked 34 Times in 23 Posts

    Default

    Great idea. I'll give it try as I've been looking for a nice way to look at the data.
    A related question: my google analytics and AWStats are quite different. Any idea why that might be?

    Thanks,

    Bob

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules