How to Create 2 Comparisons with Data Studio Scorecards

preview_player
Показать описание
Need to compare 2 time periods in Data Studio? Here's a quick but effective trick using scorecards.

Pro Tip: Be sure to name the time periods you're comparing in the report!

-----
Paid Search Magic is a paid media agency run by Amy Hebdon and James Hebdon (yes, we’re married, and we work together). We get amazing returns for our clients, and we teach other digital marketers how to run ads for better results.

Follow Paid Search Magic online here:

Рекомендации по теме
Комментарии
Автор

Needed to do exactly what you've done and that is brilliantly simple! Thank you!!

nickbaker
Автор

thanks amy it helps a lot for my career

yusufbas
Автор

Nice One... keep posting these kind of cool stuff

rajsekhar
Автор

Very nice work. Very useful. Just wanted to ask how you put arrows in change column?

tmukanov
Автор

Nice work done.... I want to know how you create table format for two different months and also shown deviation arrows as a 'change' can you make a video or give me some clue how to make this in edit mode ?

rohitthorat
Автор

Trick is good, can u please advice how to set button click graph

pravingangurde
Автор

this little trick is very useful thanks!

anggipermanaharianja
Автор

Hi Amy! Thanks for doing this. I checked out your post regarding how this data sheet was made and I am still confused.. I learn best when I have a working sample right in front of me so I was wondering if you could give us access to the sheet you showed us here? Thank you again.

heroineanime
Автор

How do I get a google sheet refreshed every time I refresh my data Stuido report ? Apparently I want BQ to feed this google sheet ..

hashfootball
Автор

After choosing the label color as white and placing it on top of scorecard its blocking the main metrics

srikar
Автор

How to display last record from GS in score card based on date filter?

premsc
Автор

If i have data
Month Salary Employee
January 10, 000. Alex
February. 15, 000. Alex
March 20, 000. Alex

and I want report such as

Filter: This month
Filter: Prev Month

Employee. March February DIfference Amount Percentage
Alex. 20, 000. 15, 000. 5, 000 33.33%


How to get such report in Data Studio?

saajanMaharjan