I have connected GSC data to Lookerstudio. What I want to do is show a weekly/monthly change of ranking keywords our site has in each of these "buckets"
- Average position 1-10
- Average position 11-20
- Average position 21+
I have tried doing this many ways with calculated fields and filters. Problem with calculated fields is that I am mixing dimensions with metrics which Looker does not like. Then with filters, I am getting issues with aggregated metrics (apparently average position is an aggregated metric).
Is there anyway to do it? I just want to have visuals that show WoW/MoM the change of the amount of ranking keywords in each of the keyword bucket groupings.
LinkedIn
Twitter
