The Definitive Guide to Conditional Formatting on Google Sheets.
There's a lot of fun stuff you can do to make your GSheet tables look better.Last week, my colleague Sona Maharjan talked about how to merge cells and data to make your tables look cool. Conditional formatting is another easy way to format your data for easy reading. In this …
Merging cells and data in Google Sheets
Merging cells is a very handy tool in google sheets. It allows you to combine two or more cells horizontally, vertically, or both. One of the main reasons people merge cells is to extend a title or any content across multiple cells.How do we merge cells in google sheets?It is …
Guide to Pivot Tables on Google Sheets.
Pivot tables on Google Sheets enable you to organize your data without manual work. Here is how you can create one.
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.
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 …
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.
Analyze Stripe charges with Airboxr
With a little help from ZapierIf you use Stripe for your business, understanding how you're doing is essential to designing your marketing and sales strategy. While we do not connect natively to Stripe, you can quickly set up your Stripe integration with a little help from Zapier. Here are the …
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 …
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 …
How to use query + importrange to filter data on multiple criteria
With and without code.The query() function is an extremely handy function within Google Sheets, that makes it incredibly easy to filter data within your sheet. Let's take three minutes to see how it works. Case in Point: Pulling data from a Facebook Ads export based on multiple criteriaLet's say we …