15 marketers and 1 LookML developer use Looker at our digital ads agency in Japan. Each marketer gives his/her client (Advertiser) access to a dashboard which shows ads performance of various media, such as Google Ads and Facebook Ads.
The LookML developer has defined every field so far, but it’s getting harder to deal with requests from marketers since they need a lot of custom measures & dimensions promptly to meet clients’ demand, so we think on 4 options.
I believe option No. 1 is the most straightforward approach. Shouldn’t we adopt option No. 2 to maintain data governance? I now startup the development center in Vietnam, so I’d like to consider option No. 3 & 4 as well.
Does anyone face a similar situation and have knowledge for a better project structure? Sharing your success/failure story is also appreciated.
Thank you!