Example SEO Project Tracker

	A	B	C	D	E	F
1	Owner	Link Type	Task	Deadline	Status	Notes

2	Usman	Admin	Create New Gmail Account For Client	20/3/2016	Completed
3	Usman	Admin	Create New Set of Pitches Based	20/3/2016	Completed
4	Usman	Guest Post	Find 20 Opportunities	20/3/2016	Assigned
5	Usman	Admin	Use Google Search Console / SEM Rush to Find Pages With Keywords Ranking 7 - 20	20/3/2016	Completed
6	Usman	Admin	Use Google Search Console to Find Pages With Large Impressions But Low Clicks	20/3/2016	Completed
7	Usman	Admin	Use Majestic to Find Anchor Text Ratio of Target Pages	20/3/2016	Completed
8	Usman	Link Roundups	Find 15 Opportunities for Cleaning Tips	23/3/2016	Working
9	Usman	Link Roundups	Create Roundup Pitch and Set Canned Response	21/3/2016	Completed
10	Usman	Resource Pages	Find 20 Opportunities for Cleaning Tips	23/3/2016	Assigned
11	Usman	Link Roundups	Pitch All 15 Opportunities (At Once)	25/3/2016	Assigned
12	Usman	Guest Post	Pitch 7 Opportunities	25/3/2016	Assigned
13	Usman	Resource Pages	Create Roundup Pitch and Guest Post Pitch and Set Canned Response	28/3/2016	Completed
14	Usman	Broken Links	Check Each Opportunity For Broken Links	30/3/2016
15	Usman	Resource Pages	Pitch All 20 Opportunities (at Once)	1/4/2016
16	Usman	Guest Post	Find 50 Opportunities	30/3/2016
17	Usman	Guest Post	Pitch 7 Opportunities	1/4/2016
18	Usman	Guest Post	Pitch 7 Opportunities	1/4/2016
19	Usman	Guest Post	Pitch 7 Opportunities	1/4/2016
20	Usman	Resource Pages	Find 20 Opportunities For Kitchen Cleaning	8/4/2016
21	Usman	Link Roundups	Find 15 Opportunities For Kitchen Cleaning	8/4/2016
22	Usman	Link Roundups	Create Roundup Pitch and Set Canned Response	8/4/2016
23	Usman	Link Roundups	Pitch All 15 Opportunities (at Once)	8/4/2016
24	Usman	Guest Post	Pitch 7 Opportunities	8/4/2016
25	Usman	Bridge Niche	Find 20 Opportunities	15/4/2016
26	Usman	Resource Pages	Create Roundup Pitch and Set Canned Response	15/4/2016
27	Usman	Broken Links	Check Each Opportunity For Broken Links	15/4/2016
28	Usman	Resource Pages	Pitch All 20 Opportunities (at Once)	15/4/2016
29	Usman	Guest Post	Pitch 7 Opportunities	15/4/2016
30	Usman	Bridge Niche	Pitch 7 Opportunities	15/4/2016
31	Usman	Guest Post	Pitch 7 Opportunities	15/4/2016
32	Usman	Bridge Niche	Pitch 7 Opportunities	15/4/2016
33	Usman	Bridge Niche	Pitch 7 Opportunities	15/4/2016
34	Usman	Guest Post	Pitch 7 Opportunities	15/4/2016
35	Usman	Sponsored Post	Find 15 Opportunities	22/4/2016
36	Usman	Bridge Niche	Find 20 Opportunities	22/4/2016
37	Usman	Local Bloggers	Find 100 Local Bloggers / Blogs (Location = London,UK)	22/4/2016
38	Usman	Guest Post	Pitch 7 Opportunities	22/4/2016
39	Usman	Sponsored Post	Pitch 5 Opportunities	22/4/2016
40	Usman	Bridge Niche	Pitch 7 Opportunities	22/4/2016
41	Usman	Local Bloggers	Pitch 2 Bloggers On a "Sponsored Post"	22/4/2016
42	Usman	Local Bloggers	Pitch 2 Bloggers On a "Guest Post" to Leverage Our Audience	22/4/2016
43	Usman	Guest Post	Pitch 7 Opportunities	22/4/2016
44	Usman	Sponsored Post	Pitch 5 Opportunities	22/4/2016
45	Usman	Bridge Niche	Pitch 7 Opportunities	22/4/2016
46	Usman	Local Bloggers	Pitch 2 Bloggers On a "Sponsored Post"	22/4/2016
47	Usman	Sponsored Post	Pitch 5 Opportunities	22/4/2016
48	Usman	Bridge Niche	Pitch 7 Opportunities	22/4/2016
49	Usman	Local Bloggers	Pitch 2 Bloggers On a "Sponsored Post"	22/4/2016
50	Usman	Guest Post	Find 50 Opportunities	29/4/2016
51	Usman	Link Roundups	Find 15 Opportunities For Niche 3	29/4/2016
52	Usman	Resource Pages	Find 20 Opportunities For Niche 3	29/4/2016
53	Usman	Resource Pages	Create Roundup Pitch and Set Canned Response	29/4/2016
54	Usman	Broken Links	Check Each Opportunity For Broken Links	29/4/2016
55	Usman	Resource Pages	Pitch All 20 Opportunities (At Once)	29/4/2016
56	Usman	Guest Post	Pitch 7 Opportunities	29/4/2016
57	Usman	Link Roundups	Create Roundup Pitch and Set Canned Response	29/4/2016
58	Usman	Link Roundups	Pitch All 15 Opportunities (At Once)	29/4/2016
59	Usman	Sponsored Post	Find 15 Opportunities
60	Usman	Bridge Outreach	Find 50 Local Blogs That Are in the SAME Vertical But Not in Competition
61	Usman	Sponsored Post	Pitch 5 Opportunities
62	Usman	Bridge Outreach	Find 50 Blogs That Are in a SIMILAR Vertical
63	Usman	Bridge Outreach	Pitch 10 Editors on a Guest Post / Exchange of Post
64	Usman	Sponsored Post	Pitch 5 Opportunities
65	Usman	Sponsored Post	Pitch 5 Opportunities
66	Usman	Link Roundups	Find 15 Opportunities For Niche 4
67	Usman	Resource Pages	Find 20 Opportunities For Niche 4
68	Usman	Link Roundups	Create Roundup Pitch and Set Canned Response
69	Usman	Link Roundups	Pitch All 15 Opportunities (At Once)
70	Usman	Resource Pages	Create Roundup Pitch and Set Canned Response
71	Usman	Broken Links	Check Each Opportunity For Broken Links
72	Usman	Resource Pages	Pitch all 20 Opportunities (at Once)
73	Usman	Blog Comments	Find 50 DA 50+ Niche Relevant Blogs that Accept Comments
74	Usman	Blog Comments	Leave 2 Comments Per Week
75	Usman	Forum Comments	Find 10 QUALITY Forums
76	Usman	Forum Comments	Join Each Forum Right Away With the Client's GMail Address
77	Usman	Forum Comments	Create a Profile on that Forum, Complete With Picture and Link to Site
78	Usman	Forum Comments	Leave 1 forum Comment Per Week on Relevant Thread
79	Usman	Social Media Groups	Find 5 QUALITY Relevant Facebook Groups
80	Usman	Social Media Groups	Find 5 QUALITY Relevant Google+ Communities
81	Usman	Social Media Groups	Leave 1 Forum Comment Per Week on Relevant Thread
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100