Google Search Console Landing Pages with Queries, Impressions, Clicks, CTR and Average Position for the last 18 months

You have to make a data blend in Google Data Studio. Follow this article.

So must stress out that you put no filter into the dashboard at all and you have a Date range control added to that report, so you can select the timeframe.

So hover over the pivot table report, and on the right upper corner you will find the 3 vertical dots - More menupoint. Click on it and select, Export. Export it to Google Sheets.

Now your Google Sheets will cry for a minute or two. In this way I exported 45000 records for the Hungarian market in the last 15 months. Dirty, I know.

I advice that you can use the TRANSLATE function if you work with a least known language. With this you can Google Translate any cell content. Yes, it is not the best for Eastern European markets, but still better than nothing.

I furthermore advice if you need to SPLIT the Landing page Url with a "/", so you can for example make a filter which query belongs to which product category. (if your url contains that information)

With the UNIQUE function you can get into one column the unique Landing Pages. For example if you had filtered the results based on Average Position and you still have lots of repetitive records, and you just want to see how many and which Landing Pages you have.

See an impressive slice of the exported Google Sheet with cca 45k records: