Methodologies
- Data Entry & Management:
- Structured approach in collecting, organizing, and updating data across multiple tabs.
- Implementation of automated fields to track key metrics like approvals and pending reviews.
- Outreach & Engagement Tracking:
- Defined columns for detailed tracking of outreach attempts and status updates.
- Flexibility in adjusting columns to align with evolving engagement strategies.
Ref Sheets
- Goals
- Purpose: Repository for company-requested information concerning creators.
- Details to be Included: Gender, niche, race, body type, and other relevant details related to the creators like quantity required for each creator list. Associated due dates.
- Latest Update: I added a tracker for total number of creators available for review. Count of creators approved based on "Hell Yes" or "Yes" in the score column and Direct links to respective creator list sheets are available.
- SheetMagic
- Purpose: Summary of the SheetMagic (ChatGPT in Sheets) functions & prompt suggestions.
- Video Menu
- Purpose: The initial video menu sheet you created and provided at the start of the project.
- Denied Creators
- Purpose: The creators you “scored” Mid or No so that I can look back when needed to learn.
Work Sheets
- Multiple sheets starting with the word 'work,' used for data cleaning purposes. Includes video data, hashtag data, and data specifically for black creators that I’m cleaning for example. You don’t ever need to go into these, this is just for me to be messy in and process the data I have.
- Video Funnel
- Hashtag Funnel
- Black Creators
- Creator Funnel
- Purpose: Serves as a repository for newly found creators not immediately related to any goal. Used for mass populating creators without detailed demographic information. Creators listed here will be moved to scoring or reviewing documents as needed. Example: Storage for Hispanic creators until required.
Review Sheets
- Individual lists of goals being worked on, providing a clean list of creators for outreach based on specific goals. Each review sheet now includes:
- Status Column (L): Allows selection of current status of outreach.
- Contact Method Column (M): To note means of communication used.
- Contact Date Column (N): Tracks initial or most recent contact date.