How do Mobile Measurement Partners Evolve From Here?
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 operating systems (OS) run app stores with corporate guidelines and regulations over the types of mobile applications that can be installed on their systems. These walled gardens were...
Coming Full Circle - The Rise and Fall of Multi-Touch Attribution
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 2.0, there was a rise in tools and reporting that were capable of stitching together unique data points in a user journey to conversion which led to multi-touch at...
SQL Clause Execution Order
Learn about the proper syntax structure and execution order for all of the SQL clauses.
Union Data with UNION and UNION ALL
UNION and UNION ALL are set operators that combine results sets from multiple queries in order to aggregate and manipulate similar information.
ORDER BY Clause
ORDER BY is a SQL query clause that allows you to sort raw data by various combinations of data attributes.
LIMIT / OFFSET Clauses
LIMIT and OFFSET are SQL query clauses that allows you to limit and offset result records by the amount provided.
HAVING Clause
The HAVING clause in SQL acts as a filtering mechanism similar to the WHERE clause, but for grouped columns and aggregate functions.
GROUP BY Clause
GROUP BY is the first non-relational layer SQL query clause. It creates unique data groupings and allows for aggregations to be used.
WHERE Clause
WHERE is a SQL query clause that allows you to filter raw data by various combinations of data attributes.
FROM Clause
The FROM clause opens up your search query to accessing data tables within your database.
Connor Phillips
contact [at] connorphillips.com
Data leader with a decade of startup and agency experience helping B2C and B2B businesses with their mobile app and web-based products.
Currently leading the Global Analytics team at the growth marketing agency, Twigeo, working with growth-focused clients ranging in industries from AI to language learning.
📬 Subscribe to My Newsletter
Get the latest articles and exclusive content straight to your inbox.
- Previous Page
- Page 3 of 11
- Next Page