Big List of Free and Open Public APIs (No Auth Needed)

An API (Application Programming Interface) allows you to send requests to a remote data set, like querying a database. The response will then be delivered back to your own application in a standardized format. This is very helpful when you’re building an app or pulling metrics for reporting, because it means you can focus on … Read more

Get SEO Data with the Google Custom Search JSON API

The Google Custom Search JSON API is primarily designed for creating applications that retrieve and display search results programmatically, like a search box widget that you place on your own website. However, as part of this service, Google provides a free Google Search API that that lets you query Google’s search engine to check search … Read more

Content Marketing Analytics: Conversion Rate by Page

While Google Analytics provides many reports and metrics designed to evaluate the effectiveness of content marketing, there is no report showing the conversion rates of specific posts or pages on your site. For example, if you’re tracking registrations on your site, you may want to know which specific posts are associated with signups, even if … Read more

Top Google Sheets Add-Ons for Spreadsheets (+User Counts)

Google’s online spreadsheet service, Google Sheets, allows users to install add-ons (aka plugins or extensions) for additional functionality. After making a little Google Sheets add-on of my own, Archive Data, I became curious about what add-ons are most popular. Through some web scraping I extracted a comprehensive list of all Google Sheets add-ons from the Sheets … Read more

Archive Data Add-On for Google Sheets

The free Google Sheets add-on Archive Data helps store historical data from your Google Sheets reports and dashboards before it gets refreshed. It allows you to set a schedule to paste from row or column X to Y, automatically creating a record of your original data. Example:You have a monthly dashboard that uses the “Google Analytics … Read more

Attribution in Google Analytics

Misunderstood Metrics #1: GA Attribution (or how someone came to your site today from that email you sent out 4 months ago) GA does a great job of making web data accessible and intuitive but there are a few dimensions and metrics that tend to trip up users, including marketing sources. Users visit your site … Read more

Complete Guide to Valuing Content in Google Analytics

For the past few years we’ve seen increasing numbers of content and ecommerce sites come together into some kind of hybrid. Online magazines hunting for new revenue streams add event tickets and product guides with click-to-buy functionality, while retailers looking to build engagement add blogs and editorial features. While the logic behind these approaches make … Read more

Coremetrics Tip: Report Segments and Time

In Coremetrics you can analyze specific kinds of visitors by applying Report Segments.  For example, you can make a segment for visitors from a certain marketing channel or who made a certain kind of purchase. I like using Report Segments because you can browse nearly the full set of standard reports for your segment, while … Read more