Howto

• Tf-Idf in Google Sheets: implementing text analysis, keyword counting, tokenisation and stemming in a spreadsheet Google Sheets, the online Excel alternative, is basically the Swiss army knife of any modern knowledge worker. We're adding to it's multitude of uses and abuses today by creating a custom Tf-Idf model _in_ Google Sheets. A Tf-Idf model can help us digest large quantities of text like reviews, comments, feedback, chat histories, and even 17th century philosophy books with ease. Continue reading...
  Howto Google-Sheets Javascript Text-Analysis Tf-Idf

  6 min read
• Real Time Analytics Monitoring with Google Sheets Whether it's because you don't want your business to lose money or because you just like to watch videos on YouTube, automating your analytics monitoring can help you sit back and relax knowing that everything's under control. This time we'll look at how a simple Google Sheet can help you check your analytics on the fly with the Google Analytics Real Time Reporting API. Continue reading...
  Howto Analytics Api Google-Analytics Google-Apps-Script Google-Sheets Monitoring Real-Time Testing

  10 min read
• Measuring with DataLayers, Data Attributes, Meta Tags and Webhooks: When to use what When asking developers to add extra information to a site like a user ID, user login status, page category, or product price the conversation that ensues can be confusing. Do you want everything in a dataLayer push? Is it a data-attribute for the element on page? And how does that match with what your SEO colleague wants? Let's find out! Continue reading...
  Howto Datalayer Development Dom Google-Analytics Json-Ld Measurement-Protocol Schema Webhooks

  6 min read
• Using Puppeteer to automate your google analytics testing Testing your analytics setup regularly can help you prevent uncomfortable situations with your boss or client when there's been another change on the site and suddenly all your campaigns and goals have zero conversions. We will look at how to test the actual requests that are being sent to Google Analytics, Facebook, or any other place you have your tags pointed at. Continue reading...
  Howto GCP Google-Analytics Puppeteer Testing Browser_automation Playwright

  7 min read
• What!? How ... ? But Why!? Seven Ways to Ask Better Questions Continue reading...
  Howto Questions

  5 min read