Meeting Title: Scorecard Automation Process Check-in Date: 2025-09-17 Meeting participants: Awaish Kumar, Casie Aviles


WEBVTT

1 00:00:12.860 00:00:15.000 Casie Aviles: Oh, can you hear me, Aliche?

2 00:00:21.590 00:00:22.910 Awaish Kumar: Hello, are you?

3 00:00:23.200 00:00:24.310 Awaish Kumar: You hear me, though?

4 00:00:24.720 00:00:26.620 Casie Aviles: Yeah, I can hear you now. Can you hear me?

5 00:00:27.310 00:00:33.460 Awaish Kumar: Yeah, yeah, so, I just wanted to discuss about the scorecard thing. Wow.

6 00:00:34.290 00:00:39.379 Awaish Kumar: So, are you, like, first… okay, first of all, are you working on,

7 00:00:39.740 00:00:43.670 Awaish Kumar: only scorecard thing, or insomnia, or other tickets as well.

8 00:00:45.490 00:00:49.730 Casie Aviles: I’m working on… Like, I also have other tickets.

9 00:00:50.190 00:00:55.900 Casie Aviles: So, daily, I’m doing the scorecard, making sure that it’s up to date, and…

10 00:00:56.590 00:01:05.700 Casie Aviles: That involves, like, partially automated process and also partially manual. So, some of the open tickets that I have…

11 00:01:05.840 00:01:08.769 Casie Aviles: It’s because we have some blockers on…

12 00:01:09.060 00:01:10.579 Casie Aviles: So there are two things that…

13 00:01:10.580 00:01:13.960 Awaish Kumar: I’m just… I just want to understand, for example, for the last week.

14 00:01:14.270 00:01:21.520 Awaish Kumar: I see that, maybe you… you have logged more than… around 15 hours?

15 00:01:21.840 00:01:23.800 Awaish Kumar: For… for insomnia.

16 00:01:24.030 00:01:32.109 Awaish Kumar: I just want to understand, is that only for… scorecard, or is that for… other tickets.

17 00:01:32.880 00:01:37.080 Casie Aviles: Yeah, it’s both. So it’s scorecard plus other tickets.

18 00:01:37.570 00:01:50.230 Awaish Kumar: Okay, so… I want to understand now that how much… We are spending on…

19 00:01:50.880 00:01:53.299 Awaish Kumar: Scorecard, every, like, one day.

20 00:01:54.830 00:01:58.209 Casie Aviles: Yeah, so for the scorecard, I’m spending around,

21 00:01:58.430 00:02:03.329 Casie Aviles: 1 hour to two hours sometimes, when I have to do the validation myself.

22 00:02:03.610 00:02:07.450 Casie Aviles: So… 1R2… Kind of.

23 00:02:08.229 00:02:12.729 Casie Aviles: So after our automation… so that means after our automation begins.

24 00:02:13.470 00:02:20.280 Awaish Kumar: Where time has… has… have not reduced, right? Because Robert said.

25 00:02:20.650 00:02:24.949 Awaish Kumar: He was also spending 2 hours, around 2 hours before.

26 00:02:25.200 00:02:29.759 Awaish Kumar: And if that is the case now as well, if we are…

27 00:02:30.020 00:02:34.420 Awaish Kumar: We end up spending 2 hours every day on this.

28 00:02:35.220 00:02:39.590 Awaish Kumar: It’s a long time, right? So…

29 00:02:39.590 00:02:40.420 Casie Aviles: Yeah.

30 00:02:41.340 00:02:56.209 Awaish Kumar: Like, after automation, it should be, like, it should be… I know it’s manual, but after the automation part, it should be, like, 30… like, ideally, it should be, like, 30 minutes, so you have everything in one sheet. You just copy the values and put it in another sheet.

31 00:02:56.470 00:03:02.730 Awaish Kumar: Right? Because you can’t write in Microsoft Sheets, maybe Excels. Maybe we can write into Google Sheets.

32 00:03:02.730 00:03:03.270 Casie Aviles: You know what I mean?

33 00:03:03.270 00:03:12.960 Awaish Kumar: That’s a form that you can just copy-paste from Google Sheet and put it in the required sales. Hence, it should, like, only 4, 5, 6,

34 00:03:13.520 00:03:20.660 Awaish Kumar: platforms. If there are only 5, 6, 7, 8 sales, then it should take, like, maybe 30 minutes. And…

35 00:03:20.830 00:03:31.579 Awaish Kumar: That’s the ideal situation. I wanted to, like, go even, like, less than 30 minutes, but max at 30 minutes. Sure, exceed that.

36 00:03:32.280 00:03:34.340 Awaish Kumar: So, currently it’s not happening.

37 00:03:34.550 00:03:42.079 Awaish Kumar: So… we want to, like, see why it’s not happening, because we worked on, like, Google Ads.

38 00:03:42.190 00:03:47.559 Awaish Kumar: seems to be automated from what I suggested, like, it goes from,

39 00:03:48.570 00:03:51.550 Awaish Kumar: polyatomic to, finally, to some Google Sheet.

40 00:03:51.990 00:03:54.540 Awaish Kumar: But then, why it takes longer?

41 00:03:55.400 00:03:56.480 Awaish Kumar: Come on.

42 00:03:58.990 00:04:05.409 Casie Aviles: I’m also, like, spending some time to kind of manually validate it, so that’s what…

43 00:04:05.560 00:04:08.560 Casie Aviles: It’s also taking a longer time.

44 00:04:08.730 00:04:10.029 Awaish Kumar: Sorry, what are you doing?

45 00:04:10.930 00:04:12.759 Casie Aviles: Can you hear me? Sorry?

46 00:04:13.450 00:04:15.910 Awaish Kumar: I can hear you, but I just missed what you said, like…

47 00:04:16.529 00:04:25.489 Casie Aviles: Yeah, so… for the… for actually filling it out, I would spend around 1 hour, right? So…

48 00:04:25.809 00:04:27.639 Casie Aviles: To update, like, the sheets.

49 00:04:27.929 00:04:39.479 Casie Aviles: And then I would also, after that, I would also kind of QA it myself. So I would manually go through all of the channels, and that can take some time.

50 00:04:39.799 00:04:40.799 Casie Aviles: So…

51 00:04:40.800 00:04:44.730 Awaish Kumar: That’s… But is that necessary? Because… we…

52 00:04:44.940 00:04:50.449 Awaish Kumar: Made the automation, because we don’t want… didn’t want it to go into these platforms.

53 00:04:50.820 00:04:52.470 Awaish Kumar: If you are electric.

54 00:04:52.620 00:04:58.620 Awaish Kumar: At the… every day, if you are logging in and going into these platforms, and

55 00:04:58.820 00:05:06.799 Awaish Kumar: then it’s just like… like, we are doing double efforts, right? We are… on the one hand, we are automating some of the process.

56 00:05:06.950 00:05:15.559 Awaish Kumar: And on the other end, once it is filled out, you are again going into those platforms and actually seeing those same values, right?

57 00:05:15.720 00:05:16.170 Casie Aviles: Yes.

58 00:05:16.170 00:05:18.700 Awaish Kumar: So, basically, it is kind of,

59 00:05:19.130 00:05:22.570 Awaish Kumar: Like, duplicate, duplicate effort on the same thing.

60 00:05:25.060 00:05:26.070 Casie Aviles: That’s true.

61 00:05:26.860 00:05:33.040 Awaish Kumar: So, like, QA should be, like, once in a while, right? So maybe, like, once… once…

62 00:05:33.420 00:05:41.459 Awaish Kumar: we are confident that whatever values you are filling in, like, the test comes… so one QA happens when we are done with development.

63 00:05:41.620 00:05:53.850 Awaish Kumar: So you done… we done automation, right? Then we adopt the process that, okay, the values come in some Google Sheet, how will copy-paste, then you QA’d it for, like, one, two, three days.

64 00:05:53.850 00:06:02.490 Awaish Kumar: And, it looks good. Now, we won’t do review, like, the QA every day, right? We are going to say, okay, it works.

65 00:06:02.540 00:06:09.100 Awaish Kumar: Let’s QA once in a while, maybe once in a week, or once in two weeks, things like that.

66 00:06:10.280 00:06:11.120 Casie Aviles: Okay.

67 00:06:11.510 00:06:13.190 Casie Aviles: Yeah, that makes sense.

68 00:06:13.190 00:06:15.150 Awaish Kumar: If you are confident that

69 00:06:15.380 00:06:31.859 Awaish Kumar: our automation is working, the values which are coming in are always, or, like, majority of the time are okay, after your QA, like, you have been queuing it for some time now, so you know that,

70 00:06:32.590 00:06:39.749 Awaish Kumar: when you fill in the values, and then QA. So, now you… are you confident that our values

71 00:06:39.890 00:06:45.150 Awaish Kumar: are correct, or you have to… once… when you QA, you identify a lot of issues.

72 00:06:46.660 00:06:52.880 Casie Aviles: Yeah, so… Let me explain this. So, okay, so for Braze.

73 00:06:53.140 00:06:55.930 Casie Aviles: the values are… I am,

74 00:06:56.310 00:07:01.440 Casie Aviles: confident with Braze. There is just one issue there that I have.

75 00:07:02.640 00:07:05.220 Casie Aviles: Which is… I escalated to support.

76 00:07:05.650 00:07:12.430 Casie Aviles: And for the… for Google Ads, that’s also… Working fine.

77 00:07:12.980 00:07:16.300 Casie Aviles: My issues are with Uber and…

78 00:07:16.570 00:07:26.240 Casie Aviles: DoorDash, because the automation that we, implemented there is using, like, web scraping, right? So.

79 00:07:26.370 00:07:37.429 Casie Aviles: This is something we… what do you call this? We talked about in… when I was building it out, where it might… it might be a bit brittle, so there are…

80 00:07:37.810 00:07:39.230 Awaish Kumar: No, sweet, I…

81 00:07:39.620 00:07:50.599 Awaish Kumar: why is… like, I know… I understand the automation part, so basically, we… we are automating the user workflow. So I, as a user.

82 00:07:50.910 00:07:54.009 Awaish Kumar: Programmatically, what I do, I will open a browser.

83 00:07:54.780 00:07:59.399 Awaish Kumar: Open that link, and then fill in the username, password, and login.

84 00:07:59.760 00:08:05.509 Awaish Kumar: and then select that sale and fill in, right? So that should not fail,

85 00:08:06.040 00:08:20.800 Awaish Kumar: always, right? It can feel like, for example, the text box… text box you were selecting for the value basically shifted to some… like, the ID was changed, or the name of that tag is changed.

86 00:08:21.200 00:08:29.140 Awaish Kumar: That can break, but… But does that break, like, really often, like, every day, or what happens?

87 00:08:30.510 00:08:38.860 Casie Aviles: No, no, it’s not every day, but it does happen… it’s been timing out, so it’s happened… we’re getting timeouts.

88 00:08:39.549 00:08:41.049 Awaish Kumar: That’s a separate issue, like…

89 00:08:41.700 00:08:42.159 Casie Aviles: Yeah.

90 00:08:42.519 00:08:48.819 Awaish Kumar: That’s our scripting issue, right? Why the timeout? Why can’t we open the new session after

91 00:08:49.859 00:08:53.169 Awaish Kumar: Like, when I, as a user, open a browser.

92 00:08:53.669 00:09:01.399 Awaish Kumar: Like, the MySession stays for quite a few times, right? It does not just… log out. There’s, like, very…

93 00:09:01.949 00:09:09.779 Awaish Kumar: frequently, and that… why is that time out? Like, it does not time out for me, like, for any… if I do anything on the use of

94 00:09:09.949 00:09:16.679 Awaish Kumar: I means you or anyone else, like, when a human uses a browser and goes into DoorDash.

95 00:09:16.979 00:09:21.389 Awaish Kumar: Does… does we get time out? If no, then it should not…

96 00:09:22.649 00:09:25.789 Awaish Kumar: Come in the… in the browser, as well.

97 00:09:29.640 00:09:33.540 Casie Aviles: Yeah, so… I guess what I can do there is to just…

98 00:09:33.540 00:09:39.860 Awaish Kumar: Like, there are a few things, like, either, like, is that timeout on the session, or what… what kind of timeout is that?

99 00:09:42.750 00:09:50.530 Casie Aviles: Yeah, it’s waiting for the page to load, and when it doesn’t load in the expected time, it’s going to time out.

100 00:09:51.530 00:09:57.600 Awaish Kumar: Okay, so you’re saying that Paige is… Slow to load.

101 00:09:57.990 00:10:04.100 Awaish Kumar: And, and that’s the reason our… Basically, the session types out.

102 00:10:04.710 00:10:07.980 Casie Aviles: Yes, that’s one of the reasons why it times out.

103 00:10:08.450 00:10:17.370 Awaish Kumar: So, like… So when I… when you load it in your browser, does it also take longer to load?

104 00:10:18.830 00:10:20.910 Casie Aviles: of when I do it manually.

105 00:10:21.130 00:10:21.940 Awaish Kumar: Yeah.

106 00:10:22.880 00:10:30.080 Casie Aviles: No, no, it’s not… it’s not going… it’s not slow, but I’m not sure how it works, like, with browser-based, like.

107 00:10:32.890 00:10:36.620 Awaish Kumar: The boundary, unknown pole.

108 00:10:37.050 00:10:44.499 Awaish Kumar: But, like, does browser-based work similar like, Selenium?

109 00:10:45.870 00:10:49.190 Casie Aviles: Yeah, it’s using, what do you call this Playwright.

110 00:10:50.500 00:10:55.959 Awaish Kumar: Yeah, yeah, but the idea is similar, like, it opens a browser, and then…

111 00:10:56.260 00:10:58.680 Awaish Kumar: Hits a URL and then logs in.

112 00:10:59.190 00:11:00.489 Casie Aviles: Hmm, yes, yes.

113 00:11:00.960 00:11:04.020 Awaish Kumar: Because that is, like, is the idea, is it similar like Selenium, right?

114 00:11:04.390 00:11:05.400 Casie Aviles: Yeah, yeah.

115 00:11:05.920 00:11:06.800 Awaish Kumar: Okay.

116 00:11:07.450 00:11:11.350 Awaish Kumar: And in that case, And that is…

117 00:11:11.480 00:11:18.939 Awaish Kumar: And then the, like, in the background, Browser-based is basically using

118 00:11:19.070 00:11:21.850 Awaish Kumar: A browser, right? A real, real browser.

119 00:11:22.130 00:11:23.080 Awaish Kumar: Right?

120 00:11:24.210 00:11:25.720 Awaish Kumar: And boom.

121 00:11:26.780 00:11:32.210 Awaish Kumar: then, in that case, it should not fail. Like, are you using real headers? Like…

122 00:11:33.670 00:11:37.140 Awaish Kumar: Like, the user agent and things like that in the script?

123 00:11:38.780 00:11:43.170 Casie Aviles: Hmm… What I mean, I’m not sure the exact.

124 00:11:43.170 00:11:43.679 Awaish Kumar: Oh, my goodness.

125 00:11:43.680 00:11:44.280 Casie Aviles: I’m using.

126 00:11:44.300 00:11:46.569 Awaish Kumar: Okay, sorry, you are hitting the…

127 00:11:46.760 00:11:53.900 Awaish Kumar: Browser-based… you create, basically, browser-based, instance in a script, like, object.

128 00:11:54.100 00:11:54.650 Casie Aviles: Yes, yes.

129 00:11:54.650 00:11:56.980 Awaish Kumar: And then load it from there, okay.

130 00:11:57.300 00:12:03.350 Awaish Kumar: Yeah, like… I think it should just walk plainly.

131 00:12:04.530 00:12:13.030 Awaish Kumar: Why? What I would suggest, in that case, Is that, maybe that’s…

132 00:12:14.160 00:12:17.370 Awaish Kumar: What, like, you… did you edit the retries for that?

133 00:12:18.800 00:12:21.640 Casie Aviles: Not yet, I’m going to edit them.

134 00:12:21.910 00:12:27.540 Awaish Kumar: So, we can say, if I… if I…

135 00:12:28.140 00:12:30.880 Awaish Kumar: If a script is… if a,

136 00:12:32.020 00:12:40.960 Awaish Kumar: browser-based request is taking longer, and then it fails, right? So… Yeah. So, number one, increase the timeout.

137 00:12:41.310 00:12:44.779 Awaish Kumar: Right? That timeout just… We maybe, like.

138 00:12:45.020 00:12:48.999 Awaish Kumar: In case that I’m out to 5 minutes, basically.

139 00:12:49.690 00:13:03.189 Awaish Kumar: There should be some parameter for that. Increase that timeout, then use a try-accept block, and the accept block, maybe, maybe, like, make it sleep for maybe 1 minute, and then…

140 00:13:03.310 00:13:11.989 Awaish Kumar: Trying to recreate the session, like, like, create the session again, like, don’t, like, close that current session of the browser.

141 00:13:12.160 00:13:16.929 Awaish Kumar: and create a session again, like, it should be in a loop, right?

142 00:13:17.200 00:13:21.050 Awaish Kumar: And in the loop, it should retry it for, like, maybe…

143 00:13:21.450 00:13:27.779 Awaish Kumar: 10 times, and we say, if it succeeds, it just gets out, but if it fails, it will retry.

144 00:13:27.920 00:13:34.450 Awaish Kumar: So, and we will retry it for, like, 10 times. And if it still fails, then… then just fill it.

145 00:13:36.140 00:13:38.370 Casie Aviles: Okay. Yeah, I will…

146 00:13:38.470 00:13:50.300 Awaish Kumar: So, when you are retrying, when you are going for retrying, don’t just, like, hit the URL again, right? Close the session completely, like, close the…

147 00:13:50.990 00:13:56.050 Awaish Kumar: Like, browser-based instance or whatever, and then create this… Excuse me.

148 00:13:56.240 00:13:59.620 Awaish Kumar: the session again, then hit the URL,

149 00:13:59.830 00:14:03.810 Awaish Kumar: Then the login, and then, like, all this stuff, so…

150 00:14:05.950 00:14:06.780 Casie Aviles: Okay.

151 00:14:10.620 00:14:12.110 Casie Aviles: Yeah, I will do that.

152 00:14:12.740 00:14:13.390 Awaish Kumar: Yep.

153 00:14:18.370 00:14:19.520 Casie Aviles: Okay, yeah.

154 00:14:19.830 00:14:22.029 Casie Aviles: Thank you. I will work on it.

155 00:14:22.030 00:14:26.430 Awaish Kumar: And, like, I want that, like, by the end of this week.

156 00:14:26.630 00:14:30.450 Awaish Kumar: We want to ensure that our script works fine.

157 00:14:31.040 00:14:36.099 Awaish Kumar: And, and from the next week, we…

158 00:14:36.680 00:14:41.739 Awaish Kumar: We are spending, like, we are comfortable with our automation, and we…

159 00:14:41.910 00:14:46.120 Awaish Kumar: Just copy-paste the values from our version.

160 00:14:46.260 00:14:56.240 Awaish Kumar: Google Sheets, so it will be just, like, maybe… I take, like, maybe 15 to 13 minutes at max, and then we QA once in a while, or we’ll QA maybe…

161 00:14:57.330 00:15:01.370 Awaish Kumar: I would say that, like, maybe once… Huh.

162 00:15:02.170 00:15:04.030 Awaish Kumar: every Monday on…

163 00:15:04.240 00:15:12.290 Awaish Kumar: every Monday after two weeks, or something like that. We’ll set that cadence. We maybe… initially, we’ll do one week, once in a week, and then we will, like.

164 00:15:12.740 00:15:18.979 Awaish Kumar: If we try… if that works fine, then we will maybe say, once in two weeks, things like that. So we’ll…

165 00:15:19.290 00:15:20.970 Awaish Kumar: Keep that approach.

166 00:15:21.160 00:15:24.670 Awaish Kumar: And, and it’s.

167 00:15:24.670 00:15:25.200 Casie Aviles: Okay.

168 00:15:25.490 00:15:27.230 Awaish Kumar: Meta, hot words.

169 00:15:27.790 00:15:28.290 Awaish Kumar: Okay.

170 00:15:28.290 00:15:30.170 Casie Aviles: Okay, yeah.

171 00:15:31.970 00:15:35.360 Casie Aviles: Okay, thank you. Yeah, I will definitely…

172 00:15:35.770 00:15:38.879 Casie Aviles: Think about the time being spent.

173 00:15:41.830 00:15:45.270 Awaish Kumar: Yeah, so it’s not like… common.

174 00:15:45.420 00:15:46.690 Awaish Kumar: It’s, it’s not…

175 00:15:46.860 00:15:58.120 Awaish Kumar: like, we want to optimize this, so you can work on other things also, for the client, like, we… client is now requesting other stuff as well, and .

176 00:15:58.120 00:15:58.760 Casie Aviles: Yeah…

177 00:15:58.760 00:16:10.620 Awaish Kumar: If we spend, like, so much time in doing this, then we can’t work on other things which they are requesting in the same budget, right? And then.

178 00:16:10.620 00:16:11.970 Casie Aviles: You gotta end up, like, giving sales.

179 00:16:11.970 00:16:14.199 Awaish Kumar: Like, okay, if you are doing same thing.

180 00:16:14.830 00:16:22.010 Awaish Kumar: Like, what, like, you haven’t optimized, you basically just… acquired the…

181 00:16:23.030 00:16:27.599 Awaish Kumar: manual work. So, basically, we want to show them that we have optimized the work.

182 00:16:27.710 00:16:33.030 Awaish Kumar: And, yeah, what they are paying brilliant for is value for money.

183 00:16:35.020 00:16:36.410 Casie Aviles: Yeah, I understand.

184 00:16:38.730 00:16:39.340 Casie Aviles: Okay.

185 00:16:39.340 00:16:40.569 Awaish Kumar: Okay, thank you.

186 00:16:41.290 00:16:49.079 Casie Aviles: Alright, so, if I need any reviews, any questions, can I just tag you as well, if you have… if you’re able to?

187 00:16:50.270 00:16:52.949 Awaish Kumar: Yeah, just… just bring me on Slack.

188 00:16:54.620 00:16:57.779 Casie Aviles: Okay, yeah, I’ll do that. Thank you, Avish.

189 00:16:57.780 00:16:58.490 Awaish Kumar: Yep.