simonbreton

// 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                      

simonbreton

{
  "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"
    }

simonbreton

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 ,

simonbreton

=arrayformula(if(A2:A<>””,if(A2:A>=EDATE(today(),-6),”last 6 months”,”older than last 6 months”),””))