Hello, API Connector users! Over the past several years we've released hundreds of updates to API Connector, including the visual field editor, new integrations, new report styles, and dozens of other features, all designed to make connecting to APIs simpler and more convenient for reporting in Google Sheets. While most features have always been available on all plans, ... Read more
Typically, a YouTube Content Owner account is used to manage many different channels. YouTube's API requires the associated YouTube Content Owner ID for access to certain revenue-related metrics. Here is how to fetch this ID: Method 1: Get the ID from the YouTube's Developer Docs Method 2: Get the ID from the URL This method ... Read more
Hi all, I'm a huge fan of what JJ and Stockton are doing at Better Than Data for agencies and consultants. They've now released a really nice template that lets you easily configure Mixed Analytics API Connector to set up your Google Analytics (GA4) request in Google Sheets, and then visualize that data in Looker ... Read more
This is the current list of country codes used by Google Analytics and Google Ads. These are also known as Geo Target IDs. List of IDs Geo ID Name Country Code 2004 Afghanistan AF 2008 Albania AL 2012 Algeria DZ 2016 American Samoa AS 2020 Andorra AD 2024 Angola AO 2010 Antarctica AQ 2028 Antigua ... Read more
This is the current list of YouTube video category IDs: 1 Film & Animation 2 Autos & Vehicles 10 Music 15 Pets & Animals 17 Sports 18 Short Movies 19 Travel & Events 20 Gaming 21 Videoblogging 22 People & Blogs 23 Comedy 24 Entertainment 25 News & Politics 26 Howto & Style 27 Education ... Read more
A YouTube channel ID is a unique identifier for a YouTube channel. In recent years YouTube has moved to channel names instead of IDs, and it's now often impossible to find a channel ID by simply browsing around YouTube's website. However, the unique ID is still very important for fetching public data like view and ... Read more
Certain APIs and datasets accept or display data in Unix epoch 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 A2. Array formulas are also provided for converting ... 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
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
