One annoyance with using the Google Analytics API is that it doesn’t format percentages correctly. Instead of coming in as fractions that you just format as a percentage, they export as whole numbers. Sure, you could create a new column next to your data where you divide the number by 100 and then format as […]
Search Results for: excel
How To Use Google Docs’ JOIN And SPLIT Functions
Google Docs offers two functions in its spreadsheets that Excel doesn’t: JOIN and SPLIT. They are the finessed alternatives to Excel’s CONCATENATE function and its scorched earth Text to Columns command. JOIN Function Let’s say you want to create a regular expression (regex) that joins together (geek speak: concatenates) a bunch of cities separated by pipe […]
Get Context for Your Keyword Research with Google Insights
Using Google Insights for Search can save you a lot of wasted time and effort going after the wrong keywords.