Using CASE formula in Data Studio to pull valuable data from Search Console
A problem I have as an SEO is that I can't see Google Search Console's data based on each day of the week. For instance, it would be difficult for me to compare the performance of my website on all Mondays of July with all Wednesdays of the same month using GSC.
Using Google Data Studio, I was able to acquire this data. If you’re interested in learning more, continue reading.
To begin, you must open Data Studio and connect it to your website's GSC.
Choose "Manage Added Data Sources" under Resource.
The next step is to select the edit action for the relevant GSC data source.
It is now time to add a new field.
Paste this formula into the formula section and give the field a name.
CASE
WHEN WEEKDAY(Date) = 1 THEN "Monday"
WHEN WEEKDAY(Date) = 2 THEN "Tuesday"
WHEN WEEKDAY(Date) = 3 THEN "Wednesday"
WHEN WEEKDAY(Date) = 4 THEN "Thursday"
WHEN WEEKDAY(Date) = 5 THEN "Friday"
WHEN WEEKDAY(Date) = 6 THEN "Saturday"
WHEN WEEKDAY(Date) = 0 THEN "Sunday"
END
Save the field, select done, and then click close.
You should now see the new field in the metrics of your data studio report if you add a chart.
With this new field, you can create insightful reports to analyze the organic performance of your website.
Let me know in the comments if you find this post insightful and would like me to share more ideas on using data studio to analyze GSC data.
Well done??