-
Where do you store your SERP data?
I’m currently planning what’s the most cost/effective way to store SERP data (ranking positions). BigQuery, MongoDB…? I’m struggling to calculate the growth of this database in the longterm and how expensive will be query this information in the long run. What do you suggest and why?
-
6 Replies
-
That’s kinda vague. What are you storing? Keyword data, ranking positions, SERP features, etc? What’s the intended outcome of having this data stored?
Databases are a dime a dozen to be honest, sticking with mainstream platforms will be the best option. MySQL is the most widely supported. You can use MySQL Workbench or number of others to assess it. MongoDB built a data visualization tool but it’s a NoSQL database.
-
How much do you actually expect to have? I’m a big fan of BigQuery but if you want subsecond response times you’ll need to cache in Postgres. If you don’t see yourself getting over like 10TB of data anytime soon than maybe just start with Postgres.
-
Truthfully, you could keep that in Excel and save yourself the headaches if all your doing is storing.
-
If you want to store ranking positions for specific queries with URL information, excel is enough to do it.
But if you want to create better graphics and draw data with easier than excel, I think BigQuery is better. -
Excel. Because I do manual tracking of SERPs.
How do you track SERPS?
-
Check AWRcloud for nice visual serp positions.
Log in to reply.