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
Is it a coincidence that all of the best suppliers of blockchain data start with the letter "C"? I think not! With the large amount of websites reporting alleged ways to get rich quick in the post-ICO boom world, where is a trader/data collector to get real information? You COULD go exchange by exchange, aggregating ... Read more
Google Tag Manager (GTM) conveniently provides a scroll depth trigger to determine how far someone has scrolled down the page. However, this scroll depth trigger doesn't work on websites using single page app (SPA) technology, since there is no full page load to reset the thresholds. This means that once you scroll down to the ... Read more
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
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
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
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
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
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
One common method of event tagging in Google Tag Manager uses GTM's built-in interaction tracking to fire tags off the classes and IDs that are already on the page. This method is fast and convenient, but not always robust in the long term because site updates often edit or remove the HTML elements that your ... Read more
