Skip to content

Instantly share code, notes, and snippets.

Simon breton simonbreton

  • Remote
Block or report user

Report or block simonbreton

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
View Digital_Brain_Resorts_World
//Tracking plan
// Google Tag Manager
//Paste this code as high in the <head> of the page as possible:
<script>(function(w,d,s,l,i){w[l]=w[l]||[];w[l].push({'gtm.start':
new Date().getTime(),event:'gtm.js'});var f=d.getElementsByTagName(s)[0],
j=d.createElement(s),dl=l!='dataLayer'?'&l='+l:'';j.async=true;j.src=
'https://www.googletagmanager.com/gtm.js?id='+i+dl;f.parentNode.insertBefore(j,f);
})(window,document,'script','dataLayer','GTM-KTT5NN8');</script>
View Datalayer - Purchases
<script>
// Send transaction data with a pageview if available
// when the page loads. Otherwise, use an event when the transaction
// data becomes available.
window.dataLayer = window.dataLayer || [];
dataLayer.push({
'event': 'purchases',
'ecommerce': {
'purchase': {
'actionField': {
View gist:ddde17d0e13f83c771bdc2d1cc93c964
SELECT *,
NULL AS extra,
0 AS AnnualBusExpenses,
0 AS MonthExtraBusExpenses,
0 AS AnnualExtraBusExpenses,
0 AS MonthBusExpenses
FROM
(SELECT Id,
Name,DATE_FORMAT(Date, "%Y-%m-%d") as Date,COALESCE(SupplierExpenses,0) as SupplierExpenses,
COALESCE(MiscEventExpenses,0) as MiscEventExpenses ,
View Last 6 months spreadsheet formula (blog article)
=arrayformula(if(A2:A<>””,if(A2:A>=EDATE(today(),-6),”last 6 months”,”older than last 6 months”),””))
You can’t perform that action at this time.