How to set up Google Sheets FILTER functions for single and multiple conditions
Oftentimes after gathering and collating data onto a spreadsheet, we want to focus on important figures that are relevant to our analysis. To do that, we have to filter our data. Google Sheets allows us to do this with the built-in FILTER function. This function works when you specify the …
Continue reading
Why is your Google Sheet so slow? And how you can speed it up.
Import functions are great until they start slowing down Google Sheet performance. Find out how Airboxr can import data without long loading times.
Continue reading
How to combine data from Facebook Ads and Google Ads
The hard way and the easy wayIf you're reading this, you're probably using both Facebook ads and Google ads. You target different audiences on their respective platforms. Facebook ads target users who show interest in products similar to yours. On the other hand, Google ads focus on users who search …
Continue reading
How to combine data from Google Ads and Google Analytics
Combining data from Google Ads and Google Analytics is tougher than it seems. Find out how you can do it through a simple two-step process with Airboxr.
Continue reading
How to get Google Analytics data into Google Sheets
And a hot tip to ensure you aren't slowing down your analysis.Google Analytics is the most popular analytics tool for websites around the world. I'm especially a big fan of the Real Time dashboard and the Source/Medium table that shows me where my traffic is coming from. However, it isn't …
Continue reading
Are you tracking the right metrics for your SaaS website?
The right tracking infrastructure for your product is essential to successIt’s 2020 and to say it’s been a crazy year is a massive understatement. Business models and revenue numbers have taken a nose-dive and leaders across the world are trying to just do enough to survive. In these trying times, …
Continue reading
How to import multiple columns with vlookup
The hard way and the easy wayWhen I try to pull data from another tab on my spreadsheet, I typically use the vlookup formula. But the vlookup formula only pulls one column at a time. This forces me to replicate the formula in multiple columns, only for my analysis to …
Continue reading