We require a Google Analytics/Search Console/Datastudio WIZARD to assist with putting together an SEO dashboard for us.
We would like to report organic traffic data for the following metrics: impressions/clicks/goal completions as well as a 30 - 90 and 365 days performance comparison (possibly with some conditional logic behind the colour scheme, like a traffic light system for performance/red/yellow/green).
We also require a Top Search Query table that reports on Clicks/Impressions/Average position/Conversions/Conversions. And also a Search Query table with all Goal/Conversion type data.
We already have a custom report setup to produce the Search Query/Keyword conversion data, but a majority of conversions are listed as "not provided", we need to see if there is a solution to this.
Any example reports/dashboards that you have already produced that are similar to this would be good to see.
I've attached a sketch of the kind of layout we are after. The main thing is to solve the "not set" "not provided" search query data. The sketch is just a broad overview, we hope to find someone who can add some ideas to the project, and make suggestions if you know a better way to get and display the data.
The data will come from GSC and GA.