- Detailed steps on how to reproduce the issue
- Win 7 64 bit SP1
- Excel 2016
- SeoTools version 7.0.11
I am using the following concatenation of text strings to ask for adwords search volume data:
Each of these petitions prints out 17 numbers for adwords for the 17 concatenated strings.
The problem is if I replicate this formula to 100 cells to sequentially ask for this data, every 3 or 4 arrays of data adwords throttles the response and SEOTOOLS doesnt handle it well and prints #VALUE!. This forces me to then manually go through all the #VALUES and asking them individually, which of course does not trigger the adwords throttle.
Basically the function should detect when adwords is not offering a response due to throttling, wait a second and then request again until a timeout is reache dor the request is fulfilled.
My adwords manager API account is correct and functioning well.