A collection of 25 posts
| 7 min read
Measuring the impact of growth marketing is complex and a blend of art and science. Unlike other business disciplines where answers can be provided in objective manners like a trail of ledgers, product usage, and customer feedback; Answers to how growth marketing impacts the bottom line are directional, subjective, and
| 9 min read
After a decade of maintaining the status quo, the marketing analytics field has experienced significant changes to measurement and reporting on an almost annual basis. These changes have brought new challenges to marketers forcing them to adjust strategy, tactics and budgets. The seminal moment that kick started this change was
| 3 min read
The Data Analytics sector has seen immense growth since the early days of the internet. The original startup boom of the 90’s put data analytics solutions on the map and drove the advancement of database technologies. This was followed by the “Big Data” movement of the 2010’s and
| 2 min read
WITH or Common Table Expressions (CTE) is a powerful SQL clause that temporarily stores results that can be referenced in other CTE's or the parent query
| 3 min read
Mobile apps and the internet are inherently different than each other despite mobile apps relying on the internet to provide much of their utility. The biggest difference between the two technologies is that the internet is an open protocol, while mobile apps are closed protocols governed by one corporation. Mobile
| 5 min read
A hotly debated area of marketing analytics is multi-touch attribution modeling. Before the advent of advanced browser and device tracking during the 2010s, last-touch attribution was the standard model used to deterministically measure the impact of marketing efforts. After tracking caught up with the evolution of the internet in Web
| 3 min read
Learn about the proper syntax structure and execution order for all of the SQL clauses.
| 5 min read
UNION and UNION ALL are set operators that combine results sets from multiple queries in order to aggregate and manipulate similar information.
| 4 min read
ORDER BY is a SQL query clause that allows you to sort raw data by various combinations of data attributes.
| 2 min read
LIMIT and OFFSET are SQL query clauses that allows you to limit and offset result records by the amount provided.
