Erik Bleske erik4github

Does Not Contain Question Marks (?) - Useful for Excluding Query Parameters in Reports

^[^\?]*$

Filter By Excluding Matching Regex:

^[^?]+(?.*)

VLOOKUP, XLOOKUP, and INDEX/MATCH

Example: Looking up a SKU to return a price.

Note that C is the the column where the SKU is located in, and H is the end of the column. The price is located in column G, so 5 columns away from C.

' Where A2 is the SKU you're looking up in the current sheet and SKU_Price_Table is a Table in another sheet '
=VLOOKUP(A2, SKU_Prices_Table!C:H, 5, FALSE)

Note that if you have numbers and text mixed together, VLOOKUP will only return the matching text columns (e.g. a SKU that is just 123 and a SKU that is F-123, VLOOKUP will return N/A for 123 even if there is a match).

Works for landing pages & pages like /this-is-how-a-url-shows-up-in-the-report/

^\/?(\[?.+\=.*)

	window._wq = window._wq \|\| [];
	window._wq.push({
	id: "_all",
	onReady: function(video) {
	video.bind("play", function() {
	_dcq.push([
	"identify",
	{
	success: function(response) {
	video.email(response.email);

	if ({{Cookie Opt-Out}} !== 'false') { // Cookie Opt-Out would be whatever you name your GTM variable for the first party cookie
	_hsq.push(['addPrivacyConsentListener', function (consent) {
	if (consent.allowed == false) {
	var cookieName = "cookiesOptOut"; // the name of the first party cookie in your GTM account to track cookie opt-in
	var cookieValue = false;
	var cookiePath = "/";
	var expirationTime = 31536000; // consent needs to be tracked for 1 year before asking again under GDPR
	document.cookie = cookieName + "=" + cookieValue + "; expires=" + expirationTime + "; path=" + cookiePath; // sets the cookie for opting out
	}
	}]

	// use history.replaceState() instead of history.pushState() in order to not spam browser history

	var f = ['🌑', '🌒', '🌓', '🌔', '🌝', '🌖', '🌗', '🌘'];

	function loop() {
	location.hash = f[Math.floor((Date.now()/100)%f.length)];

	setTimeout(loop, 50);
	}

	// if needed
	const flat = arr => [].concat(...arr);

	const swapArrow = arr => arr.map(v => ([v[0], v[1]] = [v[1], v[0]]));

	const swapWithReverse = arr => arr.map(v => v.reverse());

	function swap(arr) {
	let swapped = [];
	for (let i = 0; i < arr.length; i++) {

	example_dict = {
	'hello': {
	'world': {
	'nest': 'end'
	}
	}
	}

	def find_key(d, value):
	for k,v in d.items():

	Array.from(new FormData(formElement), event =>
	event.map(encodeURIComponent).join("=")
	).join("&");

	javascript:(function(window){
	var selection = window.getSelection();
	selection.baseNode.parentElement.innerText = selection.baseNode.textContent.toLowerCase();
	})(window);