I have a Google Analytics account for a site I now am helping with. There is a history where no filters were applied and I would like to apply a filter to make all the URLs lowercase to match them up.

I see plenty on removing querystrings and such but nothing along the lines of replacing all uppercase chars with lowercase ones.

I already have a filter for data going forward but need to do it with older data if I can.

Is it possible?

  • 2
    This is better suited for the Webmasters forum as it is not related to coding. But to comment, you can create a "Lowercase" filter on whatever it is you are trying to change, that would apply to data going forward only (not retroactive). – nyuen Mar 6 '15 at 20:17
  • nyuen - yes I already have that in place - – braindice Mar 6 '15 at 21:21
  • Seems this was posted on Stack Overflow earlier. It's best to ask for questions to be migrated to another site prior to posting there, so that we don't end up with cross-posts and duplicates if they are migrated. – dan Mar 7 '15 at 5:30

Unfortunately, it's not possible to alter historical data with any kind of GA filter. Filters only apply to data going forwards in time.

If you want, you can apply a "Lowercase" filter.

| improve this answer | |
  • How would the user apply a filter going forward if that is what they want?? I do not pay attention to GA enough to know. But this could be an opportunity to help a user. Thanks!! – closetnoc Mar 7 '15 at 0:34
  • 1
    Thanks for the suggestion, @closetnoc. Actually, I replied to OP already in SO where this question originally came from. :) – nyuen Mar 7 '15 at 1:58
  • Ah yeah. Cross posting has been happening a lot lately! Good for you!! – closetnoc Mar 7 '15 at 2:30

You cannot apply a filter to historical data. All filters in Google Analytics are applied only to data forward.

| improve this answer | |
  • Eduardo - I would think you could use the 'Search and Replace' filter to do it but not sure what to put in the 'Search string' or the 'Replace string' – braindice Mar 6 '15 at 21:22
  • Search and Replace filters will also only work going forward, and cannot be used to edit historical data. – nyuen Mar 6 '15 at 22:45

One possible solution is to download the historical data into a CSV file, and then alter the data there using the spreadsheet program of your choice. It might take a little work, but it'll get the job done.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.