January 27, 2020
Hi, I'm a blogger and have an idea for a template that can be used by content marketers like myself,
Sheet 1 should have an integration with Google Analytics for tracking their own website's analytics.
Sheet 2 will be for tracking keywords (with columns for tracking CPC, top 10 competitors ranking for the keyword).
Sheet 3 for tracking Links to top-ranking pages (with columns where I place the pages URL, another containing links e.g. link 1, link 2, link 3 etc)
Sheet 4 for tracking outreach (with columns for website url, contact person's name, email, reach out date 1, response, follow up date, response.
Sheet 5 for tracking influencers (with columns for influencer name, website URL, linked URL, Twitter Handle, number of followers).
PS: I'm an amateur with excel so I encourage you to give ideas on what can work, what can't (for example on sheet two I'm not sure how we can have a column containing 10 10 competitors) and maybe how to change some things.
July 16, 2010
I'm sure it's all possible and will be valuable for SEO. You can use PivotTables to extract the Top 10 based on a value field. I encourage you to learn PivotTables. I have a PivotTable QuickStart course that'll get you up and running in a couple of hours.
If you have any specific Excel questions along the way, be sure to post them in the forum with your sample Excel file or screenshots and we can help you further.