Data Studio
2.2K members online now
2.2K members online now
Ask questions about Data Studio
Guide Me

How to calculate the difference between two scorecards?

Follower ✭ ☆ ☆
# 1
Follower ✭ ☆ ☆

We are trying to calculate  a (simplified) profit from our Twitter campaign.

The ad spent is coming from a google sheet ( export from twitter analytics) and the revenue is coming from the data source.

Is there a way where we can show a 3d score card that just deducts the values in these two cards?


(Combining the revenue from GA in the ad spent google sheet from twitter will not fix this when the date range is changed. + it will require unnecessary exports from GA)

Thanks for your help.



1 Expert replyverified_user

How to calculate the difference between two scorecards?

Top Contributor
# 2
Top Contributor

Hi @Just B,


Google's BigQuery can be used as a data source in Data Studio... and you can get a free 30-day trial. I think you might like it for this and other purposes. 


Kind Regards,




Google AdWords Top Contributor | Google Partner | GYBO | Local Guide | My Profile