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
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
Google Analytics provides a super-easy method of tracking onsite search keywords: simply identify which query string (aka parameter) holds the onsite search term for your site, and enter that value at Admin > View > Site Search Settings. You can find your search query string by performing a search on your site and checking the ... Read more
This post shows some useful Custom JavaScript Variables for Google Tag Manager. #2 and #3 require modification for your own site, while the others can be plugged in directly. Add Custom JavaScript Variables by navigating to Variables > New > Custom JavaScript. CONTENTS #1 Value of the Closest Parent ID#2 Text of the Closest Specific ... Read more
Here we are again with another look at the top Google Sheets Add-Ons for spreadsheets. Other posts in this series: Top Google Sheets Add-Ons for Spreadsheets (+User Counts) [Oct 2018 Update] Top Google Sheets Add-Ons for Spreadsheets [July 2019 Update] Top Google Sheets Add-ons I scraped this data with a little script from the Google ... Read more
A histogram is a type of chart that visually shows the distribution of data. It's useful when looking at the average or median of a data set, to understand whether that data point is common or not. For example, an ecommerce dashboard will typically include an Average Order Value metric. Say this metric is $50. ... Read more
The box plot chart (aka box and whiskers) is a chart to visually display the distribution of a dataset: the maximum, minimum, median, and the range on either side of the median. Google Data Studio currently doesn't provide a Box Plot chart type, but you can create something similar using a Stacked Column chart type. ... Read more
