Google Tag Manager informatie exporteren naar spreadsheets

// Paste this script in the Console section of your browser Dev Tools.

gtmData = [];

 

var button = document.querySelector(".suite.suite-up-button.md-button.md-standard-theme.md-ink-ripple.layout-align-start-center.layout-row");

 

// Extract the account name

var accountNameElements = button.querySelectorAll(".suite-up-button-text-secondary");

var accountName;

if (accountNameElements.length > 1) {

accountName = accountNameElements[1].textContent.trim();

} else {

console.log("Expected more than one .suite-up-button-text-secondary element, found less");

}

 

// Extract the GTM container name

var gtmContainerNameElement = button.querySelector(".suite-up-text-name");

var gtmContainerName = gtmContainerNameElement.textContent.trim();

 

// GTM Container ID

var gtmNumber = document.querySelector('.gtm-container-public-id.md-gtm-theme').textContent.trim();

 

document.querySelectorAll('tr[gtm-table-row]').forEach(n => {

const td2 = n.querySelector('td:nth-child(2)');

const td3 = n.querySelector('td:nth-child(3)');

const td4 = n.querySelector('td:nth-child(4)');

const td5 = n.querySelector('td:nth-child(5)');

const td6 = n.querySelector('td:nth-child(6)');

const td7 = n.querySelector('td:nth-child(7)');



 

const triggerName = td2 ?td2.textContent.trim() : '';

const eventType = td3 ?td3.textContent.trim() : '';

const triggerFilters = Array.from(n.querySelectorAll('td:nth-child(4) .gtm-predicate-summary-row')).map(conditionElement => conditionElement.textContent.trim());

const folder = td5 ?td5.textContent.trim() : '';

const tags = td6 ?td6.textContent.trim() : '';

const lastEdited = td7 ?td7.textContent.trim() : '';

 

 

 

const tag = {

Account: accountName,

Property: gtmContainerName,

GTM_Container: gtmNumber,

Name: triggerName,

Type: eventType,

Folder: folder,

Tags: tags,

Last_Edited: lastEdited,

Trigger_Filters: triggerFilters

}

 

gtmData.push(tag);

})

 

console.log(gtmData); // To see the output in console

// Paste this script in the Console section of your browser Dev Tools.
gtmData = []; //create empty gtmData array.

 

// get the account / container element and store it in a variable named "button"

var button = document.querySelector(".suite.suite-up-button.md-button.md-standard-theme.md-ink-ripple.layout-align-start-center.layout-row");

 

// Get the All Accounts > {{account name}} elements in array format and store them in a variable

var accountNameElements = button.querySelectorAll(".suite-up-button-text-secondary");

 

// Extract the account name

var accountName;

 

if (accountNameElements.length > 1) {

accountName = accountNameElements[1].textContent.trim();

} else {

//if there is no account name element

console.log("Expected more than one .suite-up-button-text-secondary element, found less");

}

 

 

// Extract the GTM container element

var gtmContainerNameElement = button.querySelector(".suite-up-text-name");

 

//Get the GTM Container name

var gtmContainerName = gtmContainerNameElement.textContent.trim();

 

// GTM Container ID

var gtmNumber = document.querySelector('.gtm-container-public-id.md-gtm-theme').textContent.trim();

 

 

document.querySelectorAll('div[data-table-id="variable-list-user-defined"] tr[gtm-table-row]').forEach(n => {

//get the second column value and store it in a variable

const td2 = n.querySelector('td:nth-child(2)');

//get the third column value and store it in a variable

const td3 = n.querySelector('td:nth-child(3)');

//get the fourth column value and store it in a variable

const td4 = n.querySelector('td:nth-child(4)');

const td5 = n.querySelector('td:nth-child(5)');

 

//remove whitespaces and store the value in a new variable. Also if the value does not exist set an empty string.

//tags

const variableName = td2 ?td2.textContent.trim() : '';

//event type

const type = td3 ?td3.textContent.trim() : '';

//firing triggers

const folder = td4 ?td4.textContent.trim() : '';

//last edited

const lastEdited = td5 ?td5.textContent.trim() : '';

 

const tag = {

Account: accountName,

Property: gtmContainerName,

GTM_Container: gtmNumber,

Name: variableName,

Type: type,

Folder: folder,

Last_Edited: lastEdited

}

 

gtmData.push(tag);

})

 

console.log(gtmData); // To see the output in console

# Convert JSON object to CSV 

  

import pandas as pd 

  

# Create DataFrame from JSON file 

df = pd.read_json('file.json') # path to your JSON file 

  

# Save DataFrame to CSV file 

df.to_csv('file.csv', index=False) # target path and file name