Meeting Title: ABC Standup Date: 2025-08-18 Meeting participants: Awaish Kumar, Casie Aviles, Mustafa Raja, Amber Lin
WEBVTT
1 00:02:28.000 ⇒ 00:02:29.289 Amber Lin: Hello, team.
2 00:02:31.040 ⇒ 00:02:31.570 Mustafa Raja: Hey.
3 00:02:31.750 ⇒ 00:02:32.610 Awaish Kumar: Obama!
4 00:02:32.610 ⇒ 00:02:41.829 Amber Lin: I want to talk about installment cookies first. Casey, first of all, sorry, I did not specify the date, I think I did
5 00:02:41.980 ⇒ 00:02:45.990 Amber Lin: you were doing it according to the SOPs, I was wrong, I told Robert.
6 00:02:45.990 ⇒ 00:02:47.080 Casie Aviles: No problem.
7 00:02:47.080 ⇒ 00:02:47.940 Amber Lin: That’s fine.
8 00:02:48.620 ⇒ 00:02:53.000 Casie Aviles: Yeah, yeah, it’s fine. I did call Robert, and we just sorted it out quickly.
9 00:02:53.330 ⇒ 00:03:00.340 Amber Lin: Okay, okay, appreciate that. Let me share screen. So right now, …
10 00:03:00.730 ⇒ 00:03:06.229 Amber Lin: Okay, going back here, we have… Oh, that’s needed.
11 00:03:06.720 ⇒ 00:03:15.910 Amber Lin: We have, … So Braze is done. How’s the Google Ads automation?
12 00:03:17.190 ⇒ 00:03:17.580 Casie Aviles: ….
13 00:03:17.580 ⇒ 00:03:18.690 Awaish Kumar: Do you have any….
14 00:03:18.950 ⇒ 00:03:20.130 Casie Aviles: Oh, sorry, go ahead.
15 00:03:20.890 ⇒ 00:03:27.620 Awaish Kumar: Yeah, just a question for Insomnia. Do we have any, like, kind of planning, … Like that.
16 00:03:28.620 ⇒ 00:03:38.859 Awaish Kumar: like, we should have some tickets ready that you can say could be done in this week, and then maybe you can go over individual tickets.
17 00:03:40.260 ⇒ 00:03:51.600 Amber Lin: Well, this project is specific because we are essentially completing everything we have access to. Whatever’s left, we don’t have access to, so it’s not up to us.
18 00:03:55.810 ⇒ 00:03:57.090 Awaish Kumar: We’re gonna go.
19 00:03:57.090 ⇒ 00:04:14.230 Amber Lin: Yeah, I would love to get it done. I think right now, DoorDash can be this week, Google Ads needs to be done this week. I’ll try my best to see if I can get access to the other ones, but we don’t, so I’m gonna…
20 00:04:15.590 ⇒ 00:04:19.450 Amber Lin: Assign this… This week…
21 00:04:27.210 ⇒ 00:04:34.010 Amber Lin: Okay. How is the Google Ads process? How did the configuration go?
22 00:04:34.010 ⇒ 00:04:37.089 Casie Aviles: Okay, yeah, I can give some context. So….
23 00:04:37.090 ⇒ 00:04:42.320 Amber Lin: Basically, what I did for this one is I am getting the data.
24 00:04:42.430 ⇒ 00:04:46.100 Casie Aviles: I built on top of what Awash did, the test he did, so…
25 00:04:46.610 ⇒ 00:04:50.130 Casie Aviles: He was getting it via Polyatomic, and…
26 00:04:51.040 ⇒ 00:04:53.650 Casie Aviles: That data will be sent to Snowflake.
27 00:04:53.960 ⇒ 00:04:59.430 Casie Aviles: And I am just getting the date, so I just aggregated it based on the date.
28 00:04:59.960 ⇒ 00:05:05.900 Casie Aviles: And, yeah, we managed to match the data?
29 00:05:06.140 ⇒ 00:05:17.660 Casie Aviles: on Snowflake to Google Ads, the dashboard. But I guess… so yeah, what’s left there is to actually automate the process, because that was just a manual
30 00:05:17.890 ⇒ 00:05:18.700 Casie Aviles: Run.
31 00:05:18.930 ⇒ 00:05:20.739 Casie Aviles: And the manual upload.
32 00:05:22.190 ⇒ 00:05:25.860 Casie Aviles: So for that, I just need to build out, like, a workflow for that.
33 00:05:25.990 ⇒ 00:05:45.569 Casie Aviles: But I guess, like, the question before I actually build that is, are we… have we decided on actually going with this method, like, polyatomic? Because I believe there were… there was, like, concerns raised in terms of, like, costs, or… yeah, I think that was it.
34 00:05:47.540 ⇒ 00:05:51.199 Amber Lin: I haven’t heard back on the costs, …
35 00:05:51.490 ⇒ 00:05:58.750 Amber Lin: I don’t think there’s another way for us to do it, because the other way would be to… …
36 00:05:59.130 ⇒ 00:06:12.759 Amber Lin: connect to the Looker report that they have, which we don’t have access to that. Alternatively, I think we said to build our own as script, but I don’t know if that’s possible.
37 00:06:13.970 ⇒ 00:06:14.770 Casie Aviles: Yeah, …
38 00:06:14.970 ⇒ 00:06:25.459 Casie Aviles: I mean, me personally, as the one assigned to the ticket, I would say that the clearest path forward for me was the, yeah, this polyatomic, and then just building out
39 00:06:26.050 ⇒ 00:06:27.260 Casie Aviles: workflow.
40 00:06:27.510 ⇒ 00:06:28.980 Casie Aviles: So I… yeah.
41 00:06:29.100 ⇒ 00:06:32.609 Casie Aviles: That’s… that’s a clearer spot for me forward, so….
42 00:06:32.610 ⇒ 00:06:36.280 Amber Lin: Huh. Do we have an idea of how… what cost it would be?
43 00:06:36.810 ⇒ 00:06:40.480 Casie Aviles: No, actually, that’s the… that’s one thing I’m not sure with polyatomic.
44 00:06:41.480 ⇒ 00:06:42.510 Amber Lin: Aha.
45 00:06:43.310 ⇒ 00:06:44.270 Amber Lin: …
46 00:06:44.540 ⇒ 00:06:49.689 Amber Lin: Could we ask them for the cost, or is this something that we can figure out on their platform?
47 00:06:49.910 ⇒ 00:06:53.250 Awaish Kumar: For the cost, like, it depends on,
48 00:06:53.460 ⇒ 00:07:02.680 Awaish Kumar: I don’t know how… how they charge us, like, we are partners, but for Eden, for example, we have it based on number of rows synced.
49 00:07:02.840 ⇒ 00:07:10.479 Awaish Kumar: So, for 500K, we can think, 6.5 million rows, in a month.
50 00:07:10.810 ⇒ 00:07:12.530 Awaish Kumar: Hi, everyone.
51 00:07:13.020 ⇒ 00:07:20.280 Awaish Kumar: Yeah, and it doesn’t matter how many connectors we connect, but it’s just based on a number of rows.
52 00:07:20.450 ⇒ 00:07:22.029 Awaish Kumar: So… I see.
53 00:07:22.030 ⇒ 00:07:22.930 Casie Aviles: This is my gross.
54 00:07:22.930 ⇒ 00:07:30.059 Awaish Kumar: Yeah, that’s the minimal, price for them, from them. So, like.
55 00:07:30.240 ⇒ 00:07:33.449 Awaish Kumar: At a minimum, if client wants.
56 00:07:33.800 ⇒ 00:07:37.369 Awaish Kumar: Maybe then it will be $500K per month for them.
57 00:07:37.610 ⇒ 00:07:43.189 Awaish Kumar: Right now it’s in Brainforge, and I don’t know how they charge a Brainforge instance.
58 00:07:45.440 ⇒ 00:07:46.270 Amber Lin: ….
59 00:07:46.480 ⇒ 00:07:47.930 Awaish Kumar: Like, Barefront account?
60 00:07:48.040 ⇒ 00:07:54.940 Awaish Kumar: Right now, the connector is on Brainforge account, right? So we don’t know… we have two partners, so we don’t know how they charge us.
61 00:07:55.320 ⇒ 00:07:57.600 Awaish Kumar: That will be, like, different from the client’s.
62 00:07:58.450 ⇒ 00:07:59.770 Amber Lin: Yeah, I see.
63 00:07:59.970 ⇒ 00:08:05.439 Casie Aviles: Oh, so the client will shoulder the costs, okay. So they’ll have to create an account then?
64 00:08:08.140 ⇒ 00:08:14.179 Awaish Kumar: Yeah, Depends on the client, our engagement with client, like, whatever it is.
65 00:08:14.780 ⇒ 00:08:17.860 Awaish Kumar: If we are going to be at the cost.
66 00:08:18.240 ⇒ 00:08:21.700 Awaish Kumar: Or, like, that’s more on, like, the account owner can….
67 00:08:21.700 ⇒ 00:08:22.050 Casie Aviles: I can just….
68 00:08:22.050 ⇒ 00:08:23.859 Awaish Kumar: on this? Maybe, Robert.
69 00:08:25.930 ⇒ 00:08:26.740 Amber Lin: …
70 00:08:27.180 ⇒ 00:08:43.999 Amber Lin: I would vote that we still build it out while we wait for feedback from Robert, because this is the only… Google Ads and DoorDash are the only two items you can action on, and we are not syncing that many rows, based on my understanding, so….
71 00:08:44.190 ⇒ 00:08:45.179 Casie Aviles: We have….
72 00:08:45.180 ⇒ 00:08:48.429 Amber Lin: There, the cost, it wouldn’t be too high, is that true?
73 00:08:48.660 ⇒ 00:08:52.170 Casie Aviles: We have 43.8K rows.
74 00:08:53.940 ⇒ 00:08:55.550 Casie Aviles: And 150 rows.
75 00:08:56.060 ⇒ 00:08:59.930 Casie Aviles: Two tables, so that’s… that’s… that’s all of the rows we have right now.
76 00:09:00.420 ⇒ 00:09:09.469 Amber Lin: I see. And then I wish set a number at 5 million, so I don’t… I don’t think we will need that much.
77 00:09:10.370 ⇒ 00:09:13.550 Awaish Kumar: Yeah, but their basic plan is that, right? 500…
78 00:09:13.700 ⇒ 00:09:23.910 Awaish Kumar: dollars for 6.5 million rows per month, so I’m not sure if they have any plan which is cheaper than this.
79 00:09:25.590 ⇒ 00:09:27.030 Amber Lin: I see.
80 00:09:31.240 ⇒ 00:09:37.009 Amber Lin: … But it says it’s unlimited connectors, so it can connect to different sources, right?
81 00:09:37.500 ⇒ 00:09:42.729 Awaish Kumar: Yes, like, Google Ads, Meta… Okay. They don’t… they…
82 00:09:42.940 ⇒ 00:09:45.740 Awaish Kumar: They can build even brace, like, if… if…
83 00:09:45.870 ⇒ 00:09:49.930 Awaish Kumar: If client can pay for it, then they can build the Braze connector as well.
84 00:09:50.540 ⇒ 00:09:51.160 Amber Lin: Hmm.
85 00:09:51.390 ⇒ 00:09:52.280 Amber Lin: Okay.
86 00:09:54.030 ⇒ 00:10:00.239 Amber Lin: … Do you guys agree that we should move for… go…
87 00:10:00.550 ⇒ 00:10:05.849 Amber Lin: see if we can build the automation, and then I’m gonna ping Robert on if he.
88 00:10:05.850 ⇒ 00:10:19.620 Awaish Kumar: Yeah, like, I’m… KC, what is the blocker? Like, the… I build the two connectors in there. One is getting data from Polytomic to Snowflake, and then Snowflake to Google Sheet, so it was all automated.
89 00:10:19.870 ⇒ 00:10:22.419 Casie Aviles: Yeah, yeah, there’s no blocker in terms of, …
90 00:10:22.930 ⇒ 00:10:32.960 Casie Aviles: like, you know, the technical side, it’s just more on the decision on whether we want to proceed with this or not, because I can build it out, it’s just…
91 00:10:34.130 ⇒ 00:10:41.850 Casie Aviles: Yeah, but that’s… that’s, yeah, I would say the blocker. But I can proceed, I can work on this today if…
92 00:10:42.420 ⇒ 00:10:44.569 Casie Aviles: I can build out the automation, yeah.
93 00:10:47.810 ⇒ 00:10:54.899 Amber Lin: Okay, there’s another… Robert sent this morning on two sources, so, …
94 00:10:55.430 ⇒ 00:11:05.270 Amber Lin: Uber and DoorDash. Uber we don’t have complete access to, so, we should start with DoorDash. I think what Robert suggested…
95 00:11:05.490 ⇒ 00:11:12.910 Amber Lin: … We most likely would… Let’s see…
96 00:11:13.270 ⇒ 00:11:17.030 Amber Lin: We don’t… we won’t have API access, but…
97 00:11:17.180 ⇒ 00:11:23.820 Amber Lin: maybe we could use some web crawler to get this. What are some initial thoughts?
98 00:11:25.450 ⇒ 00:11:29.559 Casie Aviles: Mmm, a webcrawler, I’m… I would say I’m…
99 00:11:31.430 ⇒ 00:11:39.150 Casie Aviles: I have some ideas, but I think probably browser-based, maybe, but although I haven’t tried it much, I think it’s just the…
100 00:11:39.270 ⇒ 00:11:43.569 Casie Aviles: Tool that we had the most success with, in terms of, like, web crawling.
101 00:11:44.550 ⇒ 00:11:45.270 Amber Lin: Okay.
102 00:11:45.730 ⇒ 00:11:52.510 Casie Aviles: But yeah, I’ll have to… consult again with… I’ll have to consult, probably, with Sam and the AI team.
103 00:11:53.320 ⇒ 00:11:58.020 Amber Lin: I see, so let me put a spike… ….
104 00:11:58.020 ⇒ 00:12:00.070 Awaish Kumar: But what is the requirement here?
105 00:12:01.720 ⇒ 00:12:10.730 Amber Lin: So, it’s also the same section, the same numbers here, so I think we want to… ….
106 00:12:10.730 ⇒ 00:12:16.480 Awaish Kumar: Yeah, so DoDash don’t have any API? Like, is that what you’re saying, Casey?
107 00:12:17.640 ⇒ 00:12:20.339 Amber Lin: Robert said we won’t have API access.
108 00:12:22.750 ⇒ 00:12:26.749 Awaish Kumar: Okay, okay, Robert said we don’t have API access, but if we… okay.
109 00:12:27.150 ⇒ 00:12:28.330 Awaish Kumar: John, nope.
110 00:12:29.530 ⇒ 00:12:36.550 Casie Aviles: Yeah, okay. I think that was, yeah, Robert’s suggestion, if we could use a web crawler, because we don’t have API access.
111 00:12:39.360 ⇒ 00:12:42.350 Amber Lin: Alright, I will note that down.
112 00:12:42.490 ⇒ 00:12:47.710 Amber Lin: Also… I’ll create a spike ticket and assign it to you.
113 00:12:48.350 ⇒ 00:12:54.830 Amber Lin: … Could I say… Have this by tomorrow of approach.
114 00:12:55.520 ⇒ 00:12:57.000 Amber Lin: After the spike.
115 00:12:58.020 ⇒ 00:13:01.440 Casie Aviles: Okay. So by tomorrow, despite COVID.
116 00:13:01.790 ⇒ 00:13:03.210 Amber Lin: Yeah, …
117 00:13:03.420 ⇒ 00:13:11.949 Amber Lin: I think you should have access. I’m gonna work on creating the manual fuel instructions, so if there’s any access that’s pending, I’ll also notice that.
118 00:13:13.570 ⇒ 00:13:14.240 Casie Aviles: Sure.
119 00:13:14.490 ⇒ 00:13:16.929 Amber Lin: Yeah, okay. I think…
120 00:13:17.350 ⇒ 00:13:30.180 Amber Lin: On Uber, we’re still waiting on… we’re still waiting on it, so I’ll check if it works, I’ll send the instructions to you guys, and you can also start a spike on that.
121 00:13:50.050 ⇒ 00:13:50.880 Amber Lin: Alright.
122 00:13:51.550 ⇒ 00:13:56.700 Amber Lin: As for that, let’s look at the data platform side.
123 00:13:57.500 ⇒ 00:14:05.740 Amber Lin: So, we had… Oh, I guess we started the new cycle.
124 00:14:06.420 ⇒ 00:14:12.169 Casie Aviles: For me, that’s just the leftover Clockify one, and I wasn’t able to finish.
125 00:14:14.950 ⇒ 00:14:17.750 Casie Aviles: Oh, sorry, no, no, I mean operating, operating.
126 00:14:18.040 ⇒ 00:14:18.849 Amber Lin: Oh, okay.
127 00:14:19.200 ⇒ 00:14:20.939 Casie Aviles: clarifies that, I believe.
128 00:14:22.190 ⇒ 00:14:22.840 Amber Lin: Okay.
129 00:14:23.120 ⇒ 00:14:24.080 Amber Lin: …
130 00:14:27.910 ⇒ 00:14:29.289 Casie Aviles: Just need to merge it.
131 00:14:29.670 ⇒ 00:14:30.740 Casie Aviles: Looks like….
132 00:14:31.340 ⇒ 00:14:32.000 Amber Lin: Okay.
133 00:14:32.690 ⇒ 00:14:41.590 Amber Lin: … I think now that we have that, we should start thinking about how that relates to…
134 00:14:41.990 ⇒ 00:14:48.540 Amber Lin: Final usage case, I think we should book, Here.
135 00:14:48.710 ⇒ 00:14:50.709 Amber Lin: I think me and…
136 00:14:51.060 ⇒ 00:15:04.519 Amber Lin: Rico will review the dashboard first, and then suggest any changes or use cases. Maybe we end up combining those three, or end up having those separately. Maybe we have something that
137 00:15:04.780 ⇒ 00:15:08.230 Amber Lin: Relates to each other, but, …
138 00:15:08.480 ⇒ 00:15:12.500 Amber Lin: So, Clockify and Linear are available on Rail, right?
139 00:15:14.950 ⇒ 00:15:21.919 Casie Aviles: Yeah, I’m not sure, but let me check Clockify, because I did push… I did submit the PR on that.
140 00:15:23.490 ⇒ 00:15:27.009 Casie Aviles: But linear should be available. Let me check right now.
141 00:15:27.700 ⇒ 00:15:29.489 Casie Aviles: Oh yeah, Clockify is also here.
142 00:15:29.830 ⇒ 00:15:30.640 Amber Lin: Okay.
143 00:15:30.750 ⇒ 00:15:33.099 Amber Lin: So, let me see….
144 00:15:33.900 ⇒ 00:15:35.240 Casie Aviles: Yeah, we have both now.
145 00:15:35.630 ⇒ 00:15:40.110 Amber Lin: Okay, awesome. … Alright.
146 00:15:59.300 ⇒ 00:16:04.390 Amber Lin: And it’s… and all the links are available in tickets, right?
147 00:16:08.960 ⇒ 00:16:11.920 Casie Aviles: I’ll just link it, I’ll link the one for Clockify.
148 00:16:12.160 ⇒ 00:16:13.310 Amber Lin: Okay, awesome.
149 00:16:23.100 ⇒ 00:16:24.590 Amber Lin: Ticket for myself.
150 00:16:25.980 ⇒ 00:16:26.910 Amber Lin: Alright.
151 00:16:29.970 ⇒ 00:16:33.890 Amber Lin: Okay, one last thing… …
152 00:16:34.630 ⇒ 00:16:47.179 Amber Lin: Oh, Wish, on the productivity dashboard, is there any modeling tasks that need to get done? Or, Casey, did you notice any modeling needs that… when you were creating the basic dashboards?
153 00:16:50.390 ⇒ 00:16:55.959 Casie Aviles: I mean, I honestly just, … AI had it AI-generated, so….
154 00:16:55.960 ⇒ 00:16:56.490 Amber Lin: Hmm.
155 00:16:58.580 ⇒ 00:17:03.200 Casie Aviles: the AI basically did the modeling, I just double-checked if it was correct, so….
156 00:17:03.200 ⇒ 00:17:08.830 Amber Lin: Okay, awesome, okay. I’ll see what we find after… Yeah, so….
157 00:17:08.839 ⇒ 00:17:10.399 Awaish Kumar: Basically, that’s…
158 00:17:10.629 ⇒ 00:17:23.079 Awaish Kumar: that’s for us to build it, like, Pastev has some tasks, which is, like, for the modeling work, right? So, right now, these are just basic dashboards, which gives us some…
159 00:17:23.199 ⇒ 00:17:26.139 Awaish Kumar: Visibility on individual platforms.
160 00:17:26.309 ⇒ 00:17:33.959 Awaish Kumar: But, yeah, like, the tasks for Vashtiv are more like combining these sources together.
161 00:17:34.550 ⇒ 00:17:39.620 Awaish Kumar: going to give us productivity-related you know, metrics.
162 00:17:39.860 ⇒ 00:17:40.505 Amber Lin: Mmm….
163 00:17:41.430 ⇒ 00:17:47.559 Awaish Kumar: So, like, clockify combined with linear, which will give us, like, how many story points assigned this week.
164 00:17:48.180 ⇒ 00:17:50.990 Awaish Kumar: less than the hours long. Simply cut.
165 00:17:53.920 ⇒ 00:17:58.450 Awaish Kumar: So, yeah, for that, we need modeling, and we have already
166 00:17:58.670 ⇒ 00:18:05.029 Awaish Kumar: assigned some tickets to Ashley, so… I think he’s off two days, but when he’s back, maybe…
167 00:18:05.200 ⇒ 00:18:06.459 Awaish Kumar: He can look at it.
168 00:18:07.040 ⇒ 00:18:14.400 Amber Lin: Okay, so the next one, at least the most immediate one, would be combining linear and clockified data.
169 00:18:15.810 ⇒ 00:18:22.460 Awaish Kumar: Yeah. Not just two, like, all three, like… Premier Fire and Operating.
170 00:18:22.760 ⇒ 00:18:29.220 Amber Lin: Okay, I’m gonna change this ticket to modeling… Combine.
171 00:18:29.590 ⇒ 00:18:32.250 Amber Lin: The near occupied.
172 00:18:32.890 ⇒ 00:18:38.230 Amber Lin: And… author or anything else.
173 00:18:40.150 ⇒ 00:18:49.759 Amber Lin: Okay. Do we have the financial information somewhere of the cost and revenue of different things?
174 00:18:50.810 ⇒ 00:18:54.639 Awaish Kumar: For each client, the tools we use, and the cost we…
175 00:18:55.070 ⇒ 00:18:58.309 Awaish Kumar: Cost incurred is basically… is available in the sheets.
176 00:18:59.980 ⇒ 00:19:01.520 Awaish Kumar: Okay.
177 00:19:01.520 ⇒ 00:19:02.210 Amber Lin: Okay.
178 00:19:03.710 ⇒ 00:19:08.550 Amber Lin: Daisy, do you think that’s also something we can add to…
179 00:19:09.040 ⇒ 00:19:12.470 Amber Lin: You can do in real, or is that something that needs modeling?
180 00:19:14.460 ⇒ 00:19:16.000 Awaish Kumar: Yeah, and we…
181 00:19:16.870 ⇒ 00:19:24.409 Awaish Kumar: We might need to put that in, maybe, in the model, so it will simplify the dashboarding work.
182 00:19:24.950 ⇒ 00:19:32.660 Amber Lin: Okay, so… in… Add financial data to the model.
183 00:19:32.910 ⇒ 00:19:37.780 Amber Lin: In turn… including her… her client.
184 00:19:38.040 ⇒ 00:19:42.760 Amber Lin: … Costs… Okay.
185 00:19:44.440 ⇒ 00:19:50.269 Amber Lin: Rates, … Person, and then tool main boss.
186 00:19:56.560 ⇒ 00:20:01.570 Awaish Kumar: So, like, are you good with the plan for Insomnia this week?
187 00:20:03.180 ⇒ 00:20:10.650 Amber Lin: … What are you referring to when you say a plan? Right now, we have….
188 00:20:11.130 ⇒ 00:20:14.400 Awaish Kumar: I mean… Does that mean, like, …
189 00:20:14.650 ⇒ 00:20:19.669 Awaish Kumar: Like, at the end of each week, what tickets we want to be completed.
190 00:20:21.110 ⇒ 00:20:23.770 Amber Lin: Well, we want to finish automating.
191 00:20:24.160 ⇒ 00:20:31.079 Amber Lin: Google Ads, Today or tomorrow, and then we want to get DoorDash done by the end of this week.
192 00:20:31.280 ⇒ 00:20:36.300 Amber Lin: And depending if we get access to Uber, that’s something we can start on as well.
193 00:20:38.520 ⇒ 00:20:39.960 Awaish Kumar: Okay.
194 00:20:41.640 ⇒ 00:20:49.989 Amber Lin: I can change this to… Casey, when do you think you can get the Google Ads stuff done with Polyatomic?
195 00:20:51.560 ⇒ 00:20:56.989 Casie Aviles: If it’s the priority, then I can work on it today, definitely.
196 00:20:58.270 ⇒ 00:21:01.959 Casie Aviles: But then if I have, like, other priorities with other clients, or….
197 00:21:02.310 ⇒ 00:21:02.920 Amber Lin: Hmm.
198 00:21:02.920 ⇒ 00:21:03.520 Casie Aviles: Or urgent.
199 00:21:03.520 ⇒ 00:21:05.079 Amber Lin: Are you working for?
200 00:21:05.760 ⇒ 00:21:13.310 Casie Aviles: Well, no, I mean, I mean ABC, yeah, yeah, because there’s, like, leftover triage stuff that I haven’t, you know, closed out.
201 00:21:14.290 ⇒ 00:21:20.680 Casie Aviles: And I think, yeah, I’m just wondering if I, like, I need to give some time there as well, because I’ve been…
202 00:21:21.570 ⇒ 00:21:25.700 Casie Aviles: doing too much on insomnia, I believe, so… I see, okay.
203 00:21:25.700 ⇒ 00:21:33.129 Amber Lin: I forgot to give some love to ABC. Okay, we’ll look at ABC together. I think there’s some triage…
204 00:21:33.400 ⇒ 00:21:45.660 Amber Lin: That needs to be done. I can see if I can help with this. I’m also gonna ask Janice to start helping us triage. This is a little hard… a lot for us to do. I think on…
205 00:21:46.230 ⇒ 00:21:54.659 Amber Lin: the ABC side, mainly triage tickets, and then I think we need to… I wanna check on…
206 00:21:55.080 ⇒ 00:22:01.549 Amber Lin: I’ll send a few tickets in the channel to check it… check on it, haven’t had time to look through and think about it.
207 00:22:01.660 ⇒ 00:22:02.950 Casie Aviles: Okay. ….
208 00:22:03.350 ⇒ 00:22:10.360 Amber Lin: From what I remember, it’s the cancellations of how it returns the exact words.
209 00:22:10.360 ⇒ 00:22:13.639 Casie Aviles: Yes, yes, I have to… I have to finish that.
210 00:22:14.180 ⇒ 00:22:23.509 Amber Lin: Hmm. And then the… … the… Inspector sheet…
211 00:22:24.610 ⇒ 00:22:30.840 Amber Lin: And, skills and zips, because I think the skills and zips are still hard-coded.
212 00:22:30.840 ⇒ 00:22:47.590 Mustafa Raja: Yep, yep, the skills and chip, skills and zips is still hard-coded. Yeah. Although I did, for the, for the sheet that had duplicate, CSRs, I did, did remove all the duplication.
213 00:22:47.840 ⇒ 00:22:53.100 Mustafa Raja: Made sure that, everyone comes in only once in the sheet.
214 00:22:53.570 ⇒ 00:22:57.129 Amber Lin: Okay, is there a way we can…
215 00:22:57.350 ⇒ 00:23:07.679 Amber Lin: So, you know we have the service areas, the inspectors, the skills and zips, they’re all based on zip codes. Could we create a database?
216 00:23:08.400 ⇒ 00:23:10.060 Amber Lin: Based on that….
217 00:23:10.060 ⇒ 00:23:12.860 Mustafa Raja: meaning a table in Superbase.
218 00:23:13.940 ⇒ 00:23:14.860 Amber Lin: …
219 00:23:15.610 ⇒ 00:23:28.499 Amber Lin: I don’t know what tool we will decide to use, but say, I think the primary key would be the zip code, and then, like, there will be different services, and under that we’ll have, like, oh, this is a technician, and that’s the inspector.
220 00:23:28.500 ⇒ 00:23:31.610 Mustafa Raja: Yeah, I think we should be able to do that, right, Casey?
221 00:23:32.890 ⇒ 00:23:34.259 Casie Aviles: I’m sorry, what was that?
222 00:23:34.590 ⇒ 00:23:35.070 Casie Aviles: Yeah.
223 00:23:35.070 ⇒ 00:23:42.489 Mustafa Raja: Sorry, sorry, sorry. So the goal, so the goal would be to, have zip code as, as a primary key.
224 00:23:42.900 ⇒ 00:23:53.219 Mustafa Raja: And have the skills and zips sheets, and the inspector sheet thing as, as displayed in the table.
225 00:23:55.130 ⇒ 00:23:59.789 Casie Aviles: Yeah, yeah, I mean, we could, we could have, like, we could use the zips as the….
226 00:23:59.790 ⇒ 00:24:03.690 Mustafa Raja: But then how are we updating it then, though?
227 00:24:04.070 ⇒ 00:24:05.669 Mustafa Raja: How are we updating the.
228 00:24:05.670 ⇒ 00:24:06.609 Casie Aviles: Inspector sheet?
229 00:24:06.610 ⇒ 00:24:13.589 Mustafa Raja: Yeah, if we… if we put it in a database, the CSRs, they wouldn’t be able to update it, no?
230 00:24:13.980 ⇒ 00:24:22.199 Casie Aviles: Oh, yeah, yeah, you’re right, you’re right. They wouldn’t be able to update that. We would be… we would be the one responsible updating that. That’s the only….
231 00:24:23.080 ⇒ 00:24:24.010 Amber Lin: leave them.
232 00:24:24.010 ⇒ 00:24:25.230 Mustafa Raja: it’s hard-coded.
233 00:24:25.540 ⇒ 00:24:37.990 Amber Lin: Could we then create, say, for example, a Google Form that, asks them what changes should be made, and then we either append or replace the cell in our database?
234 00:24:38.430 ⇒ 00:24:39.970 Mustafa Raja: Where this could be looped into.
235 00:24:40.860 ⇒ 00:24:41.570 Amber Lin: Okay.
236 00:24:42.100 ⇒ 00:24:59.160 Mustafa Raja: I’m sure that we can… I’m sure we can, add new rules. It’s the pen that we need to look into if we can fetch the data, and present it in a… in a Google form or not. It’s about presenting in a Google Form, if we can.
237 00:24:59.160 ⇒ 00:25:01.280 Amber Lin: Why do we need to present it in a Google Form?
238 00:25:01.280 ⇒ 00:25:10.070 Mustafa Raja: Meaning if they want to update a zip code, they would enter the zip code and we’ll fetch the data for them, and present them in the Google form, no?
239 00:25:10.870 ⇒ 00:25:28.219 Amber Lin: I was thinking that we don’t have to show what it is, because they can ask Andy to see what… what it is, and then they will say, oh, we have this new… usually when they send updates, they’re like, oh, we have this new inspector who’s now able to do
240 00:25:28.220 ⇒ 00:25:33.000 Amber Lin: service for these 20 zips. Please add him.
241 00:25:33.030 ⇒ 00:25:38.760 Amber Lin: And then we add him. So, usually it’s adding a name or removing a name in a cell.
242 00:25:38.760 ⇒ 00:25:46.960 Mustafa Raja: So, so it’s always going to be, this new person, works in this zip in this service.
243 00:25:47.600 ⇒ 00:25:48.560 Amber Lin: …
244 00:25:49.740 ⇒ 00:25:59.980 Amber Lin: I guess you can put it like that, or it could be this person now also services these zips, or this person no longer services these zip codes.
245 00:26:02.300 ⇒ 00:26:07.260 Mustafa Raja: Hmm… But we have a lot of services.
246 00:26:08.600 ⇒ 00:26:10.090 Amber Lin: Yes, that is true.
247 00:26:10.760 ⇒ 00:26:12.090 Mustafa Raja: Yeah, yeah, this could work.
248 00:26:13.770 ⇒ 00:26:14.610 Mustafa Raja: Yeah.
249 00:26:14.610 ⇒ 00:26:15.150 Amber Lin: Okay.
250 00:26:15.320 ⇒ 00:26:16.560 Amber Lin: Okay.
251 00:26:17.600 ⇒ 00:26:18.360 Amber Lin: Alright.
252 00:26:18.830 ⇒ 00:26:27.479 Amber Lin: So, I think we have two things. One is to create that database, and two is to create the form that
253 00:26:27.790 ⇒ 00:26:29.609 Amber Lin: Helps update it.
254 00:26:30.000 ⇒ 00:26:30.650 Amber Lin: ….
255 00:26:30.690 ⇒ 00:26:37.640 Casie Aviles: Hmm… So, where are we going, we’re going to for, … basically drop… There’s the sheets.
256 00:26:37.830 ⇒ 00:26:40.130 Casie Aviles: the spreadsheets on Google?
257 00:26:42.090 ⇒ 00:26:43.090 Casie Aviles: Or no.
258 00:26:44.940 ⇒ 00:26:47.280 Amber Lin: That’s my understanding.
259 00:26:48.290 ⇒ 00:26:52.600 Casie Aviles: I think it would still help if they could see it, because I…
260 00:26:53.020 ⇒ 00:27:01.230 Casie Aviles: Yeah, like, if they could still have, like, some… ownership over… Like, a spreadsheet.
261 00:27:01.600 ⇒ 00:27:06.980 Casie Aviles: I think it might be difficult to sync updates just via Google Form.
262 00:27:09.110 ⇒ 00:27:12.629 Amber Lin: I don’t know, those are just some of my thoughts, like….
263 00:27:13.010 ⇒ 00:27:15.450 Casie Aviles: Because it’s, like, tabular data, and…
264 00:27:15.680 ⇒ 00:27:18.260 Casie Aviles: Like, how are they going to submit the…
265 00:27:18.740 ⇒ 00:27:24.819 Casie Aviles: the updates to us, like, will they type it somehow, or… and then we have to decipher that, or…
266 00:27:26.680 ⇒ 00:27:33.370 Casie Aviles: Yeah, I’m thinking right now, it’s a bit… it’s a bit hard for them to update it.
267 00:27:33.370 ⇒ 00:27:34.420 Amber Lin: …
268 00:27:34.850 ⇒ 00:27:52.949 Amber Lin: Anyways, right now they have to type… they search for zip codes manually and update it by person. And usually what happens is that the service manager submits an update, and then given Denise goes into that sheet and looks at it. So it’s… they’re… they’re all.
269 00:27:52.950 ⇒ 00:27:53.470 Casie Aviles: Also….
270 00:27:53.470 ⇒ 00:28:01.089 Amber Lin: the request from the service managers, and what they want is actually so that they don’t have to do the intermediate step.
271 00:28:02.100 ⇒ 00:28:06.420 Casie Aviles: Okay, so it’s going to be from their service manager directly to us?
272 00:28:07.310 ⇒ 00:28:08.560 Amber Lin: Yeah, I think so.
273 00:28:08.700 ⇒ 00:28:13.869 Amber Lin: Directly to the spreadsheet, and if we can automate it, I think it’ll make our lives easier.
274 00:28:14.310 ⇒ 00:28:15.509 Casie Aviles: Okay, okay.
275 00:28:15.660 ⇒ 00:28:17.000 Amber Lin: Yeah, that makes sense.
276 00:28:17.430 ⇒ 00:28:26.820 Amber Lin: Yeah, and with that, I don’t think we can autom… it’s… it could be easier to automate it towards a database, rather than automating it to this spreadsheet.
277 00:28:30.960 ⇒ 00:28:31.570 Casie Aviles: Okay.
278 00:28:34.420 ⇒ 00:28:43.450 Amber Lin: … Can I assign a spike ticket, for the database and then for the automations?
279 00:28:45.200 ⇒ 00:28:46.490 Casie Aviles: Yeah, yeah.
280 00:28:47.690 ⇒ 00:28:55.280 Casie Aviles: So, what… what you’re think… sorry, I was just gonna ask, what you’re thinking, Mustaf, as we do, like, a querying?
281 00:28:55.420 ⇒ 00:28:57.849 Casie Aviles: Agent over the database, right?
282 00:28:59.470 ⇒ 00:29:06.829 Mustafa Raja: I don’t think we would need, an agent if it’s only a number of services per zip.
283 00:29:07.070 ⇒ 00:29:10.080 Mustafa Raja: We can just… Can’t we just lay out…
284 00:29:10.620 ⇒ 00:29:13.129 Mustafa Raja: Lay it out in the Google form.
285 00:29:13.750 ⇒ 00:29:21.810 Casie Aviles: Oh, okay, okay, okay. Yeah, sorry, I was thinking. The thing would be, how are we removing a person from the zip door?
286 00:29:22.720 ⇒ 00:29:24.810 Mustafa Raja: From a service.
287 00:29:25.450 ⇒ 00:29:26.990 Mustafa Raja: This way, we could add….
288 00:29:29.510 ⇒ 00:29:30.340 Amber Lin: Mmm….
289 00:29:30.340 ⇒ 00:29:32.399 Mustafa Raja: Yeah, the spike should cover this, though.
290 00:29:32.650 ⇒ 00:29:33.590 Casie Aviles: Yeah, yeah, okay.
291 00:29:33.590 ⇒ 00:29:35.569 Mustafa Raja: That should cover our questions.
292 00:29:36.270 ⇒ 00:29:38.230 Amber Lin: Okay. So, ….
293 00:29:38.230 ⇒ 00:29:46.190 Mustafa Raja: So we need to… we need to update the zip, add a new zip, and remove people from existing zips, right?
294 00:29:47.650 ⇒ 00:29:51.390 Amber Lin: Yeah, Ed… Remove…
295 00:29:55.220 ⇒ 00:29:59.450 Amber Lin: Wait, what’s the third one? Advert someone, remove someone.
296 00:30:00.490 ⇒ 00:30:05.900 Mustafa Raja: Yeah, add new zips, and update zips, I guess we can say. Append or update.
297 00:30:06.910 ⇒ 00:30:07.620 Amber Lin: Okay.
298 00:30:08.740 ⇒ 00:30:09.840 Amber Lin: Alright.
299 00:30:10.110 ⇒ 00:30:11.340 Amber Lin: So….
300 00:30:13.050 ⇒ 00:30:18.170 Mustafa Raja: And we have set number of services, … per zip, right?
301 00:30:19.700 ⇒ 00:30:20.890 Amber Lin: What’s that?
302 00:30:21.120 ⇒ 00:30:23.750 Mustafa Raja: Meaning that we have this, this, this, this…
303 00:30:23.960 ⇒ 00:30:25.899 Mustafa Raja: all of the services per zip.
304 00:30:27.270 ⇒ 00:30:29.730 Amber Lin: Yes, yes, we should.
305 00:30:29.890 ⇒ 00:30:33.859 Amber Lin: I think we still need to ex…
306 00:30:34.460 ⇒ 00:30:45.289 Amber Lin: expand it, but pretty much… we can clean it up and verify with them, but we have the skills…
307 00:30:45.770 ⇒ 00:30:51.559 Amber Lin: Dear. We have this, which contains all the zip codes, and if they service or not.
308 00:30:52.010 ⇒ 00:31:01.309 Amber Lin: … And then… We have the inspector… oh gosh, and the inspector sheet has the different…
309 00:31:01.650 ⇒ 00:31:06.030 Amber Lin: Services, if they are serviced, and who is an instructor.
310 00:31:08.640 ⇒ 00:31:09.410 Amber Lin: Yeah.
311 00:31:10.180 ⇒ 00:31:11.080 Amber Lin: Okay.
312 00:31:11.850 ⇒ 00:31:16.139 Amber Lin: Who’s gonna do this spike ticket?
313 00:31:20.870 ⇒ 00:31:23.930 Casie Aviles: Yeah, yeah, just assign it to me for now.
314 00:31:31.740 ⇒ 00:31:33.559 Amber Lin: How long would this spike take?
315 00:31:35.690 ⇒ 00:31:40.920 Casie Aviles: I would… I typically do spikes, within 1-2 hour ranges.
316 00:31:41.330 ⇒ 00:31:41.860 Amber Lin: Oh.
317 00:31:42.730 ⇒ 00:31:44.560 Amber Lin: Okay, so I’ll set one point.
318 00:31:44.850 ⇒ 00:31:45.790 Amber Lin: With that.
319 00:31:47.580 ⇒ 00:31:51.949 Amber Lin: Alright, and then I guess we need to decide what database we’re using.
320 00:31:52.530 ⇒ 00:31:53.120 Amber Lin: Creatures.
321 00:31:53.120 ⇒ 00:31:58.139 Mustafa Raja: So you’re using… I guess we’re using Googlebase for everything, right, Casey?
322 00:31:58.140 ⇒ 00:32:02.660 Casie Aviles: Yeah, yeah, we don’t want… I mean, we don’t have any plans to use something else.
323 00:32:02.800 ⇒ 00:32:03.450 Casie Aviles: Right now?
324 00:32:03.720 ⇒ 00:32:04.600 Mustafa Raja: Yeah.
325 00:32:04.930 ⇒ 00:32:07.460 Mustafa Raja: Yeah, let’s just go with supervision, I guess.
326 00:32:09.660 ⇒ 00:32:14.250 Amber Lin: I think for the triage tickets, …
327 00:32:14.480 ⇒ 00:32:19.649 Amber Lin: I think most of them doesn’t have to be assigned to you guys, I’m just gonna go through and see.
328 00:32:19.810 ⇒ 00:32:25.209 Amber Lin: Which ones need to be assigned to us, and then we’ll… we’ll take a look.
329 00:32:25.860 ⇒ 00:32:29.960 Amber Lin: But… prioritize the…
330 00:32:30.470 ⇒ 00:32:36.909 Amber Lin: Insomnia, and then… it’s because they’re both spikes, I think. Let’s do the spikes so we can report on what we’re gonna do.
331 00:32:38.050 ⇒ 00:32:38.760 Casie Aviles: Okay.
332 00:32:39.140 ⇒ 00:32:40.640 Amber Lin: Alright, thanks guys.
333 00:32:41.270 ⇒ 00:32:41.620 Mustafa Raja: True.
334 00:32:42.140 ⇒ 00:32:43.979 Amber Lin: Bye, bye-bye. Bye.
335 00:32:43.980 ⇒ 00:32:44.540 Casie Aviles: U.