The rules for search engine optimization have changed. It’s no longer about individual keywords and page rank – experts tell us it’s about topics and the “long tail”. But if position and individual terms aren’t the focus, how do you know if changes you made have any impact? This free Excel report demonstrates a new way to […]
Newsletter
Simple SEO Report Automation
Ever since Google switched to “(not provided)” keywords in Google Analytics, we’ve been forced to look to Google Webmaster Tools (now called Google Search Console) to see how our pages are ranking in search, and what search terms they are ranking for. The new Google Search Console interface allows you to see your top ranking pages, and […]
Do You Have The Time?
When creating Google Analytics reports in Excel, time metrics like Avg Session Duration are delivered in seconds, but people want to see the number shown in minutes and seconds as “1:52” (instead of as “112” seconds). Attempts to format the number as “Time” in Excel prove frustrating because Excel expects time numbers to be fractions of a day, not […]