Apprenticeship Week 8

I’m constantly amazed by how long I’ve been in my apprenticeship. It’s the end of June already?
Crazier still, my birthday is in two weeks, so I’m almost 19! It’s almost time for another post reflecting on the past year, like I did when I started my blog last July. Tuesday marks this blog’s anniversary.
I have two months at Original One Part, 10 months into my Praxis experience, two days shy of a year blogging, and two weeks shy of 19 years I’ve been alive.

Projects This Week

Last week Josh assigned me a project tracking APS representative visits to body shops. I have to put reps’ recent visits in the sheet so we can see the average number of visits and decide which reps to keep and which reps are not worth the money. (The reps send month-end reports and do tracking with us to ensure we’re getting our money’s worth, too.)
Additionally, I have to make sure the account information is up to date in Salespad, Hubspot, and also listed in the market shop lists. In the spreadsheet document with the APS visits tracker, there are sheets with lists of all the bodyshops in that market that have or are being visited by the reps.
Right now I’m focusing on recording all of the visits from reps that are not already logged and ensuring every shop they visit is on the market shop list. Once that is complete it’ll be easier to go through Hubspot and Salespad and have up to date account information on all sides.
So far I’ve gotten through all the emails from three reps, excluding any emails that came in for this coming week. There’s still countless emails to go through and it’s crazy tedious.
There’s a second part of the project that I haven’t even started, Action Alerts. There’s a whole email folder to go through for that. I have to ask Josh what to do for that, because it’s unclear to me from looking at the emails what I’m supposed to do with them. I still have so much of the first part that I haven’t talked to Josh about this yet.

Challenges This Week

On Tuesday our systems went down for a couple hours. We couldn’t use Salespad or the customer service portal, and the program on Parts Trader that does our auto quoting went down. We had to manually write quotes on Parts Trader using the inventory from our website. The phones still worked, so we had to use old order history to get pricing for people over the phone. We couldn’t give Ted, the warehouse manager, hand written or printed our orders because he couldn’t find the parts to pull with his scanner. Once everything was back up I had three or four orders to put in from Parts Trader, and total we had about fifteen orders go in the log all at once.

Apprenticeship Week 7!

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.

Projects:

I have some work and “personal” projects happening this week and going forward.

Work:

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.

  1. 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.
  2. 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.
  3. 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.
  4. 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.

Personal:

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.

Other Updates:

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.

Conclusion:

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.

Apprenticeship Week 5

It’s been a month and two days at my new job!

Current Projects:

I’m still working on adding Kayce’s old call notes to the Salespad CRM tab. I’m almost caught up with when she sent it to me.

Yesterday we had a meeting and next week Josh is going to show me APS so I can make sure all our contact information is up to date. We’re looking to expand our marketing efforts to include an email list, and I’ll be helping get the necessary information to make that possible.

Things I Learned:

Don’t convey uncertainty to the customer! We can figure out details on the back-end to ensure a great experience for the customer. We should not give them reason to doubt what we’re saying.

I had one call with a customer where I was explaining why we issue parts on a Net30. I mentioned that part of that was to make any returns easier. This made the customer uncertain about using our parts. Going forward I didn’t mention that and only said it was to make things as easy and smooth as possible for the bodyshop.

In a different call I mentioned that we LTL some engine cradles because of the weight. Herb told me to tell the customer we could get it to them 2nd day like our website promises and we can pay more for shipping to meet that if necessary.