Data

A collection of 25 posts

Data

A Phased Approach to Growth Analytics Architecture

| 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

Data

2023 Marketing Analytics Predictions

| 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

Data

Overthinking the Modern Data Stack

| 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

Data

WITH Clause

| 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

Data

How do Mobile Measurement Partners Evolve From Here?

| 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

Data

Coming Full Circle - The Rise and Fall of Multi-Touch Attribution

| 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

Data

Union Data with UNION and UNION ALL

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

Data

ORDER BY Clause

| 4 min read

ORDER BY is a SQL query clause that allows you to sort raw data by various combinations of data attributes.

Data

LIMIT / OFFSET Clauses

| 2 min read

LIMIT and OFFSET are SQL query clauses that allows you to limit and offset result records by the amount provided.