- Duration: 27 min
- Platform: zoom
- Source: Read.ai 01JAZJ7RMHT752NPJVHTZYQWKF (https://app.read.ai/analytics/meetings/01JAZJ7RMHT752NPJVHTZYQWKF)
Transcript
[UNKNOWN_SPEAKER]: Hey guys. Hey, what’s up guys? Hello. [Michael Houck]: So let’s just quickly check in here. Yesterday we got some stuff done, which is good. And I think it sounds like we’re going to get some more stuff done today, which is also good. Sid, do you want to go first? Let me just pull up your stuff here. [Sid]: Where are we at with the follower growth tracking data? Yeah. Yeah. It’s 940 is in progress. I, I have a check for the, I’m like, I’m checking the data, which was imported. I see some entries were imported twice. So a questionnaire, I see that. Same, like the many follower counts, which are linked with multiple accounts. For example, let’s say the follower count is 13700. Then it is linked with two accounts. I mean, most of these records are linked with multiple accounts. That is something I was trying to debug. Why is that the case? Some just random numbers. They don’t they’re not in sequence. For example, if 13700 it is linked with two accounts, that’s fine. But the previous numbers, they are not linked. So just looking at the data that we have there. [Michael Houck]: And that table, what do you mean linked to two accounts, each row only has one date, one account and one follower count. [Sid]: I mean, there are two accounts in the account in the account growth table. [UNKNOWN_SPEAKER]: I don’t think so. [Michael Houck]: Let me give an example in the ledger. [Sid]: Yeah, at least that wasn’t that was important. 13708 is what I see. 13708 13694. Oh, wait, hold on. [Michael Houck]: Actually, I realized that in the Google Sheet, I don’t know if we have those IDs. [Sid]: Can you share your screen or something? Curious again. You you Yeah, sharing my screen. I hope it’s visible. So, for example, this was a query I ran, and I see that this record is… You don’t understand the data. [Michael Houck]: Multiple people can have the same amount of followers. Yeah, yeah, I get that. [Sid]: I mean, I got the point that it will ask multiple people. But when we are fetching in the API, it is getting records from other accounts also. So that is what I was seeing either an issue is this issue in the API or in the database. And then I understand the data. That’s not a problem. I’m trying to figure out where the problem is, where it is lying. Is it the API that is pulling wrong data? Or is it the data that is imported? So that’s what I’m seeing. I think once I find this, then it will be easier to fix. That’s, that’s what I’m working on right now. [Rafael Bruno]: Okay, I don’t think that the problem is on the data. Because at least for that table, the data is pretty simple. You have the account ID and the number of followers. [Sid]: Yeah, so the API then it’s also giving me results for different accounts. So that was, I mean, first I checked in the API, I didn’t, that was one thing. And then I saw that I moved to data. So the data that we have, so that’s why I just did like I was just sharing thoughts, but I’m still debugging. Most likely, I learned to change change something in the API, the data looks straightforward to me as well. But those are just thoughts what I was doing, like what I’m doing currently. [UNKNOWN_SPEAKER]: Okay. Um, okay. [Michael Houck]: What about the headshots? [Sid]: Headshots. So Rafael, I mean, we, we have, I mean, we want to plan it out, Rafael and Priswan. So we’ll have, I think I dropped a message yesterday. There was an update. Rafael, do you have any thoughts on that? How should we do it? [Rafael Bruno]: The headshots? Let me check here. I think that is wrong. Oh, I thought that you moved on that. But let’s move on. On Rizwan’s approach, you don’t need to create an API, you just need to execute a script to do that. [Sid]: Yeah, but even Rizwan is not sure, I mean Rizwan had some questions, so maybe shall we get on a call and finalize who is doing what, so that it’s clear for each one of us? [Rafael Bruno]: Okay. Basically, all that you need to do is, if I understood correctly, read all the photos on S3 and map them to the new folder. That’s what Rizwan is doing, right? [Sid]: That’s what he is doing. We just need to give them the ID from based on the new ID that he’ll be using to create the folder. So he’ll give us the folder. About the ID, this is simple. You just need to make a query on the accounts table and get the ID and the table ID and best because they will be built. Let me write the query here. I know I quoted the data so I know. I just learned. [UNKNOWN_SPEAKER]: Yeah. [Sid]: The point is like, should we get on the call to finalize who is doing what so that he knows what he wants, he has to do. And it is clear to all the three of us so that we don’t keep just chatting or talking about the same thing. Okay. Also confused yesterday. [Rafael Bruno]: OK. OK. [Michael Houck]: And then what about the referral earning data and payouts not being processed? Yeah, so I’m just waiting for Rafael to complete it. [Rafael Bruno]: This, I think that it will be better if I assume that task because I’m finishing that and I will make the payout. [Michael Houck]: I resend that one to you, Rafael. Okay, Sid, the other ones on your plate are 959, 665, and 935. Are any of those in progress or are they still to do? [Sid]: I’m just waiting for the 940 to be finished. After that, I think the rest three, I can finish them pretty quickly. [UNKNOWN_SPEAKER]: That’s straightforward. Okay. [Sid]: I mean, the 940 and these two are only the big time consuming, but I’ll finish them ASAP. And move to other tickets. Cool. [UNKNOWN_SPEAKER]: Sounds good. [Michael Houck]: Yeah, we definitely need to because I think if we look at what’s been done this sprint, we only have two things completed so far. They’re both extra small size. So we definitely need to make some progress on some of this other stuff. OK. Rafael, on your side, catch me up on the data issues with the wallet. Are we good there? OK. [Rafael Bruno]: About that, I finally was able to solve that. I have the scripts here. I just didn’t run the scripts yesterday because I was tired and I was afraid to make some mistakes. And today, I asked Sid to get the latest data from Airtable because I noticed that from TweetJoy, there was some modification on their table. I think it was something that we discussed before about Varun’s account. [Michael Houck]: And it changed the ledger. [Rafael Bruno]: And when I compare the data that we have on the thing that we migrated weeks ago, And the data that we have right now on the ledger, they are different. So for to be easy to fix the Twitjoy problem, it’s easier just to download the data from Airtable again and execute that script on this new data. [Michael Houck]: just Varun’s account? [UNKNOWN_SPEAKER]: I think it, yeah. [Rafael Bruno]: The other ones I can solve manually, but Varun’s account, it’s like $2,000 of difference. So it's... [Michael Houck]: Right, but I don't think we should make that change because if we make that change, it's gonna appear like TweetJoy has $2,000 of extra balance to spend when they don’t. They spent that money on Varun’s account. [Rafael Bruno]: Varun then does more. Yeah, that’s the issue. It’s like they spend, $9,000, but on our record, it's that they just spent $7,000. So I need those other $2,000 to make the balance correct. It's like they are missing $2,000 of charges. [Michael Houck]: In AWS or in Airtable? [Rafael Bruno]: Let me try to explain in another way. The data that we had in the past on Airtable showed that TweetJoy spent like $7,000, if I'm not mistaken, $7,000, but actually they spent $9,000. The other $2,000 were in Varun’s account. And right now, when I look at Airtable, TweetJoy has the full 9,000. But that data is not on the thing that we migrated with Airbyte. So I needed to migrate the ledger data again to get that difference. So TweetJoy’s account can have the correct balance. [Michael Houck]: This is because Varun’s engagements were split between two accounts. [UNKNOWN_SPEAKER]: right? Yeah. [Michael Houck]: Okay, so what is Tweetjoy’s correct wallet balance right now? [UNKNOWN_SPEAKER]: Let me check. [Rafael Bruno]: The thing that is running. On production says that 3Joy’s total chargers is about $9,000. No, no, no. Deposits. How much should they deposit? Deposits. [UNKNOWN_SPEAKER]: 9,000. [Michael Houck]: The difference between deposits and chargers is about $20. Sorry, I need to know what the amount of deposits they have made is that you have a record of [UNKNOWN_SPEAKER]: Okay. I will share the… I share on the channel. On where, sorry? On the channel, the conversation that we had. Okay, cool. [Rafael Bruno]: We have the same amount for deposits, so that deposit number is correct. [UNKNOWN_SPEAKER]: Yeah. [Michael Houck]: So do we need to change anything? It looks like we already have the correct number in there. [Rafael Bruno]: No, the deposits is correct. The charges is not correct. [Michael Houck]: Oh, I see what you’re saying. Charges, hold on, on my side. Have they, can you see how many charges they’ve made since the migration? [Rafael Bruno]: It says here $119 of chargers. [Michael Houck]: Okay, so 119 new dollars of charges? [UNKNOWN_SPEAKER]: Yeah. [Michael Houck]: Okay, so what I see in Airtable is that they have $9,038 in charges. [Rafael Bruno]: that is still less than the deposits. Let me check. Can you check again? In the deposits that they have on their table. Yeah, that’s what I’m looking at. [Michael Houck]: That’s where I got the number that’s the same as the number that you gave me. [Rafael Bruno]: That’s weird. I think that I have to look to investigate this if they had new deposits on Stripe that we didn’t put here on the table because there is no new deposits. [Michael Houck]: I already checked Stripe. I already checked it. I’m looking at all of their payments. [Rafael Bruno]: Yeah, I don’t see anything since the migration. So when I fix the wallet issue, they will have a negative balance because they spend more than they deposit. [Michael Houck]: No. You’re missing the point. What I’m saying is that the deposits are correct between both databases. This is why we should have done this faster. The deposits are correct. The charges, it sounds like, are also largely correct. So I’m disputing the idea that there is a big negative amount, which makes me concerned that there might be other issues with Amazon. Do you understand? It could be wrong, but what I’m seeing in Airtable very clearly is that when I look at all charges from TweetJoy, the number that I get is $9,038. When you add on the 119 that you get from since we migrated, that is very close to the 9172 number of deposits that they’ve made. So if there is a negative number, I guess it’d be a slight negative number, maybe, or it would be very, very close. [Rafael Bruno]: The thing is, this is the production data that I’m telling you. The data that I’m trying to migrate is not here. The data that I’m trying to migrate has that difference of money that… Right, right, right. [Michael Houck]: I understand that. And what I’m saying to you is that the data you’re trying to migrate sounds like it’s wrong. [Rafael Bruno]: Yeah, that’s the issue because it’s from the ledger, but not the corrected ledger. Because if I recall correctly, when I identified that we had a problem with Varun and Twitjoy, the ledger was in one state. When I checked again, like yesterday, the ledger was in another state. So it seems that the ledger changed. No? [Michael Houck]: No updates have been made to Airtable at all. I just checked. [Rafael Bruno]: There’s no new charges. There’s no new lines in the links table. Not like new lines, but modifying the user and the client account. [Michael Houck]: Sorry, I don’t understand because the data in the ledger looks corrupt. And the data in the production database looks correct. Both of them look correct. [Rafael Bruno]: So I don’t understand. The production database is correct because I fixed, I removed volumes, and I removed his account, his individual account. And I put that under TweetJoy. But the thing on, How can I explain this? The thing that is different is that when I try to get the data from the ledger, the number is not adding. It’s not the same. My idea, no. So we didn’t modify the ledger. As far as I know, why would we? [Michael Houck]: We have nothing to do in there. We’re not using it anymore. Even opened it until now. [UNKNOWN_SPEAKER]: Okay. [Rafael Bruno]: I have to check the script here again. [UNKNOWN_SPEAKER]: Well, okay. [Michael Houck]: If you run what you have set up, what would happen? [Rafael Bruno]: TweetJoy would have, instead of like 9,000 chargers, he would have like seven or 8,000 chargers. [Michael Houck]: Okay, that’s incorrect because they have 9,000 chargers. [UNKNOWN_SPEAKER]: Yeah. [Rafael Bruno]: And he is the only one who has this issue. The other users, they are all OK. Yeah. OK. [Michael Houck]: Well, we have to fix that before we run it then, I guess. Jesus. All right. What about everything else? [Rafael Bruno]: Where are we at with everything else? Besides that, the other activity related with engagements incorrectly marked as missed I’m almost finishing that. It’s just like two records that I need to update on the database. And then I can move that to done. In like under 30 minutes, I can get that done. And I will start the Stripe. I will continue the Stripe tasks today. OK. [Michael Houck]: Do we have any shot of getting some of this other stuff done this sprint? For a month, or are we going to have to move it to next sprint? [Rafael Bruno]: You meant the other activities on the to-do list. Yeah, maybe the XS and the S ones. But the medium ones, I don’t think so. They’re all small. [Michael Houck]: All of them are XS and S. Single one. [Rafael Bruno]: They’ve just been sitting there forever. Okay, after I finish those tasks, I can give you a better estimation. [UNKNOWN_SPEAKER]: Okay. [Michael Houck]: Sounds good. Let’s