@Korbin, please put together a master tab XLSX with ONLY people from the attached 3 spreadsheets that are noted as attorneys onto a single tab. You can use the column names below, as not all file columns match. I will need this before the end of the day. Thank you.
@Adrienne Hester What is the status field that determines if a contact is a lawyer within the SOM2023Members and SOM List Serv - 2022 Original?
@Korbin that is a question for @Ryan. That list is before my time with the company.
@Korbin, please look at the columns and decipher the answer
@Korbin please make the following edits @Ryan
@Adrienne Hester FYI @Ryan
Cleaned and Deduped from the original CSV's
@Korbin. Take the attached list, merge it into the above list, look for updates to email addresses and firms, and resubmit. FYI @Ryan
This list is the most current for some. For instance, Je Yon Jung is now a partner at May Jung Law Firm. This is no longer her email address, jjung@maylightfootlaw.com. It is her correct email address, jeyon@mayjung.com.
Thank you.
@Korbin for clarification, you're stating everyone on the 2023 registration list is already on the 2022 list with updated emails, firms, titles, etc., and that you removed any duplicates and updated Ja Yon Jung?
@Adrienne Hester, is Ben Crump a "plaintiff attorney" or is he a "CEO?" FYI @Ryan
But if his title is wrong in the excel file then the titles within that file do not matterβ¦
You will need to fact check. Titles do matter. @Korbin we are sending this to Shades of Mass our other important client co-founded by Ben Crump and Fu of DiCello Levitt. It needs to be correct. Reacquainted yourself with the SOM website. We're about to be busy with them and the majority are emails.
@Adrienne Hester, we need to figure out an appropriate title for this sheet. As it stands Ben is listed as a Plantiff Lawyer but on his website it says he is a Trial Lawyer.
How many other lawyers are incorrectly titled?
Please adviseβ¦
You will need to research. The sheet is labeled correctly. I suggest cross-checking against other email lists you have for the firms you recognize.
@Adrienne Hester The email lists Iβve dealt with are all comprised of leads/ contacts.
If you believe in the labels on the sheet then I can send you the completed File shortly.
No @Korbin you need to do what is asked. It's not ready.
@Korbin , this is for senior partners and principal partners at Ben Crump and DiCello.
Once done please upload to MailChimp as a new master list so your hard work can be reused in the future emails they will do with us.
@Korbin did you click the account recovery and receive directions to reset it? What is the ETA on the list today?
@Adrienne Hester, please take the time and read carefully the text that is highlighted in salmon from the screenshot.
@Korbin, the login for SOM mailchimp:
<a href="mailto:m-abram@rogers.com">m-abram@rogers.com</a> MailChimp2022!
@Korbin, do now cause I'm coming up for air from a very focused task
@Ryan FYI @Adrienne Hester
I uploaded the entire cleaned and deduped list into MailChimp into a new Audience labeled: Master SOM Conference List 2022-23
@Korbin Also, upload the Excel spreadsheet here., FYI @Ryan
@Adrienne Hester FYI @Ryan
Its correct and accurate according to the data provided.
Thanks. @Korbin, the following line items didn't translate due to an accent mark, missing a name or is a duplicate. These will need to be updated in MailChimp. FYI @Ryan 236 - last name - Felipe LlinÑs Negret 331 - first name - Cybèle 275 - last name Elkadi 780 - Joi Travis 935 & 936 - delete - LaRuby is a partner in her own firm MayJung 1039 - last name - York 1111- last name- Pérez 1358 - delete duplicate - Ryan Vaspra
@Adrienne Hester FYI @Ryan
I had a reminder go off just now notifying me I have a dentist app at 4 today.
@Adrienne Hester FYI @Ryan
I need access to the DiCello SurveyMonkey account that is about to expire so I can extract files for Kim Mulder.
I need you @Adrienne Hester to get a hold of Abe at DiCello. He receives the 2-F code to gain access to the SM account. Please have him email me the code like last time.
Thank you!
*Thread Reply:* @Adrienne Hester, this is the correct way to get us access to the old account for sure. I think it's an email he forwards, so make sure he sends it to either you directly, Korbin directly and not me.
FYI @Andy Rogers
*Thread Reply:* Hi @Ryan, I sent Abe a text to email Korbin. FYI @Andy Rogers
*Thread Reply:* Thank you
@Adrienne Hester FYI @Ryan
I have gained access to the DiCello SurveyMonkey.
Thank you!
@Korbin, decrease the size of the signature for consistency. Also, please tag me in the channel that you are sending a test or I will not see it. I ask again to not thread me when replying. I won't see it. Thanks @Ryan
@Adrienne Hester, will the "subject" field remain the same?
@Korbin, what do you suggest for the subject line with this being an update email?
@Adrienne Hester, thank you for your response. Please provide the subject line for the ad hoc email going to both CLJ and Flatirons OPN contacts.
@Korbin provide a suggestion and we will go from there.
@Adrienne Hester, did Abe from Dicello moonlight his SurveyMonkey account that was tied into the Camp Lejeune survey?
@Korbin, looking him up in LawRuler, his second interview file is here. Ask Brianna or Brittany for a full report with all questions on the intake and see if that gives Kim what she needs. https://tortintakeprofessionals.lawruler.com/update-lead.aspx?lead=314151
@Ryan FYI @Adrienne Hester
Would you like me to send out that Ad Hoc email now?
@Adrienne Hester FYI @Ryan
I will have to leave early on 6/5/24
I have a doctors appointment
@Korbin, please see below and update your list accordingly. I'll keep you posted. Vernon "called the invalid clients to obtain updated email addresses. Several of the clients were declined by the firm (Dunne and Norman) and some have been hard to reach clients that may be opt outs (Frey and Kucsmas). For the others, I called and left voicemails, and requested that the CSP assigned follow up with them. One of the clients, David Gross, stated he does not have or use email. I will update the email addresses once we receive them."
@Adrienne Hester FYI @Ryan
There is a 50/50 chance I will be having minor surgery today. If I do have surgery, I will have to work from home for the rest of the week.
Thank you!
@Korbin, the number Phone: 2252334084 calling LOSG is "Spam number that keeps calling. It told me to press 2 to opt out which I did and they called right back again with the same automated message." Please block. FYI @Ryan
@Adrienne Hester FYI @Ryan
2252334084 has been blocked by caller IP Address within Leadspedia
@Korbin, reach out to Kelly to help him with MOZ crawl errors for Ben Crump. There are roughly 600 pages that still need to be updated.
@Korbin , you can request WP access from LaToya to do these yourself with Kellyβs help.
Kelly took us from 2800 to 600, almost done.
*Thread Reply:* @Adrienne Hester, you're welcome!
@Korbin, this LOSG number First Name: +12157922570 Last Name: Data not found Nicolette: "This was the same spam call we keep getting asking us to confirm our business so customers can find us. I hit 2 again to opt out; it seems they just keep calling on different numbers." FYI, @Ryan, is there a way to do an overall spam check?
@Korbin there is water in the building. The jugs and the actual building. Why did you leave FYI @Ryan
There is no water. I went to 3 different locations. I have clean water at home, along with WiFi. If you need me, you can reach me here in slack.
@Korbin , we do not have a WFH policy, please return to work and discuss fresh water with HR.
@Ryan, with all due respect, itβs not my job to discuss and coordinate the replenishment of water with HRβ¦
Will have you talk to Shellie about both water and walkout
Itβs not a walkout, I will still be able to complete my tasks along with SEO today
Might even be able to accomplish more than I originally had planned. We will see
I disagree. I think you should go back to office and talk to Shellie.
@Ryan, Iβm thirsty right now.., their is no water in a building with over 200 people
@Korbin LOSG is getting more spam with this number 4124609994
@Adrienne Hester FYI @Ryan
That number is not the same number that was previously spamming LOSG.
@Adrienne Hester, would you like for me to block this new number? 4124609994
@Korbin it's fine that it's not the same number. It's not fine that it's happening again. Yes, please block every time we get a new number spamming. Thank you.
*Thread Reply:* @Korbin, block them in CTM. We do not use call tracking in leadspedia at all.