***Tip: Have a question? Ask in the comment section below or in this Facebook group. You can also sign up for our free newsletter.*** Are you wondering how to send Google Sheet files as attachments in scheduled emails? If you are a coder, you can code your own GoogleApps script. However, not everyone is a coder […]
Category: Excel/Google Sheets Functions
Supermetrics for Google Sheets & PowerBI: The Ultimate PPC Reporting Combo
***Tip: Have a question? Ask in the comment section below or in this Facebook group. You can also sign up for our free newsletter.*** Everyone is currently playing with Google Data Studio. However, there is also an alternative reporting combination which no one is using: Supermetrics for Google Sheets & PowerBI from Microsoft. So let’s have […]
Using Google Sheets as Data Source in Power Query
***Tip: Have a question? Ask in the comment section below or in this Facebook group. You can also sign up for our free newsletter.*** Google Sheets have replaced Excel in a lot of companies so how do Google Sheets get along with Power Query? Actually pretty well. Sample scenario: You store reference sheets via Google Sheets […]
How to Do VLOOKUP in Power Query?
***Tip: Have a question? Ask in the comment section below or in this Facebook group. You can also sign up for our free newsletter.*** Sooner or later, everyone needs to match data from one table to another based on a common key. In standard Excel, VLOOKUP function would be used. In Power Query, “Merge” function needs […]
Commonly Used Excel & Google Sheets Functions in PPC Industry
***Tip: Have a question? Ask in the comment section below or in this Facebook group. You can also sign up for our free newsletter.*** The attached file in this article lists all the handy functions used in the PPC industry. The functions are separated into 5 categories: Logic + Text functions Date functions Sum + Count […]