Convert Unix Timestamps to Google Sheets Dates

Certain APIs and datasets accept or display data in Unix timestamps, which are not natively recognized by Google Sheets and can therefore not be used for calculations or other data transformations. These timestamps can be converted as follows, substituting in your date cell where you see A1. Convert regular date to UNIX timestamp Convert UNIX ... Read more

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

An API (Application Programming Interface) allows you to send and receive data from a remote server, 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 ... 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 LayerStep 2: Set up Custom Dimensions in Google Analytics AdminStep 3: ... 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