Tag Archives: google sheets

Google Sheets and Python

So you’re building a simple internal app and you think “I’m gonna need a database right?” Well, not so fast. As this tweet points out, Google Sheets might be all you need. Let’s see how we can use Python to access Google Sheets. To kick things off we’ll first create a project inside of Google’s… Read More »

How to create Google Data Studio Dashboards for SEO

Hello everyone. You’re waiting for dinner. So yeah, I will try and make it exciting. So yeah. Firstly, who am I? Yeah, so I’m the SEO lead at Vodafone group so I manage 22 markets, 560 million mobile customers. I’ve been an SEO for 20 years. But I’ve developed complete love for Data Studio. And… Read More »

Analyze sentiment of open-ended feedback and gain insights in Google Sheets – Sheets to Apps

Facebook Ads Dashboard with Google Data Studio | Lesson 3

– Alright, so now that we have prepared our data in Google Sheets, we are ready to visualize it. We’ll first calculate our metrics, then lay out our dashboard, and then, finally, implement our data in Google Data Studio. All and more coming up right after this. (upbeat music) Today our journey starts in Google… Read More »

Introduction to Google Data Studio

Welcome to Google Data Studio! This short video will show you how to accomplish the 3 primary tasks you need to create beautiful reports that tell stories with your data: Connecting to your data Visualizing that data to gain insights And sharing reports and collaborating on them with your colleagues and customers You can follow… Read More »

Combine Data Sources in Google Data Studio | Lesson 2

In this lesson we’re going to set up our data sources in Google Sheets with the help of Super metrics so we’re going to pull the data from Facebook ads and Google analytics and then prepare it so it’s Ready to be used as a source within Google Data studio now all the more coming… Read More »

Link Building with Google Sheets: Start Guest Posting in 15 Minutes

Today, we’re going to create a link building template like this, where you can find prospects and valid email addresses in under 15 minutes. Stay tuned. [music] What’s up SEOs? Sam Oh here with Ahrefs, the SEO tool that helps you grow your search traffic, research your competitors and dominate your niche. Now, if you’ve… Read More »