Extracting Queries from Google Search Console

Support
#1

Hi folks,

I'm noticing that when extracting queries with the GSC connector, the queries do not sort by top clicks. However, when my colleague runs the same formula (out of the tool) it works -- this may be because he has the previous version of the tool. It seems that with the current version, the connector is not sorting the queries, but instead pulling them in randomly.

The formula generated by the GSC connector: =Dump(Connector("GoogleSearchConsole.SearchAnalytics","http://www.[site].com/","2017-03-17","2017-03-23","page=[page]","web",5,0,"Query,Clicks",FALSE))

I also noticed that I do not get the requested number of requested items either -- when I requested 5 queries (using the formula above) I received 3 queries. And to verify these issues, I used the GSC platform (same parameters) to check which queries and how many should've populated from the formula -- and they differed for me, while matched for my colleague.

Please let me know if there is a workaround or fix for this.

Thanks!

#2

Hi,

Thank you for reporting this. I'm not getting the correct rows when using formula mode so we will try and fix this asap. We've had some related input-formula bugs so hopefully we can sort all of these out.

What version are your colleague using when extractingn correct results?

#3

Fixed in 7.0.8 http://links.seotoolsforexcel.com/latest/

#4

Thank you very much!

#5

Hello,

I got data with formula
=Dump(Connector("GoogleSearchConsole.SearchAnalytics";"http://www.[site].de/";"2017-07-01";"2017-07-31";FALSCH;;"web";200;0;"Query,Clicks,Impressions,Ctr,Position";WAHR))

After getting the data I want to sort them by position, that works. After sorting I want to delete bad rankings/positions, for example from position 30 on. But when I delete these lines, the sorting gets lost.

I just got the latest version.