@Mike I was speaking with Dwight and he mentioned he has experience with dbt. We are going to use them as our data transformation layer. He mentioned some pitfalls he had seen in the past and I was wondering if we could borrow him during one of our trainings/meetings?
Also, in the future when we are building out the Shield Data Warehouse we could use his expertise in SQL for schema design and dev work too. If you approve, I would like to work with you on a shared task management as to not overload Dwight or take him away from your projects too much. It should only be periodically and when you can spare him but there are only a couple people that have any SQL knowledge let alone already with the tool we are choosing. Let me know your thoughts. Happy to hop on a call, thanks!
Hey Nicholas. Dwight is not super technical.. I don't think he's your guy for writing SQL. and to be honest, I really can't spare him right now. we're super understaffed, and we have a backlog a mile long.
Well if that is the case, we donβt need to utilize him for the dev work or anything g like that but I would like to pick his brain a little in regards to dbt. Nothing that will take any significant amount of his time just someone of questions then. No one has experience with this tool so something I guess is better than nothing.
yea, that would be fine as long as he's up for it. I don't want to volunteer him for anything lol
And he's leaving tomorrow on vacation for a week. My week is going to be absolutely insane π
No, totally fair he seemed happy to help but wanted your approval considering everything. He explained how busy you were so my proposition was contingent on your blessings and when you could spare. Ya I just said bye to him and this wasnβt even a this next week consideration it would be at least 2-3weeks before I would even need him at the earliest. Anyways appreciate the consideration and hope things get better!
I sincerely appreciate your consideration. if you're talking 2-3 weeks out then ping me again when it gets closer to time, and we'll see if circumstances have changed on our end. you know how it is.. there's no telling what all is going to be different in 2-3 weeks
** meaning that we may be able to spare him a bit more in 2-3 weeks. sorry, my brain is giving up on me
Hey @Nicholas McFadden. hope you've been well. Brian pointed me to you to see if you could help us find the lawruler merge tags/custom field name for a couple of intake fields. does that sound like something you may know about?
Yes I think I can help with that
Speaking of Brian we are going to g to need him to make some changes to get the Dialer to work in the interim. We need to figure out how soon he can make them. Unfortunately he will have to make changes again for LawRuler but we canβt wait the 4-5 weeks they are saying they need
yea, I know Brian has a lot on his plate. I hated to bother him but didn't know who else to go to. this is the first time we've asked him for anything in a while.
the fields we're looking for are on the Bailey Glasser - AFFF- Craig Goldenfarb integration.. we need the values for "Date received" and "Contract sent date"
Ok I will take a look, do you need this today or can I get this to you tomorrow?
I hate to ask, but this is to fix the client's broken integration, and I told them we'd have a solution today. we've been trying to find it since yesterday
Ok give me like an hour or two and Iβll get it for you
I greatly appreciate it man. if there's anything I can help you with let me know
we're not sure what the actual field names are in LR, the client is just asking for those two fields.. do you see anything that's even close to those?
No I mean the actual name of the intake form
need to search that to get the case type id and then have to use that to get the question list to get the question id
I believe it is Firefighting Foam - BG - Miller Goldenfarb - Shield Legal
Ok thanks I will try to get that and let you know
Ok I am not seeing those fields in the question list. Are you looking for "Sent E-sign Date" and the "E-Signed Received Date"?
pretty sure "sent e-sign" is correct.. not 100% sure about the other one, but at this point I'll take it lol
this is the entire question list response for that case type:
got it. I'll see if I can find any values that'll work for this. thanks again!
I canβt get the βE-Signed Dateβ date myself so I have to create a custom report and I can call that from the API but I donβt get back the custom field ids just the data itself
Itβs something Iβve asked them to work on mut currently the eta for anything from the is 4-5weeksβ¦.
I could be wrong, but I think those are "standard" fields in LR, so I might be able to get them directly from LR. I'm looking now to see what I can find
Ya but lawruler havenβt given access to everything in their API
the email automation in LR. it has a widget with a dropdown that has a list of all the fields
Itβs not an intake form field but the statuses of the lead reflect those things so wonβt get exact date but if you want to count up leads in a certain statuses we could
I don't really care if they are 100% correct or not lol. I just need to give the client a solution
I think the fields you listed will work, I just can't find the merge tags for them in LR
I see <<Created Date>> but not sure if it has a value or not. I can test it.
That might be the leads created date
I think so, but if that's all I have to work with I have to send the client something
Welcome! Sorry could get exactly what you were looking for but welcome to my dev hell courtesy of LawRuler lol
At times I get worried we havenβt made as much progress as I intended but luckily Cam understands my hands are tied
I havenβt had the most dev experience but I can say this has been the worst lol
do you know who I should go to for lead backfills and lists/reports? I just got this from the client
> Can you instead send me a list, a manifest if you will, of all the leads that your campaign shows as part of the DMA inventory? I am in urgent need to audit and ensure all cases are accounted for and worked on.
What do you mean by lead backfills? I can pull all the records for specific case types and statues and send that over. What info/fields would they need to see for each lead?
backfills are when we repost all of the leads that came in before the api integration was done, or if there was a problem with any leads. we don't need to do that here though thankfully. they are just asking for a list of the all the leads for that campaign. I'm assuming they want as much data as possible.
Well if you can get me the list of case types associated, I can pull those records, and send it to them. This a one off or need to be recurring?
one off. should just be for Firefighting Foam - BG - Miller Goldenfarb - Shield Legal
any and all statuses, correct?
hmm good question. pretty sure they only want the leads that were sent to them
Double check that and any specific fields they have to have and Iβll work on it
I emailed them but I think they are est so it's 6:40 their time
is it a lot of work to generate a report that has all the intake data?
Do you have sec to talk about the two candidates Cory sent over? Have one interview at 9am and the other at 2pm
Just want to hear your opinions and understand your needs before I speak to them
Spoke to Cory but wanted to talk to you too
Looking to get some Power Automate creds for Shane and I. Would like to start playing around and getting familiar with it. Do you manage that or is that a Joe request?
right now we just use a shared account that was inherited from the former developer. we're trying to find a way to get it merged into our microsoft account
But could I get access to the shared account in the meantime?
rahatyasir@shieldlegal767.onmicrosoft.com / #z4^3nP:xUV&==~
@Mike please send me the most recent code for the PA account
what is the new gmail account?
5J5A4p&c7Q9wqyF5$SJNVXL5WgFq@v
what is the password for the dev gmail account?
dwight is going through the other integrations and making the changes
I'm about to head out.. it's 6:30 my time. dwight should have things from here. if you guys run into any issues shoot me a text
@Mike we are needing the API Key for the Cloudmersive Document Conversion Connection
I'm not sure what that is or where to get it. rahat set all of that up when he made the pa account
Do you have his contact info? Can you call him to get this?
Also we just need to get everything away from this guys account
I don't unfortunately. I've only interacted with him once or twice in the past.
just sent a auth code for the main account can you send this to me?
I setup 2fa for ahsan and dwight both btw. they should be able to do the same for you
it timed out going to try it again
ok got it thanks and yes lets get
it's the same account, you just add your own authenticator for 2fa
to set up my authenticator I need a code that was just sent
is there something preventing dwight or ahsan's ability to get you the 2fa code? they should both setup
I don't mind giving it to you, I just might not see your message or reply in time, and those guys are physically there with you
ahsan says he never got it setup and dwight isnt here
dwight is here now and he is saying he never got it to work either
I will have to try later. Thank you for your help
@Mike hope you are well, could you transfer ownership of the automations in Monday.com to me?
@Nicholas McFadden sure thing. as soon as I get to a good stopping point I'll take care of it
I transferred all that I could. it won't let me transfer the ones with slack connections. there were only 2 like that
you transferred it to my shield email?
not sure. it's whichever email is tied to your monday account
I have one for each apparently. No worries Iβll see which one. Thanks!
@Mike hope youβre doing well. We have a DM in the TIP slack that we would like to convert to a channel. However, none of us have the permission to do it. Would you be able to do this for us?
Hey Nick. I can help with that. I'll need you to add my tip slack user to the chat though.
Ok thank you! Not a problem doing so now
mike it a private channel please
np at all! ty for understanding. I know the new policy sucks
Life is good man, I can't complain. How are things going for you?
I understand so no worries. Good to here man! Same, getting into a good groove. Starting to move off of integrations onto other projects but it was a lot to juggle before.
You'll be happy to hear that Dwight is doing really well and same with Ahsan.
Oh man I really do love to hear that. They're great people
Couldn't agree more, a testament to you! Wish I had more of them!
Appreciate you too man. Always being willing to help out
Of course! I hate that I left everything where/how it was, but I literally just had to get out man
No totally understand man you have to do what is right for you. I am a big advocate for mental health I am actually on the board of a mental health non-profit out in California. Always here if you need to vent because this job can be crazy for sure. Also, if you're ever in town we should grab a drink!
Absolutely! I'm a huge advocate for mental health myself, so I commend you on your efforts! If I can ever help you guys out please don't hesitate to ask.
Thanks I really appreciate it and same to you!
Hey a couple of my guys do not have access to the TIP slack and all of the company notifications come through the general channel. Could we get them added so that they do not miss any of the notifications?
Hey bud I'm not in the office rn. Would you please email help@shield-legal.com to open a ticket and I'll handle it when I get back
Actually I misunderstood the team. They already have access but wanted the notifications to be on the Shield general channel. No need for you to do anything. Thanks though!
hey just so I'm clear are you taking over the tt crm event stuff or am I still going to be expected to handle it?
I don't mind either way, just need to know so I don't step on your toes
Well I don't know what else needs to be done or what they have asked you to do with it. They just told me to jump in and help out. It has kinda morphed into my responsibility but I would like your input
Now are the zaps running off of the email automations?
no the zaps feed in the data from fb and tt native forms
the data posts directly from the native ads into zapier, to be more clear
I spoke with Dwight and he let me now that the tt id should be going to an S5 field in LR. Did a quick check and we didn't see the id or even the S5 field on one we checked for some reason so we have to investigate that further but if we are able to find the data in there then we are good. We'll build the container/app to handle the posts, filter just for the TT events (no way to do this in LR), and include the event routing info for post back.
Hey bud. I sent this to your other slack user, but not sure if you monitor that account, so dropping it here:
> Hey @Nicholas McFadden. Do you need anything from me on the tt crm stuff? It was my understanding that the integrations team had taken over the project, but if that's not the case or if I can help in any way please let me know.
Hey I got Mark to setup what I needed from him yesterday. Iβve been swamped with Flatirons stuff but I am hoping to finish it up this afternoon so we can fire a test. Iβll let you know how it goes and if I have any difficulty today maybe we hop on a call tomorrow?
Sure thing! Just let me know if and when
Do you know what these events are where it shows a postback to a zapier for Tony ?
yes, that's the lawruler automation for the native leads integration
@Mike Hey would you mind hoping on a quick call to show me how to fire off a test lead from TT so that it flows all the way to LR? Once I do that I think we are ready to go live
Hey @Nicholas McFadden. There's not a way to do end-to-end testing like that through TT. The testing in TT is just to make sure they're receiving the events. I believe the media buyers have a way to submit a test form though
Hey would you be available to get on a call with Nitido today at 11am PST
I expected the team to catch you up on what was needed but sounds like none of them did
yea I can do that. I have another call right before that so I might be a few minutes late though
I can see if we can push it back 30 min if that helps
Also forwarded you an email with some documentation of their system. I have the posting back to them covered but it is the web form connection to our media that I need help with because I have just dealt with it once it hits Leadspedia
11 is fine. I should be done by then, but if not it won't be much longer after that
I had to request access to that doc. not sure if you created it or not