erik4github

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);

erik4github

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

erik4github

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
        }
    }]

erik4github

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

• ^[^\?]*$

Filter By Excluding Matching Regex:

• ^[^?]+(?.*)

erik4github

// 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);
    }

erik4github

// 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++) {

erik4github

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

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

erik4github

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

erik4github

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).

erik4github

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

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