Google Sheets

If you’re using Google Sheets, you probably need to reference or import data from another sheet every once in a while. It’s not very complicated, and there are a few ways to do that. You can copy/paste the data, of course. For a tiny, select dataset, that might work. But that way, your data won’t ...

Can’t make up your mind between Supermetrics for Data Studio and Supermetrics for Google Sheets (or Excel)? While we’d naturally recommend that you get both — Data Studio for data visualization and reporting and one of the spreadsheet products for data crunching and analysis — there are a few things you should consider before you ...

In today’s data-driven world, the ability to extract data from your website or app analytics platform is crucial to gaining insights and making better business decisions. What’s more, you’ll have ownership of your data, allowing you to further transform, blend or manage it how you need to. While Google Analytics 4 (GA4) offers powerful tools ...

Since 2014, Supermetrics for Google Sheets has been helping marketers and analysts automate tedious and repetitive tasks with the scheduled refreshing and emailing features. Fast forward six years, and we’ve moved the scheduler to the Google Sheets sidebar, making it even easier for you to stay on top of all the marketing metrics that matter ...

As digital marketers, we’re often experiencing data overload. And that’s why having a clear process for analyzing your paid campaigns’ performance is critical.  This process will help when you’re asking questions, like: To answer these questions, pivot tables come in handy. What are pivot tables? Pivot tables allow you to group data in a meaningful ...

Copy/pasting data from your web analytics platform to Google Sheets can be a total nightmare.  It’s boring, time-consuming, and you’re bound to copy data into the wrong cell at some point. And that’s why today, I’m going to show you how to import your website data to Google Sheets. Ready? Let’s go. How to import ...

TL;DR If you want to hit the ground running, take a copy of this Google Ads budget tracker template for Google Sheets. For more tips on how to improve your budget tracking, keep reading. If you’re a performance marketer, you’d probably agree that keeping track of your ad spend is a time consuming and error-prone ...

Whether you’re working on SEO or paid search, you’d probably agree that keyword research is a hairy beast. It’s slow, manual, and well… boring. But what if we told you that you can automate the process and get a list of hundreds of relevant keywords and your current ranking data flowing directly into your Google ...

Google Sheets is a great tool for marketers to gather, analyze, and report on how their marketing is performing. But getting started can be tricky, which is where ready made templates come in. In this article we’ve collected different Google Sheets templates for marketers to help you get started building your own marketing reports. We’ve ...

OKRs (objectives and key results) is an actionable framework for setting and tracking company goals. At kemb – a digital marketing agency, we’ve been using OKRs since 2014 and we’re convinced that they can help companies not only to perform better but also to increase employee satisfaction, since they help everyone work toward the same ...