Sample Project Tracking Sheet

	A	B	C	D	E	F	G	H	I	J	K	L	M	O	Q
1
2	Sample Project Tracking Sheet							Smartsheet Tip ➜	Customize the list of possible statuses and priorities to the right so that the Status and Priority columns can use standardized values.					STATUS KEY	PRIORITY KEY
3														On Hold	Low
4	PROJECT TITLE		Sample					COMPANY NAME	Sample					Not Yet Started	Medium
5	PROJECT MANAGER		Assigned Account Manager 123-123-1234, accountmanager@ailie.com					DATE	2/1/24					In Progress	High
6	Meeting Request Form	https://www.ailie.com/book-a-meeting												Complete
7	Change Requets	https://www.ailie.com/change-request-form
8	PROJECT DETAILS								DELIVERABLES		COST/HOURS
9	STATUS	PRIORITY	START DATE	END DATE	DURATION	TASK NAME	ASSIGNEE	DESCRIPTION	DELIVERABLE	% DONE	FIXED COST	ESTIMATED HOURS	ACTUAL HOURS
10	Monthly Meeting
11								*All documents brought to or referred to during the meeting must be signed by the client in Adobe Autosign. The purpose of the monthly meeting is to bring together the monthly business report, and monthly budget report, business plan (encompassing LT-& ST-Goals) for the purpose of understanding what is/is not working and as a result generation.
12	Monthly Business Report
13								A report that includes data from Google Search Console, Google Analytics, Google Local Business, Google Ads, FB Analytics, LinkedIn Analytics, SEMRUSH, Ocean 1 SEO.
14	Monthly Budget Report
15								A report that encompasses the monthly planned and actual expenses.
16	Business Plan Created By Client (5- to 10- year Plan)
17	To be discussed next meeting							The Business Plan is shared with the project manager so there is clarity around short & long term goals which are recorded in this project management sheet.
18	Social Media Management /Post Delivery/ Content Management/Engagement
19		High	ONGOING	None	5 Per Week	Task		Creating a post for each social outlet starting with a graphic orr video creation. Then building content for the post. Next delivering it to Twitter, Instagram, Facebook, Google Local Business, Blogger.
20	SEO Work / SEO AUDIT / GOOGLE ANALYTICS Key Word Website Intigration (Ongoing)
21		High	ONGOING	None	10	Task		This is something that is done weekly. It is up to the amout of money that is available.
22	Monthly Newsletters
23
24	Import All Customer Data
25						\
26
27
28	Edit Directory Submissions With Correct Contact Information & New URL
29	In Progress	High			10	Directory Submissions
30
31
32	Create New Backlinks
33		High			5 A Week	Backlinks		Concept: Ask other business owners to list URL on their site. This is being done through backlink building. This may include the idea of 1. Google Adsense. 2. A loyalty program with client that if they they will get a discount. 3. Have an ad space on the site and leave room for advertising others that advertise Account Abilty. 4. Offer to pay for ad space on other sites. Ocean One SEO will build backlinks.
34	Linkedin Ads
35
36
37
38	Analytics Tracking
39		High				Analytics Tracking		I need access to the Google Local Business Page, Google Search Console, Google Analytics		?
40	ON Page SEO
41		High				On Page SEO		Work On Meta Discriptions, Meta Tags & Keywords quality review.		?
42	Paid Ads
43		High		None	on going	Task		Google ads, Twitter ads, Facebook ads
44	App?
45	Not Yet Started	High		None	1	Task		Add It
46	Google Local Business / Google Search Console / Google Annalytics Mainteance
47		High		None	1	Task		Add It
48	You Tube Ads
49		High				Task
50	Automated Responses
51		High		None	1	Task		CRM
52	Click Funnels
53								On Going Effort
54	Pop Up For Advertising
55		High		None	1	Task		Done
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100