Written by 
Google Analytics Keyboard Shortcuts
Since I got so many comments (on and offline) from this tweet, figured it was worth a quick post!
The full list of shortcuts from GA:
Enjoy :)
Concatenate Takes Too Long
Adam asked for help with an awesome idea… that I can’t share. But I can share something that took this “awesome idea” from being tedious to set up to a snap.
I needed a way to concatenate a few hundred cells of data, using the pipe bar | between each. The idea of needing to do this over and over was rather mind numbing. I searched for a faster way to do this, but came up blank. I couldn’t imagine there wasn’t a way to speed up the process, so I reached out to help from the team.
Apparently there’s no quick, simple solution in Excel, but Google Docs is another story! Here’s how you do it:
- Put your info in column A
- In column C, type: =join(“|”,A:A)
That’s it!! In just two seconds, all of the info was concatenated. So how else can we use this? I only needed to separate the information in each cell. We could put all kinds of other fun RegEx in, though! Looking at tons of keywords and only want to match the exact term, not the long tail? Replace the pipe bar with “$|^” and suddenly you have an easy RegEx to drop into the filter.
Seriously, how could I have not known this before?
Grateful hat tip to Ethan for sharing this helpful tip! Saved me a few minutes, which I put into writing this post :)