![]() Throughout our conversation, we talk a lot about organizational design, and how to set your teams up for breaking down siloes and fostering experimentation. She also dives into the close interplay between product and marketing teams, particularly for product-led growth companies. We start today’s conversation by dissecting some of the messaging challenges facing horizontal products like both Airtable and Atlassian, and her tips for narrowing in on the right persona. She also sits on the board for MongoDB and Zendesk. Archana joined Airtable last year after 7 years at Atlassian, where she eventually became the company’s Head of Enterprise and Cloud Marketing. Today’s episode is with Archana Agrawal, CMO of Airtable, a low-code platform for building collaborative apps. You can email us questions directly at or follow us on Twitter /firstround and /brettberson As a former engineer-turned-marketer, Archana has an incredibly unique, data-driven perspective as a CMO. Today’s conversation is of course a must-listen for marketers, but folks all over the org chart at product-led growth companies will appreciate the insights from both Atlassian and Airtable. She explains how she oversees all the different marketing functions that report up to her as CMO, and the rituals she’s established for keeping the pulse on what most deserves her attention. ![]() There was another thread here that suggested a different approach for just summing FTE count which uses multiple lookups but it’s not very feasible given the scale.Today’s episode is with Archana Agrawal, CMO of Airtable, a low-code platform for building collaborative apps. I am just using this one as example - my true org chart will have 1,000 employees and 10s of levels so I need a way to do this that is repeatable. For example, for the CEO Breann Bedoya, the total should be $2.14M which is the sum of all the people in the departments underneath here (you can check this by going to the Departments tab and summing the total salaries across the 4 departments). ![]() The issue that I seem to be running into is that I need a column summing each of the different “levels” of the org chart otherwise salaries are not counted correctly. For Tawana, she has 4 direct reports whose sum is $420k total. Each of Bonnie’s 4 reports make $100k per year, so you can see that the rollup in column “Children – Total Salary” is $400k total. If helpful, I have already found a way to get the parent and children of each of the employees and I am able to roll-up the salaries for the direct reports. I need to be able to do this for many different levels – for example, I would also want to be able to know the salaries of all of Bonnie’s reports. Is this possible?įor example, I want for Tawana Muro in the org chart below I would want a column that has the salaries of everyone contained in the red box. I am looking to roll up the salaries for everyone who sits below a certain person in an org chart. I am working on an org chart built using the startup org chart template - my base is available here.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |