Category Google Sheets

September 5, 2019

How to merge data from various sources in Google Sheets.

Here is a simple guide on how to merge data from various sources in Google Sheets. Let’s say you have two data source, for example, Facebook Ads and Google Ads, and that you want to sum their Impressions, Clicks, Conversions, and Cost. Here is a simple illustration made with Google Data Studio of what you will be able to achieve by following this guide. [caption id=“attachment_1524” align=“aligncenter” width=“616”] Google Data Studio Dashboard with individual and merged data sets[/caption]

July 4, 2017

5 tips and formula to blend data in Google Spreadsheet

You have a spreadsheet full of data. It’s messy and you don’t really know how to merge and organize all this. In this blog post, I will give you a quick overview of the best tips and formula blend data in Google Spreadsheet. If you have read my article about using Supermetrics these tips and formulas will be definitively useful. I hope it will lead my readers to the path for more efficiency.