I’ve been working on automating parts of my SEO reporting workflow recently, mainly to avoid manually comparing keyword ranking exports every week.
One simple thing that helped was using Python to compare two CSV exports and quickly identify ranking movements:import pandas as pd
def compare_ranks(old_csv, new_csv):
old = pd.read_csv(old_csv, index_col='keyword')
new = pd.read_csv(new_csv, index_col='keyword')
changes = new['rank'] - old['rank']
return changes[changes != 0]
rank_changes = compare_ranks(
'ranks_week1.csv',
'ranks_week2.csv'
)
print(rank_changes)
I’m also experimenting with different ways to automate data collection from rank tracking tools instead of exporting everything manually each time.
Top comments (1)
Great.
Hope to see your future plan!