Downloading Search Console Data?

chriscc

Member
Joined
Sep 6, 2016
Messages
11
Hi all.

Hopefully the right place for this post.

I want to download the historic daily number of impressions/clicks my site is getting. Easy, right? I went to Search Console -> Search Traffic -> Search Analytics, then set the date range (back to the beginning of July). Graph shows all the clicks and impressions. So far so good. Scroll down, hit download, open the CSV and it does *not* give me the day-by-day data but the clicks by keyword data.

Any ideas how to get the day-by-day data?

Thank you!
 

chriscc

Member
Joined
Sep 6, 2016
Messages
11
Thanks Heckler! I created a new project, read the API docs, fired up Python, and then realised it was Friday night and I couldn't be bothered. Just gonna enter the last 90 days manually, reading off the Search Console graph :)
 

Eric Rohrback

Moderator
Joined
Oct 3, 2012
Messages
989
Yeah, you really need to use the API to accomplish this. Doing it manually is a real pain. It also all depends what you're using the data for. The data reported in GSC isn't accurate, but gives you a good high level view of what's going on with the site. Don't take those numbers as absolutes.

What are you trying to do with the data?
 

chriscc

Member
Joined
Sep 6, 2016
Messages
11
Hi Eric

I was trying to get an excel (one row for each day) tracking: impressions and clicks from GSC; impressions and actions from GMB; and users and sessions from Analytics. I've done it manually now (I've only one small site to look after). But you're right it's a pain. I'm surprised someone like Moz or Ahrefs don't offer something where you can give them the API keys and they can pull all the data for you (or maybe they do and I haven't found that function)

Cheers
 

Weekly Digest

Weekly Digest
Subscribe/Unsubscribe

Promoted Posts

New advertising option: A review of your product or service posted by a Sterling Sky employee. This will also be shared on the Sterling Sky & LSF Twitter accounts, our Facebook group, LinkedIn, and both newsletters. More...

Local Search Forum


Google Product Exert

@LocalSearchLink

Join Our Facebook Group

Top