AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Data Studio
2K members online now
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 My Business & Google Ads Top Contributor
Google Partner | GYBO Agency | Local Guide | My Profile