Data

SELECT Clause

SELECT is a foundational SQL clause that is mandatory to run queries. Learn more about SELECT with the start to my series on basic SQL queries.

Technology

Web 3.0 and the Promise of a Privacy-First Future

The evolution of the internet with web 3.0 and the privacy-first technologies leading new ways of identification

The Enjoyment of Working on Passion Projects
Founder Story

The Enjoyment of Working on Passion Projects

Coming to the realization that side projects need to be passion driven. Otherwise you run the risk of burn out.

The Losers in Apple's Privacy Battle - Small E-Commerce Businesses
Business

The Losers in Apple's Privacy Battle - Small E-Commerce Businesses

The move by Apple to regulate third party data sharing and advertising cornered publishers like Facebook and Google and will accelerate the centralization of commerce within these platforms adversely impacting e-commerce businesses.

Combating Marketing Analytics Measurement Paralysis
Data

Combating Marketing Analytics Measurement Paralysis

Handling organizational questioning and debate by understanding the topics of deterministic vs probabilistic modeling and attribution

Productivity in Isolation
Thoughts

Productivity in Isolation

Fight boredom and improve your well-being during isolation by staying productive!

Data

Index Match

Index-Match is a powerful spreadsheet lookup formula that is dynamic in nature and can handle searches regardless of a ranges directional data structure

Linking Data Between Google Sheets

How to use IMPORTRANGE, the function that allows you to import data from a separate Google Sheet.

What Are Good Foundational Google Analytics View Filters?

Prevent dirty data with view filters for ip address exclusion, path preference and hostname specification

Sync Google Analytics Data To A Google Sheet

Yes, there is a Google Sheets plugin that will allow you to run Google Analytics reports in a Google Sheet via the API call. In the supporting article I will show you how to use this tool.