Skip to content

Instantly share code, notes, and snippets.

@itsderek23

itsderek23/lost_keywords.py

Created July 6, 2019 20:26
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save itsderek23/e0381ab54a9ba73e2bbac4edf33bda5e to your computer and use it in GitHub Desktop.
Save itsderek23/e0381ab54a9ba73e2bbac4edf33bda5e to your computer and use it in GitHub Desktop.
Download ZIP
SERP Analysis - Lost Keywords
Raw
lost_keywords.py
# for each query, find min & max date
df_by_query_date = df.groupby("query").aggregate({"date": ["min","max"], "clicks": "sum",
"impressions": "sum", "position": "mean"}).sort_values(("impressions","sum"),ascending=False)
# filter to just queries in above the median in impressions
df_by_query_date = df_by_query_date[df_by_query_date[("impressions","sum")] >= df_by_query_date[("impressions","sum")].quantile(0.50)]
# find all queries that haven't appeared in the last two weeks
df_by_query_date[df_by_query_date[("date","max")] < datetime.datetime.now() - datetime.timedelta(days=14)].head(5)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment