Meeting Title: Robert <> Demilade Date: 2025-03-28 Meeting participants: Robert Tseng, Demilade Agboola
WEBVTT
1 00:00:18.660 ⇒ 00:00:19.579 Demilade Agboola: How are wet
2 00:00:21.000 ⇒ 00:00:22.120 Robert Tseng: He didn’t want it.
3 00:00:23.480 ⇒ 00:00:24.440 Demilade Agboola: How are you?
4 00:00:25.710 ⇒ 00:00:32.746 Robert Tseng: I’m good better today, less you know, yesterday was a rough day. I acknowledge that. So
5 00:00:33.390 ⇒ 00:00:38.639 Robert Tseng: hopefully, we minimize the amount of urgent stuff that comes our way.
6 00:00:39.115 ⇒ 00:00:48.399 Robert Tseng: Yeah, I mean, I just thought it’d be helpful to just kind of hop on the hop on the phone with you, I know, like your role as like the Senior de here is like
7 00:00:48.640 ⇒ 00:01:08.379 Robert Tseng: it’s a little bit less defined than like a wish. I wish I just like, give him tickets, and he just knocks out model changes, whereas, like for you, I’m like defaulting to letting you own process. Because that’s kind of what I want from like the the Senior D, I guess kind of what Utam was doing before.
8 00:01:08.640 ⇒ 00:01:17.179 Robert Tseng: So yeah, I mean, that’s why I assigned you the tableau. Kind of deployment stuff. And then, yeah, I’m kind of like
9 00:01:18.440 ⇒ 00:01:28.609 Robert Tseng: I’m putting you on on the hook for for, like some of that kind of. It’s like the devops work and making sure that the implementation is smooth data quality. Yeah, we all own it.
10 00:01:29.240 ⇒ 00:01:31.840 Robert Tseng: I mean, I’m still reviewing. I spend like
11 00:01:32.100 ⇒ 00:01:39.219 Robert Tseng: few hours a week a day, almost like reviewing people’s work all the time which is, which is fine. I think that’s just where I’m at.
12 00:01:40.000 ⇒ 00:01:42.530 Robert Tseng: And eventually, like, I want.
13 00:01:42.750 ⇒ 00:01:49.239 Robert Tseng: I want you to be able to. If we’re gonna give you more hours on this client like I want you to. I want to do it when you’re
14 00:01:49.570 ⇒ 00:01:53.420 Robert Tseng: confident in being able to review work here as well.
15 00:01:54.680 ⇒ 00:02:05.639 Robert Tseng: But yeah, I’m just. I’m giving you some time to ramp up get familiar. You did a few investigations this week on in data sources. You weren’t look data models you weren’t looking at before, which is fine.
16 00:02:06.844 ⇒ 00:02:13.609 Robert Tseng: So. Yeah, I think that’s kind of how I see the the overall situation of how you’re how you’re doing on this client.
17 00:02:14.660 ⇒ 00:02:27.529 Robert Tseng: How do you? What do you. What do you think about that like? Are those expectations off like, yeah, where do you? Where do you feel like you’re you need more support in or like. If you want to give me feedback like, what? What are you thinking
18 00:02:29.490 ⇒ 00:02:30.530 Demilade Agboola: I think.
19 00:02:31.255 ⇒ 00:02:34.280 Demilade Agboola: This they’re like.
20 00:02:34.540 ⇒ 00:02:44.720 Demilade Agboola: because there’s like very little like documentation. A lot of what I have to like, pick up or like figure out, is pretty much like on the fly
21 00:02:45.392 ⇒ 00:02:54.869 Demilade Agboola: and also cause I didn’t actually like build a lot of it. So like that context is also missing as well. It’s
22 00:02:55.640 ⇒ 00:03:04.470 Demilade Agboola: it makes it tricky to be able to answer questions quickly, because not only do I, because I just don’t necessarily always want to just answer. But I want to have the right answers to the questions
23 00:03:04.590 ⇒ 00:03:09.210 Demilade Agboola: right? I want to be able to know, like if
24 00:03:10.310 ⇒ 00:03:20.410 Demilade Agboola: if we’re responding to this, it’s not, you know, like it breaks the clients trust, because then they discover that the answer is like bogus, and they have to come back and be like, actually, no, that doesn’t make any sense.
25 00:03:20.824 ⇒ 00:03:38.760 Demilade Agboola: So just being able to feel confident in that space to be able to respond to different scenarios and be able to say, Hey, actually, you know, this is incorrect. No, this is correct. Actually give us some time to be able to handle this. But yeah, I do understand the general concept of having to own processes.
26 00:03:39.636 ⇒ 00:03:41.393 Demilade Agboola: And having to
27 00:03:42.660 ⇒ 00:03:54.109 Demilade Agboola: and having to like run certain things. I think it’s just a bit. It’s it’s trickier to do that when you don’t cost like, you’re constantly like trying to get some of the context of certain things.
28 00:03:54.640 ⇒ 00:03:58.329 Demilade Agboola: and you’re like that. That can be a bit tricky
29 00:03:59.300 ⇒ 00:04:02.065 Robert Tseng: Yeah, yeah, no. I I hear that.
30 00:04:02.870 ⇒ 00:04:08.119 Robert Tseng: yeah. I mean, I guess for me, like, I think I mentioned this over slack. But it’s like, Okay, I
31 00:04:09.680 ⇒ 00:04:14.629 Robert Tseng: I’ve been at this client longer than anyone on the brain force team has. And and then I like
32 00:04:14.710 ⇒ 00:04:36.809 Robert Tseng: had to get up to speed so that he could go and build out some of the main models, and he handed it off to a wish and a wishes. And then, now it’s like to you. And it’s like, yeah, in some sense, like, it’s, it’s just a feeling. I haven’t actually measured it. I feel like people are picking it up faster and faster because you’re able to go and look at the models that we’ve built, and those are easier to unpack, maybe, than like
33 00:04:36.810 ⇒ 00:04:53.300 Robert Tseng: the models that I mean, I don’t even know you would call them models. But like the scheduled queries that Rob had before. So you’re not looking at those anymore. You’re really just trying to understand the logic in our work. And any questions of like, Oh, how is our model different from like
34 00:04:54.020 ⇒ 00:05:12.575 Robert Tseng: Rob’s model, which is a very common request, like, I don’t want you banging your head over like the kind of figuring that out like either I know the answer, or we should know the answer, because we’ve already graduated from that point, and we should just be maintaining and continuing to like, make our like set of smart models better.
35 00:05:13.150 ⇒ 00:05:25.130 Robert Tseng: but yeah, I hear you that sometimes, like you feel like you need the context. You need to go back. But I do feel like. Sometimes it may mislead you more that it could help. So I’m just trying to like short circuit, that process as much as I can. Where?
36 00:05:25.573 ⇒ 00:05:37.770 Robert Tseng: Yeah, if you’re gonna about to go down a rabbit hole, it’s gonna take you a while, like, you know, maybe there’s like something that we can give you point you in the right direction at least, where to where to look, that could. That will speed that part up.
37 00:05:39.170 ⇒ 00:05:40.309 Robert Tseng: Does that make sense
38 00:05:40.750 ⇒ 00:05:41.770 Demilade Agboola: Yeah, that does
39 00:05:42.410 ⇒ 00:05:48.299 Demilade Agboola: But yeah, I I like, put yesterday, I was going through like crops models.
40 00:05:48.940 ⇒ 00:06:01.839 Demilade Agboola: the? So basically, he scheduled queries, the the things he sent over, unless I was able to like figure out everything. But obviously that was like a time consuming process. And I also had like things for open up and stems. I had like a couple of meetings with them.
41 00:06:01.940 ⇒ 00:06:04.040 Demilade Agboola: So that was also taking out of my time.
42 00:06:04.830 ⇒ 00:06:08.680 Demilade Agboola: Yeah, so yeah, just being able to
43 00:06:09.350 ⇒ 00:06:20.540 Demilade Agboola: figure out like, how much context I need, I guess, would be very helpful. But just generally, yeah, being able to handle processes is not really a problem. In in the overall sense of it.
44 00:06:21.060 ⇒ 00:06:42.867 Robert Tseng: Okay, yeah. And let’s just talk specifically about this product mapping thing, because this is one that like, yeah, I could go and jump in and like, run this whole thing. But I’m really trying to like, let you own that. So you know you, you’ve seen a few of the artifacts already out there like you’ve seen the Google Sheet where the I mean. Maybe if it’s helpful I’ll just like watch them one more time. But like
45 00:06:45.320 ⇒ 00:06:47.656 Demilade Agboola: Because I’ve actually been looking at it.
46 00:06:47.990 ⇒ 00:06:48.910 Robert Tseng: Okay. Great.
47 00:06:49.130 ⇒ 00:06:56.901 Demilade Agboola: So this is our like team products. And this is what all the data that we have.
48 00:06:57.510 ⇒ 00:07:04.320 Demilade Agboola: Oh, yeah, like putting together. So it’s the product, id the bundle id. We created a
49 00:07:04.600 ⇒ 00:07:12.290 Demilade Agboola: an artificial product. Id. And then we so we have product, name, product, category, subcategory, name subname all that stuff.
50 00:07:12.420 ⇒ 00:07:19.460 Demilade Agboola: the cogs, the pharmacy, the schedule, basically. And then this is what we generate. Our scale ourselves
51 00:07:19.460 ⇒ 00:07:20.140 Robert Tseng: Yep.
52 00:07:20.140 ⇒ 00:07:24.540 Demilade Agboola: And this is what we have right in here
53 00:07:24.540 ⇒ 00:07:32.499 Robert Tseng: This is what Zack is gonna be sending us. This is not what we currently use. But yeah, Zack, sorry is the guy to ask, yeah.
54 00:07:32.500 ⇒ 00:07:40.179 Demilade Agboola: Yes, and the thing to note is that there are the columns that are missing.
55 00:07:40.885 ⇒ 00:07:43.304 Demilade Agboola: Is exactly what I sent to you.
56 00:07:43.650 ⇒ 00:07:49.929 Robert Tseng: Yeah, it’s just the sub name subcategory categories. But you know, we we met a couple of days ago saying, like.
57 00:07:50.190 ⇒ 00:07:59.929 Robert Tseng: can we just build that out. We have the product name. We. We can apply the logic of turning ozempic month 2 into category, into subcategory
58 00:08:00.340 ⇒ 00:08:06.234 Robert Tseng: or whatever I was epic, and it’s in the weight, loss, category, or what or whatever. And we can, we can do some of that.
59 00:08:06.990 ⇒ 00:08:19.750 Demilade Agboola: Yeah, so- so we can, we can do that. That’s really not a problem. I think my worry quote unquote would be when new things come in, because right now, like we know recently got like compounded there are something
60 00:08:20.236 ⇒ 00:08:21.210 Robert Tseng: Yeah. Yep.
61 00:08:21.210 ⇒ 00:08:34.349 Demilade Agboola: Exactly so. If that comes in we would be we would be lost. Now I could set up a test, and so automatically flag that that’s fine. But it’s just the thing of like, okay. So when that happens, they would have to go in and feel that
62 00:08:34.990 ⇒ 00:08:35.750 Robert Tseng: Yes.
63 00:08:35.970 ⇒ 00:08:42.760 Demilade Agboola: Okay, alright. So in that case, that that would not necessarily a problem. So in that case, we could just fill out the cogs.
64 00:08:43.179 ⇒ 00:08:44.980 Demilade Agboola: or we could also map to cogs.
65 00:08:46.250 ⇒ 00:08:48.329 Demilade Agboola: So my my question is, how much?
66 00:08:48.540 ⇒ 00:08:50.989 Demilade Agboola: How much do we want them to do?
67 00:08:51.610 ⇒ 00:09:03.559 Demilade Agboola: Because if if we want them to add cogs, cause I feel like they. They’re constantly calculating cogs, and quantity. I don’t know how how often they update quantity.
68 00:09:03.780 ⇒ 00:09:06.040 Demilade Agboola: Then we will.
69 00:09:06.980 ⇒ 00:09:12.120 Demilade Agboola: So I’m trying to see the list I sent you of the things we don’t.
70 00:09:14.670 ⇒ 00:09:15.480 Demilade Agboola: So it’s
71 00:09:15.860 ⇒ 00:09:26.499 Demilade Agboola: all right. So if we are, we can, we can map things like subname variance, category subcategory. But I think we might need them to update cogs and units of measure
72 00:09:27.020 ⇒ 00:09:30.020 Demilade Agboola: quantity, because those are like dynamic properties. I guess
73 00:09:32.310 ⇒ 00:09:35.970 Robert Tseng: Yeah, can I share my screen? I have those accounts. I can pull up
74 00:09:37.670 ⇒ 00:09:38.500 Demilade Agboola: Priority.
75 00:09:39.280 ⇒ 00:09:41.500 Robert Tseng: I’m gonna can. I? Can I share my screen
76 00:09:41.680 ⇒ 00:09:46.559 Demilade Agboola: Okay, yeah, also something quick as well. I did a quick search. And there are some
77 00:09:47.254 ⇒ 00:09:55.800 Demilade Agboola: things that coming from our team products. So that’s from the mapping sheets that do not exist in stack sheets. So I was going to flag that as well
78 00:09:55.800 ⇒ 00:09:58.800 Robert Tseng: Yeah, those are probably inactive products at this point
79 00:09:59.040 ⇒ 00:10:00.270 Demilade Agboola: Okay. Gotcha
80 00:10:00.730 ⇒ 00:10:09.949 Robert Tseng: Yeah, which is fine, like, I think our model should always have. Who knows? Like it’s May. It may be he’s only pulling active products from that week.
81 00:10:10.950 ⇒ 00:10:22.640 Robert Tseng: Yeah, I mean, we’re just not coordinated enough to. We don’t get a clean product list from the the business. To tell us this is. This is how we know what products are coming in. It’s like only when when basket to us
82 00:10:23.240 ⇒ 00:10:24.519 Demilade Agboola: Okay, that makes sense
83 00:10:24.960 ⇒ 00:10:25.540 Robert Tseng: Yeah.
84 00:10:26.510 ⇒ 00:10:35.119 Robert Tseng: Okay. So yeah, I mean, what you showed me was pretty much. This is the sheet, right? This is the vast sheet or not exactly oops.
85 00:10:37.350 ⇒ 00:10:43.000 Robert Tseng: There we go. That’s that’s also not it. Okay, but whatever you you saw it already, and
86 00:10:44.460 ⇒ 00:10:51.000 Robert Tseng: so this is the product offering sheet, or is this it?
87 00:10:51.420 ⇒ 00:10:52.340 Robert Tseng: Yeah, it is.
88 00:10:53.396 ⇒ 00:11:10.190 Robert Tseng: Yeah. So this is like what Rebecca’s team, Rebecca’s the farmhouse team. They go in here, and they. This is their way of just like maintaining it like we’re regardless of what we do like. Christiana’s job, her full time job is really just maintain this like, that’s her. That’s her thing.
89 00:11:10.350 ⇒ 00:11:26.450 Robert Tseng: We just need to tran. We needed to translate that into something we actually use. Which is why we built out this sheet. This is what feeds dim products. Right? So what we did was we took these red columns that she highlighted, and we asked Bax to give us these columns.
90 00:11:26.620 ⇒ 00:11:31.399 Robert Tseng: We don’t get all of them. Most of them are pretty like we can calculate them like
91 00:11:31.950 ⇒ 00:11:35.960 Robert Tseng: I don’t know how often we’re using like all these fields. So it’s kind of like
92 00:11:37.180 ⇒ 00:11:51.540 Robert Tseng: like. If this is the existing process. Christiana’s question is like, What do I do about this now like? Am I maintaining this still or like, what’s the new process? And so if we’re taking Zack’s Zack Bask’s new sheet.
93 00:11:51.870 ⇒ 00:12:00.269 Robert Tseng: Csv. Like, where are we putting it? Are we gonna put it into this spreadsheet? Are we gonna replace this mapping sheet? Is it gonna cause everything to break
94 00:12:00.946 ⇒ 00:12:22.129 Robert Tseng: like? What like is it gonna live here? Is it? Gonna live in a separate Google sheet? That’s kind of like, you know, what? How are we going to consume the Csv data like if if we want to go direct and upload into bigquery, that’s fine. But then Christiana will not be able to edit it right, because there are still certain things that she comes in to put to put
95 00:12:22.660 ⇒ 00:12:42.180 Robert Tseng: so things like visit, fee, dispense, fee all these like highlighted things. These are the fields that she needs to go and fill out. She pulls them from here or wherever she gets them. So there is like a part where we don’t have the complete handoff. But if we can have, like a clean product list that we sent to her.
96 00:12:42.450 ⇒ 00:12:51.909 Robert Tseng: and it’s not like she has to redo this from scratch every week. It’s just like, okay, well, she’s reviewing this every week, and if there are new products that aren’t there.
97 00:12:52.683 ⇒ 00:13:14.299 Robert Tseng: then she needs to go and fill in these fees. And if there are changes to the products, I don’t want Rebecca telling me she’s gonna have to assign Christiana. Christiana is gonna go and update these. And that’s that’s the process. So I think that’s what I’m asking you to kind of set up like, what does what does taking in taking in the weekly Csv look like
98 00:13:15.360 ⇒ 00:13:20.910 Robert Tseng: like if I were to just I mean, you don’t have to follow this step, but I want to like push this along. So
99 00:13:21.160 ⇒ 00:13:25.678 Robert Tseng: I don’t think it should live in this sheet. I think it should live in a separate sheet.
100 00:13:26.580 ⇒ 00:13:37.820 Robert Tseng: because I mean, I well, if it’s yeah what I just, I don’t wanna risk getting kicked out of it, or whatever kicked out or anything. I mean, if it’s helpful to keep it in the same one like
101 00:13:40.460 ⇒ 00:14:05.219 Robert Tseng: Or maybe maybe we do. And and I. But I think the Google sheet format is helpful for Christiana because she just goes in. And she manually keys in like these products that that’s her job. So like, I, I wanna make it as simple for her to do that where she can go. And just like reference. Okay, what are the product? Ids. She looks at the same ids. She’ll go into her master list, which is like somewhere here.
102 00:14:05.770 ⇒ 00:14:10.509 Robert Tseng: and she’ll go find the cogs number, and then she’ll key it into this thing
103 00:14:10.790 ⇒ 00:14:22.430 Robert Tseng: we we’re not gonna programmatically replace like her on the on the cogs fees. Part like I don’t. Maybe at some point we will. But I don’t think that’s really what we’re gonna focus on doing.
104 00:14:24.440 ⇒ 00:14:29.429 Demilade Agboola: But if if she’s the one that has to key this in so that
105 00:14:29.580 ⇒ 00:14:40.559 Demilade Agboola: what I can see if we’re going to create a new sheet. That means you’ll either have to keep. I don’t know if whoever uses this, because if creating new sheet, I mean, should. I should have to update it in 2 places every single time
106 00:14:41.620 ⇒ 00:15:09.859 Robert Tseng: Well, so, yeah, no. I mean, this would be sunset. Right? This is what we’re pulling into bigquery right now. So either you kind of. Just update this and make it so that it’s still usable for bigquery. And she we can rename it. Just make it clear, be like great. This is the. This is the revamp master product data mapping sheet. It’s got fewer columns. Because turns out we don’t actually use most of them. It’s something that we will kind of dump into this sheet every Thursday when Zach best gives us the sheet.
107 00:15:09.860 ⇒ 00:15:24.530 Robert Tseng: And, Christiana, your job is by Friday of every week. You need to go in, and if there are any fields that are missing, any products that are missing cogs, you need to go and key it in, or if there are any cogs changes, you need to key it in, and that’s that’s what we’ll tell her.
108 00:15:25.206 ⇒ 00:15:29.350 Robert Tseng: Like. That’s that’s that to me is the is, is, the is, is the handoff.
109 00:15:30.090 ⇒ 00:15:36.210 Demilade Agboola: Yeah, actually think, yeah, I think that’s the best, because if we do something else it’ll probably be harder for her to maintain 2 sheets
110 00:15:36.500 ⇒ 00:15:37.130 Robert Tseng: Yeah.
111 00:15:37.130 ⇒ 00:16:03.440 Robert Tseng: no, I mean, that’s that’s fine. I’m just worried that if we change the schema right now, like, will our tables break or anything, because I don’t really know how flexible it is for us to adjust and remove rows and to fit sack past Csv. Into this. I think that’s kind of on you to kind of figure out, is it? Yeah, is it just a straight copy onto this? Or like, I don’t know how you want to do it, but that’s what I want you to outline and and communicate to her
112 00:16:05.080 ⇒ 00:16:10.080 Demilade Agboola: Sounds good. I will let you know. I’ll I’ll figure it out for the next like hour or 2.
113 00:16:10.710 ⇒ 00:16:11.380 Robert Tseng: Okay.
114 00:16:11.890 ⇒ 00:16:12.480 Demilade Agboola: Bye.
115 00:16:13.580 ⇒ 00:16:16.619 Robert Tseng: Cool. Any other questions on this?
116 00:16:17.670 ⇒ 00:16:25.728 Robert Tseng: I think I don’t. I don’t think I got clarity from you on like, okay, we have product name. So how are we going to roll that out to these other things?
117 00:16:26.120 ⇒ 00:16:38.699 Robert Tseng: we have all these other cat. I don’t know what is. I don’t know off the top of my head like what is actually being used in our models. Do we actually need product sub names, product variants and
118 00:16:39.980 ⇒ 00:16:48.880 Robert Tseng: product category subcategory like, do we actually rely on these things? Because if not, we can cut them out because we already do it in our model. We don’t need to show
119 00:16:49.020 ⇒ 00:16:57.339 Robert Tseng: this to anybody like this is not helping. No, like no one uses this other than other than the data team. So
120 00:16:58.080 ⇒ 00:17:01.600 Robert Tseng: that’s that’s kind of on you to kind of figure out, too. It’s like
121 00:17:01.810 ⇒ 00:17:18.610 Robert Tseng: we get all these ids. We get the product name. What are the other like categories that we need to create out of it, and we programmatically do so without because Christiana, like copy paste it, she spent like I don’t know how many hours
122 00:17:18.730 ⇒ 00:17:20.700 Robert Tseng: logging into like
123 00:17:21.430 ⇒ 00:17:32.680 Robert Tseng: she. I think she walked us through her process. She goes into bask, and she just copy paste things one by one out of there. She didn’t write these. She everything is copied out of out of out of bask.
124 00:17:32.770 ⇒ 00:17:56.519 Robert Tseng: and like I don’t know who uses it. Do we use this, if not like. We don’t need it like we just. We just keep it as simple as was helpful for us, which to me, I think, is just having the Ids having the making sure the cogs of the at the Id level is there and then any like type of category that we use for our actual models. We we keep, but everything else we can trim down
125 00:17:57.260 ⇒ 00:18:06.689 Demilade Agboola: Alright. So but my question is, are we using it based off the things that currently exist? Or is there anything in the pipeline that potentially might need these things. So that’s the that’s the real question.
126 00:18:07.060 ⇒ 00:18:10.429 Robert Tseng: Yeah. So that’s that’s what I want you to like. Figure out
127 00:18:11.670 ⇒ 00:18:12.360 Demilade Agboola: Okay.
128 00:18:12.690 ⇒ 00:18:16.909 Robert Tseng: Yeah, like, you should be able to go and find the raw source.
129 00:18:17.080 ⇒ 00:18:20.500 Robert Tseng: And then with Dbt, shouldn’t we be able to figure out like
130 00:18:20.790 ⇒ 00:18:26.960 Robert Tseng: which fields are being used in which models like, I think that’s I would figure that out
131 00:18:27.610 ⇒ 00:18:32.549 Demilade Agboola: No, no, no, I I can see I can see everything. But my! My thing is like
132 00:18:33.210 ⇒ 00:18:36.999 Demilade Agboola: in the downstream, like in the dashboards.
133 00:18:37.941 ⇒ 00:18:41.460 Demilade Agboola: I’d have to go through and figure out what every single like, what every
134 00:18:42.680 ⇒ 00:19:01.519 Demilade Agboola: what, every single dimension that’s being used, that’s 1. But even just 2 is like, I’m thinking about the roadmap for things that we have out like coming out very soon. Is this just a thing of like I should focus solely focus on what we’re doing right now, and if anything else is needed, we will add it when we need it.
135 00:19:04.680 ⇒ 00:19:05.773 Robert Tseng: I see?
136 00:19:06.560 ⇒ 00:19:12.470 Robert Tseng: yeah. Well, I my hunch is that we’re not using all of these. I think we have logic
137 00:19:12.720 ⇒ 00:19:20.299 Robert Tseng: that’s not dependent on this, we in our rejects, we create the categories ourselves. We’re not really pulling in these same things like
138 00:19:20.480 ⇒ 00:19:20.820 Demilade Agboola: Okay.
139 00:19:20.820 ⇒ 00:19:28.899 Robert Tseng: Product category. Maybe we do. But I feel like we already just do that hard coded into the Regex bottles. So we don’t really even use these things
140 00:19:29.560 ⇒ 00:19:38.199 Demilade Agboola: No, don’t use, I can tell you. Like off top of my head we don’t use like subname. We don’t use subcategory. We don’t like. There are a number of things we don’t use.
141 00:19:39.130 ⇒ 00:19:44.439 Robert Tseng: Yeah. So it’s like, if we don’t use them, we don’t. We don’t really need to include them. Yeah.
142 00:19:45.070 ⇒ 00:19:59.539 Demilade Agboola: Alright, so I would. I would look at that like I said. It’s just a thing of I’m not sure like if there’s anything else we want to build, and then maybe a thing of like oh, we might want to look at it from like the drilling down into like the categories or subcategories, or something
143 00:19:59.960 ⇒ 00:20:16.990 Robert Tseng: Yeah, I mean, I think the very name itself like this is, this is what Zack gives us. I don’t think it gives us anything else. But from here, like I know that, majaro, this is a monthly. I know the quantity of it like I know it’s a weekly like I know all of these things from it.
144 00:20:17.460 ⇒ 00:20:17.950 Demilade Agboola: Yeah.
145 00:20:17.950 ⇒ 00:20:21.290 Robert Tseng: We should be extracting those out if they have it.
146 00:20:21.820 ⇒ 00:20:29.559 Robert Tseng: Product court. I mean that that’s kind of like what I want to. That’s that’s the exercise, like, I think is that’s necessary. Here.
147 00:20:29.610 ⇒ 00:20:52.400 Robert Tseng: you look at you just I mean, I can just eyeball it and be like, okay from here, from the variant name I see a product name. It’s the 1st word I see a frequency. I see monthly. I see quarterly. I see a quantity like I know the dosage is different. There’s a 2.5 milligram versus a 5 milligram like that’s 3 fields that I think we could extract right away. That’s pretty
148 00:20:52.540 ⇒ 00:20:54.459 Robert Tseng: easy. And then and and like
149 00:20:54.650 ⇒ 00:21:14.279 Robert Tseng: like that, that could be helpful later on. When we’re doing an analysis that’s like, okay, let’s let’s look at drugs that are 0 point 5 milligrams versus point 2 5. That’s where we start to use these categories. I mean, right now, we don’t do any sort of analysis at that rate. So that’s not urgent. But like
150 00:21:14.680 ⇒ 00:21:26.860 Robert Tseng: that’s why I’m saying is, I don’t. I think it’s fine. If we just leave it as we just keep what we are using, and if we need to break it out more, we already have this so that we can break it out further in the future.
151 00:21:27.480 ⇒ 00:21:34.869 Demilade Agboola: Makes sense alright. It’s all good. I’ll go through, and I’ll put everything back and like let you know, like I’ll send a message on the group
152 00:21:35.490 ⇒ 00:21:38.030 Robert Tseng: Okay. Cool. Alright. Thanks. Demo.
153 00:21:38.680 ⇒ 00:21:39.320 Demilade Agboola: Sounds good
154 00:21:39.320 ⇒ 00:21:40.560 Robert Tseng: Yeah, bye.