This was not supposed to come out before the post I’m writing about week 6/FEEcon. But here we are.Last week I only worked two days and the rest of the week was spent at or preparing for FEEcon. This week I worked about 8:40 or 8:45-5 and today I worked 8:40ish to 6.
I have some work and “personal” projects happening this week and going forward.
Before I went to Atlanta I was assigned a project inputting old customer feedback into the Salespad CRM tab. There were probably close to 300 lines in the spreadsheet. Now there are about 10, all instances that I couldn’t find the account it went to. I searched using the name of the body shop first, but some, like Fender Mender, Caliber, Service King, and ABRA have too many shops to find with the main part of their name. Then I tried searching the invoices using the shop name and looking at the invoices from around the time of the feedback. Nothing matched. Everything that did match is up to date and recorded.
Today the main manager, Josh, showed me a new project he needs me to do. It’s massive and will take me quite a while to get through. He connected me to a folder in his inbox containing lists of shops that APS representatives visit in the various city-specific markets we’re targeting. I have to record the number of shops visited in the market on the specific day and update the information we have about each shop in the APS spreadsheet, Salespad, and Hubspot.
I’ve decided to tackle the project in what is hopefully as efficient a manner as possible.
- I sorted the emails by sender so I’m only dealing with a certain set of markets at a time. I check if it’s a days list or a weeks list of visits. I count the number of shops and divide by the days if necessary. I put the number(s) in the correct box(es) on the APS visit count sheet.
- Then I go to the sheet with the market’s shop list, find each of the shops from that email and check them against Salespad for information. I’m not creating the missing accounts yet.
- I categorize the email in Outlook with the green “Complete” I created as well as the market label. If/when someone else becomes the owner of this project in the future, it will be easier for them to see what was put in the sheet and which market the information belongs to. The Complete label also prevents me from forgetting which emails I’ve already processed the information for.
- When I finish the emails about APS visits and possibly the other emails that I need to ask about Monday, this will be the next or last step: Go through each of the market shop lists and make sure there are matching, up to date Hubspot and Salespad accounts for them.
I realized the other week when the creator of Blurt, Corey Gwin, was the guest speaker for the Praxis Wednesday call that I needed to get back to writing regularly.
Then at FEEcon, I lamented the fact that I had not been working toward my writing goals while taking notes in the Creative Track breakout sessions I attended. (More on that to come in my post specifically about FEEcon.) I also got an idea for a new blog. I haven’t talked about my idea for that blog with anyone yet, so while I definitely plan on starting it, I want to get some feedback first.
I’ve also decided to take a different approach to writing my novel — I want to try writing a bunch of short stories that take place at various points of the story and then stitch them together. With this I could either publish it as a sort-of-disjointed-but-connected set of short stories or use this to circumvent the problems I’m having with what comes next. I have some idea what needs to happen, but I’m struggling with the immediate next steps for the characters. This would allow me to skip to wherever I want to write and come back.Basically, I will be getting back into writing.I’m probably going to do some design work for a media business my dad and cousin are trying to start. They have a flier my cousin paid someone on Fiver to make, and I told my dad about Easil. Once I get a hold of making writing a habit and becoming more productive, I want to practice design again by making my own blog post images.
I found out on Friday that my car totaled so I’ve been taking the MetroLink to get from IL into St. Louis almost right next to where I work. I learned today that it’s more dangerous than I realized. I knew there were some questionable stops, but at the station nearest my work, someone was shot recently. So I will definitely not be taking the Metro any longer than I need to. Because I was rear ended a couple weeks ago, I’ve had to learn a lot. I interacted with insurance, an ABRA from a customer side, applied for a loan, looked for a car, and tomorrow I’m going to look at some cars I found.
It’s been a really crazy week, but it’s been good. A lot is happening, and while it can be a mixed bag sometimes, I’m enjoying the ride and looking forward to the adventures that await.