Meeting Title: Working session Date: 2025-06-11 Meeting participants: Caio Velasco, Emily Giant
WEBVTT
1 00:01:00.810 ⇒ 00:01:03.389 Emily Giant: Good morning or bad morning.
2 00:01:04.110 ⇒ 00:01:04.759 Caio Velasco: Yes.
3 00:01:05.910 ⇒ 00:01:06.870 Caio Velasco: How are you?
4 00:01:07.274 ⇒ 00:01:09.700 Emily Giant: I’m good. How about you?
5 00:01:09.940 ⇒ 00:01:11.580 Caio Velasco: I’m good. I’m good. Yes.
6 00:01:12.300 ⇒ 00:01:14.810 Emily Giant: And I mean sorry. Go ahead.
7 00:01:14.950 ⇒ 00:01:16.380 Caio Velasco: Of the Cat Situation.
8 00:01:17.340 ⇒ 00:01:19.039 Emily Giant: The kitten found a new home.
9 00:01:19.350 ⇒ 00:01:27.670 Emily Giant: So down to 2 again. So I don’t think the other cat that’s not ours is going anywhere. He’s just going to be
10 00:01:28.040 ⇒ 00:01:40.710 Emily Giant: chipped and put outside. But good! They’re way more in control than last week. Last week was a mess with the kitten. There was just so so much drama. Do you have any animals.
11 00:01:41.120 ⇒ 00:01:50.040 Caio Velasco: No, I don’t. But I have a friend that has 2 2 cats, and a 3rd appeared. So it’s kind of the same situation, but they’re now back to 2 again. Same thing.
12 00:01:50.040 ⇒ 00:02:03.779 Emily Giant: This is the second time that we’ve had a kitten appear that you can’t send it away. It’s just like a little helpless baby. But then you’re like, Oh, why me? Why, it’s like thousands of dollars
13 00:02:03.940 ⇒ 00:02:12.800 Emily Giant: landing on your stuff that you have to spend, because it’s not just a cute, fuzzy animal. It’s money out of the bank is what it is.
14 00:02:12.800 ⇒ 00:02:13.329 Caio Velasco: Of course.
15 00:02:14.065 ⇒ 00:02:14.800 Emily Giant: Yeah.
16 00:02:14.890 ⇒ 00:02:17.739 Caio Velasco: I feel like that. You always have to take to the vet and.
17 00:02:18.290 ⇒ 00:02:18.640 Emily Giant: Yeah.
18 00:02:18.910 ⇒ 00:02:20.239 Caio Velasco: So many things.
19 00:02:20.870 ⇒ 00:02:34.459 Emily Giant: Yeah, we had to take her to the vet right away because she had a couple of issues. She’s fine now, but like I spent $300 on a cat that I did not ask for that just gone on my front porch, so.
20 00:02:34.990 ⇒ 00:02:35.380 Caio Velasco: There you go!
21 00:02:35.380 ⇒ 00:02:48.610 Emily Giant: I’m like. I’m hoping I don’t do enough charity work. So maybe like that’s my is taking care of stray cats that wind up on my porch, but I really appreciate you sending over this agenda.
22 00:02:48.610 ⇒ 00:02:49.570 Caio Velasco: No problem.
23 00:02:49.570 ⇒ 00:02:56.529 Emily Giant: I think it’s a good. It gives me a good idea of like what you want to still know as opposed to me, trying to like.
24 00:02:56.800 ⇒ 00:03:16.539 Emily Giant: figure out and fill in the blank. Sometimes it’s really hard. When you’ve worked with the data for a long time to to know what people don’t know where the gaps are. So the 1st thing was to go over Alex’s comments. Do you want to share, screen and go over his comments? Or would you like me to whatever.
25 00:03:18.930 ⇒ 00:03:21.860 Caio Velasco: I mean, do you? Do you prefer? And then you already mark or.
26 00:03:22.110 ⇒ 00:03:35.815 Emily Giant: I half the time. I think I’m sharing my screen, and I’m not even sharing my screen. Demotti will tell you. I will talk for an hour, and he’ll be like, Are you sharing your screen? And I’m like, Oh, God, no! I thought I was the whole time so.
27 00:03:36.840 ⇒ 00:03:39.100 Caio Velasco: I think I think you can see my browser right.
28 00:03:39.100 ⇒ 00:03:40.280 Emily Giant: Yes, I can.
29 00:03:40.530 ⇒ 00:03:45.796 Caio Velasco: Okay, cool, you know. Put that you’re up here so it’ll be like also, like this.
30 00:03:46.090 ⇒ 00:03:46.920 Emily Giant: Great.
31 00:03:46.920 ⇒ 00:03:50.060 Caio Velasco: Okay, okay? So
32 00:03:50.210 ⇒ 00:03:55.579 Caio Velasco: yeah. So I saw during the meeting yesterday that Alex was putting a lot of comments. So that’s good.
33 00:03:56.434 ⇒ 00:04:00.070 Caio Velasco: What I noticed is that most things market
34 00:04:00.950 ⇒ 00:04:09.000 Caio Velasco: as depth to be deprecated like with a yes, they they are most of them already inactive. Already post.
35 00:04:09.350 ⇒ 00:04:11.680 Emily Giant: Yeah, we pulled a lot of those off the other day.
36 00:04:11.680 ⇒ 00:04:13.330 Caio Velasco: Yeah, yeah, exactly.
37 00:04:13.840 ⇒ 00:04:27.480 Caio Velasco: And then. Now, it’s just basically going through whatever is left here. And see, we really can duplicate this or not, and then I will go in and I turn everything off. And we we do that email I sent to you, and then we move forward.
38 00:04:28.520 ⇒ 00:04:35.729 Caio Velasco: So the 1st one. So the 1st one was clear. Just deprecate. I am assuming that you agree kind of.
39 00:04:36.240 ⇒ 00:04:39.010 Emily Giant: Yeah, that sounds good.
40 00:04:39.290 ⇒ 00:04:44.020 Caio Velasco: Okay, okay, cool. So this I would just where it boots
41 00:04:45.580 ⇒ 00:04:50.326 Caio Velasco: and do like a big yes, then I will know what I have to do there.
42 00:04:51.060 ⇒ 00:04:54.210 Caio Velasco: and okay, yes, this one.
43 00:04:54.980 ⇒ 00:05:00.280 Caio Velasco: So this has not been updated since 2, 1020, 23 triple check with coach.
44 00:05:00.280 ⇒ 00:05:02.570 Caio Velasco: Okay, I’ll check with coach.
45 00:05:02.710 ⇒ 00:05:05.920 Emily Giant: Yeah, but I’m pretty sure you can turn that off
46 00:05:06.490 ⇒ 00:05:11.489 Emily Giant: if it hasn’t updated it. Just it’s hard to imagine that’s accurate in any way.
47 00:05:12.240 ⇒ 00:05:14.709 Caio Velasco: Okay, so this is also a yes, then.
48 00:05:15.260 ⇒ 00:05:16.829 Emily Giant: I’ll ask him right now, though.
49 00:05:17.126 ⇒ 00:05:17.720 Caio Velasco: Okay. Okay.
50 00:05:19.270 ⇒ 00:05:26.340 Caio Velasco: Yeah. I’ll put image cool.
51 00:05:32.660 ⇒ 00:05:37.540 Caio Velasco: Yes, it’s easier to copy this right.
52 00:05:41.310 ⇒ 00:05:48.772 Caio Velasco: The 1st time that I saw it was like dupe dupe dupe was like dope or dupe, and there’s like, Oh, no, it’s for duplicate duplicated.
53 00:05:49.240 ⇒ 00:05:51.073 Caio Velasco: Yes, dude.
54 00:06:35.550 ⇒ 00:06:36.080 Emily Giant: Okay.
55 00:06:37.350 ⇒ 00:06:37.910 Caio Velasco: Good.
56 00:06:39.030 ⇒ 00:06:41.489 Emily Giant: The next one that we go through. I’ll just
57 00:06:42.290 ⇒ 00:06:50.639 Emily Giant: instead of sending out an email. I think we could. Just, I’ll slack the people and go back in and just get it done.
58 00:06:50.960 ⇒ 00:06:55.989 Caio Velasco: Yeah, no, no problem. I’m putting here in updating the reason. So it’ll be okay.
59 00:06:55.990 ⇒ 00:06:57.769 Emily Giant: Yep. Perfect. Okay.
60 00:06:58.390 ⇒ 00:07:00.380 Caio Velasco: This is deprecated.
61 00:07:01.050 ⇒ 00:07:04.109 Caio Velasco: This you just did, this deprecated.
62 00:07:06.320 ⇒ 00:07:07.660 Emily Giant: Okay. Yep.
63 00:07:08.170 ⇒ 00:07:13.280 Caio Velasco: Personal business to deprecate. Okay, so back with this.
64 00:07:13.430 ⇒ 00:07:16.050 Caio Velasco: well, you want this part here. And we said, Yes,
65 00:07:18.270 ⇒ 00:07:25.160 Caio Velasco: and then, yes, yes, yes, then make the precaution. This was.
66 00:07:25.160 ⇒ 00:07:28.100 Emily Giant: Yep, that’s salesforce our old system.
67 00:07:28.490 ⇒ 00:07:29.150 Caio Velasco: Okay.
68 00:07:36.300 ⇒ 00:07:38.979 Caio Velasco: Yes, yes, yes. Then this one.
69 00:07:38.980 ⇒ 00:07:40.470 Emily Giant: Just click all of them.
70 00:07:41.900 ⇒ 00:07:43.030 Emily Giant: Okay.
71 00:07:43.430 ⇒ 00:07:44.010 Caio Velasco: Duplicate.
72 00:07:44.357 ⇒ 00:07:45.052 Emily Giant: All right.
73 00:07:52.970 ⇒ 00:07:57.139 Caio Velasco: There’s only to investigate but deprecate all ga stuff.
74 00:08:04.460 ⇒ 00:08:06.949 Caio Velasco: Okay? So probably de-deprecate them.
75 00:08:10.670 ⇒ 00:08:11.690 Emily Giant: Yeah. Yep.
76 00:08:11.690 ⇒ 00:08:14.270 Caio Velasco: Yeah and good.
77 00:08:19.590 ⇒ 00:08:24.239 Caio Velasco: This promo code, last updated was 2022 deprecate.
78 00:08:24.960 ⇒ 00:08:27.120 Caio Velasco: Okay, that’s easier.
79 00:08:29.870 ⇒ 00:08:36.839 Caio Velasco: This one retention models. These are related to the Fy. 23 retention model Steven Butte.
80 00:08:43.740 ⇒ 00:08:44.989 Caio Velasco: So there’s 1.
81 00:08:45.990 ⇒ 00:08:50.100 Caio Velasco: This can be deprecated. But you should get some knowledge of this, as this will
82 00:08:50.330 ⇒ 00:08:53.509 Caio Velasco: has to be built out using the new data marks eventually.
83 00:08:54.040 ⇒ 00:08:55.090 Emily Giant: Makes sense.
84 00:08:58.770 ⇒ 00:09:01.570 Caio Velasco: So do we. Do we deprecate this, but.
85 00:09:01.570 ⇒ 00:09:02.310 Emily Giant: Yeah.
86 00:09:02.310 ⇒ 00:09:04.639 Caio Velasco: Need to like a follow up on that.
87 00:09:04.960 ⇒ 00:09:10.160 Emily Giant: It. Yeah, those won’t be updated ever again. So
88 00:09:11.460 ⇒ 00:09:19.170 Emily Giant: we can deprecate. But it sounds like, as long. Is the data still going to be available like just not updated.
89 00:09:22.670 ⇒ 00:09:24.560 Caio Velasco: Well, if they if they’ve been.
90 00:09:25.450 ⇒ 00:09:30.659 Emily Giant: They? If they’re inside redshift, I would assume. Yes, you’re just turning off the pipe.
91 00:09:31.010 ⇒ 00:09:31.890 Caio Velasco: Yeah.
92 00:09:31.890 ⇒ 00:09:37.660 Emily Giant: Then you can deprecate that as long as I can access the old data that will never be updated again.
93 00:09:38.780 ⇒ 00:09:46.590 Emily Giant: I don’t even think anyone has access to the to to that.
94 00:09:46.860 ⇒ 00:09:48.700 Emily Giant: It’s a former employee.
95 00:09:49.390 ⇒ 00:09:50.070 Caio Velasco: Okay.
96 00:09:56.630 ⇒ 00:10:00.620 Caio Velasco: this one, I think the same right? Same thing.
97 00:10:00.890 ⇒ 00:10:09.079 Emily Giant: Yes, exactly, Coach wrote back. He doesn’t even know what the spreadsheet is, so we can turn that off.
98 00:10:09.620 ⇒ 00:10:10.400 Caio Velasco: Okay.
99 00:10:15.550 ⇒ 00:10:18.410 Caio Velasco: Do, I mean. Sorry. Sorry. Were you talking about the one before.
100 00:10:18.630 ⇒ 00:10:19.439 Emily Giant: The
101 00:10:21.710 ⇒ 00:10:25.509 Emily Giant: There was one that said Emily, to ask coach, where’d it go?
102 00:10:27.738 ⇒ 00:10:29.350 Caio Velasco: Okay. Okay. Sorry. Sorry. This one.
103 00:10:29.350 ⇒ 00:10:31.300 Emily Giant: Sorry, but I was like.
104 00:10:31.570 ⇒ 00:10:34.310 Caio Velasco: Okay. So he said, he doesn’t even know.
105 00:10:35.089 ⇒ 00:10:35.869 Emily Giant: Yeah.
106 00:10:35.870 ⇒ 00:10:37.879 Caio Velasco: Okay, okay? So
107 00:10:48.720 ⇒ 00:10:53.539 Caio Velasco: And okay, there’s 1.
108 00:10:53.930 ⇒ 00:10:59.409 Caio Velasco: Let’s set it. February 24, th deprecate the skew forecast for Luke.
109 00:11:05.480 ⇒ 00:11:06.330 Caio Velasco: Let’s.
110 00:11:06.330 ⇒ 00:11:09.429 Emily Giant: I’ll ask finance right now about all of the quickbooks stuff.
111 00:11:09.630 ⇒ 00:11:18.400 Emily Giant: We have so much, so many quickbook tables synced, that I am not familiar with.
112 00:11:19.630 ⇒ 00:11:20.930 Caio Velasco: Oh, okay, that’s perfect.
113 00:11:21.190 ⇒ 00:11:23.500 Caio Velasco: And what’s the name of the person.
114 00:11:24.690 ⇒ 00:11:26.010 Emily Giant: Dean, Mark.
115 00:11:28.160 ⇒ 00:11:28.920 Caio Velasco: Bing.
116 00:11:29.520 ⇒ 00:11:35.250 Emily Giant: There’s 2 Deans, so there’s there’s Dean from planning and Dean from finance. Dean. Mark Yup is finance.
117 00:11:35.780 ⇒ 00:11:36.680 Caio Velasco: Believable.
118 00:11:50.690 ⇒ 00:11:57.750 Caio Velasco: Yeah, this also platform.
119 00:11:58.580 ⇒ 00:12:01.165 Caio Velasco: Yeah, this is good. This is a question that I had
120 00:12:01.400 ⇒ 00:12:01.860 Emily Giant: I mean.
121 00:12:01.860 ⇒ 00:12:06.189 Caio Velasco: When I went into Hivo I saw that 4 web hooks.
122 00:12:06.980 ⇒ 00:12:10.460 Caio Velasco: Apparently you have to delete the
123 00:12:10.610 ⇒ 00:12:14.970 Caio Velasco: pipeline itself. The integration, whatever they call you cannot just turn off.
124 00:12:15.920 ⇒ 00:12:16.450 Emily Giant: No way.
125 00:12:16.450 ⇒ 00:12:21.030 Caio Velasco: That’s yeah. So that’s I mean, you can even log in for you to see this
126 00:12:23.140 ⇒ 00:12:28.850 Caio Velasco: and I’m not sure like, well, you lose the configuration of the of when someone integrates at that. But
127 00:12:29.960 ⇒ 00:12:36.779 Caio Velasco: I don’t have other more knowledge than that. So this is this one, Steve, which is active.
128 00:12:36.950 ⇒ 00:12:38.390 Emily Giant: Oh, my good! No!
129 00:12:40.400 ⇒ 00:12:41.270 Caio Velasco: Okay? And
130 00:12:43.180 ⇒ 00:12:54.340 Caio Velasco: yeah, I didn’t see any place that you could turn that off just a little button here saying, Delete and I also checked on chat. Pt, and said that yeah, web hooks, web hooks apparently
131 00:12:54.530 ⇒ 00:12:55.859 Caio Velasco: can only be deleted.
132 00:12:56.170 ⇒ 00:13:04.820 Emily Giant: Oh, my God, delete it! Just delete it. We don’t have sticky I/O anymore. It was the worst software we’ve ever had. It was like somebody’s college.
133 00:13:05.469 ⇒ 00:13:13.460 Emily Giant: They’re like project at the end of their their degree. It was so bad. You can definitely delete that
134 00:13:14.410 ⇒ 00:13:15.190 Caio Velasco: Nice.
135 00:13:15.740 ⇒ 00:13:24.089 Caio Velasco: Okay, one time, one time, one time, and then last one. Yotpo. What is Yotpo?
136 00:13:25.150 ⇒ 00:13:36.600 Emily Giant: It is like a yelp reviews. Google reviews all of our reviews going like this like it aggregates all the reviews to give you a more comprehensive score.
137 00:13:40.210 ⇒ 00:13:43.360 Caio Velasco: Okay? And this, what is here.
138 00:13:43.520 ⇒ 00:13:50.199 Caio Velasco: This is actively pulling review information from your point. This is used anywhere by say, order. It should not be deprecated.
139 00:13:51.170 ⇒ 00:13:52.630 Caio Velasco: It is used.
140 00:13:53.850 ⇒ 00:13:57.570 Emily Giant: It’s not good since we had our
141 00:13:57.800 ⇒ 00:14:01.099 Emily Giant: migration to shopify, but it is used.
142 00:14:01.876 ⇒ 00:14:07.490 Caio Velasco: Okay- okay, okay, so boom.
143 00:14:19.220 ⇒ 00:14:23.250 Caio Velasco: okay, yeah. So.
144 00:14:23.630 ⇒ 00:14:29.029 Caio Velasco: But I think we cleared it. Let me check whatever was left in blanks, because no, it’s a no.
145 00:14:29.680 ⇒ 00:14:30.510 Emily Giant: Yeah.
146 00:14:30.670 ⇒ 00:14:33.019 Caio Velasco: No blinks, no blinks.
147 00:14:37.520 ⇒ 00:14:44.890 Caio Velasco: Brings in the city basically mutual loyalty from people.
148 00:14:45.250 ⇒ 00:14:47.979 Caio Velasco: Let me check this. I didn’t remember this.
149 00:14:48.810 ⇒ 00:14:52.770 Emily Giant: I can’t imagine that this still is useful.
150 00:14:53.110 ⇒ 00:14:56.230 Emily Giant: But did Alex not leave a note on that.
151 00:14:57.260 ⇒ 00:15:06.379 Caio Velasco: Not on this one, probably because I didn’t even see there was a 1 without anything here.
152 00:15:06.590 ⇒ 00:15:08.519 Emily Giant: Yeah. Let me ask him real quick.
153 00:15:08.740 ⇒ 00:15:10.300 Caio Velasco: Okay, do you actually.
154 00:15:10.698 ⇒ 00:15:11.892 Emily Giant: Add it to
155 00:15:12.770 ⇒ 00:15:15.169 Emily Giant: I have a meeting with him at 10,
156 00:15:16.370 ⇒ 00:15:19.439 Emily Giant: so I’ll I’ll make sure to update that.
157 00:15:19.850 ⇒ 00:15:25.340 Emily Giant: or I could just ask him. Let’s just stripe pot, as they say.
158 00:15:26.420 ⇒ 00:15:29.290 Caio Velasco: This one here, or whatever.
159 00:16:01.760 ⇒ 00:16:02.180 Caio Velasco: I’m not.
160 00:16:05.680 ⇒ 00:16:14.259 Emily Giant: Yeah, alright. I reached out and Alex about the quickbooks tables, and then the Yatpo loyalty.
161 00:16:14.550 ⇒ 00:16:24.231 Caio Velasco: Okay, cool, perfect. And I well, I believe that polytomic, since there was only one. It’s the net. New netsuit thing. Yeah. Okay, so that’s definitely not
162 00:16:26.062 ⇒ 00:16:33.550 Caio Velasco: Okay. So then, for the next, for the next part, dashboards.
163 00:16:33.880 ⇒ 00:16:36.680 Emily Giant: The I have one more question. Sorry quickly.
164 00:16:38.520 ⇒ 00:16:50.209 Emily Giant: for the Hevo data I saw that shopify has like a test store, and that seems to be active, and I don’t know if that needs to be the case. Like
165 00:16:51.070 ⇒ 00:16:57.941 Emily Giant: from my perspective, we only need to use the shopify products feed. And
166 00:16:58.870 ⇒ 00:17:04.999 Emily Giant: I just wanted to check on the state of that shopify products is yes, but like shopify, test store is active and
167 00:17:05.380 ⇒ 00:17:06.239 Emily Giant: I don’t.
168 00:17:06.460 ⇒ 00:17:08.750 Emily Giant: Oh, it’s the development environment.
169 00:17:10.730 ⇒ 00:17:11.400 Caio Velasco: Work.
170 00:17:11.599 ⇒ 00:17:14.979 Emily Giant: We? Yeah, yeah, I guess Dev probably uses that. But
171 00:17:15.800 ⇒ 00:17:18.710 Emily Giant: I just don’t know if it needs to update every 10 min
172 00:17:18.910 ⇒ 00:17:26.819 Emily Giant: like that seems overkill for a production environment. So I’ll I will ask that during.
173 00:17:28.860 ⇒ 00:17:34.760 Caio Velasco: And you also brought something interesting like, well, let’s say that we already clean everything we wanted and turn it off.
174 00:17:35.460 ⇒ 00:17:41.029 Caio Velasco: Would the next step also be understand? If the frequency makes sense.
175 00:17:42.020 ⇒ 00:17:46.960 Caio Velasco: Yeah, as a new ticket, for example. Okay, okay, okay, okay.
176 00:17:47.160 ⇒ 00:17:51.870 Caio Velasco: So let me even put here my notes.
177 00:18:03.020 ⇒ 00:18:03.700 Caio Velasco: See?
178 00:18:05.080 ⇒ 00:18:05.780 Caio Velasco: Okay.
179 00:18:27.520 ⇒ 00:18:29.549 Caio Velasco: that was that was it.
180 00:18:30.220 ⇒ 00:18:30.514 Emily Giant: Yep.
181 00:18:30.810 ⇒ 00:18:31.440 Caio Velasco: Yep.
182 00:18:32.240 ⇒ 00:18:43.049 Emily Giant: So I’ll I’ll be responsible for updating the 2 outstanding the quick books and then the test store. I don’t think that I’m not even sure we need that test store
183 00:18:43.150 ⇒ 00:18:47.040 Emily Giant: sync for shopify. And that’s a lot of data like a lot.
184 00:18:47.140 ⇒ 00:18:47.790 Emily Giant: So.
185 00:18:47.790 ⇒ 00:18:49.890 Caio Velasco: Especially after 10 min.
186 00:18:49.890 ⇒ 00:18:50.520 Emily Giant: Yeah.
187 00:18:52.370 ⇒ 00:18:56.719 Caio Velasco: Okay, let me get this as a
188 00:19:01.840 ⇒ 00:19:03.390 Caio Velasco: this way. I’ll do like this.
189 00:19:06.490 ⇒ 00:19:13.500 Caio Velasco: Okay, cool. Then, moving to dashboards, welcome.
190 00:19:13.900 ⇒ 00:19:19.910 Caio Velasco: I was looking into this, and also I saw, I remember, that a meeting I had with them and amber.
191 00:19:20.040 ⇒ 00:19:20.820 Caio Velasco: So
192 00:19:21.420 ⇒ 00:19:28.879 Caio Velasco: this was me going to looker I mean, I don’t know if you know I can show you, because it’s always good to learn something. Case you don’t know.
193 00:19:30.540 ⇒ 00:19:39.620 Caio Velasco: I well, I never touched lookup before I can be honest. So I learned that here, in the export part, you have something called
194 00:19:39.780 ⇒ 00:19:41.160 Caio Velasco: system activity.
195 00:19:41.450 ⇒ 00:19:49.520 Caio Velasco: and with this system activity, you have content usage and dashboard, which were the most important one for us. So you see who access it. What.
196 00:19:49.890 ⇒ 00:19:56.031 Caio Velasco: however, in content to use it, I can get like less less asset accessed.
197 00:19:56.600 ⇒ 00:20:02.659 Caio Velasco: create the dates, those things dashboard names, you could also see, look or other things.
198 00:20:02.920 ⇒ 00:20:13.679 Caio Velasco: But they didn’t have a part for user details. So then I noticed that in the dashboard part you can have user details. So I have to do like a extracting
199 00:20:13.920 ⇒ 00:20:19.359 Caio Velasco: a Csv from one a Csv. From other joining dashboard ids, and I think it worked.
200 00:20:20.185 ⇒ 00:20:21.010 Emily Giant: Yay!
201 00:20:21.010 ⇒ 00:20:27.620 Caio Velasco: Yeah. So then, I was able to have to create this list, which is huge, 700,
202 00:20:29.081 ⇒ 00:20:34.168 Caio Velasco: 700 dashboards. I don’t even know how people can do so many
203 00:20:34.860 ⇒ 00:20:36.050 Emily Giant: Oh!
204 00:20:36.330 ⇒ 00:20:36.800 Caio Velasco: Right, right.
205 00:20:36.800 ⇒ 00:20:38.270 Emily Giant: Like, yeah.
206 00:20:38.840 ⇒ 00:20:52.780 Caio Velasco: Let me see what was different than the other one. This is unique things. These is where I’m okay. This is probably where I just merge it all of them. There’s a bit more.
207 00:20:54.780 ⇒ 00:21:01.339 Caio Velasco: okay. And then, well, basically, when I was talking to them, we’re just trying to see like, how could we
208 00:21:01.540 ⇒ 00:21:14.530 Caio Velasco: subset this into what are the unused ones, or something? We are super clear that we want to just deprecate something that was excessive like I don’t know one year ago, or something. These are metrics that we have to define here.
209 00:21:14.530 ⇒ 00:21:14.940 Emily Giant: Hmm.
210 00:21:15.309 ⇒ 00:21:21.590 Caio Velasco: And that would be like the 1st layer of deprecation, let’s say, looking at less access dates
211 00:21:22.210 ⇒ 00:21:28.499 Caio Velasco: and also with view counts. I think those 2 can give us a an interesting idea already.
212 00:21:30.820 ⇒ 00:21:33.020 Caio Velasco: And well, let me see if I can.
213 00:21:36.930 ⇒ 00:21:38.840 Caio Velasco: As well let me see just one thing.
214 00:21:39.520 ⇒ 00:21:40.980 Caio Velasco: Get this name?
215 00:21:41.260 ⇒ 00:21:43.809 Caio Velasco: It’s 577.
216 00:21:46.920 ⇒ 00:21:48.239 Caio Velasco: Okay, there’s a minute.
217 00:21:50.410 ⇒ 00:21:50.960 Caio Velasco: Yeah.
218 00:21:50.960 ⇒ 00:21:56.466 Emily Giant: Anything with old or archive in the title. That’s a quick win, like we don’t need those
219 00:21:57.490 ⇒ 00:21:59.010 Caio Velasco: Okay, okay, I see.
220 00:21:59.740 ⇒ 00:22:00.630 Caio Velasco: 14.
221 00:22:02.370 ⇒ 00:22:06.422 Caio Velasco: Yeah. Well, let’s start here. Then the easier one. Just the dashboards.
222 00:22:08.760 ⇒ 00:22:19.339 Emily Giant: So okay, view, Count, I would say anything with a view that was created or has not been looked at in over a year with a view count of less than a hundred.
223 00:22:20.050 ⇒ 00:22:25.039 Emily Giant: less than 200, I would say, get rid of it. It last accessed.
224 00:22:25.190 ⇒ 00:22:30.070 Emily Giant: Yeah, I can’t imagine, since we just had mother’s day.
225 00:22:30.470 ⇒ 00:22:36.930 Emily Giant: everything that would have been looked at would have been looked at so within the last month.
226 00:22:37.792 ⇒ 00:22:41.649 Emily Giant: Yeah, and that’s a very generous
227 00:22:42.760 ⇒ 00:22:46.890 Emily Giant: deletion point like I feel like that’s probably not nearly
228 00:22:48.260 ⇒ 00:22:51.020 Emily Giant: strict enough with the criteria. But
229 00:22:51.580 ⇒ 00:22:57.281 Emily Giant: that’s 1 way to start anything with old or archived in the title.
230 00:22:59.110 ⇒ 00:22:59.690 Caio Velasco: Okay.
231 00:22:59.910 ⇒ 00:23:02.269 Emily Giant: And then I saw one with like a bunch of
232 00:23:03.400 ⇒ 00:23:27.580 Emily Giant: Let me pull up on my end, too, so I can independently look with a bunch of like employees that haven’t been here for over 3 years, and I can’t imagine that that data is still intact after the migration with what they built. So anything with Morgan crawl as the the builder I would look at
233 00:23:29.182 ⇒ 00:23:40.227 Emily Giant: she built several anything that Justin Levano built. He’s here, but he’s our product designer, and was generally making dashboards for himself.
234 00:23:40.960 ⇒ 00:23:44.589 Emily Giant: So I can go in here real quick and start marking.
235 00:23:45.210 ⇒ 00:23:47.150 Caio Velasco: Like filtering and marking.
236 00:23:47.420 ⇒ 00:23:50.500 Emily Giant: Which Tab, would you like me to do that on.
237 00:23:52.870 ⇒ 00:23:54.950 Caio Velasco: Well, since you mentioned the name of
238 00:23:56.220 ⇒ 00:24:01.779 Caio Velasco: the the employees, the users, maybe we can do on the audit one, since it’s the most complete one.
239 00:24:04.380 ⇒ 00:24:05.190 Emily Giant: Okay.
240 00:24:07.070 ⇒ 00:24:08.869 Caio Velasco: To put on my notes.
241 00:24:08.870 ⇒ 00:24:09.649 Emily Giant: Share it with
242 00:24:15.220 ⇒ 00:24:16.470 Emily Giant: redshift
243 00:24:19.700 ⇒ 00:24:22.750 Emily Giant: dashboards, looking for dashboards.
244 00:24:26.000 ⇒ 00:24:26.520 Caio Velasco: Okay, you’re ready.
245 00:24:26.520 ⇒ 00:24:31.790 Emily Giant: Everyone’s Internet has been really slow the last 2 days.
246 00:24:32.390 ⇒ 00:24:40.240 Emily Giant: I feel like I’m going in and out like my my Internet, okay, I’m in.
247 00:24:40.900 ⇒ 00:24:42.730 Emily Giant: So if I’m filtering.
248 00:24:43.380 ⇒ 00:24:46.649 Caio Velasco: You can filter, we will sort by whatever you prefer. There.
249 00:24:52.180 ⇒ 00:24:56.090 Emily Giant: All right. I’m gonna sort by yuri Samwell.
250 00:24:56.820 ⇒ 00:25:02.930 Emily Giant: But wait, let me sort by date first.st That seems like the biggest win view count and date.
251 00:25:03.100 ⇒ 00:25:03.920 Caio Velasco: Yes.
252 00:25:04.970 ⇒ 00:25:06.600 Emily Giant: Super easy.
253 00:25:08.700 ⇒ 00:25:10.950 Emily Giant: So let’s say anything
254 00:25:17.350 ⇒ 00:25:21.590 Emily Giant: less than 100.
255 00:25:26.420 ⇒ 00:25:27.609 Caio Velasco: For one year, and.
256 00:25:38.230 ⇒ 00:25:44.139 Emily Giant: Good enough, and the created date or updated date is.
257 00:25:46.380 ⇒ 00:25:49.169 Emily Giant: I just don’t want any 2025 s.
258 00:25:58.380 ⇒ 00:25:58.970 Caio Velasco: Right.
259 00:25:59.100 ⇒ 00:26:05.430 Caio Velasco: It’s interesting that there’s 2 filtering the large numbers.
260 00:26:06.720 ⇒ 00:26:08.920 Caio Velasco: Maybe this is not. Let’s see.
261 00:26:19.620 ⇒ 00:26:23.808 Emily Giant: I’m trying to use filters, and it’s a racket. I need to just sort these columns
262 00:26:25.060 ⇒ 00:26:30.740 Emily Giant: because I have to like uncheck a million boxes. Silliness.
263 00:26:38.310 ⇒ 00:26:41.399 Caio Velasco: yeah. So you filter for less than 100. Right?
264 00:26:42.970 ⇒ 00:26:45.810 Emily Giant: I just sorted it instead, because.
265 00:26:46.290 ⇒ 00:26:50.990 Caio Velasco: Okay. Okay. Okay. I was worried that for some reason they were not getting the number type, but.
266 00:26:52.670 ⇒ 00:26:55.869 Emily Giant: All right. So yeah, like, Morgan crawl.
267 00:26:56.950 ⇒ 00:26:58.600 Emily Giant: These are all
268 00:26:59.460 ⇒ 00:27:09.379 Emily Giant: okay. I would leave the total active subscriptions one. It doesn’t work at all. We don’t even update that data. I should ask, actually, what your opinion is.
269 00:27:09.510 ⇒ 00:27:12.049 Emily Giant: This is a dashboard we’re going to have to rebuild.
270 00:27:12.280 ⇒ 00:27:15.469 Emily Giant: It does not work. It’s based on our old platform.
271 00:27:16.460 ⇒ 00:27:23.050 Emily Giant: But I don’t want to lose the knowledge that we have to rebuild this with updated data.
272 00:27:27.090 ⇒ 00:27:29.800 Caio Velasco: So would you still say, like, deprecate.
273 00:27:30.350 ⇒ 00:27:34.220 Caio Velasco: So this, okay? So the logic, it’s as I see. Also being built in looker.
274 00:27:36.960 ⇒ 00:27:37.870 Emily Giant: Pardon.
275 00:27:37.870 ⇒ 00:27:41.639 Caio Velasco: The logic. It’s also being built in Lucas, not only something coming from.
276 00:27:42.980 ⇒ 00:27:45.364 Emily Giant: No, that’s all. Dbt.
277 00:27:47.050 ⇒ 00:27:52.189 Caio Velasco: Okay. So your question is that you’re not using that anymore. But the logic is important.
278 00:27:52.920 ⇒ 00:27:54.480 Emily Giant: Yes, exactly.
279 00:27:56.380 ⇒ 00:27:58.229 Caio Velasco: That’s something to deprecade of.
280 00:28:01.550 ⇒ 00:28:04.600 Caio Velasco: Well, maybe I can. We can mark them here.
281 00:28:05.400 ⇒ 00:28:06.960 Caio Velasco: Then I can check as well.
282 00:28:07.460 ⇒ 00:28:14.849 Emily Giant: The historical knowledge, I guess, is what I mean. Like, we don’t wanna lose access to those answers.
283 00:28:15.340 ⇒ 00:28:17.809 Emily Giant: even though they’ll never be updated.
284 00:28:19.280 ⇒ 00:28:33.610 Caio Velasco: Yeah, because I’m thinking here, if if there is a Dbt model which is the main source for that dashboard or something, if you deprecate the dashboard. I’m not sure it’s gonna I don’t know if it’s gonna affect the model itself. But if other things were done in Looker, then it’s a problem.
285 00:28:34.050 ⇒ 00:28:38.350 Emily Giant: Yeah, no, no, there’s no logic around subscriptions in Looker.
286 00:28:39.790 ⇒ 00:28:42.839 Emily Giant: So that should be okay to deprecate.
287 00:28:50.780 ⇒ 00:28:56.430 Caio Velasco: So these, okay, so we are sorting by the least view, count.
288 00:28:57.670 ⇒ 00:28:58.780 Caio Velasco: Oldest.
289 00:28:58.990 ⇒ 00:29:00.740 Emily Giant: And least view count.
290 00:29:01.490 ⇒ 00:29:02.230 Caio Velasco: Okay.
291 00:29:05.340 ⇒ 00:29:10.730 Caio Velasco: But then well, let’s see this just for number one we have, like, I want.
292 00:29:11.530 ⇒ 00:29:15.220 Emily Giant: Erase them. They just aren’t used.
293 00:29:15.570 ⇒ 00:29:21.740 Caio Velasco: All of them. But this one, you have this this question. Okay, check the warranty.
294 00:29:25.730 ⇒ 00:29:26.470 Caio Velasco: Okay.
295 00:29:31.250 ⇒ 00:29:34.470 Caio Velasco: So for view, count up to what.
296 00:29:36.500 ⇒ 00:29:39.899 Emily Giant: I would say all the way to.
297 00:29:40.210 ⇒ 00:29:42.387 Caio Velasco: That’s good, because it’s a lot.
298 00:29:52.070 ⇒ 00:29:58.430 Emily Giant: Some of these are hilariously old. Okay.
299 00:30:01.730 ⇒ 00:30:04.660 Emily Giant: 6 views, 9 views.
300 00:30:15.900 ⇒ 00:30:16.713 Emily Giant: I would.
301 00:30:21.170 ⇒ 00:30:27.799 Caio Velasco: So for well, we’re gonna start this with number one, because there’s a standard of them. So do you think that for number one.
302 00:30:27.960 ⇒ 00:30:33.350 Caio Velasco: like 2122, 2324. There’s some access in 25,
303 00:30:35.510 ⇒ 00:30:37.190 Caio Velasco: even though just one time.
304 00:30:39.410 ⇒ 00:30:42.010 Emily Giant: I would. I can ask Jessica.
305 00:30:42.240 ⇒ 00:30:45.979 Emily Giant: but certainly if I built it, just get rid of it.
306 00:30:46.840 ⇒ 00:30:47.445 Emily Giant: Okay.
307 00:30:50.000 ⇒ 00:30:58.720 Caio Velasco: Okay, okay. So I’m also taking. Let me take this and also the account number as well.
308 00:30:59.140 ⇒ 00:31:12.809 Emily Giant: I’m going to highlight the ones that I will ask the stakeholder in these. But I think all the way up to like I’ve gone all the way up to 500, and I think we can erase Mo. We can deprecate most of them.
309 00:31:13.260 ⇒ 00:31:15.550 Caio Velasco: Okay? 500. Mean, like, row number.
310 00:31:15.880 ⇒ 00:31:16.245 Emily Giant: Yes.
311 00:31:16.610 ⇒ 00:31:17.690 Caio Velasco: Yeah, okay.
312 00:31:20.740 ⇒ 00:31:26.929 Caio Velasco: so I wanna put a yes for everyone. But then this, you can highlight whatever you prefer.
313 00:31:39.090 ⇒ 00:31:42.029 Emily Giant: Okay, I’m turning the ones green that I need to ask about
314 00:31:42.420 ⇒ 00:31:45.100 Emily Giant: in those rows what in the.
315 00:31:54.600 ⇒ 00:32:04.000 Caio Velasco: It’s interesting because kind of, I mean I I haven’t used Luke or much, but people could have also just saved as a book unnecessary as a dashboard.
316 00:32:04.000 ⇒ 00:32:04.820 Emily Giant: -
317 00:32:08.390 ⇒ 00:32:12.699 Emily Giant: which I people don’t realize that like you can just send the results.
318 00:32:13.691 ⇒ 00:32:23.100 Emily Giant: It’s a training thing, but still gracious.
319 00:32:24.820 ⇒ 00:32:30.530 Emily Giant: So I’m highlighting a lot of. So Jesse S. He was my direct report for a while, and like
320 00:32:30.840 ⇒ 00:32:37.099 Emily Giant: he connects everything he does to web hooks, so I don’t know if those show the usage when it’s being used
321 00:32:37.370 ⇒ 00:32:38.840 Emily Giant: via a web hook.
322 00:32:39.270 ⇒ 00:32:43.329 Emily Giant: So I am highlighting a bunch of his that I I know to be like.
323 00:32:44.640 ⇒ 00:32:50.350 Emily Giant: probably actually use, just not touched or updated by name.
324 00:33:07.270 ⇒ 00:33:10.739 Caio Velasco: And this subset is from people that are still there.
325 00:33:12.250 ⇒ 00:33:13.270 Emily Giant: Yes.
326 00:33:13.270 ⇒ 00:33:13.880 Caio Velasco: Hmm!
327 00:33:15.130 ⇒ 00:33:16.400 Caio Velasco: This one.
328 00:33:16.560 ⇒ 00:33:19.790 Emily Giant: Definitely green. How did that one get in there?
329 00:33:21.130 ⇒ 00:33:28.350 Emily Giant: Care action subscriptions? I know they use that every week can’t go local.
330 00:33:52.010 ⇒ 00:33:54.440 Emily Giant: maybe, and maybe.
331 00:34:41.310 ⇒ 00:34:50.289 Caio Velasco: And bear in mind that the dates here. Apparently they are not on us format. So it’s a day and month.
332 00:34:51.040 ⇒ 00:34:53.710 Emily Giant: Okay, it’s close enough.
333 00:34:53.880 ⇒ 00:35:00.069 Emily Giant: It’s definitely enough information to know that people still aren’t looking at these.
334 00:35:09.260 ⇒ 00:35:13.009 Emily Giant: I Oh, my goodness, like I.
335 00:35:13.660 ⇒ 00:35:19.607 Emily Giant: So this don’t even know how to use liquor. So I’m just like, no, no, you can’t have it.
336 00:35:22.880 ⇒ 00:35:25.859 Emily Giant: Oh, my God, okay.
337 00:35:31.990 ⇒ 00:35:39.640 Emily Giant: like this. Sales revenue dashboard! I I cringe to wonder what is in that dashboard. But I will never know, because we’re gonna delete it.
338 00:35:55.760 ⇒ 00:35:58.800 Emily Giant: So those step batch
339 00:36:05.880 ⇒ 00:36:06.939 Emily Giant: all right.
340 00:36:20.070 ⇒ 00:36:24.450 Emily Giant: So if I filter out the yeses and babies.
341 00:36:27.070 ⇒ 00:36:31.090 Emily Giant: We still have a ton where the view count is one.
342 00:36:32.970 ⇒ 00:36:38.200 Emily Giant: I think we can probably just go ahead and mark all of those as yes.
343 00:36:50.770 ⇒ 00:36:53.460 Emily Giant: Oh, some of them are even like in the trash.
344 00:36:54.170 ⇒ 00:36:56.839 Emily Giant: I would say anything that’s like in the trash.
345 00:36:57.180 ⇒ 00:36:59.220 Emily Giant: It’s a definite yes.
346 00:36:59.600 ⇒ 00:37:02.880 Caio Velasco: Yeah, yeah, that’s why I put that as well. Just remember. True.
347 00:37:03.040 ⇒ 00:37:05.599 Caio Velasco: like, it’s in the trash, most likely.
348 00:37:05.600 ⇒ 00:37:06.260 Emily Giant: Yeah.
349 00:37:40.240 ⇒ 00:37:42.840 Caio Velasco: Do you want me to? Oh, you’re doing okay. Cool?
350 00:37:47.190 ⇒ 00:37:48.210 Caio Velasco: Oh, perfect.
351 00:38:03.980 ⇒ 00:38:04.560 Emily Giant: Thank you.
352 00:38:06.340 ⇒ 00:38:11.069 Caio Velasco: Yeah, there’s also, I think, the the column right before it’s moved to trash. Then it’s a yes or no.
353 00:38:11.760 ⇒ 00:38:16.319 Caio Velasco: The other one was just the date. But I also started with that, just so that you know.
354 00:38:18.890 ⇒ 00:38:19.950 Emily Giant: That’s good.
355 00:38:20.150 ⇒ 00:38:20.710 Caio Velasco: Okay.
356 00:38:21.180 ⇒ 00:38:28.989 Emily Giant: I’m like all of like, technically, these are all deprecated because the revenue data doesn’t work. But in terms of like
357 00:38:30.250 ⇒ 00:38:32.090 Emily Giant: deleting versus.
358 00:38:32.770 ⇒ 00:38:40.749 Emily Giant: not deleting. I’m I’m just making sure I’m answering the right question when we say deprecated. This is just to indicate that it no longer
359 00:38:41.360 ⇒ 00:38:44.890 Emily Giant: works. Or is this to indicate that we are getting rid of it.
360 00:38:45.300 ⇒ 00:38:52.220 Caio Velasco: I think the idea is that we are getting rid of it like a clean up part. Yeah.
361 00:38:52.430 ⇒ 00:38:55.690 Caio Velasco: And then at some point, maybe with the work being done
362 00:38:55.910 ⇒ 00:39:03.960 Caio Velasco: in terms of finding the important Dbt models. And what are they pointing to in terms of dashboard? Then maybe those would be the ones who
363 00:39:04.390 ⇒ 00:39:05.949 Caio Velasco: it would work on.
364 00:39:06.500 ⇒ 00:39:07.100 Emily Giant: Hey?
365 00:39:08.780 ⇒ 00:39:10.460 Emily Giant: You count one.
366 00:40:31.210 ⇒ 00:40:34.300 Caio Velasco: Test. There’s a test one that’s definitely good.
367 00:40:34.470 ⇒ 00:40:41.110 Emily Giant: Yeah, anything that says test and has like a single view.
368 00:40:41.640 ⇒ 00:40:42.310 Emily Giant: It’s perfect.
369 00:40:43.930 ⇒ 00:40:44.390 Emily Giant: 8.
370 00:40:47.590 ⇒ 00:40:49.010 Caio Velasco: Test again.
371 00:41:06.770 ⇒ 00:41:07.640 Emily Giant: Actually.
372 00:41:29.830 ⇒ 00:41:41.969 Caio Velasco: And then we have also the other layer of work, that when we decide which one to be deprecated, we will have to go in and well deprecate them, delete them. Then, in Brazil we say that we, for those things we have to hire an intern.
373 00:41:42.980 ⇒ 00:41:44.611 Emily Giant: Yeah, you’re an intern.
374 00:41:46.440 ⇒ 00:41:48.650 Caio Velasco: At least over there it can be quite cheap, so.
375 00:41:49.210 ⇒ 00:41:52.090 Emily Giant: Yeah, do it for free.
376 00:41:52.330 ⇒ 00:41:52.980 Caio Velasco: Hmm.
377 00:41:53.690 ⇒ 00:42:00.079 Emily Giant: I’m just like, just let’s just delete looker like, forget this. Let’s just start from scratch.
378 00:42:04.290 ⇒ 00:42:06.233 Emily Giant: How did this happen?
379 00:42:07.600 ⇒ 00:42:10.440 Caio Velasco: Yeah, how long has been urban stem zone?
380 00:42:10.900 ⇒ 00:42:12.816 Caio Velasco: Not long enough for this.
381 00:42:14.050 ⇒ 00:42:15.859 Emily Giant: Think 2,015.
382 00:42:16.190 ⇒ 00:42:17.970 Caio Velasco: Oh, okay. Okay. Okay.
383 00:42:17.970 ⇒ 00:42:26.950 Emily Giant: But, Looker, I want to say Looker did not start until later. So
384 00:42:27.855 ⇒ 00:42:34.079 Emily Giant: 2020, I don’t think I’ve seen reports earlier than 2020 or 2021.
385 00:42:35.030 ⇒ 00:42:35.880 Caio Velasco: Okay.
386 00:42:36.080 ⇒ 00:42:46.309 Emily Giant: We had, like our data engineer was like a a mad scientist that I I really liked his personality, but I don’t know what, up to
387 00:42:46.430 ⇒ 00:42:48.860 Emily Giant: wild stuff.
388 00:42:55.030 ⇒ 00:43:03.679 Caio Velasco: And it’s interesting because well, even if it’s 5 years with 50 weeks per year.
389 00:43:03.870 ⇒ 00:43:08.599 Caio Velasco: maybe 2, that 3 dashboards, more or less per week being built.
390 00:43:08.940 ⇒ 00:43:10.180 Caio Velasco: It’s almost.
391 00:43:13.680 ⇒ 00:43:17.049 Emily Giant: And if people look at the same ones over and over and over again.
392 00:43:17.260 ⇒ 00:43:17.980 Caio Velasco: Right.
393 00:43:18.190 ⇒ 00:43:20.229 Emily Giant: You’re all pretty much wrong.
394 00:43:21.124 ⇒ 00:43:23.660 Emily Giant: At this point, but.
395 00:43:28.010 ⇒ 00:43:29.140 Caio Velasco: Where is this?
396 00:43:30.700 ⇒ 00:43:32.549 Caio Velasco: I’ll freeze the 1st row
397 00:43:52.910 ⇒ 00:43:53.620 Caio Velasco: this.
398 00:44:12.840 ⇒ 00:44:23.899 Emily Giant: This is also like going through the graveyard of urban stems employees. Because half of these people do not work here anymore. I’m like, oh, yeah, a cat browse. She was great. Joe Thompson.
399 00:44:25.460 ⇒ 00:44:26.529 Caio Velasco: Yes, true.
400 00:44:28.520 ⇒ 00:44:29.430 Emily Giant: Okay.
401 00:44:31.040 ⇒ 00:44:35.049 Caio Velasco: Yeah, there’s some other here that seems to be also from the system.
402 00:44:35.290 ⇒ 00:44:36.870 Caio Velasco: I don’t even know what that means.
403 00:44:37.160 ⇒ 00:44:38.970 Emily Giant: Yeah, I’d
404 00:44:49.550 ⇒ 00:44:52.320 Emily Giant: express checker. What is this?
405 00:45:09.660 ⇒ 00:45:21.099 Emily Giant: I would say anything that has a holiday like M. Day, 23 or V day 20. Anything that isn’t 2025 we can filter for those and
406 00:45:21.500 ⇒ 00:45:22.683 Emily Giant: get rid of them.
407 00:45:23.360 ⇒ 00:45:24.010 Caio Velasco: Okay.
408 00:45:24.170 ⇒ 00:45:25.829 Emily Giant: Be a ton of those.
409 00:45:27.370 ⇒ 00:45:36.599 Emily Giant: or even anything with just like Fy. 23, we should be able to still pull that data for hindsight. But I don’t think we’re ever going to go. Be like
410 00:45:36.830 ⇒ 00:45:45.520 Emily Giant: what happened just solely in the year of 2023 without comparing it to like the present date.
411 00:45:48.850 ⇒ 00:45:49.530 Caio Velasco: Okay.
412 00:45:54.170 ⇒ 00:45:56.310 Emily Giant: Flowers cool.
413 00:46:43.920 ⇒ 00:46:52.699 Emily Giant: Don’t know what these Google 360 ones are. They look incredibly old, so we can deprecate them. But they don’t have like a user.
414 00:46:53.590 ⇒ 00:46:57.929 Caio Velasco: True. True, I I can check. What are those they just came
415 00:46:59.290 ⇒ 00:47:01.600 Caio Velasco: from when I extracted the Csv.
416 00:47:03.790 ⇒ 00:47:06.600 Caio Velasco: Well, maybe I still have to. Look here, let me check.
417 00:47:07.040 ⇒ 00:47:08.520 Caio Velasco: Oh, boy, definitely.
418 00:47:21.930 ⇒ 00:47:25.360 Caio Velasco: let’s see this. Probably there’s 1.
419 00:47:33.460 ⇒ 00:47:37.680 Caio Velasco: What’s a number 3 60, for example.
420 00:47:57.880 ⇒ 00:47:59.870 Caio Velasco: where they come.
421 00:48:31.700 ⇒ 00:48:34.450 Caio Velasco: Yeah, this is well, I think this is just
422 00:48:35.010 ⇒ 00:48:40.550 Caio Velasco: something from the system, because the even looking here at look in the loop.
423 00:48:41.660 ⇒ 00:48:42.380 Emily Giant: Hmm.
424 00:48:42.380 ⇒ 00:48:44.419 Caio Velasco: Yeah. Doesn’t seem to be.
425 00:48:44.820 ⇒ 00:48:45.650 Emily Giant: Yeah.
426 00:48:48.990 ⇒ 00:48:53.280 Caio Velasco: Where you can try to access. But either you didn’t access or you don’t have access.
427 00:48:56.450 ⇒ 00:49:06.470 Caio Velasco: I mean, I think on your side you can, you can click on the link. Maybe you will have a permission. But I’m not sure even if that’s a permission problem, or if it’s something that actually doesn’t exist. But it’s
428 00:49:06.720 ⇒ 00:49:07.869 Caio Velasco: in the system.
429 00:49:14.030 ⇒ 00:49:19.489 Emily Giant: I’ll check that out one sec. New dashboard made by nobody.
430 00:49:19.650 ⇒ 00:49:22.699 Emily Giant: Let me check out that. That sounds interesting.
431 00:49:25.380 ⇒ 00:49:27.979 Emily Giant: How many more do we have. I feel like we’re the
432 00:49:28.250 ⇒ 00:49:33.399 Emily Giant: burning through these. And I did start to work on the Dbt models that will
433 00:49:33.560 ⇒ 00:49:43.879 Emily Giant: probably take me another like, sit down. I can do it independently, but probably another hour and a half, just because it, like some of the models.
434 00:49:44.390 ⇒ 00:49:52.239 Emily Giant: take some explanation of Okay, well, this is just an empty dashboard. Sorry I opened up.
435 00:49:52.240 ⇒ 00:49:52.649 Caio Velasco: Thank you.
436 00:49:52.650 ⇒ 00:49:57.344 Emily Giant: New day as this dashboard is empty. So I think safely, we can
437 00:49:58.110 ⇒ 00:49:59.909 Emily Giant: go ahead and get rid of that.
438 00:50:01.750 ⇒ 00:50:05.670 Emily Giant: Okay, but
439 00:50:17.290 ⇒ 00:50:19.830 Emily Giant: okay, so this is what we’ve got left.
440 00:50:22.040 ⇒ 00:50:24.780 Emily Giant: Alright, I’m gonna do a quick
441 00:50:25.390 ⇒ 00:50:27.480 Emily Giant: search for M. Day and V-day.
442 00:50:28.430 ⇒ 00:50:29.050 Caio Velasco: One thing.
443 00:50:35.800 ⇒ 00:50:42.940 Emily Giant: And if these have not been used in 2025 like, we don’t even really need to look at them, they can just go
444 00:51:05.730 ⇒ 00:51:09.200 Emily Giant: and the executive summary order velocity.
445 00:51:16.910 ⇒ 00:51:18.710 Emily Giant: I’m sure that was incorrectly marked
446 00:52:15.270 ⇒ 00:52:16.040 Emily Giant: name.
447 00:52:18.190 ⇒ 00:52:21.310 Emily Giant: That’s only 6.
448 00:52:21.580 ⇒ 00:52:25.449 Emily Giant: Okay, that’s a good. I’m sure I can go in and like. Refine
449 00:52:32.020 ⇒ 00:52:35.290 Emily Giant: some of these, but that’s a good like quick hit.
450 00:52:35.660 ⇒ 00:52:36.230 Caio Velasco: Yeah.
451 00:52:53.120 ⇒ 00:53:01.710 Caio Velasco: And I think I think someone mentioned is that most. Let’s say that the the biggest chunk of revenue would come from mother’s day.
452 00:53:02.060 ⇒ 00:53:02.580 Emily Giant: Yes.
453 00:53:02.580 ⇒ 00:53:03.750 Caio Velasco: Is that right? Okay.
454 00:53:04.640 ⇒ 00:53:10.200 Caio Velasco: Yeah, also, like Valentine’s Day, or or others important, like Christmas or something. I’m not really.
455 00:53:11.747 ⇒ 00:53:25.170 Emily Giant: Valentine’s Day would be our other really big, and there’s a a sprinkle during Christmas and Thanksgiving, but by far Valentine’s Day are our 2 largest holidays.
456 00:53:28.700 ⇒ 00:53:29.440 Emily Giant: Okay.
457 00:53:32.320 ⇒ 00:53:35.630 Caio Velasco: So everything. Not 25 year, also deprecate.
458 00:53:36.260 ⇒ 00:53:36.590 Emily Giant: Yep.
459 00:54:12.390 ⇒ 00:54:13.480 Emily Giant: to all of them.
460 00:54:14.750 ⇒ 00:54:15.940 Caio Velasco: Almost. Yeah.
461 00:54:16.050 ⇒ 00:54:20.619 Caio Velasco: Well, no, it’s not locked.
462 00:54:23.490 ⇒ 00:54:24.639 Emily Giant: That’s great. Okay?
463 00:54:30.400 ⇒ 00:54:31.340 Emily Giant: All right.
464 00:54:33.260 ⇒ 00:54:35.230 Caio Velasco: Let me see how many? Yes, we have.
465 00:54:37.430 ⇒ 00:54:39.820 Emily Giant: Let’s find now the word old.
466 00:54:42.500 ⇒ 00:54:48.919 Emily Giant: This feels like a good. I’m not even gonna look at what these are. If they’re marked as old, they’re not used.
467 00:54:53.030 ⇒ 00:54:56.250 Caio Velasco: They had a lot of counts in 25.
468 00:54:56.740 ⇒ 00:54:59.939 Caio Velasco: I also it’s weird that they are market sold.
469 00:55:00.450 ⇒ 00:55:11.819 Emily Giant: It’s the old inventory we, the old inventory models. So when we atomic all of these became deprecated, so they’re not even usable.
470 00:55:12.090 ⇒ 00:55:13.160 Caio Velasco: Okay. Okay?
471 00:55:13.940 ⇒ 00:55:18.620 Caio Velasco: Oh, yeah, for sure. It wouldn’t be really nice to have another column here with the models.
472 00:55:20.970 ⇒ 00:55:21.970 Caio Velasco: I’ll get there.
473 00:55:23.340 ⇒ 00:55:28.570 Emily Giant: Data problems I use all the time daily ref huddle.
474 00:55:34.980 ⇒ 00:55:35.650 Emily Giant: All right.
475 00:55:36.810 ⇒ 00:55:39.220 Emily Giant: Now, I’m just gonna do a little bit of like
476 00:55:40.220 ⇒ 00:55:42.940 Emily Giant: quick hit user filtering. Morgan crawl.
477 00:55:45.110 ⇒ 00:55:46.150 Emily Giant: These cannot go.
478 00:55:48.430 ⇒ 00:55:49.499 Caio Velasco: Just do that or no.
479 00:55:50.670 ⇒ 00:55:51.110 Emily Giant: Nope.
480 00:55:51.550 ⇒ 00:55:52.120 Caio Velasco: Nope.
481 00:55:55.170 ⇒ 00:55:55.520 Emily Giant: Oops!
482 00:55:56.750 ⇒ 00:55:59.839 Caio Velasco: Everything. That’s 1 in 25.
483 00:56:01.060 ⇒ 00:56:02.190 Emily Giant: Okay. Let me see.
484 00:56:02.730 ⇒ 00:56:03.590 Caio Velasco: This one.
485 00:56:04.800 ⇒ 00:56:05.830 Emily Giant: Okay.
486 00:56:06.580 ⇒ 00:56:08.150 Caio Velasco: I mean, actually.
487 00:56:09.082 ⇒ 00:56:10.170 Emily Giant: That is, maybe.
488 00:56:10.950 ⇒ 00:56:15.030 Emily Giant: But I, that data does not work well. So
489 00:56:17.520 ⇒ 00:56:22.690 Caio Velasco: Is okay, cause the one above. Maybe it’s 25 as well.
490 00:56:23.050 ⇒ 00:56:25.000 Caio Velasco: I mean, not as well. But it’s 25.
491 00:56:25.670 ⇒ 00:56:29.530 Emily Giant: There’s no way that dashboard works. That’s not the polyatomic data.
492 00:56:31.330 ⇒ 00:56:34.729 Emily Giant: So that one we can deprecate.
493 00:56:35.050 ⇒ 00:56:35.700 Caio Velasco: Okay.
494 00:56:35.960 ⇒ 00:56:36.670 Emily Giant: All about.
495 00:56:36.670 ⇒ 00:56:40.520 Caio Velasco: Maybe here, it’s because you know the dashboard, I assume.
496 00:56:41.560 ⇒ 00:56:42.370 Caio Velasco: Okay.
497 00:56:45.690 ⇒ 00:56:46.830 Caio Velasco: and you’re in.
498 00:56:48.800 ⇒ 00:56:52.190 Emily Giant: Okay, there are 2. These look like they’re still looked at a lot
499 00:56:52.540 ⇒ 00:56:55.260 Emily Giant: daily. Scm, so I’m just gonna put, no.
500 00:56:58.080 ⇒ 00:57:01.080 Emily Giant: okay. It looks like a lot of his stuff is. Still.
501 00:57:03.670 ⇒ 00:57:05.639 Emily Giant: I’m going to mark these as maybe
502 00:57:09.080 ⇒ 00:57:14.160 Emily Giant: I don’t know what is being looked at, but he hasn’t been with the company in over 3 years.
503 00:57:14.970 ⇒ 00:57:15.820 Emily Giant: No.
504 00:57:52.260 ⇒ 00:57:55.519 Emily Giant: I’m seeing that a lot of these are being used. And I’m like.
505 00:57:56.410 ⇒ 00:58:03.270 Emily Giant: I know that data doesn’t work anymore. I hope that business decisions are not being made based on
506 00:58:04.630 ⇒ 00:58:06.029 Emily Giant: these results.
507 00:58:07.180 ⇒ 00:58:16.159 Emily Giant: See, Justin, he’s still here, but I don’t think he really uses any of his dashboards.
508 00:58:21.460 ⇒ 00:58:22.529 Caio Velasco: Keep it under me.
509 00:58:26.360 ⇒ 00:58:32.329 Emily Giant: Okay, I know we both have to hop doing this last little, you see, reporting.
510 00:58:36.400 ⇒ 00:58:37.260 Emily Giant: okay.
511 00:58:37.260 ⇒ 00:58:41.919 Caio Velasco: Or if you have time, and you want to continue this for 5, 10 min, it’s okay. But if you don’t, no problem.
512 00:58:42.960 ⇒ 00:58:45.579 Emily Giant: I. I have my call with Alex.
513 00:58:45.580 ⇒ 00:58:45.970 Caio Velasco: Okay.
514 00:58:45.970 ⇒ 00:58:51.650 Emily Giant: But how are we doing? I just wanna see like how much we have still to go.
515 00:59:00.830 ⇒ 00:59:02.859 Emily Giant: Sure, all my filters are off. Okay.
516 00:59:03.620 ⇒ 00:59:09.029 Emily Giant: So if I’m filtering for blanks, we still have
517 00:59:16.590 ⇒ 00:59:20.619 Emily Giant: 400 review. So we’re about half long.
518 00:59:20.840 ⇒ 00:59:22.110 Caio Velasco: Yeah, which is great.
519 00:59:22.590 ⇒ 00:59:24.600 Emily Giant: Alright. I will finish this.
520 00:59:25.890 ⇒ 00:59:29.602 Emily Giant: I’ll try to finish this like after our stand up today.
521 00:59:29.940 ⇒ 00:59:30.530 Caio Velasco: Okay.
522 00:59:31.770 ⇒ 00:59:32.620 Emily Giant: Yeah.
523 00:59:33.090 ⇒ 00:59:39.999 Caio Velasco: No, I think we did a lot. I think, when if you tell people that we have 800 that we did already have honestly, it’s a lot.
524 00:59:40.630 ⇒ 00:59:58.879 Emily Giant: Progress is happening. I do feel confident about that. Okay, thank you so much. It’s really helpful to like focus in with someone on, even even though they’re menial tasks, it helps get them done like things that I have doing, because they’re so easy that, like you don’t.
525 00:59:58.880 ⇒ 01:00:00.100 Caio Velasco: No, I agree, I agree.
526 01:00:00.770 ⇒ 01:00:06.120 Caio Velasco: And then next time, Friday we can continue for the modeling part. If we didn’t pinch this.
527 01:00:06.390 ⇒ 01:00:16.239 Emily Giant: I’ll do as much as I can with the modeling part, because those take so much like explanation. I’ll try to get like 90% of those done so that we can just
528 01:00:16.800 ⇒ 01:00:20.000 Emily Giant: spend more time like talking about the models.
529 01:00:21.300 ⇒ 01:00:25.020 Caio Velasco: Yeah, do whatever you prefer. If you wanna go over with me, it’s okay. Otherwise.
530 01:00:26.140 ⇒ 01:00:26.680 Emily Giant: All right.
531 01:00:27.135 ⇒ 01:00:30.990 Emily Giant: Yeah, alright, I will see you in a little bit at the stand up.
532 01:00:31.200 ⇒ 01:00:32.190 Caio Velasco: Bye.