How this ex-Googler builds his Facebook & Google Ads reports
TL;DR: Juan Lombana, a Google Marketing expert, switched from manual reporting on Google Sheets to blend and visualize Facebook Ads and Google Ads data on Google Data Studio, automatically. Here’s how he does it. About Juan Lombana Juan Lombana is, probably, the most renowned Google Ads expert in the Hispanic market and Latin America. He’s […]
How we landed a Fortune 500 company with content marketing
Long story short: we published a COVID-19 dashboard that went kind of viral and attracted the attention of a large company that would become a customer, leading to several projects and contracts with our startup. I’d like to say that such a win was premeditated, and it was part of our marketing strategy, but it […]
How to create a Google Data Studio report with Google Sheets
In the last session, we explored the Google Data Studio connectors. In this session, we will create a report on Google Data Studio with Google Sheets. Why Google Sheets is Great for Data Studio There’s a misunderstanding of people comparing Google Sheets VS Google Data Studio, when they’re complementary, not alternatives. As we have mentioned […]
How to automate your Facebook Ads reports on Google Data Studio (templates included)
This is a complete and comprehensive guide to help you fully automate their Facebook Ads reports on Google Data Studio. Here are the steps we will follow: Setting up a Google Data Studio account If it is the first time you are using Google Data Studio, here are some things you need to know. Google Data Studio […]
Branded vs. non-branded searches report with Google Search Console and Data Studio (Free Templates included!)
In this tutorial, you will learn why breaking down traffic into branded and non-branded matters for analyzing your SEO efforts, how to do it, and a free Google Data Studio (formerly Looker Studio) template that will save you a ton of time. Why analyzing branded and non-branded searches matter Should branded searches count in your […]
How to Create an Instagram Report on Google Data Studio
Creating content for Instagram takes a significant amount of time, especially if you intend to post frequently. Connecting Instagram to Google Data Studio (formerly Looker Studio) can be difficult, particularly for beginners. In this blog post, you’ll learn how to create a Instagram Report on Google Data Studio! In case you want a quick answer, […]
Behind the scenes: July 2020 product updates
Most of our first users have trusted Porter because they know us personally. So I wanted to start writing about who we’re, what we’re doing, and have the most open and transparent communication with those who visit our site. We’re happy our Facebook Ads connector for Google Data Studio is doing fine! We know we’re […]
How to calculate cost-related metrics on Google Data Studio
If you’re using our Facebook Ads connector for Google Data Studio or similar connectors, you may notice that we don’t bring all the cost-related metrics. We bring, for instance, Cost per Click, but not Cost per Purchase, or Cost per Comment or Cost per Added Cart. Why is that? We’re already pulling over 600 fields […]
How to run an SEO keyword audit on Google Data Studio
Like most of you, I’m an SEO guy. Chances are you’re kind of obsessed with tracking keyword rankings. You also know about the opportunity of long-tail and short-tail keywords and why they matter, but do you know how much traffic you get from long-tail keywords, for instance? And also, you may have a huge list of […]
Get Started with Google Data Studio: Most Common Questions
Google Data Studio (formerly Looker Studio) most common questions This article is a transcription of our Youtube tutorial. If you want to learn Google Data Studio from scratch; if you want a better way to tell stories and present your data; if you want to learn data visualization—a must-have skill in your company, career, agency, […]