Our data rarely sits in a single tool or platform. Usually we need to take a look at numbers from different sources to see a useful version of what's happening in our business or those of our clients.
There are times that it makes sense to visualize data from multiple platforms side by side, but there are also times that we need to show similar or closely related metrics from different platforms on a single chart or graph.
Cost (Ad Spend) is one of the metrics that occurs across multiple ad platforms and thus, we usually want to see a breakdown, or trend, of our expenditure over different channels in a single chart.
Today, we're going to see how to show Cost data, per day, from Facebook Ads and Google Ads in a single time-series chart.
I this example, I use the built-in data connector for Google Ads, and Supermetrics for Facebook Ads data.
📩 Receive my weekly Looker Studio tips
🖇 Connect with me on LinkedIn