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

Leverage Enhanced Ecommerce Data Layer for Marketing Pixels

This post contains scripts that you can use as Custom JS Variables in Google Tag Manager. These scripts all target the quite specific (yet common) use case where a site already running Google Analytics Enhanced Ecommerce now needs to run additional marketing or analytics tags. Related post: Collect Enhanced Ecommerce Values into GTM Variables CONTENTS … Read more

Set up Custom Dimensions using GA, GTM, and the Data Layer

Adding a custom dimension to Google Analytics involves several interconnected parts: the data layer, tag manager setup, and admin settings in GA. This post walks through each step of the process to show how they fit together. CONTENTS Step 1: Push Values into the Data Layer Step 2: Set up Custom Dimensions in Google Analytics Admin … 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

Troubleshoot FB Pixel Errors Affecting Delivery

In Facebook Ads Manager, you may come across an error message banner stating “Pixel Error Affecting Delivery • An error with your Facebook pixel may be affecting the delivery of one or more of your ad sets. You can troubleshoot this error in Events Manager.” This post will describe the steps you can take to … Read more

[July 2019 Update] Top Google Sheets Add-ons

It’s been a while since I did this, so this is an updated look at the top Google Sheets add-ons. I scraped this data from the Google Sheets add-on store. Earlier posts in this series: Top Google Sheets Add-Ons for Spreadsheets (+User Counts) [Oct 2018 Update] Top Google Sheets Add-Ons for Spreadsheets [Jan 2019 Update] … Read more

Remove fbclid Parameter from GA Reports

In late 2018, Facebook began appending “fbclid” query strings to the ends of all outbound URLs originating from Facebook’s site. These URLs take the format &fbclid=IwAR0Ylspg9Zo1-4JLuy5L3N7RhNTHg5BETDMlsQkUST8QC1JCo3iC6-54_PQ, and are appended to all outbound content, both FB ads as well as organic posts. This post will show you how to remove this parameter from your Google Analytics … Read more