Simple data blending in Google Data Studio
You don't have to play with a single data source anymore.
Think about you have a physical store and want to run local ads to drive traffic to your website. How do you merge online advertisement efforts with offline visits or purchase?
There is certainly no direct and %100 correct way to do it but, let me elaborate a bit more :
You have a website
You run Instagram ads that land the promotion page
Online visitors get the discount code
Then they visit your physical store and purchase the product
If this scenario seems familiar then your performance metrics will be something like offline visit(or purchase) conversion rate. (Store Visit/Website Lead)
Let’s assume that you have both these data on Google Sheets and want Data Studio to calculate the conversion rate. To do it, just select 2 inputs -> right-click -> then blend data.