Skip to content

Instantly share code, notes, and snippets.

Avatar

Simon breton simonbreton

View GitHub Profile
View product-impressions
// Measures product impressions and also tracks a standard
// pageview for the tag configuration.
// Product impressions are sent by pushing an impressions object
// containing one or more impressionFieldObjects.
window.dataLayer = window.dataLayer || [];
dataLayer.push({
'event':'impressions'
'currencyCode': 'EUR',
'impressions': '3', // number of impressions
View resume.json
{
"basics": {
"name": "Simon Breton",
"label": "Analytics Engineer",
"summary": "I'm french, living in Mexico and working remotely as analytics consultant. As I'm progressing in my carrer I became more and more technical. I'm extremely interested in the new Analytics Engineer trend",
"website": "www.blueprint-analytics.com",
"email": "simon@blueprint-analytics.com",
"location": {
"city": "Mexico/Paris"
}
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.