Meeting Title: PostHog Data Integration Sync Date: 2026-03-25 Meeting participants: Demilade Agboola, Mustafa Raja
WEBVTT
1 00:00:22.110 ⇒ 00:00:22.705 Mustafa Raja: Ayy.
2 00:00:25.340 ⇒ 00:00:26.720 Demilade Agboola: Hi, Mustafa, how are you?
3 00:00:27.750 ⇒ 00:00:29.520 Mustafa Raja: How are you? I’m doing good.
4 00:00:29.800 ⇒ 00:00:31.069 Demilade Agboola: Okay, how was your time off?
5 00:00:32.640 ⇒ 00:00:33.869 Mustafa Raja: Yeah, pretty good.
6 00:00:34.120 ⇒ 00:00:34.999 Demilade Agboola: That’s good to hear.
7 00:00:35.000 ⇒ 00:00:38.270 Mustafa Raja: We’ll be off for next 10 days, after…
8 00:00:39.650 ⇒ 00:00:43.399 Mustafa Raja: After next week, Wednesday. Actually, after next week, Tuesday.
9 00:00:44.540 ⇒ 00:00:47.240 Demilade Agboola: Okay, alright. That’s when you’re going to Saudi Arabia, right?
10 00:00:47.640 ⇒ 00:00:49.729 Mustafa Raja: Yeah, yeah, that… that is correct.
11 00:00:50.750 ⇒ 00:00:52.589 Demilade Agboola: That’s pretty cool, it’s pretty cool. Hope you have fun.
12 00:00:53.520 ⇒ 00:00:54.570 Mustafa Raja: Yeah.
13 00:00:54.690 ⇒ 00:00:57.170 Mustafa Raja: The war is also shutting down now.
14 00:00:58.810 ⇒ 00:01:00.979 Demilade Agboola: I was gonna say, what time’s the weather you’re going off, right?
15 00:01:01.920 ⇒ 00:01:04.199 Mustafa Raja: Yes, yes, he is aware of that.
16 00:01:04.499 ⇒ 00:01:08.159 Demilade Agboola: So, because I will need to obviously talk to him about… Oh, man.
17 00:01:08.160 ⇒ 00:01:09.090 Mustafa Raja: The locations, yeah.
18 00:01:09.330 ⇒ 00:01:11.160 Demilade Agboola: Yeah, default on all of that.
19 00:01:14.240 ⇒ 00:01:15.210 Demilade Agboola: That’s so good.
20 00:01:16.030 ⇒ 00:01:18.049 Demilade Agboola: Come on, hope you have a great trip.
21 00:01:18.710 ⇒ 00:01:24.129 Mustafa Raja: Yeah, thank you. Okay, so, regarding this…
22 00:01:28.020 ⇒ 00:01:29.440 Mustafa Raja: Let me share my screen.
23 00:01:34.050 ⇒ 00:01:38.439 Mustafa Raja: Okay, so, let me actually see if we have…
24 00:01:38.860 ⇒ 00:01:44.160 Mustafa Raja: This should be in here. Post log data, cohort persons, cohorts.
25 00:01:45.530 ⇒ 00:01:47.249 Mustafa Raja: There’s just zero rows in there.
26 00:01:51.490 ⇒ 00:01:54.380 Mustafa Raja: My roles and projects, definitions…
27 00:01:54.620 ⇒ 00:02:01.690 Mustafa Raja: So, do you think we’ll have to create cohorts inside of Post Hog to get this data in?
28 00:02:03.500 ⇒ 00:02:06.790 Demilade Agboola: What is in the post… what is in the post hog data?
29 00:02:07.640 ⇒ 00:02:09.579 Demilade Agboola: Like, what is in the raw table?
30 00:02:11.120 ⇒ 00:02:11.990 Mustafa Raja: Nothing.
31 00:02:12.300 ⇒ 00:02:25.700 Mustafa Raja: So, there’s 4 tables that have come in, one, one for property definitions that has 178 rows, and then projects that has 5 rows, and then cohort and cohort person has nothing.
32 00:02:26.280 ⇒ 00:02:26.950 Demilade Agboola: Okay.
33 00:02:30.060 ⇒ 00:02:32.069 Demilade Agboola: That should be…
34 00:02:32.070 ⇒ 00:02:35.779 Mustafa Raja: I’m wondering if there’s a way to get the event data at all or not.
35 00:02:37.220 ⇒ 00:02:38.020 Mustafa Raja: The event date.
36 00:02:38.020 ⇒ 00:02:38.540 Demilade Agboola: Huh?
37 00:02:39.700 ⇒ 00:02:40.729 Demilade Agboola: He wants to… that’s…
38 00:02:40.730 ⇒ 00:02:45.290 Mustafa Raja: Yeah… Okay, okay.
39 00:02:47.670 ⇒ 00:02:52.559 Mustafa Raja: Because a lot of these charts are being built on that. See, this is page view events.
40 00:02:58.660 ⇒ 00:02:59.550 Demilade Agboola: Hmm…
41 00:03:02.640 ⇒ 00:03:03.820 Demilade Agboola: So there’s some…
42 00:03:05.410 ⇒ 00:03:12.249 Demilade Agboola: So I looked at the run. It appears there’s some things you might need to tweak in the API key. Give me one second.
43 00:03:29.460 ⇒ 00:03:31.420 Demilade Agboola: API key, etc.
44 00:03:37.400 ⇒ 00:03:38.210 Demilade Agboola: Hmm.
45 00:04:26.020 ⇒ 00:04:28.289 Demilade Agboola: Let’s see… so it’s…
46 00:04:31.340 ⇒ 00:04:32.570 Demilade Agboola: Events…
47 00:05:51.320 ⇒ 00:05:52.320 Demilade Agboola: I can…
48 00:06:03.520 ⇒ 00:06:05.409 Demilade Agboola: I’ve actually had the dashboard so far.
49 00:06:07.940 ⇒ 00:06:09.250 Mustafa Raja: Yeah.
50 00:06:11.290 ⇒ 00:06:13.119 Mustafa Raja: So this is what we have right now.
51 00:06:13.960 ⇒ 00:06:18.740 Mustafa Raja: New admins in the last 30 days, we don’t have any, because… Because of the data, right?
52 00:06:18.960 ⇒ 00:06:20.609 Demilade Agboola: Yeah, but I lost that today.
53 00:06:21.650 ⇒ 00:06:28.189 Mustafa Raja: This is some other stuff, so growth, month over month, and total users per account.
54 00:06:29.320 ⇒ 00:06:31.249 Mustafa Raja: Then we have the issue renewal.
55 00:06:32.040 ⇒ 00:06:41.039 Mustafa Raja: Then… tickets submitted, users who made the workflow. This, I’m fixing right now, and then we have total…
56 00:06:41.630 ⇒ 00:06:43.109 Mustafa Raja: Meeting duration over time.
57 00:06:43.830 ⇒ 00:06:48.390 Mustafa Raja: And then I believe I’m going to add two more.
58 00:06:48.390 ⇒ 00:06:49.380 Demilade Agboola: for customers.
59 00:06:50.090 ⇒ 00:06:50.920 Mustafa Raja: Sorry?
60 00:06:51.020 ⇒ 00:06:53.509 Demilade Agboola: Can we make a filter for customers?
61 00:06:53.510 ⇒ 00:06:59.250 Mustafa Raja: Yes, for that, we have to, Do the thing, no?
62 00:06:59.790 ⇒ 00:07:06.410 Mustafa Raja: We have to join… Customers, in Salesforce and in product data.
63 00:07:06.950 ⇒ 00:07:08.450 Demilade Agboola: Okay, alright, sounds good.
64 00:07:08.450 ⇒ 00:07:13.070 Mustafa Raja: Yeah, via domain, we left that conversation last week, midway.
65 00:07:14.130 ⇒ 00:07:16.679 Mustafa Raja: So… we can take it from there.
66 00:07:20.680 ⇒ 00:07:30.150 Mustafa Raja: Yeah, I just found… I just found that, in product data and in Salesforce, the ones that do not match do not have the same domain at all.
67 00:07:30.820 ⇒ 00:07:37.150 Mustafa Raja: Even when we remove the, even when we trim it down to the… just the name of the domain, you know?
68 00:07:37.990 ⇒ 00:07:39.190 Demilade Agboola: Sorry, can I repeat that?
69 00:07:40.190 ⇒ 00:07:45.689 Mustafa Raja: So I found that the ones, the ones that do not match.
70 00:07:46.200 ⇒ 00:07:56.340 Mustafa Raja: the companies that do not match their domain among product data and Salesforce data, they just have two different domains in both, you know?
71 00:07:57.180 ⇒ 00:07:59.350 Demilade Agboola: Oh, they have two different domains in both.
72 00:07:59.630 ⇒ 00:08:02.120 Demilade Agboola: Have you tried, even, like, when you strip it of the.
73 00:08:02.120 ⇒ 00:08:06.180 Mustafa Raja: Yeah, even if we trim it down to the… just the name of the domain.
74 00:08:06.650 ⇒ 00:08:18.340 Mustafa Raja: it’s like… because the name of the domain is different, you know? So, it’s going to be ABC in product data and XYZ in Salesforce, and there’s no way that’s going to match, right?
75 00:08:18.690 ⇒ 00:08:20.629 Demilade Agboola: Yeah, I got what you mean.
76 00:08:23.720 ⇒ 00:08:27.620 Mustafa Raja: Okay, and then, let me tell you what I’m adding.
77 00:08:28.310 ⇒ 00:08:37.509 Mustafa Raja: So I’ll be adding workflow types and workflows by trigger, though I think we need further clarification on both of those by their team.
78 00:08:38.580 ⇒ 00:08:46.300 Mustafa Raja: But I have a version that we can install there. And then users logged in…
79 00:08:47.680 ⇒ 00:08:50.179 Mustafa Raja: And this one, we need posthog.
80 00:08:53.170 ⇒ 00:08:58.820 Mustafa Raja: One method that we need is Boston for… Ausson, pourchant.
81 00:08:58.980 ⇒ 00:09:00.949 Demilade Agboola: Are you sure we can’t get that from the product data?
82 00:09:01.870 ⇒ 00:09:06.199 Mustafa Raja: This is logged in, we cannot, right? Because we don’t have session data at all, you know?
83 00:09:06.680 ⇒ 00:09:11.039 Demilade Agboola: Yeah, yeah, but I’m talking about the workflow, changing activities, like meetings and stuff.
84 00:09:12.580 ⇒ 00:09:22.329 Mustafa Raja: No meeting in 30 days, but this… this one, no? Leads and assignments. I don’t think that this one is going to be in there. We can do the meetings, but not this.
85 00:09:24.250 ⇒ 00:09:24.960 Demilade Agboola: Alright.
86 00:09:25.490 ⇒ 00:09:26.600 Demilade Agboola: Give me one second.
87 00:09:28.470 ⇒ 00:09:35.270 Mustafa Raja: Even for this, I think… I think we’ll have to build this in post-op, because I don’t think that this… this has been built in post-op, I couldn’t see it.
88 00:16:07.010 ⇒ 00:16:10.319 Demilade Agboola: Oh, Mustafs, can you check? You should be able to see events now.
89 00:16:23.040 ⇒ 00:16:24.010 Mustafa Raja: Yeah, I’m taking…
90 00:17:06.150 ⇒ 00:17:08.410 Mustafa Raja: It is there, but it has zero doors.
91 00:17:09.740 ⇒ 00:17:10.589 Demilade Agboola: Okay.
92 00:17:19.730 ⇒ 00:17:23.319 Mustafa Raja: Can we just get everything that is in posthog in here?
93 00:17:24.510 ⇒ 00:17:26.149 Demilade Agboola: Yeah, I mean, that’s what I’m trying to do.
94 00:17:26.619 ⇒ 00:17:27.099 Mustafa Raja: Okay, bro.
95 00:17:27.099 ⇒ 00:17:27.799 Demilade Agboola: have…
96 00:17:32.859 ⇒ 00:17:34.419 Demilade Agboola: It’s almost in zero records.
97 00:20:43.260 ⇒ 00:20:44.250 Demilade Agboola: Jenny.
98 00:20:45.460 ⇒ 00:20:46.530 Mustafa Raja: Yes.
99 00:20:46.790 ⇒ 00:20:47.409 Demilade Agboola: Oh, okay.
100 00:20:47.740 ⇒ 00:20:48.570 Demilade Agboola: What did you say?
101 00:20:49.040 ⇒ 00:20:51.660 Mustafa Raja: Were you saying something? Were you saying something?
102 00:20:51.660 ⇒ 00:20:57.550 Demilade Agboola: I just said, I’ve mentioned it to Polyatomic that we were having issues with their endpoint, or, like, with the post…
103 00:21:01.310 ⇒ 00:21:03.700 Mustafa Raja: So we may have to wait for them then, right?
104 00:21:04.300 ⇒ 00:21:08.919 Demilade Agboola: I just want an engineer to investigate and just be sure, like.
105 00:21:09.240 ⇒ 00:21:13.029 Demilade Agboola: The endpoints are fine, the connection is fine, and then, potentially.
106 00:21:13.200 ⇒ 00:21:15.990 Demilade Agboola: We’ll look into what needs to be done from that point on.
107 00:21:17.270 ⇒ 00:21:18.060 Mustafa Raja: Okay.
108 00:21:48.620 ⇒ 00:21:53.399 Mustafa Raja: Okay, so, Deathen wants to take a look at, how we are going to…
109 00:21:53.760 ⇒ 00:21:56.800 Mustafa Raja: Match the companies between?
110 00:21:57.630 ⇒ 00:21:59.429 Demilade Agboola: Yeah, sure, let’s take a look at that.
111 00:22:03.990 ⇒ 00:22:04.910 Mustafa Raja: Nope, okay.
112 00:22:08.470 ⇒ 00:22:13.259 Mustafa Raja: I guess I have this… oh, I just have this in the chat here.
113 00:22:19.390 ⇒ 00:22:25.909 Mustafa Raja: Do you want to use this cursor, to first explore, you know, what companies do not match, or something like that?
114 00:22:26.420 ⇒ 00:22:31.649 Demilade Agboola: First off, can we go to the tables in Mother Doc? I just wanted to see…
115 00:22:32.740 ⇒ 00:22:34.610 Demilade Agboola: What we’re trying to join.
116 00:22:35.930 ⇒ 00:22:40.079 Mustafa Raja: So, we are trying to join this raw teams.
117 00:22:41.300 ⇒ 00:22:42.740 Demilade Agboola: to…
118 00:22:43.430 ⇒ 00:22:46.590 Mustafa Raja: Do… the Salesforce account.
119 00:22:48.890 ⇒ 00:22:51.070 Demilade Agboola: Okay, alright, let me hop in and look at it.
120 00:22:51.580 ⇒ 00:22:55.299 Demilade Agboola: Okay. I just want to see the content of the tables, and…
121 00:22:57.840 ⇒ 00:22:58.970 Mustafa Raja: Yes.
122 00:23:01.160 ⇒ 00:23:09.140 Demilade Agboola: Just… just… I don’t know if you did it, but can you ask Cursor if there are any keys to join the tables? Let’s just see what it says.
123 00:23:09.280 ⇒ 00:23:10.909 Mustafa Raja: Oh, yeah,
124 00:23:11.460 ⇒ 00:23:22.779 Mustafa Raja: it said that the domain is the best, best choice. We have, it couldn’t find any, Salesforce IDs in the raw data, coming from product.
125 00:23:25.650 ⇒ 00:23:26.400 Demilade Agboola: Okay.
126 00:23:32.130 ⇒ 00:23:33.549 Mustafa Raja: Let me do that again.
127 00:23:33.960 ⇒ 00:23:36.060 Mustafa Raja: Just to be 100% sure.
128 00:23:38.650 ⇒ 00:23:39.640 Mustafa Raja: Hmm.
129 00:24:07.660 ⇒ 00:24:08.719 Demilade Agboola: Actually, they are.
130 00:24:08.840 ⇒ 00:24:12.150 Demilade Agboola: If you go to raw members.
131 00:24:16.670 ⇒ 00:24:17.900 Demilade Agboola: Raw members.
132 00:24:20.500 ⇒ 00:24:22.709 Demilade Agboola: Do you see a Salesforce user ID?
133 00:24:26.130 ⇒ 00:24:27.860 Mustafa Raja: This is $95,000.
134 00:24:28.790 ⇒ 00:24:32.900 Demilade Agboola: Yeah, well, let’s just see what… We’re able to get…
135 00:24:33.160 ⇒ 00:24:34.330 Mustafa Raja: Okay.
136 00:24:34.930 ⇒ 00:24:42.480 Demilade Agboola: Yeah, let’s… let’s do… first off, do… can you do a distinct count? Okay, let me just do it myself. Don’t worry, give me one second.
137 00:24:43.950 ⇒ 00:24:44.480 Demilade Agboola: Inc.
138 00:24:46.560 ⇒ 00:24:49.280 Demilade Agboola: counts… Salesforce…
139 00:24:53.960 ⇒ 00:24:54.900 Demilade Agboola: Here’s the…
140 00:25:10.400 ⇒ 00:25:11.570 Demilade Agboola: Anybody’s fine.
141 00:25:11.820 ⇒ 00:25:16.010 Demilade Agboola: So, the reason why it’s 95% null is teams make up
142 00:25:16.810 ⇒ 00:25:19.909 Demilade Agboola: Give me one second, let me just confirm something before I…
143 00:25:19.910 ⇒ 00:25:23.299 Mustafa Raja: It’s 60% null, not 95.
144 00:25:23.300 ⇒ 00:25:31.900 Demilade Agboola: still, like, the idea is this. Members make up teams. I want to be sure… that…
145 00:25:32.200 ⇒ 00:25:36.010 Demilade Agboola: And so these Salesforce IDs are for the members and the teams.
146 00:25:37.670 ⇒ 00:25:43.020 Demilade Agboola: I want to be sure that each team Has a unique…
147 00:25:45.470 ⇒ 00:25:46.609 Mustafa Raja: Since we’re signing.
148 00:25:46.610 ⇒ 00:25:47.150 Demilade Agboola: Yeah.
149 00:25:47.390 ⇒ 00:25:48.300 Demilade Agboola: Exactly.
150 00:25:49.030 ⇒ 00:25:51.659 Mustafa Raja: And then we can manage that with contact, I believe.
151 00:25:52.310 ⇒ 00:25:55.989 Demilade Agboola: With account ID, which… I think it should be account ID.
152 00:25:56.170 ⇒ 00:25:57.430 Mustafa Raja: Oh, okay, see.
153 00:25:59.130 ⇒ 00:26:00.700 Demilade Agboola: But give me one second, I just… again, let me call.
154 00:26:00.700 ⇒ 00:26:01.700 Mustafa Raja: Understood.
155 00:32:17.720 ⇒ 00:32:19.240 Demilade Agboola: Figured out the issue.
156 00:32:19.450 ⇒ 00:32:23.390 Demilade Agboola: There’s no, like, we don’t… the admin access…
157 00:32:24.980 ⇒ 00:32:28.770 Demilade Agboola: Like, we don’t have admin access in post-Huggage, we’re just regular members.
158 00:32:28.920 ⇒ 00:32:30.919 Demilade Agboola: So, that will be an issue.
159 00:32:33.570 ⇒ 00:32:34.990 Mustafa Raja: Oh, okay.
160 00:32:34.990 ⇒ 00:32:39.050 Demilade Agboola: And so I’ve reached out to Caitlin. We’ll see what she says.
161 00:32:41.890 ⇒ 00:32:42.540 Mustafa Raja: Okay.
162 00:33:17.200 ⇒ 00:33:17.870 Mustafa Raja: Hmm.
163 00:34:10.080 ⇒ 00:34:10.780 Mustafa Raja: Thank you.
164 00:35:07.110 ⇒ 00:35:10.450 Demilade Agboola: Okay, sorry, I’m trying to… let me get back to the mother doc.
165 00:35:11.240 ⇒ 00:35:12.100 Demilade Agboola: Deanie?
166 00:35:12.740 ⇒ 00:35:13.510 Demilade Agboola: Yep.
167 00:40:21.080 ⇒ 00:40:25.480 Mustafa Raja: Nandir said that we are already admin there, in the post fork.
168 00:40:26.060 ⇒ 00:40:26.790 Demilade Agboola: Okay.
169 00:40:27.590 ⇒ 00:40:33.820 Mustafa Raja: Nandika said that we, we are already admin in the… In the posthog.
170 00:40:33.820 ⇒ 00:40:36.590 Demilade Agboola: We are not, I just checked it now, unless she’s made the change.
171 00:40:38.160 ⇒ 00:40:39.219 Mustafa Raja: Okay, good.
172 00:40:39.990 ⇒ 00:40:41.010 Demilade Agboola: Give me one second.
173 00:47:36.560 ⇒ 00:47:40.629 Mustafa Raja: Let me know, although, once you work out…
174 00:47:42.230 ⇒ 00:47:47.359 Mustafa Raja: the connection between product data and Salesforce, we can then take a look at the dashboard.
175 00:47:47.500 ⇒ 00:47:49.829 Mustafa Raja: I have some questions also.
176 00:48:04.030 ⇒ 00:48:05.070 Mustafa Raja: Can you hear me?
177 00:48:06.470 ⇒ 00:48:12.250 Demilade Agboola: Oh, sorry, I was actually talking, but I was mute. I think there’s a query that Krista has helped me find. I want to see…
178 00:48:16.110 ⇒ 00:48:17.619 Demilade Agboola: If it works…
179 00:48:20.230 ⇒ 00:48:20.880 Mustafa Raja: Yep.
180 00:50:52.630 ⇒ 00:51:05.850 Demilade Agboola: Okay, so… I have a query, but this only gives… This only gives, 307 rows.
181 00:51:09.680 ⇒ 00:51:13.379 Mustafa Raja: That’s… that’s nice. How are we doing that?
182 00:51:13.940 ⇒ 00:51:15.170 Demilade Agboola: I’ll send you the query.
183 00:51:15.930 ⇒ 00:51:16.860 Mustafa Raja: Oh, damn.
184 00:51:16.990 ⇒ 00:51:18.370 Demilade Agboola: Let’s see…
185 00:51:24.320 ⇒ 00:51:29.799 Demilade Agboola: basically, I took each of the team, I went to where, like, the members are.
186 00:51:30.790 ⇒ 00:51:39.060 Demilade Agboola: Used it to map it, join to the team members in in Salesforce.
187 00:51:41.430 ⇒ 00:51:45.369 Demilade Agboola: Each team member in Salesforce has an account ID.
188 00:51:46.320 ⇒ 00:51:49.639 Demilade Agboola: And so I used that… I used that account ID.
189 00:51:50.270 ⇒ 00:51:56.399 Demilade Agboola: on Salesforce. Like, I don’t know how to explain, but, like, once it’s… once a user ID exists.
190 00:51:57.850 ⇒ 00:52:02.900 Demilade Agboola: it has a Salesforce user ID. I then use that Salesforce… let me just share it.
191 00:52:03.040 ⇒ 00:52:03.980 Demilade Agboola: So it’s…
192 00:52:03.980 ⇒ 00:52:08.950 Mustafa Raja: So the member, so the members, thing, we’re matching that, right? Members…
193 00:52:09.190 ⇒ 00:52:11.420 Demilade Agboola: Okay, actually, no, you know what, let me even make it better.
194 00:52:27.660 ⇒ 00:52:30.149 Mustafa Raja: So we are matching with Salesforce contacts, right?
195 00:52:30.500 ⇒ 00:52:31.130 Demilade Agboola: Yes.
196 00:52:32.850 ⇒ 00:52:33.810 Mustafa Raja: Lemons. Yeah.
197 00:52:35.870 ⇒ 00:52:42.540 Demilade Agboola: I think, actually, Salesforce… user ID might actually be a better way to look at it.
198 00:52:51.570 ⇒ 00:52:53.799 Mustafa Raja: You’re trying to match with user object now?
199 00:52:57.580 ⇒ 00:53:00.649 Demilade Agboola: Yeah, I’m trying to switch it to the user ID.
200 00:55:53.370 ⇒ 00:55:57.179 Demilade Agboola: Okay. I think this is the best way to rejoin it so far, what I’ve seen.
201 00:55:57.950 ⇒ 00:56:01.780 Demilade Agboola: The other way, like, doesn’t seem to have more rules, so we’re fine.
202 00:56:03.590 ⇒ 00:56:09.520 Mustafa Raja: Okay. So, there’s going to… there’s still going to be some,
203 00:56:10.390 ⇒ 00:56:12.469 Mustafa Raja: Some accounts that do not match, right?
204 00:56:12.790 ⇒ 00:56:18.580 Mustafa Raja: I’m just wondering, how many accounts we are able to match using the Salesforce ID versus domain.
205 00:56:19.340 ⇒ 00:56:22.409 Demilade Agboola: I don’t know how many were matching with the domain, you would have to check that for me.
206 00:56:23.390 ⇒ 00:56:26.340 Mustafa Raja: Yes, I sent you the…
207 00:56:26.810 ⇒ 00:56:30.079 Mustafa Raja: So, we were able to match 366…
208 00:56:31.900 ⇒ 00:56:33.839 Demilade Agboola: Okay, in that case, let’s use Domain then.
209 00:56:35.570 ⇒ 00:56:37.199 Mustafa Raja: Yeah, and I’m wondering…
210 00:56:37.200 ⇒ 00:56:40.729 Demilade Agboola: them, like, duplicates, like, the one double-counted teams.
211 00:56:42.770 ⇒ 00:56:47.839 Mustafa Raja: I believe it did not, but I can double-check that. Also,
212 00:56:48.020 ⇒ 00:56:57.449 Mustafa Raja: Also, I’m wondering, we would want, all of them to match, right? So we’ll have to ask, we’ll have to ask default team.
213 00:56:57.570 ⇒ 00:57:01.850 Mustafa Raja: to change domains, either in the product or in Salesforce, right?
214 00:57:03.900 ⇒ 00:57:08.549 Demilade Agboola: Ideally, but we will need to figure out why they’re not matching.
215 00:57:09.200 ⇒ 00:57:10.990 Demilade Agboola: Is it cause they were…
216 00:57:11.180 ⇒ 00:57:13.620 Mustafa Raja: So, let me share my screen.
217 00:57:13.980 ⇒ 00:57:14.670 Demilade Agboola: Okay.
218 00:57:18.080 ⇒ 00:57:25.120 Mustafa Raja: So… Let’s take a look at air by,
219 00:57:25.600 ⇒ 00:57:27.699 Mustafa Raja: Yeah, let’s take a look at Airbyte.
220 00:57:28.390 ⇒ 00:57:29.590 Mustafa Raja: Salesforce.
221 00:57:33.890 ⇒ 00:57:35.240 Mustafa Raja: Login…
222 00:57:48.240 ⇒ 00:57:49.040 Mustafa Raja: Alright.
223 00:58:30.440 ⇒ 00:58:40.030 Mustafa Raja: It’s hereby.com in… Salesforce and airbag, airbag.io in… In product.
224 00:58:41.030 ⇒ 00:58:47.129 Mustafa Raja: So we should be able to match this one, when we trim. Let’s take a look at some of the…
225 00:58:50.180 ⇒ 00:58:52.250 Mustafa Raja: Hadi, let’s take a look at HDI.
226 00:58:57.640 ⇒ 00:59:01.279 Mustafa Raja: Yeah, so for this one, the…
227 00:59:01.800 ⇒ 00:59:10.630 Mustafa Raja: The product domain is a totally different string than, the… domain in, Salesforce, right?
228 00:59:13.420 ⇒ 00:59:14.500 Mustafa Raja: Can you see this?
229 00:59:14.980 ⇒ 00:59:17.459 Demilade Agboola: Yes, I can see it. What’s your question?
230 00:59:18.300 ⇒ 00:59:32.269 Mustafa Raja: I’m just saying that this is one reason why we’re not able to match all of the accounts with Salesforce, and this is where we need help from default team, right?
231 00:59:32.370 ⇒ 00:59:39.799 Mustafa Raja: So they should be able to maintain this, make sure that the domains are matching.
232 00:59:44.020 ⇒ 00:59:47.620 Demilade Agboola: Yeah, yeah, we’ll talk to them about that, like, I know…
233 00:59:49.110 ⇒ 00:59:51.569 Demilade Agboola: I will give… I know,
234 00:59:52.620 ⇒ 00:59:57.529 Demilade Agboola: Caitlin mentioned a way to probably join it, but I’m going to look, let me see if I can find it now.
235 00:59:58.490 ⇒ 01:00:01.999 Demilade Agboola: There’s just been quite a bit of stuff recently.
236 01:02:37.270 ⇒ 01:02:42.370 Demilade Agboola: Okay, I can’t seem to see any of the contexts of all that. I think I might have to reach out to…
237 01:02:43.720 ⇒ 01:02:44.640 Mustafa Raja: Yeah.
238 01:02:49.670 ⇒ 01:02:57.249 Mustafa Raja: So this is the summary, I just re-ran cursor, asked to rematch using domains, and this is the summary if you…
239 01:02:57.850 ⇒ 01:02:59.840 Mustafa Raja: Want to keep this in context?
240 01:03:02.650 ⇒ 01:03:03.530 Demilade Agboola: Okay.
241 01:03:07.330 ⇒ 01:03:09.919 Demilade Agboola: Alright then, I think let’s just use it then.
242 01:03:11.080 ⇒ 01:03:11.710 Mustafa Raja: Yeah.
243 01:03:12.100 ⇒ 01:03:20.339 Mustafa Raja: Also, so… Yeah, I guess we’ll have to talk to them to get this… What’s it called?
244 01:03:20.490 ⇒ 01:03:22.149 Mustafa Raja: Filter in, then, right?
245 01:03:26.060 ⇒ 01:03:32.020 Demilade Agboola: Yeah, so we’ll just use the domain and add that as, a filter.
246 01:03:33.780 ⇒ 01:03:34.660 Mustafa Raja: Okay.
247 01:03:37.510 ⇒ 01:03:41.290 Mustafa Raja: So, so what we want to do is,
248 01:03:41.860 ⇒ 01:03:44.970 Mustafa Raja: We just want, we just want to add domain here.
249 01:03:45.380 ⇒ 01:03:49.009 Mustafa Raja: Because we are not joining, joining stuff right now, right?
250 01:03:53.120 ⇒ 01:03:57.099 Demilade Agboola: Yeah, yeah, but, like, domain… like, we can use domain. Once we join it, we can then
251 01:03:57.310 ⇒ 01:03:59.320 Demilade Agboola: Use it to get a count’s name.
252 01:04:00.760 ⇒ 01:04:06.190 Demilade Agboola: Have it there as a filter, and then we can use it to, like, filter the dashboards, basically.
253 01:04:06.380 ⇒ 01:04:11.949 Mustafa Raja: Yeah, yeah, what I’m asking is, do… should I have, should I add that right now or not?
254 01:04:15.730 ⇒ 01:04:17.240 Demilade Agboola: Please add your item, like…
255 01:04:17.590 ⇒ 01:04:23.049 Demilade Agboola: Because I want us to, like, once you can do that, I want to share with, Utam.
256 01:04:24.370 ⇒ 01:04:28.950 Demilade Agboola: Because we want to be able to, like, Utena wants to look at it like, today?
257 01:04:29.310 ⇒ 01:04:30.820 Demilade Agboola: Before…
258 01:04:32.440 ⇒ 01:04:40.170 Demilade Agboola: So we can… he can give feedback before tomorrow’s meeting, basically. So when we start tomorrow, we know what we need to do and clear up before the meeting tomorrow.
259 01:04:40.540 ⇒ 01:04:42.459 Demilade Agboola: Cause we want to show this tomorrow.
260 01:04:42.670 ⇒ 01:04:45.259 Demilade Agboola: Alright, so can we scroll down a bit, please?
261 01:04:47.680 ⇒ 01:04:50.099 Demilade Agboola: No, no, no, please. Yeah, it can’t go down.
262 01:04:51.290 ⇒ 01:04:51.740 Mustafa Raja: Yeah.
263 01:04:51.740 ⇒ 01:04:56.780 Demilade Agboola: found some more… Workflow per trigger… .
264 01:04:59.610 ⇒ 01:05:04.369 Mustafa Raja: Yeah, so, so for these two, I have some questions, right?
265 01:05:04.370 ⇒ 01:05:05.610 Demilade Agboola: He was gonna eat that.
266 01:05:06.350 ⇒ 01:05:13.369 Mustafa Raja: Okay, so, this is coming from… This is coming from…
267 01:05:21.890 ⇒ 01:05:25.059 Mustafa Raja: This is coming from raw forms type, right?
268 01:05:26.390 ⇒ 01:05:32.050 Mustafa Raja: Now, all of the types have triggers in them, except these two.
269 01:05:34.880 ⇒ 01:05:42.369 Mustafa Raja: So yeah, I just… I just want to, you know, confirm how should we be dealing this, you know.
270 01:05:49.370 ⇒ 01:05:52.730 Demilade Agboola: All of them have triggers except, what, regular and imported.
271 01:05:53.140 ⇒ 01:05:53.860 Mustafa Raja: Yep.
272 01:05:54.540 ⇒ 01:05:57.439 Mustafa Raja: Regularly imported, and this unknown
273 01:05:58.080 ⇒ 01:06:03.260 Mustafa Raja: And then we have this playbook, and then this is duplicated, so I might just hide this.
274 01:06:09.880 ⇒ 01:06:13.749 Demilade Agboola: So you think you should hide that, and then… okay, I think…
275 01:06:14.230 ⇒ 01:06:21.350 Demilade Agboola: what exactly is a trigger? A trigger is basically when you’re trying to do, like, a workflow, like.
276 01:06:21.670 ⇒ 01:06:25.879 Mustafa Raja: Yeah, I think, I think the trigger is, what runs the workflow, no?
277 01:06:28.430 ⇒ 01:06:29.290 Demilade Agboola: Oh, okay.
278 01:06:36.600 ⇒ 01:06:39.949 Demilade Agboola: Okay, so I think what we need to do in this case is…
279 01:06:41.230 ⇒ 01:06:43.529 Demilade Agboola: So what exactly would regular be?
280 01:06:43.700 ⇒ 01:06:47.630 Demilade Agboola: And what would… imported B.
281 01:06:49.130 ⇒ 01:06:51.909 Mustafa Raja: Yeah, that’s just… I’m not sure of, you know.
282 01:07:57.890 ⇒ 01:08:01.820 Demilade Agboola: Mmm… time.
283 01:08:12.720 ⇒ 01:08:16.510 Demilade Agboola: So in the meta, what’s in trigger config?
284 01:08:22.410 ⇒ 01:08:28.399 Demilade Agboola: So, for when we have the workflow as regular, Alright.
285 01:08:33.370 ⇒ 01:08:35.649 Demilade Agboola: What is in… what is in the matter?
286 01:08:40.770 ⇒ 01:08:43.360 Demilade Agboola: So when we have type as regular, what is in, like, the meta?
287 01:08:44.569 ⇒ 01:08:47.689 Mustafa Raja: Mmm, Meta is not for those, I think.
288 01:08:48.080 ⇒ 01:08:49.319 Demilade Agboola: Can we please check that?
289 01:08:55.520 ⇒ 01:09:00.319 Mustafa Raja: I think I explored this with Kersh also, let me… Go back up.
290 01:09:54.210 ⇒ 01:10:02.930 Mustafa Raja: Yeah, trigger config… For regular rows, it’s null for 62%.
291 01:10:04.220 ⇒ 01:10:09.959 Mustafa Raja: And where it exists, It’s just… it just says, trigger config none.
292 01:10:11.340 ⇒ 01:10:20.720 Demilade Agboola: Alright, I don’t think regular is a trigger. That’s… that’s the… what I was trying to see.
293 01:10:39.090 ⇒ 01:10:43.520 Demilade Agboola: do for the other ones that look weird as well. Let’s see if they are triggers as well.
294 01:10:46.410 ⇒ 01:10:53.140 Demilade Agboola: So, also for, like, also the other types, like, meeting book trigger, what does it show for the trigger as well? Let’s see.
295 01:11:33.430 ⇒ 01:11:35.169 Mustafa Raja: Let’s config none, and…
296 01:11:44.130 ⇒ 01:11:46.419 Mustafa Raja: It sometimes has events, and then…
297 01:11:46.420 ⇒ 01:11:48.229 Demilade Agboola: Yeah, sometimes it’s trigger config, man.
298 01:11:48.560 ⇒ 01:11:49.410 Mustafa Raja: Hmm.
299 01:11:51.240 ⇒ 01:11:53.740 Mustafa Raja: Yeah, I guess this is,
300 01:11:54.380 ⇒ 01:11:57.460 Mustafa Raja: We may need some clarification from them on this.
301 01:12:01.820 ⇒ 01:12:02.549 Mustafa Raja: with it.
302 01:12:05.800 ⇒ 01:12:10.679 Demilade Agboola: I don’t know what those event keys mean, so I’ll also be able to, like, mean to ask them.
303 01:12:11.960 ⇒ 01:12:18.070 Demilade Agboola: Can you go into… So… Can we go into…
304 01:12:18.650 ⇒ 01:12:22.590 Demilade Agboola: The workflow details, like, the workflow description and stuff.
305 01:12:24.740 ⇒ 01:12:27.920 Demilade Agboola: For this, like, why is it just like this? Can we go there?
306 01:12:29.960 ⇒ 01:12:31.950 Demilade Agboola: No, can you go back, please?
307 01:12:35.790 ⇒ 01:12:40.070 Demilade Agboola: there is, like, a workflow name or workflow description.
308 01:12:40.070 ⇒ 01:12:41.119 Mustafa Raja: Oh, yeah.
309 01:12:41.970 ⇒ 01:12:47.960 Mustafa Raja: Bookmark description… Yeah, it’s mutually non… null.
310 01:12:48.320 ⇒ 01:12:49.240 Mustafa Raja: But I think it’s like.
311 01:12:49.240 ⇒ 01:12:51.999 Demilade Agboola: the meta ID that has, like, a, you know.
312 01:12:54.770 ⇒ 01:12:57.640 Demilade Agboola: I think it’s that? Is it the one beside workflow name?
313 01:12:58.780 ⇒ 01:12:59.680 Mustafa Raja: Yeah, this one, no?
314 01:12:59.680 ⇒ 01:13:00.040 Demilade Agboola: No, no, no.
315 01:13:00.040 ⇒ 01:13:00.480 Mustafa Raja: Beautiful.
316 01:13:00.480 ⇒ 01:13:02.139 Demilade Agboola: On the left side, or something.
317 01:13:02.580 ⇒ 01:13:04.669 Demilade Agboola: AJ, can you check, please?
318 01:13:06.590 ⇒ 01:13:07.660 Demilade Agboola: Interesting.
319 01:13:08.320 ⇒ 01:13:11.650 Demilade Agboola: I know there’s one that has, like, integration IED and all that detail.
320 01:13:12.280 ⇒ 01:13:17.139 Mustafa Raja: Oh, that one would be… There’s no?
321 01:13:17.340 ⇒ 01:13:19.810 Mustafa Raja: So, this would have integration ID.
322 01:13:21.270 ⇒ 01:13:24.650 Demilade Agboola: Does this have anything about triggers as well, or it’s just only integration ID?
323 01:13:24.650 ⇒ 01:13:29.700 Mustafa Raja: I think, yeah, I checked a few, and I didn’t find anything about triggers yet.
324 01:13:31.590 ⇒ 01:13:35.950 Mustafa Raja: I can ask, sir, to dig there, do a deeper dive, let me…
325 01:15:02.350 ⇒ 01:15:06.710 Mustafa Raja: He’s just saying the trigger category is just the… Type…
326 01:15:07.750 ⇒ 01:15:12.779 Mustafa Raja: Inside Workflow, trigger context shows up as trigger record variables.
327 01:17:26.790 ⇒ 01:17:35.730 Mustafa Raja: Yeah, for the regular phones… Total regular forms is this, has a workflow.
328 01:17:40.430 ⇒ 01:17:43.390 Demilade Agboola: So… Basically…
329 01:17:45.100 ⇒ 01:17:48.609 Mustafa Raja: This may, this may not be a good signal for this.
330 01:17:48.910 ⇒ 01:17:49.630 Demilade Agboola: Yeah.
331 01:17:54.480 ⇒ 01:17:56.549 Demilade Agboola: Also, can you look at imported as well?
332 01:17:56.940 ⇒ 01:18:00.079 Mustafa Raja: Yeah, and he must… I was going to do that.
333 01:18:05.710 ⇒ 01:18:07.010 Mustafa Raja: Important.
334 01:18:31.990 ⇒ 01:18:39.439 Demilade Agboola: Okay, yeah, so let’s exclude them. Can you just do different types by trigger record count?
335 01:18:40.430 ⇒ 01:18:46.300 Demilade Agboola: So, can you go back to the cursor and tell it to give you the different… Typed by…
336 01:18:46.820 ⇒ 01:18:48.350 Demilade Agboola: trigger record count.
337 01:18:48.520 ⇒ 01:18:53.400 Demilade Agboola: Just write it like that, can you give me the trig… the different types by trigger record count?
338 01:19:50.180 ⇒ 01:19:52.900 Mustafa Raja: What, counts by type?
339 01:19:57.770 ⇒ 01:19:58.710 Demilade Agboola: Yeah.
340 01:19:58.930 ⇒ 01:19:59.929 Mustafa Raja: You wanted it?
341 01:20:00.130 ⇒ 01:20:01.569 Demilade Agboola: Yeah, this is all fantasy.
342 01:20:02.140 ⇒ 01:20:03.280 Demilade Agboola: Oh, no.
343 01:20:07.830 ⇒ 01:20:09.370 Demilade Agboola: Interesting, I know.
344 01:20:22.610 ⇒ 01:20:24.139 Demilade Agboola: Wait, can you… yeah.
345 01:20:26.710 ⇒ 01:20:27.570 Mustafa Raja: Yeah, sorry?
346 01:20:27.750 ⇒ 01:20:30.460 Demilade Agboola: Can you go down a bit, so I’m to the bottom?
347 01:20:30.850 ⇒ 01:20:32.919 Demilade Agboola: Can you also exclude playbook and null?
348 01:20:34.240 ⇒ 01:20:40.589 Mustafa Raja: Playbook null, and then we will have one more. This deprecated, I should get rid of this also, no?
349 01:20:40.970 ⇒ 01:20:42.090 Demilade Agboola: Probably, yeah.
350 01:20:46.510 ⇒ 01:20:48.529 Demilade Agboola: And also the other meeting booked.
351 01:20:51.690 ⇒ 01:20:54.619 Mustafa Raja: Oh yeah, we have a meeting book trigger, why is that there?
352 01:20:56.900 ⇒ 01:20:57.770 Mustafa Raja: Ding.
353 01:21:03.360 ⇒ 01:21:07.280 Mustafa Raja: Okay… The playbook…
354 01:21:12.860 ⇒ 01:21:16.010 Mustafa Raja: I think null… yeah, knowledge is just unknown.
355 01:21:30.760 ⇒ 01:21:37.650 Mustafa Raja: Okay, then comes this one, the variety of, workflow times, right?
356 01:21:43.100 ⇒ 01:21:45.240 Demilade Agboola: So, how are we defining workflow type?
357 01:21:45.240 ⇒ 01:21:46.190 Mustafa Raja: Yeah.
358 01:21:46.560 ⇒ 01:21:48.390 Mustafa Raja: Let me get that…
359 01:21:55.370 ⇒ 01:22:05.020 Mustafa Raja: Okay, so, what it initially did is it tried to infer type of the workflow, from the name.
360 01:22:05.270 ⇒ 01:22:08.170 Mustafa Raja: Which was complete useless. Read.
361 01:22:09.720 ⇒ 01:22:24.100 Mustafa Raja: So, I tried to, so what I asked it to do is, do not… do not take the name as source of truth for that, find something else that we can use, to define the types. And then what it did is…
362 01:22:30.910 ⇒ 01:22:36.439 Mustafa Raja: It sort of combined some of those, form types.
363 01:22:36.810 ⇒ 01:22:40.260 Mustafa Raja: To come up with these categories.
364 01:22:40.740 ⇒ 01:22:43.250 Mustafa Raja: Does this make sense, what it’s doing?
365 01:22:45.770 ⇒ 01:22:47.160 Demilade Agboola: So, first…
366 01:22:47.160 ⇒ 01:22:52.069 Mustafa Raja: Salesforce automation, what it’s doing is it’s adding up this one.
367 01:22:52.680 ⇒ 01:22:53.910 Mustafa Raja: And this one.
368 01:22:54.280 ⇒ 01:22:55.110 Demilade Agboola: Can we…
369 01:22:55.240 ⇒ 01:23:01.329 Demilade Agboola: Can we just ask them if they have an idea of what the workflow types are for them?
370 01:23:01.940 ⇒ 01:23:05.460 Mustafa Raja: Default folk, right?
371 01:23:05.460 ⇒ 01:23:08.529 Demilade Agboola: Yeah, so, like, Caitlin, or…
372 01:23:10.740 ⇒ 01:23:15.120 Mustafa Raja: Should I just, ask Nandika in this thread?
373 01:23:15.260 ⇒ 01:23:20.379 Demilade Agboola: Yeah, just bump it up to her and just ask, like, hey, how… what are the different workflow types?
374 01:23:20.590 ⇒ 01:23:23.590 Demilade Agboola: Or, like, can… I’m lately, sorry.
375 01:23:24.120 ⇒ 01:23:30.260 Demilade Agboola: Okay, can you go and explain, like, what, what did you… Cool.
376 01:23:30.500 ⇒ 01:23:33.230 Mustafa Raja: This is just the source that we’ll be getting it from.
377 01:23:36.590 ⇒ 01:23:39.600 Demilade Agboola: So there’s a workflow JSON and trigger type.
378 01:23:40.710 ⇒ 01:23:44.109 Demilade Agboola: What is in the workflow, JSON, please? Can I see that?
379 01:23:44.730 ⇒ 01:23:47.450 Mustafa Raja: That’s… that’s what we were looking into, no?
380 01:23:47.810 ⇒ 01:23:50.479 Demilade Agboola: Yeah, yeah, I just wanted to see if I can… I can’t remember what’s in there.
381 01:23:51.270 ⇒ 01:23:58.570 Mustafa Raja: Well, it’s integration… And stuff like that.
382 01:23:59.070 ⇒ 01:24:00.300 Demilade Agboola: Can you go up, please?
383 01:24:05.350 ⇒ 01:24:08.349 Demilade Agboola: I think… I think it’s more of integration ID.
384 01:24:09.890 ⇒ 01:24:11.090 Demilade Agboola: Or wait, I’m missing.
385 01:24:12.190 ⇒ 01:24:15.149 Mustafa Raja: I think you worked on that earlier, no?
386 01:24:15.150 ⇒ 01:24:16.250 Demilade Agboola: Yeah…
387 01:24:17.260 ⇒ 01:24:18.370 Mustafa Raja: It’s this one, no?
388 01:24:20.080 ⇒ 01:24:22.140 Demilade Agboola: I think so, but I can’t remember.
389 01:24:22.560 ⇒ 01:24:23.729 Demilade Agboola: At this point.
390 01:24:29.230 ⇒ 01:24:33.890 Demilade Agboola: Because I’m thinking… It’s like workflow start.
391 01:24:34.780 ⇒ 01:24:36.240 Demilade Agboola: Subtype action.
392 01:24:36.880 ⇒ 01:24:38.369 Demilade Agboola: Anything special, I agree.
393 01:24:43.270 ⇒ 01:24:45.970 Demilade Agboola: You can keep scrolling down in that… in that JSON.
394 01:24:50.310 ⇒ 01:24:51.240 Demilade Agboola: Hmm…
395 01:25:04.000 ⇒ 01:25:07.119 Demilade Agboola: Okay, can you open up that JSON? That workflow JSON, please?
396 01:25:27.430 ⇒ 01:25:31.250 Mustafa Raja: This is a lot of HTML, I think… let me remove this.
397 01:27:20.170 ⇒ 01:27:22.869 Mustafa Raja: So, should I just be asking them?
398 01:27:23.620 ⇒ 01:27:25.269 Mustafa Raja: What’s the idea of this?
399 01:27:25.800 ⇒ 01:27:35.129 Demilade Agboola: Let me see… Can we go back up to the definite reference? What triggers this king?
400 01:27:35.980 ⇒ 01:27:39.270 Demilade Agboola: Can you go back to the… no, can you go back to the doc that you were just looking at now?
401 01:27:41.940 ⇒ 01:27:44.810 Demilade Agboola: So, what’s your guys’ drive?
402 01:27:46.010 ⇒ 01:27:54.309 Demilade Agboola: Automation usage, cool. Breath of product usage across workflow categories. I think that’s just integration ID. Can we make it integration ID?
403 01:27:55.600 ⇒ 01:27:56.140 Demilade Agboola: Like, I think.
404 01:27:56.140 ⇒ 01:27:56.850 Mustafa Raja: Consumer.
405 01:27:56.850 ⇒ 01:28:01.399 Demilade Agboola: will, like, put stuff around, like, maybe Slack or HubSpot and all that stuff.
406 01:28:01.790 ⇒ 01:28:04.460 Demilade Agboola: I think that’s the core of what they want to see.
407 01:28:05.090 ⇒ 01:28:07.310 Mustafa Raja: Okay, variety of workflow types.
408 01:28:10.460 ⇒ 01:28:11.560 Mustafa Raja: Categories.
409 01:28:12.320 ⇒ 01:28:13.240 Mustafa Raja: Okay.
410 01:28:14.030 ⇒ 01:28:17.009 Mustafa Raja: Do you have query that built up… built this up?
411 01:28:19.860 ⇒ 01:28:20.520 Demilade Agboola: What’d say?
412 01:28:21.630 ⇒ 01:28:23.250 Mustafa Raja: Did you have the query that built this?
413 01:28:26.110 ⇒ 01:28:29.439 Mustafa Raja: If not, I can, get Cursor to replicate this.
414 01:28:29.710 ⇒ 01:28:36.239 Demilade Agboola: Yes, please. I can try and find it. If I can find it, I’ll get it across to you, but off the top of my head, I’m not sure I can remember.
415 01:28:37.220 ⇒ 01:28:40.350 Mustafa Raja: Yeah, let me just get a cursor to do this, then…
416 01:28:44.100 ⇒ 01:28:47.000 Mustafa Raja: Okay… so these two are good.
417 01:28:48.920 ⇒ 01:28:51.630 Mustafa Raja: And I guess the rest are good.
418 01:28:53.200 ⇒ 01:28:54.030 Mustafa Raja: What?
419 01:28:54.240 ⇒ 01:28:55.309 Mustafa Raja: Here goes this.
420 01:28:56.130 ⇒ 01:29:01.899 Mustafa Raja: Okay, one last one, and I guess then we should be good.
421 01:29:02.150 ⇒ 01:29:03.450 Mustafa Raja: Oh yeah, I’ve seen it.
422 01:29:04.300 ⇒ 01:29:05.400 Mustafa Raja: the query?
423 01:29:06.580 ⇒ 01:29:07.940 Mustafa Raja: Oh, thank you so much.
424 01:29:08.340 ⇒ 01:29:11.330 Mustafa Raja: Okay, so,
425 01:29:14.970 ⇒ 01:29:26.449 Mustafa Raja: So, for admin disconnecting an integration, right, so Nandiga said that, they delete the row if someone disconnects an integration, so there may not be a way to confirm that.
426 01:29:26.930 ⇒ 01:29:31.799 Mustafa Raja: But we can check in workflow versions, but this might be tricky, right?
427 01:29:31.960 ⇒ 01:29:42.230 Mustafa Raja: Cursor said that they not matches, the work, the warehouse raw deletion, no historical raw to join to.
428 01:29:44.160 ⇒ 01:29:49.350 Mustafa Raja: So we may need, app audit logs. Can I get your eyes on this?
429 01:29:51.320 ⇒ 01:29:52.629 Demilade Agboola: Okay, so I’m looking at it now, yeah.
430 01:29:54.110 ⇒ 01:30:03.019 Demilade Agboola: The… So I’m looking at what you’re trying to say now. So, basically… So this is… null. Okay.
431 01:30:04.630 ⇒ 01:30:07.980 Demilade Agboola: So, where your transist when it’s deleted?
432 01:30:11.980 ⇒ 01:30:13.439 Demilade Agboola: Can you hear me?
433 01:30:14.080 ⇒ 01:30:15.150 Mustafa Raja: Yeah, sorry?
434 01:30:15.360 ⇒ 01:30:16.529 Demilade Agboola: What are you trying to do now?
435 01:30:17.460 ⇒ 01:30:22.170 Mustafa Raja: So, let’s go into the document, right?
436 01:30:23.550 ⇒ 01:30:33.650 Mustafa Raja: So, admin disconnecting and integrating… I believe this is just checking if, if an integration was removed from a workflow, you know?
437 01:30:36.800 ⇒ 01:30:40.150 Mustafa Raja: Does that make sense? And wouldn’t…
438 01:30:40.150 ⇒ 01:30:42.449 Demilade Agboola: Can you show me that again?
439 01:30:43.080 ⇒ 01:30:44.180 Mustafa Raja: Yeah, it’s this…
440 01:31:01.580 ⇒ 01:31:03.730 Demilade Agboola: Ask around if we did it the wrong screen.
441 01:31:07.650 ⇒ 01:31:09.549 Demilade Agboola: Trying to think? I’m trying to think.
442 01:31:11.030 ⇒ 01:31:11.830 Mustafa Raja: Yeah.
443 01:31:12.740 ⇒ 01:31:17.140 Demilade Agboola: Is there a way we can compare workflows
444 01:31:18.370 ⇒ 01:31:23.769 Demilade Agboola: Within companies and see if the… if it’s missing a particular integration.
445 01:31:24.080 ⇒ 01:31:27.630 Mustafa Raja: Yeah, I think there is a way…
446 01:31:30.890 ⇒ 01:31:38.670 Mustafa Raja: Friday… I think submissions might have… Versions… foam version.
447 01:31:40.110 ⇒ 01:31:42.940 Mustafa Raja: Let’s take a deeper look into this.
448 01:31:46.690 ⇒ 01:31:48.520 Mustafa Raja: Query in current notebook.
449 01:31:52.730 ⇒ 01:31:53.820 Mustafa Raja: Almighty.
450 01:31:55.520 ⇒ 01:31:56.410 Mustafa Raja: Boom.
451 01:31:58.280 ⇒ 01:31:59.180 Mustafa Raja: Word.
452 01:32:02.910 ⇒ 01:32:04.049 Mustafa Raja: phone version.
453 01:32:07.740 ⇒ 01:32:09.430 Mustafa Raja: lost data…
454 01:32:48.740 ⇒ 01:32:50.190 Mustafa Raja: Commission and default.
455 01:32:58.690 ⇒ 01:32:59.470 Mustafa Raja: Sure, no.
456 01:34:11.120 ⇒ 01:34:13.350 Mustafa Raja: Prophones, hmm…
457 01:34:19.440 ⇒ 01:34:25.030 Mustafa Raja: I think this is just the… Input… For the submission?
458 01:34:35.450 ⇒ 01:34:42.469 Mustafa Raja: We are able to get form version, but I don’t know if we have JSON for the form… for the form version, you know?
459 01:34:43.700 ⇒ 01:34:46.219 Demilade Agboola: Is there any way we can compare…
460 01:34:50.240 ⇒ 01:34:52.820 Demilade Agboola: Previous versions of the same form.
461 01:34:54.700 ⇒ 01:34:56.659 Demilade Agboola: And see what’s changed.
462 01:34:57.070 ⇒ 01:34:58.100 Demilade Agboola: Do you get what I mean?
463 01:34:58.630 ⇒ 01:35:00.619 Mustafa Raja: Yeah, I get that.
464 01:35:01.710 ⇒ 01:35:07.369 Mustafa Raja: I’m just trying to see if we can even see multiple versions of the same form, you know?
465 01:35:07.370 ⇒ 01:35:08.120 Demilade Agboola: Okay.
466 01:35:16.940 ⇒ 01:35:23.250 Mustafa Raja: Revision number… okay, revision number… Revision number…
467 01:36:12.570 ⇒ 01:36:16.580 Mustafa Raja: Yeah, we are able to get the foam version.
468 01:36:18.460 ⇒ 01:36:22.739 Mustafa Raja: And this is… this… this, I believe, is the input.
469 01:36:25.680 ⇒ 01:36:27.840 Mustafa Raja: Hitting the option ID…
470 01:36:32.030 ⇒ 01:36:33.000 Mustafa Raja: Responses…
471 01:36:41.220 ⇒ 01:36:49.530 Mustafa Raja: I think they’re just, once a workflow updates, they just update the JSON blob, you know?
472 01:36:50.190 ⇒ 01:36:53.269 Mustafa Raja: We might have historical JSON blobs.
473 01:36:54.210 ⇒ 01:36:58.729 Mustafa Raja: If we do… We’ll have to ask them if we do or not.
474 01:36:59.390 ⇒ 01:37:03.690 Demilade Agboola: Okay, so, yeah, like, let’s just… cause the inside might be tricky, so let’s just ask that.
475 01:37:03.970 ⇒ 01:37:06.530 Demilade Agboola: have… can we ask, like, Nadica in the thread?
476 01:37:06.980 ⇒ 01:37:10.299 Demilade Agboola: Like, hey, do you keep previous versions?
477 01:37:10.800 ⇒ 01:37:12.150 Demilade Agboola: of forms?
478 01:37:16.410 ⇒ 01:37:18.849 Demilade Agboola: Cause we’re trying to do it, use it for the…
479 01:37:19.610 ⇒ 01:37:28.179 Mustafa Raja: I’m just going to say, once we update a workflow, do we keep the older version, or just update the workflow blob in the forms table?
480 01:37:30.570 ⇒ 01:37:32.209 Demilade Agboola: Yeah, yeah, fair enough.
481 01:37:33.710 ⇒ 01:37:36.530 Mustafa Raja: Once we did a workflow…
482 01:38:34.800 ⇒ 01:38:36.529 Mustafa Raja: Yeah, and this is clear enough, right?
483 01:38:37.210 ⇒ 01:38:41.519 Demilade Agboola: Also, do we keep the historical version, or do we just update the JSON?
484 01:38:43.510 ⇒ 01:38:45.740 Demilade Agboola: Yeah. Yeah, that’s clear.
485 01:38:46.210 ⇒ 01:38:54.149 Demilade Agboola: Also, try and add… just add this, that we want to see if we can find the changes in workflow.
486 01:38:54.300 ⇒ 01:38:58.020 Demilade Agboola: We want to use that to find the changes in… Workflow.
487 01:39:00.070 ⇒ 01:39:02.579 Demilade Agboola: We want to see if we can see the changes in workflow.
488 01:39:05.970 ⇒ 01:39:10.180 Demilade Agboola: It helps to, like, put why you’re doing it so that they can see that it’s important, yeah.
489 01:39:32.180 ⇒ 01:39:36.550 Mustafa Raja: I don’t think so, because form ID is unique and forms table, no?
490 01:39:39.050 ⇒ 01:39:40.939 Mustafa Raja: Do we have a workflow ID?
491 01:39:43.420 ⇒ 01:39:55.600 Mustafa Raja: Workflow name… Raw forms… ID… There’s no workflow ID.
492 01:39:57.440 ⇒ 01:40:04.619 Mustafa Raja: Workflow… See, it is… oh, we have one. But this is none.
493 01:40:06.440 ⇒ 01:40:07.960 Mustafa Raja: Over here…
494 01:40:25.460 ⇒ 01:40:28.269 Mustafa Raja: Okay, workflow ID is null for the whole table.
495 01:40:32.410 ⇒ 01:40:38.510 Mustafa Raja: And form is… form ID is unique code, so…
496 01:40:46.850 ⇒ 01:40:48.460 Mustafa Raja: I think,
497 01:40:51.390 ⇒ 01:41:05.120 Mustafa Raja: Should I reply here, if he can confirm that? Because, form ID is unique, and I believe they’re just updating the, JSON blob, since I am unable to find,
498 01:41:06.870 ⇒ 01:41:08.769 Mustafa Raja: Any other JSON.
499 01:41:09.350 ⇒ 01:41:17.100 Demilade Agboola: Let’s just say that, yeah, we can see that, but it appears that… There aren’t historical versions.
500 01:41:17.340 ⇒ 01:41:20.769 Demilade Agboola: And it just is the new version, or the current version that is there.
501 01:41:22.790 ⇒ 01:41:24.340 Demilade Agboola: Do you get… do you get what I mean?
502 01:41:24.780 ⇒ 01:41:25.470 Mustafa Raja: Sony?
503 01:41:25.900 ⇒ 01:41:32.210 Demilade Agboola: Just tell her that we can see that, but we can’t see the historical version, only what appears to be the latest version.
504 01:41:32.210 ⇒ 01:41:42.209 Mustafa Raja: I’ll just say that, in submissions, we can see form versions, but we are unable to retrieve forms of prior versions.
505 01:41:44.210 ⇒ 01:41:50.009 Demilade Agboola: Yeah, you can just say… all we can see appears to be the current versions, but we can’t see any historical versions of…
506 01:41:50.320 ⇒ 01:41:54.140 Mustafa Raja: I don’t… We can see,
507 01:42:10.540 ⇒ 01:42:27.010 Mustafa Raja: Mr. I can… Historic conversions… Whom’s even… I was using that.
508 01:42:34.140 ⇒ 01:42:37.599 Mustafa Raja: And I should add, could you double-check that first, right?
509 01:42:39.500 ⇒ 01:42:42.090 Demilade Agboola: I don’t think that’s necessary, just to have what we can see.
510 01:42:43.080 ⇒ 01:42:45.000 Demilade Agboola: We’ve already asked the question, so if…
511 01:42:47.530 ⇒ 01:42:51.670 Mustafa Raja: Yeah, I am just super careful when I’m communicating with client, I…
512 01:42:52.270 ⇒ 01:42:53.930 Mustafa Raja: I don’t want too much of those.
513 01:42:54.490 ⇒ 01:42:56.649 Demilade Agboola: Yeah, I understand, it’s a lot of pressure sometimes.
514 01:42:57.170 ⇒ 01:42:58.289 Mustafa Raja: Oh, yeah.
515 01:43:03.540 ⇒ 01:43:11.889 Mustafa Raja: Oh, okay, so she said that we will be able to get that soon, okay.
516 01:43:18.760 ⇒ 01:43:20.670 Mustafa Raja: Where is the trend in this?
517 01:43:42.080 ⇒ 01:43:49.160 Mustafa Raja: Okay, from here, this is blocked because of, Bosnog.
518 01:43:50.780 ⇒ 01:43:56.360 Mustafa Raja: Do you want to, let me start the document here.
519 01:44:10.220 ⇒ 01:44:11.170 Mustafa Raja: All the time.
520 01:44:12.990 ⇒ 01:44:13.840 Mustafa Raja: Data.
521 01:44:16.160 ⇒ 01:44:17.990 Mustafa Raja: Usually, generate the workflow.
522 01:44:21.930 ⇒ 01:44:22.690 Mustafa Raja: Boom.
523 01:44:25.030 ⇒ 01:44:26.160 Mustafa Raja: Book the meeting.
524 01:44:30.550 ⇒ 01:44:31.350 Mustafa Raja: Hmm.
525 01:44:51.120 ⇒ 01:44:51.920 Mustafa Raja: Oh, damn.
526 01:45:16.620 ⇒ 01:45:18.420 Mustafa Raja: this before onboarding.
527 01:45:19.420 ⇒ 01:45:21.599 Mustafa Raja: manage definitions from…
528 01:45:31.160 ⇒ 01:45:33.399 Mustafa Raja: What definition, definition, verification.
529 01:45:42.960 ⇒ 01:45:44.239 Mustafa Raja: This is confirmed.
530 01:45:56.850 ⇒ 01:45:58.159 Mustafa Raja: I’m doing a presentation.
531 01:46:01.110 ⇒ 01:46:01.830 Mustafa Raja: Okay.
532 01:46:12.200 ⇒ 01:46:13.300 Mustafa Raja: Beautiful shot.
533 01:47:01.400 ⇒ 01:47:03.240 Mustafa Raja: Okay, so…
534 01:47:07.770 ⇒ 01:47:10.379 Mustafa Raja: Can you take a look at the list I sent you?
535 01:47:13.260 ⇒ 01:47:15.669 Mustafa Raja: This is where we’re standing right now.
536 01:47:16.550 ⇒ 01:47:25.420 Demilade Agboola: Also, can you send the dashboard to the internal client default, and just say, like, Presenting.
537 01:47:25.420 ⇒ 01:47:26.190 Mustafa Raja: Pardon me.
538 01:47:26.630 ⇒ 01:47:27.260 Demilade Agboola: Yeah.
539 01:47:28.210 ⇒ 01:47:29.520 Mustafa Raja: Okay,
540 01:47:30.640 ⇒ 01:47:47.949 Mustafa Raja: I want to confirm with you, so we want, should I just add, right now, a customer filter, and filter based on, domains that are in, product data, since majority of these ones are coming from product data?
541 01:47:48.470 ⇒ 01:47:53.459 Demilade Agboola: Yes, please, but not domains. Can we, like, do, like, the account name or something?
542 01:47:55.870 ⇒ 01:47:57.339 Mustafa Raja: Okay, yeah, I can do that.
543 01:47:57.640 ⇒ 01:47:58.790 Demilade Agboola: Yeah, so that way…
544 01:47:58.790 ⇒ 01:47:59.950 Mustafa Raja: Can I ask, Guaido?
545 01:48:00.890 ⇒ 01:48:04.520 Demilade Agboola: I want us to be able to see… like…
546 01:48:04.920 ⇒ 01:48:13.120 Demilade Agboola: The total engagement, like, what’s going on with the user, as well as how long you can get to… can you scroll down a bit?
547 01:48:14.280 ⇒ 01:48:19.770 Demilade Agboola: as long as how long the days to renewal are due, so that they can easily start to see, hey.
548 01:48:20.100 ⇒ 01:48:23.210 Demilade Agboola: We’re very close to renewal to this client.
549 01:48:23.530 ⇒ 01:48:24.320 Demilade Agboola: And…
550 01:48:25.020 ⇒ 01:48:26.939 Mustafa Raja: Yeah, I want to add here that this…
551 01:48:26.940 ⇒ 01:48:27.490 Demilade Agboola: Thank you.
552 01:48:27.490 ⇒ 01:48:31.040 Mustafa Raja: This is… this is coming from, Salesforce.
553 01:48:31.190 ⇒ 01:48:34.059 Demilade Agboola: Yeah, I know. That’s what I’m trying to say. That’s why I wanted to be account name.
554 01:48:34.360 ⇒ 01:48:37.760 Demilade Agboola: So that everything changes. Do you get my point? Like, they can see, hey.
555 01:48:37.990 ⇒ 01:48:48.290 Demilade Agboola: the engagement type, like, the meeting time duration over the last couple of weeks has been reducing. We’re 3 weeks away from renewal. We need to get this number up. Like, do you get…
556 01:48:48.780 ⇒ 01:48:57.429 Mustafa Raja: Yeah, I get that. I’m just saying that, since we right now, are not matching the two, right? It’s not perfect.
557 01:48:57.430 ⇒ 01:49:02.010 Demilade Agboola: But we need to… like, my point is, I want the entire dashboard to change.
558 01:49:02.120 ⇒ 01:49:02.880 Demilade Agboola: together.
559 01:49:02.880 ⇒ 01:49:04.580 Mustafa Raja: Okay, yeah, yeah, yeah, that makes sense.
560 01:49:04.580 ⇒ 01:49:07.309 Demilade Agboola: Like, to the information that matters to these people.
561 01:49:08.130 ⇒ 01:49:11.990 Mustafa Raja: Okay. Yeah, it may not be perfect, but we might get to somewhere, yeah.
562 01:49:11.990 ⇒ 01:49:12.620 Demilade Agboola: Yeah.
563 01:49:14.170 ⇒ 01:49:24.470 Demilade Agboola: And then when we do what we can, we can then ask the question, hey, this is the… this is the join we’ve done so far. If we want to get 100% joined.
564 01:49:24.860 ⇒ 01:49:27.600 Demilade Agboola: We will need to do this, do you get my point? But we should.
565 01:49:27.600 ⇒ 01:49:28.000 Mustafa Raja: Yes.
566 01:49:28.000 ⇒ 01:49:32.670 Demilade Agboola: say we’re not going to do anything, or we will just do part of the graphs changing.
567 01:49:33.750 ⇒ 01:49:39.920 Demilade Agboola: when we can do everything and just be like, hey, if you want to have 100%, this is what we need to do. Do you get my point?
568 01:49:40.360 ⇒ 01:49:42.170 Mustafa Raja: Yeah, this makes sense.
569 01:49:45.640 ⇒ 01:49:49.040 Demilade Agboola: Alright, so just quickly do that, and then…
570 01:49:49.040 ⇒ 01:49:53.359 Mustafa Raja: Yeah, I’ll add those things, and then I’ll, I’ll ping in the internal channel.
571 01:49:53.360 ⇒ 01:49:54.399 Demilade Agboola: Alright, sounds good.
572 01:49:54.710 ⇒ 01:50:12.340 Mustafa Raja: One more thing, to enable the filter, do I need to also match the account with, with the domain in the, product data like we did, over here?
573 01:50:12.670 ⇒ 01:50:17.710 Demilade Agboola: Yes, once you match it, then you can now add Salesforce attribution, like.
574 01:50:18.360 ⇒ 01:50:28.410 Demilade Agboola: It recognizes that the Salesforce account is also the team name, or the team, and then you can put the account name across everywhere that you can use as a filter.
575 01:50:28.820 ⇒ 01:50:35.640 Mustafa Raja: Yeah, okay. And this would be left… left join, with the product data, right?
576 01:50:37.010 ⇒ 01:50:38.650 Demilade Agboola: Producted out with left join it.
577 01:50:40.460 ⇒ 01:50:41.109 Demilade Agboola: So it’s product.
578 01:50:41.110 ⇒ 01:50:41.900 Mustafa Raja: Sorry, we’re…
579 01:50:41.900 ⇒ 01:50:43.489 Demilade Agboola: join Salesforce data.
580 01:50:44.050 ⇒ 01:50:48.760 Mustafa Raja: Okay, so that means we might lose some of the companies in Salesforce, right?
581 01:50:50.920 ⇒ 01:50:52.880 Mustafa Raja: The ones that would not match.
582 01:50:52.880 ⇒ 01:50:53.700 Demilade Agboola: Yeah.
583 01:50:54.500 ⇒ 01:50:55.820 Mustafa Raja: And that’s okay, right?
584 01:50:55.820 ⇒ 01:50:56.959 Demilade Agboola: Yes, that is okay.
585 01:50:57.520 ⇒ 01:50:59.800 Mustafa Raja: Okay, yeah, I just wanted to confirm all of these.
586 01:50:59.970 ⇒ 01:51:01.600 Demilade Agboola: Alright, sounds fine. Sounds good.
587 01:51:01.600 ⇒ 01:51:10.990 Mustafa Raja: Okay, I guess, I guess, yeah, so to do for me is get the filter, and fix the workflow type, right?
588 01:51:12.110 ⇒ 01:51:16.240 Demilade Agboola: Yeah, that will be the next two things, or the next two things I want to do.
589 01:51:16.710 ⇒ 01:51:22.510 Mustafa Raja: Yeah, and then once Nandiga confirms, Which one?
590 01:51:23.040 ⇒ 01:51:31.530 Mustafa Raja: This one, I should be able to get that too. Okay, thank you so much. I think this, I think this is… this was really needed. Thank you.
591 01:51:31.940 ⇒ 01:51:34.329 Demilade Agboola: Alright, sounds good. Let’s let me know how it’s going.
592 01:51:34.750 ⇒ 01:51:36.940 Mustafa Raja: Yeah, yeah, I’ll keep you in loop.
593 01:51:37.160 ⇒ 01:51:38.200 Demilade Agboola: Thank you.
594 01:51:38.670 ⇒ 01:51:39.919 Mustafa Raja: Yeah, have a good day, bye.