prabapro

#!/bin/bash

# Get the list of available branches
available_branches=$(git branch --list)

# Prompt to select a branch
echo "🌍 Available branches:"
echo "$available_branches"
read -p "❗ Please enter the branch name to commit to (or press Enter for current branch): " selected_branch

prabapro

{
    "exportFormatVersion": 2,
    "exportTime": "2022-08-05 10:09:11",
    "containerVersion": {
        "path": "accounts/6006227429/containers/90922809/versions/2",
        "accountId": "6006227429",
        "containerId": "90922809",
        "containerVersionId": "2",
        "name": "[Praba] GA4 Ecommerce Events Boilerplate by MeasureSchool - v1.0",
        "description": "GA4 Ecommerce Events Boilerplate by MeasureSchool.\n\nFor queries, write to praba@measureschool.com",

prabapro

MeasureSchool - ThriveCart Ecommerce Events (UA & GA4)

Instructions - ThriveCart

1. Copy the contents from 01-base-all-pages.html & paste it on All Pages box in the ThriveCart Product Checkout page - Replace GTM-xxxxx with your GTM container ID - Line 12.

2. Copy the contents from 02-checkout-page.html & paste it on Checkout Page box.

prabapro

Vidyard Video Listener for Google Tag Manager

• Demo
• Listener
• GTM Recipe

prabapro

MeasureSchool GA4 <> BigQuery Guide - 2022 July - v1.0

• Query #01 - Top 10 events for the past 30 days (excluding today)
• Query #02 - Top 10 events for the past 30 days (including today)
• Query #03 - Unnesting event_params to see the pages viewed in a date range.
• Query #04 - Removing the query strings from the URL
• Query #05 - Count Users & New Users
• Query #06 - Count users by acquisition campaign
• [Query #07 - Count users by Browsers & Browser versions](https://gist.github.com/prab

prabapro

function() {
  
  var orderData = {{dlv - order-data v1}};
  var items = {{dlv - items - v1}};

  var actionField = {
    id: orderData.id,
    affiliation: orderData.affiliation,
    revenue: orderData.revenue,
    shipping: orderData.shipping,

prabapro

select
  timestamp_micros(event_timestamp) as timestamp_utc, -- converts the timestamp into UTC
  format_datetime("%Y-%d-%m %H-%M-%S %Z", (timestamp_micros(event_timestamp)), 'America/New_York') as timestamp_newyork, --timestamp in NY
  event_name,
  (select value.string_value from unnest(event_params) where key = 'transaction_id') as transaction_id, -- gets the string value
  (select value.int_value from unnest(event_params) where key = 'value') as transaction_value, --gets the integer value
  (select value.string_value from unnest(event_params) where key = 'currency') as currency,
  (select value.string_value from unnest (event_params) where key = 'page_title') as page_title,
  (select value.string_value from unnest (event_params) where key = 'page_location') as url
  

prabapro

Check if jQuery is enabled on the site - running the below snippet on the browser console will return the result.

(function() {
    if (window.jQuery) {  
        // jQuery is loaded
        return("Yeah! JQuery loaded");
    } else {
 // jQuery is not loaded

prabapro

function exportToBigQuery() {

    var projectId = 'learn-big-query-307011'; //GCP Project ID here
    var datasetId = 'ga_gbq_data_pipeline_demo'; //GBQ Dataset ID
    var tableId = 'ga_codechilli_users_by_country'; //GBQ Table ID

    var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
    var values = spreadsheet.getSheetByName('data').getDataRange().getValues();
    var csv = generateCSV(values);

prabapro

GTMTips: Prevent Clicks And Form Submits From Redirecting

Extracted from Simo Ahava's Blog Post

Using Custom beforeunload script

Google Tag Manager offers us some nice built-in triggers so that we can automatically listen for specific user interactions on the website, reacting to them however we wish, though typically it would be to fire a tag. The tricky thing especially with the click triggers and form submission tracking is that the page has a nasty habit of redirecting you to the link or form target page before letting you see the respective data in Google Tag Manager’s excellent preview mode.

>This solution should work with all redirects regardless of how they’re implemented. The trick is to add an event listener to the beforeunload browser, opening a prompt that asks if you really want to leave the current page. You can then press “Cancel” (or equivalent) to stay on the current page to see what the browser event w