2

I am using Google Console Search API to extract the search Analytics data. I am using query() method for retrieving data.
Parameters:

startDate: '2017-05-10'

endDate: '2017-05-10'

dimensions: ['date','query','page','country','device']

aggregationType: byPage

rowLimit: 1000

startRow: 0.

It should give me 1000 records, right? But I am getting less no of records(853). what could be the reason?

While reading the documentation I have come across that when we use date in dimension group and if we don't have data for that day then the row is excluded from result set. Is this the reason?

Any help would be appreciated. Thanks

Subhash Deshmukh
  • 350
  • 3
  • 18
  • What do the result rows look like? I've never seen a query with that many items in dimensions. I only do queries with one dimension per query. I have a theory why you're not getting 1,000 records but I need to know what your results look like first. – eyedar Aug 04 '17 at 20:36

2 Answers2

2

Check out my answer for getting more results here: https://stackoverflow.com/a/45628911/2527200

I noticed, that requesting for page and query at the same time results in less results. You should request only query or page in the dimensions.

Tanktiger
  • 80
  • 1
  • 12
  • I have aware of the documentation to get the query result more than default 5000 records. But, my query was about I am not able to get the record count I have mentioned. ie. if I set the limit to 1000 which is less than max 5000 record limit I am not able to get 1000 records also. I am getting 700 records. – Subhash Deshmukh Nov 20 '17 at 13:58
  • So, I explored a bit about it and found out that this is how the API behaves. I solution I have implemented is I am counting the number of records received in the first request and setting startrow with that value for the next request till all the records are pulled. Is it making in sense? – Subhash Deshmukh Nov 20 '17 at 13:59
  • This makes sense but if you set the limit to 1000 and get less results, this must be because there are no more results. – Tanktiger Dec 01 '17 at 17:47
  • I searched for this possibility also, but there was some cases where records were more than 1000 and in first request it is returning only 800. Do u think is it the issue on the google side? – Subhash Deshmukh Dec 01 '17 at 17:51
0

I think You can search for 1000 urls by one account. RowLimit is the maximum number of rows to return. The API does not support paged results. Default is 1,000

johnyT
  • 59
  • 11
  • T I think by 1000 urls you mean 1000 properties per account. But I am using searchAnalytics query to extract statistics for single property only. Yes I know the API does not support paged results. Default is 1000 but I can give maximun rowLimit=5000. I figured out that I am not getting all data because the dimension grouping I have used is not correct. So instead of that I used dimensions=['date','query'] and used filters for make request against each query. This is working in my case. – Subhash Deshmukh Jun 05 '17 at 07:01