SEMrush for data studio - No query that combines dimension: time vs Metric: Position
We have a subscription to the Google Data Studio connector pro package. I am trying to create a graph that displays the dimension: date against the metric: keyword position in data studio bar chart so we can compare the amount of keywords positioned 1-3, 4-10 and 11-20 against each month for a specific domain to show our clients SEO growth (see image attached below).
The problem is that no query combines this data. Would it be possible to construct this graph in Google Sheets and then importing it into Google Data Studio?
Has anybody know of any solutions?