Hello,
we run an agency and for every client we have a different base. The base is almost identical for every client. We now have access to the business plan, and we want to use a master base to consolidate the data from every client into one base, so that we can benchmark our performance as a whole, and dive deeper into every client if we wish.
We have a table called KPIs in every client base. The KPIs are always the same. For that reason I have created the same base in our master base, and I am now syncing data from master into each client base. We also have a projects table for every client, which includes 3 fields (primary metric, secondary metric, tertiary metric). These field are linked records from the KPI table. In the KPI table (for each client) we can then see how many times a KPI has been used for that client, and the overall uplift for a KPI with a client.
I want the same information to be shown in the KPI table in our master base, but then for all clients. I thought about creating a projects table in the master base, and using multi-source syncing to get all projects in there. This would include the metric fields, which I hoped would be linked to the KPI table. But this is not working as I expected.
I hope the above context explains what I am trying to achieve.
Anybody who knows how to do what I want with native Airtable functionality?
