Last week I did a Mozinar on content purging, and how it can improve your SEO. If that sounds interesting to you, click this link to check out the recording.
Now in that webinar, I shared a Google Sheets tool we built to help pull website data fast. Paste a list of your URLs, and voilà – your data is available in a Google Sheets format (which you can easily export into Excel if you wanted to). From different groupings from different date ranges, get your sessions, pageviews, conversions, etc. Not unlike something you can get from URLprofiler or Screaming Frog, but if you like this alternative, you can have it.
Today we’re making that tool available to you as our latest addition to Greenlane Garage.
Try It Now > The URL Performance Tool (in Google Sheets)
Simply click the link above. You’ll be prompted to make a copy (so be logged into Google).
The tool looks like this:
The tool was created to provide a high-level snapshot of a page’s performance without the need of logging into, and navigating through, an analytics platform. Built with the Supermetrics add-on for Google sheets (which you will require for this to work), and combined with Google Analytics, it brings together widely used tools in a scalable and customizable format. Quickly get data like sessions, pageviews, average time on page, bounce rate, conversions and conversion rate.
So next time you just want a quick look at website data for a list of your URLs, you can go to Google Analytics and wrestle it out of there, or use this tool.
- Installed Supermetrics
- Active Google Analytics account, and login access to the desired account
- Google sheets
Note: The logic used to create this tool can easily be converted for use in the Google Analytics API if that is your preference.
Give it a try. If you have any questions, email firstname.lastname@example.org. Have fun!