Automated ROI Reporting and Social Value Assessment in Sprout Social

The main goal of this project is to set up and automate report generation in Sprout Social to enhance the accuracy and efficiency of ROI reporting. This includes creating customized report templates that pull relevant data and developing a method to assign reasonable monetary values to social actions, akin to PR evaluation techniques.

Capacity and Schedule Optimization Project

The main goal of this project is to optimize the tracking and management of Keep Social Media Social's overall capacity and schedule to improve project planning and prioritization. By leveraging existing tools like Asana, Toggl, and spreadsheets, or potentially adopting new solutions, the project aims to provide a clear understanding of individual staff capacity and enhance the agency’s efficiency in time management. This will involve several different steps for the students, including: - Analyzing the current capacity and schedule tracking methods used by Keep Social Media Social. - Researching and evaluating existing tools such as Asana, Toggl, and spreadsheets for their suitability in improving capacity and schedule management. - Developing a plan for implementing the chosen tools or new solutions to optimize capacity and schedule tracking. - Testing the new system and making necessary adjustments based on feedback. - Providing training and documentation for staff on how to use the new tools or solutions effectively.

Hubspot Sales Optimization Project

The main goal for the project is to optimize paid Hubspot functions and better manage the sales process and performance of Keep Social Media Social within Hubspot. This will involve several different steps for the team, including: Programming "sales packages" into Hubspot. Building out products in Hubspot. Better managing the sales process such as pipelines, etc. Better tracking sales performance of the organization within Hubspot. Create training manual with best practices. Provide training to our staff.

Competitor, Industry & Pricing Analysis

We would like to have a better understanding of our competitors, their pricing, and the way they are packaging their social media services. We are a 5-year old social media agency that *only* offers social media services - ie no SEO, PPC, web design, etc. We do however offer a wide variety of services that relate to social media including (but not limited to) Social Media Management services (platform management and campaign execution of Facebook, Instagram, LinkedIn, Pinterest, Twitter, etc. Most of these services are provided through a package and our minimum is $1,500 per month.) Social Media Paid Advertising services (ad campaigns on the above platforms) Social Media Strategy services (we create the social strategy/plan and they execute. These are generally quite custom.) Social Media Consulting / Training services (we provide hands-on consulting/training as needed for our clients. These are generally quite custom.) Social Media Content Creation services (These can be a-la-cart or built into a management service. These include blogs, videos, Instagram Reels, and more.) Please note we do not provide any traditional PR services. This project will include: An identification of our current competitors (both niche, general and freelance) An identification of potential future competitors (eg. a large company in a similar industry who may enter the space) The creation of a matrix identifying features shared across the companies and those that are different. A summary of 2-4 paragraphs describing our competitive advantages and disadvantages relative to the competition identified. This could be done in the form of a SWOT analysis. A scope and pricing summary that details how competitors package / scope their services and the prices they charge for the services. This may also include "a-la-cart" pricing for things like blogs, videos that are 1 minute long and paid advertising pricing structures. This would include all forms of competitors. We will give you access to organizational assets to support this project such as personnel, website analytics, sales and brand collateral, and more. We can suggest names of competitors to research. We can suggest hashtags and search terms to find additional competitors. Objective We hope to gain a comprehensive understanding of the competitors in our space and how we can differentiate ourselves through our product/service offering, pricing, and our messaging.