Meeting Title: ABC Standup Date: 2025-09-09 Meeting participants: Mustafa Raja, Justin Breshears, Amber Lin, Casie Aviles
WEBVTT
1 00:00:30.470 ⇒ 00:00:31.740 Amber Lin: Hello!
2 00:00:32.060 ⇒ 00:00:34.459 Amber Lin: Michelle, do you know Casey’s joining?
3 00:00:36.490 ⇒ 00:00:37.850 Mustafa Raja: Yeah.
4 00:00:38.000 ⇒ 00:00:39.440 Mustafa Raja: Yeah, he’s, he’s here.
5 00:00:39.740 ⇒ 00:00:41.030 Amber Lin: Okay, hi Casey.
6 00:00:41.310 ⇒ 00:00:42.620 Amber Lin: Awesome.
7 00:00:43.330 ⇒ 00:00:52.089 Amber Lin: Justin will be taking over Insomnia next week, so he’s listening in to the stand-up and catching up on progress.
8 00:00:52.440 ⇒ 00:00:53.220 Mustafa Raja: A…
9 00:00:54.250 ⇒ 00:00:55.970 Justin Breshears: How’s it going? Good to…
10 00:00:55.970 ⇒ 00:00:56.580 Mustafa Raja: Doing good.
11 00:00:56.580 ⇒ 00:00:58.109 Justin Breshears: Virtually meet y’all.
12 00:00:58.630 ⇒ 00:00:59.820 Mustafa Raja: Yeah, nice to meet you.
13 00:01:00.940 ⇒ 00:01:02.590 Amber Lin: Yeah.
14 00:01:02.970 ⇒ 00:01:12.609 Amber Lin: So, let’s start with Insomnia. Mostly, I just want to update on where things are, and then also to write an update to the client.
15 00:01:12.760 ⇒ 00:01:23.089 Amber Lin: So, I think I saw, yeah, I saw the updates for this. I… is DoorDash also fixed?
16 00:01:23.550 ⇒ 00:01:26.559 Casie Aviles: No, this was in… this is still in to-do.
17 00:01:26.560 ⇒ 00:01:32.820 Amber Lin: Oh, okay. The Uber… but the Uber… And… is the Uber ads?
18 00:01:32.970 ⇒ 00:01:34.200 Amber Lin: Fixed.
19 00:01:34.570 ⇒ 00:01:41.349 Amber Lin: Yeah, okay, in progress. Okay, sounds good.
20 00:01:41.640 ⇒ 00:01:45.170 Amber Lin: And are they on track for…
21 00:01:45.370 ⇒ 00:01:48.270 Amber Lin: This one for today, and that one for tomorrow.
22 00:01:49.950 ⇒ 00:01:54.439 Casie Aviles: Yeah, this one, for Braze, this is partially fixed, like.
23 00:01:55.260 ⇒ 00:02:02.660 Casie Aviles: I fixed one of the bugs there, but there’s still one more that I need to check, if… if there’s, like, if we can… yeah.
24 00:02:03.230 ⇒ 00:02:09.050 Casie Aviles: We can actually… solve that one with the data that we get from the API, but…
25 00:02:09.289 ⇒ 00:02:10.149 Amber Lin: Yeah, that’s me.
26 00:02:10.150 ⇒ 00:02:10.910 Casie Aviles: Okay. That’s it.
27 00:02:11.500 ⇒ 00:02:12.529 Amber Lin: I see.
28 00:02:12.770 ⇒ 00:02:21.690 Amber Lin: And… I think 4 are different sources. Right now, they’re all in the intermediate spreadsheet, right?
29 00:02:22.430 ⇒ 00:02:26.070 Casie Aviles: Yes. And then you have to copy it over to the daily scorecard.
30 00:02:26.790 ⇒ 00:02:28.990 Casie Aviles: Yes, that’s how it works right now.
31 00:02:29.190 ⇒ 00:02:33.279 Amber Lin: How will we get it to the daily scorecard?
32 00:02:37.020 ⇒ 00:02:42.860 Casie Aviles: I think when… I’ll have to look into it, because if we can… because if we can…
33 00:02:44.490 ⇒ 00:02:50.979 Casie Aviles: connect our spreadsheet to their spreadsheet, then that should be no problem, but…
34 00:02:51.180 ⇒ 00:02:55.680 Casie Aviles: If that’s not possible, because it’s in a SharePoint
35 00:02:56.850 ⇒ 00:03:00.729 Casie Aviles: Yeah, it’s an Excel file, so it’s not exactly Google Sheets.
36 00:03:01.550 ⇒ 00:03:06.919 Casie Aviles: So that might be more… That might be… yeah, that might require a different approach.
37 00:03:07.870 ⇒ 00:03:14.059 Amber Lin: Gotcha. So we should spike on… Do we have SharePoint access?
38 00:03:16.200 ⇒ 00:03:23.659 Casie Aviles: I think so, I mean, we can, we can view their, their files, their… They share with us.
39 00:03:25.650 ⇒ 00:03:28.179 Amber Lin: Let’s see, Google Sheet…
40 00:03:28.770 ⇒ 00:03:30.180 Casie Aviles: Yeah, that, that’s…
41 00:03:31.460 ⇒ 00:03:33.190 Amber Lin: Automation…
42 00:03:37.320 ⇒ 00:03:50.730 Amber Lin: We can do that. Or could we create… would we create a version of our own on Google Sheets, or should we just create that in SharePoint?
43 00:03:51.350 ⇒ 00:03:59.820 Casie Aviles: I think… The decision at first was that we shouldn’t Connect the automations to their…
44 00:04:00.390 ⇒ 00:04:07.409 Casie Aviles: SharePoint, because, yeah, we don’t… because we didn’t want to mess up their… Makes sense. Their sheets.
45 00:04:07.780 ⇒ 00:04:11.689 Casie Aviles: Yeah. Which is why we created the sheet… our own Google Sheets.
46 00:04:11.690 ⇒ 00:04:21.329 Amber Lin: Can we assemble our own Google Sheets like their daily impact scorecard in just Google Sheets? Like, assemble it, assemble it in the same format?
47 00:04:22.190 ⇒ 00:04:28.580 Casie Aviles: Yeah, I’ve done something like that, but it’s not… it’s not exactly like their version, but…
48 00:04:28.760 ⇒ 00:04:31.609 Casie Aviles: It should make it easier to, like, just…
49 00:04:32.000 ⇒ 00:04:34.059 Casie Aviles: Formatted in the same way that they did.
50 00:04:34.060 ⇒ 00:04:35.560 Amber Lin: Okay.
51 00:04:35.720 ⇒ 00:04:38.870 Amber Lin: I think that’s the first thing we can do, and then…
52 00:04:39.510 ⇒ 00:04:46.920 Amber Lin: like, ideally, we can just copy-paste that page each day from Google Sheets to their sheet.
53 00:04:47.280 ⇒ 00:04:50.910 Casie Aviles: Yeah, I can add a screenshot to that ticket of how I…
54 00:04:50.910 ⇒ 00:04:51.460 Amber Lin: Awesome.
55 00:04:52.080 ⇒ 00:04:52.670 Casie Aviles: Yeah.
56 00:04:53.850 ⇒ 00:05:00.819 Amber Lin: And then after that, we can… Asked them if we wanna…
57 00:05:00.970 ⇒ 00:05:07.030 Amber Lin: Paste that in, because I think that will make the manual… manual stuff a lot… A bit loose.
58 00:05:08.080 ⇒ 00:05:09.270 Amber Lin: Hmm…
59 00:05:17.780 ⇒ 00:05:20.600 Amber Lin: Yeah, so overall, I think…
60 00:05:21.260 ⇒ 00:05:29.739 Amber Lin: Casey, can you tell me overall what’s the progress for each of these sources? I know we’re missing stuff for Meta and the 30 Sales Fresh.
61 00:05:30.040 ⇒ 00:05:32.749 Amber Lin: And Grubhub, honestly.
62 00:05:33.190 ⇒ 00:05:35.810 Casie Aviles: Yeah, those ones are blocked.
63 00:05:37.590 ⇒ 00:05:41.610 Casie Aviles: Yeah, for Meta, It looks like…
64 00:05:43.190 ⇒ 00:05:48.180 Casie Aviles: That Robert wants us to, like…
65 00:05:48.480 ⇒ 00:05:52.620 Casie Aviles: Talk to the client, and ask, like, push, push on them to…
66 00:05:52.760 ⇒ 00:05:55.110 Amber Lin: Give us the axis.
67 00:05:56.080 ⇒ 00:05:58.650 Casie Aviles: Yeah, I guess that’s, that’s,
68 00:05:59.020 ⇒ 00:06:02.490 Casie Aviles: what we could do for Meta, for Braze.
69 00:06:03.110 ⇒ 00:06:06.140 Casie Aviles: I would say that This is…
70 00:06:06.750 ⇒ 00:06:11.269 Casie Aviles: for the most part, working, it’s just… there are just some bugs that I…
71 00:06:11.710 ⇒ 00:06:13.380 Casie Aviles: one that I have to fix, so…
72 00:06:14.470 ⇒ 00:06:34.230 Amber Lin: Gotcha. Race… I guess, overall, we have… The source says we… are granted access… 2 in… sheet…
73 00:06:34.820 ⇒ 00:06:38.230 Amber Lin: We’ll work on assembly.
74 00:06:38.620 ⇒ 00:06:44.900 Amber Lin: The missing access… Red, .
75 00:06:45.860 ⇒ 00:06:50.319 Casie Aviles: They… yeah, this one, we get it from just the emails.
76 00:06:50.580 ⇒ 00:06:52.949 Casie Aviles: Yeah. You’re saying daily sales finish.
77 00:06:53.660 ⇒ 00:07:03.329 Amber Lin: True. How about the intermediate spreadsheets? There’s intermediate spreadsheets for phrase and also for their own marketing.
78 00:07:07.370 ⇒ 00:07:16.360 Amber Lin: So, the marketing tracker… Are we updating those as well? Is there automation that we update those?
79 00:07:16.910 ⇒ 00:07:23.710 Casie Aviles: Yeah, yeah, I’m also updating that, manually from our spreadsheet.
80 00:07:25.460 ⇒ 00:07:28.209 Casie Aviles: From the data that I have on our spreadsheet.
81 00:07:29.470 ⇒ 00:07:30.600 Amber Lin: Gotcha.
82 00:07:31.050 ⇒ 00:07:33.719 Amber Lin: And same for FDA projections.
83 00:07:34.600 ⇒ 00:07:35.300 Casie Aviles: Yes.
84 00:07:36.040 ⇒ 00:07:39.590 Amber Lin: Oh… how are we going to automate that?
85 00:07:41.750 ⇒ 00:07:46.479 Casie Aviles: It’s the same case for their, for the daily impact scorecard. It’s all in SharePoint.
86 00:07:47.720 ⇒ 00:07:48.610 Amber Lin: Ugh.
87 00:07:50.440 ⇒ 00:07:51.560 Amber Lin: I see.
88 00:07:51.560 ⇒ 00:07:53.810 Casie Aviles: So the best that I could do is to just…
89 00:07:54.090 ⇒ 00:07:58.109 Casie Aviles: Copy the format that they have for those intermediate sheets.
90 00:08:00.000 ⇒ 00:08:00.730 Casie Aviles: Right now…
91 00:08:00.730 ⇒ 00:08:03.339 Amber Lin: Do we have, like, a SharePoint account?
92 00:08:03.870 ⇒ 00:08:10.880 Amber Lin: Maybe we can directly do the automations into SharePoint rather than Google Sheets, but it might be harder.
93 00:08:13.210 ⇒ 00:08:21.739 Casie Aviles: Right now, it’s connected to our Google spreadsheets, but yeah, that’s also going to be part of my investigation as to how.
94 00:08:21.740 ⇒ 00:08:22.670 Amber Lin: Woohoo.
95 00:08:23.860 ⇒ 00:08:28.189 Casie Aviles: potentially, directly get the data to SharePoint.
96 00:08:28.950 ⇒ 00:08:31.030 Casie Aviles: If it’s possible. If not, then…
97 00:08:31.030 ⇒ 00:08:31.550 Amber Lin: Yep.
98 00:08:31.780 ⇒ 00:08:33.429 Casie Aviles: We’ll have to make do with the…
99 00:08:34.789 ⇒ 00:08:39.009 Casie Aviles: Google spreadsheet, and probably we will just share it with them.
100 00:08:40.250 ⇒ 00:08:42.790 Amber Lin: Okay, sounds good.
101 00:08:43.190 ⇒ 00:08:51.599 Amber Lin: Did you add… okay, great. Oh, that’s essentially the same as what they have.
102 00:08:52.180 ⇒ 00:08:54.850 Casie Aviles: Yes, so this is just one…
103 00:08:55.380 ⇒ 00:08:57.359 Casie Aviles: For, like, per day, and then I would…
104 00:08:58.160 ⇒ 00:09:00.789 Casie Aviles: Edit the… the date.
105 00:09:01.260 ⇒ 00:09:04.149 Casie Aviles: To make two… and then it will get refreshed by…
106 00:09:05.110 ⇒ 00:09:07.669 Casie Aviles: The data from a particular date.
107 00:09:08.400 ⇒ 00:09:10.050 Amber Lin: Oh…
108 00:09:10.550 ⇒ 00:09:14.579 Casie Aviles: So it’s pulling from data from the other sheets that I have.
109 00:09:15.040 ⇒ 00:09:16.540 Amber Lin: Mmm, very cool.
110 00:09:17.290 ⇒ 00:09:22.089 Amber Lin: Okay, and then this is what we filled in for the FDA.
111 00:09:22.280 ⇒ 00:09:31.010 Amber Lin: Where do we fill in for the… Like, the marketing performance tracker.
112 00:09:32.650 ⇒ 00:09:35.330 Casie Aviles: That’s… that’s a different sheet. This is for.
113 00:09:35.330 ⇒ 00:09:35.870 Amber Lin: Oh, okay.
114 00:09:35.870 ⇒ 00:09:36.850 Casie Aviles: stock scorecard.
115 00:09:36.850 ⇒ 00:09:38.680 Amber Lin: Okay, okay, sounds good.
116 00:09:39.010 ⇒ 00:09:42.880 Amber Lin: So I think… I think we can show Robert…
117 00:09:43.290 ⇒ 00:09:45.619 Amber Lin: This is something that we have.
118 00:09:50.740 ⇒ 00:09:55.129 Casie Aviles: Okay, sounds good. I’ll just keep attaching the screenshots.
119 00:09:55.580 ⇒ 00:10:05.150 Amber Lin: Yeah, awesome. I think that’s all for Insomniac Cookies for now. They have some more stuff that’s less on the automation side. I think we should just wrap up…
120 00:10:05.710 ⇒ 00:10:13.810 Amber Lin: Yeah, just wrap… we should just wrap up the meta and then get access from them.
121 00:10:14.250 ⇒ 00:10:14.950 Amber Lin: Okay.
122 00:10:16.190 ⇒ 00:10:17.500 Amber Lin: Awesome.
123 00:10:20.730 ⇒ 00:10:23.979 Amber Lin: Alright, and then we can do ABC…
124 00:10:24.440 ⇒ 00:10:29.069 Amber Lin: Let’s go here. I have a few triage tickets come in.
125 00:10:33.870 ⇒ 00:10:35.539 Amber Lin: I’ll edit that.
126 00:10:36.660 ⇒ 00:10:37.440 Amber Lin: Okay.
127 00:11:02.550 ⇒ 00:11:03.410 Amber Lin: Huh?
128 00:11:05.450 ⇒ 00:11:07.020 Amber Lin: I’m so confused.
129 00:11:13.940 ⇒ 00:11:20.330 Amber Lin: Yeah, I’ll go triage these. I feel like this is… Less urgent.
130 00:11:21.160 ⇒ 00:11:22.350 Amber Lin: Alright.
131 00:11:23.550 ⇒ 00:11:37.699 Amber Lin: I’ll check… I’ll check on these… Oh… Okay, that’s for Brenda…
132 00:11:38.780 ⇒ 00:11:41.289 Amber Lin: So, goat, how did this one go?
133 00:11:42.970 ⇒ 00:11:48.679 Casie Aviles: I moved… is it okay if I moved it to today? This one’s still in progress.
134 00:11:49.170 ⇒ 00:11:49.780 Amber Lin: Okay.
135 00:11:50.280 ⇒ 00:11:52.300 Amber Lin: Okay, would you get it done today?
136 00:11:53.460 ⇒ 00:11:59.060 Casie Aviles: Yeah, I’ll try to have it today. Yesterday, I just focused on the insomnia stuff.
137 00:11:59.060 ⇒ 00:12:01.210 Amber Lin: Gotcha. Understood. This is not…
138 00:12:01.600 ⇒ 00:12:09.269 Amber Lin: as urgent as long as we have something by Thursday, so I’ll let you figure out the time and when you want to do it.
139 00:12:09.610 ⇒ 00:12:10.260 Casie Aviles: Okay.
140 00:12:10.590 ⇒ 00:12:13.399 Amber Lin: Okay, I’ll say this is for next week.
141 00:12:19.350 ⇒ 00:12:25.680 Casie Aviles: I moved some of these to done because I saw Janice commented on them, so I moved those to done.
142 00:12:25.930 ⇒ 00:12:29.560 Amber Lin: Awesome. Yeah, I’ll check… I’ll check with her.
143 00:12:32.690 ⇒ 00:12:33.370 Amber Lin: Oh.
144 00:12:34.480 ⇒ 00:12:35.190 Amber Lin: Huh.
145 00:12:35.410 ⇒ 00:12:36.810 Amber Lin: I’ll check.
146 00:12:37.240 ⇒ 00:12:40.790 Amber Lin: Yeah, and that’s for Janiece’s feedback.
147 00:12:46.180 ⇒ 00:12:53.770 Amber Lin: Mustafa, is… these are good, right? I can add… I… do you think we’re good to ask the lawn people to start testing?
148 00:12:55.000 ⇒ 00:12:55.869 Mustafa Raja: Yeah.
149 00:12:56.130 ⇒ 00:12:56.730 Amber Lin: Okay.
150 00:12:57.460 ⇒ 00:12:58.829 Amber Lin: Sounds good.
151 00:13:00.800 ⇒ 00:13:04.500 Amber Lin: I will add that. That was…
152 00:13:04.720 ⇒ 00:13:08.329 Amber Lin: Last cycle, that’s good as well, right?
153 00:13:09.010 ⇒ 00:13:14.419 Mustafa Raja: Yeah, I would say that,
154 00:13:14.780 ⇒ 00:13:22.190 Mustafa Raja: We can improve, improve that, though, because what we are doing right now is we are giving the whole sheets to the…
155 00:13:22.360 ⇒ 00:13:24.719 Mustafa Raja: AI agent. What we…
156 00:13:25.150 ⇒ 00:13:28.360 Mustafa Raja: Roger can do is give it the… only the…
157 00:13:29.650 ⇒ 00:13:35.350 Mustafa Raja: zip code. And this is one of the issues that came into triage too.
158 00:13:36.210 ⇒ 00:13:46.750 Mustafa Raja: I see. Casey, how far do you think we’re from deploying the zip code database? Because that should be fixed, if we have that database in.
159 00:13:46.750 ⇒ 00:13:47.650 Amber Lin: Live.
160 00:13:49.510 ⇒ 00:13:58.909 Casie Aviles: So, the steps that I believe we need to take first is to be done with the… so we’ll just need to validate first, because we don’t want to push it.
161 00:14:00.510 ⇒ 00:14:03.040 Casie Aviles: with… With lots of holes.
162 00:14:03.290 ⇒ 00:14:04.610 Amber Lin: So…
163 00:14:04.800 ⇒ 00:14:08.279 Casie Aviles: We’ll make… we’ll make sure that that’s as,
164 00:14:08.810 ⇒ 00:14:12.650 Casie Aviles: Yeah, like, the data integrity is good. And then after that.
165 00:14:13.180 ⇒ 00:14:17.739 Casie Aviles: We would need to also do, like, the querying thing.
166 00:14:17.890 ⇒ 00:14:24.419 Casie Aviles: So… That’s another… That’s also something we need to work on, so if…
167 00:14:26.030 ⇒ 00:14:29.169 Casie Aviles: We can be done… With all of that.
168 00:14:29.700 ⇒ 00:14:32.630 Casie Aviles: this week, then I guess, next week.
169 00:14:33.010 ⇒ 00:14:37.189 Casie Aviles: we can… Probably have it live.
170 00:14:37.990 ⇒ 00:14:39.550 Casie Aviles: Early next week, yeah.
171 00:14:40.070 ⇒ 00:14:50.930 Amber Lin: Sounds good. How would we test it? Are we just gonna roll it out to everybody, all just immediately, or are we going to specify, who has access to that?
172 00:14:53.940 ⇒ 00:14:58.800 Casie Aviles: I think it’s not… Really locked behind any…
173 00:14:59.750 ⇒ 00:15:03.919 Casie Aviles: So, like, I mean, it’s just going to be connected to Andy.
174 00:15:04.060 ⇒ 00:15:05.890 Amber Lin: Directly, so…
175 00:15:05.890 ⇒ 00:15:10.610 Casie Aviles: Anyone who should be able to use ANDI will… Have access to it.
176 00:15:11.050 ⇒ 00:15:12.410 Amber Lin: Gotcha.
177 00:15:15.430 ⇒ 00:15:18.390 Amber Lin: Sounds good. Let me check with Luton.
178 00:15:19.410 ⇒ 00:15:25.130 Amber Lin: Or… The transcripts…
179 00:15:41.030 ⇒ 00:15:42.260 Amber Lin: Alright.
180 00:15:42.730 ⇒ 00:15:48.599 Amber Lin: I think that’s all. I just… I think we’re just focusing on pushing… the database.
181 00:15:48.770 ⇒ 00:15:55.499 Amber Lin: Across… Seems like most of your feedback here, you’ve already done.
182 00:15:55.750 ⇒ 00:15:58.279 Amber Lin: And then also Mustafa…
183 00:15:58.700 ⇒ 00:16:00.000 Mustafa Raja: Yeah.
184 00:16:00.000 ⇒ 00:16:00.910 Amber Lin: these.
185 00:16:00.910 ⇒ 00:16:08.380 Mustafa Raja: Yeah, today I’ll… I didn’t get much time yesterday. For the teenagers, I’ll look into these today.
186 00:16:08.650 ⇒ 00:16:09.290 Amber Lin: Okay.
187 00:16:09.320 ⇒ 00:16:10.669 Mustafa Raja: Yeah, sounds good.
188 00:16:10.950 ⇒ 00:16:18.170 Amber Lin: Let me know, and I’ll go triage the new ones, and I’m talking to the client tomorrow, so we’ll know what they think.
189 00:16:18.350 ⇒ 00:16:18.790 Mustafa Raja: Okay.
190 00:16:18.790 ⇒ 00:16:20.290 Amber Lin: Alright, thank you all.
191 00:16:20.290 ⇒ 00:16:21.090 Mustafa Raja: Thank you.
192 00:16:21.500 ⇒ 00:16:22.020 Amber Lin: Right.
193 00:16:22.150 ⇒ 00:16:23.130 Amber Lin: Bye. Thank you.