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 […]
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 […]
Valid Combinations of Dimensions and Metrics
When building new Google Analytics queries, you are faced with picking from over 400 dimensions and metrics, not all of which work together. To make the selection process easier, the latest release of the Analytics Edge connectors for Google Analytics will give you a visual indicator of invalid selections (Free version available now, Pro version […]