Hey Guys, I've been entering in the media buyer's spend through the retool app into bigquery. It's working great but there is one thing to address. When the media buyers enter in Nitido's spend they do not use verticals. They just give a number. I was thinking the fix could be as simple as implementing a "Nitido" vertical into leadspedia but wanted to confirm because I am not sure how that part of the financials is used. Once that is addressed I can meet with all the media buyers and show them how to use the app.
@Brian Hirst , we can do that they break it down by Vertical, for Nitido so it works as is yeah ? Ask them and CR
Cam got back to me. Media buyers will enter in their Nitido spend by vertical as well.
That would be great way to demo and train , thanks Brian
https://www.loom.com/share/28a4f9b3f57144b4bab37ff36f924948?sid=1e413bc8-5aec-4431-8921-fb7d21fc5959
@Brian Hirst, great. This looks good and has @Zekarias Haile working on financials in new system. Once we see old financials with spend matching new financials with same spend submitted, we will start to roll this out soon. We need to get new BI financials pivioted into the old PG BI financial_details format so we can join new financials to the new tablles.
I was thinking about it and is there any benefit to putting the Nitido spend into specific verticals? If not it's just more entries for the media buyers. It's fine if you guys see a benefit to it, but if not, less entries=less opportunity for mistakes. Also, let me know when I can get with the media buyers to implement.
It makes sense from a financial and operating "line item" comparison versus a flag-based attribute on the table schema. I'm good with it, just need to teach MBs.
Works for me