Allow formulas to be used in the backend. We use this currently in supermetrics so we can have a template sheet where stakeholders can enter in filters (dates, campaign names) etc.
Currently Datastudio overwrites all the query parameters in the back end with RAW text.
Checking in, is there a planned schedule for this?
Hi there! Thanks for the follow-up. This is planned for this year, we will notify it once done.
Hello, I think that the request is to allow formulas on DataslayerQueries configuration cells. For example, the date cells could refer to values of other sheets. Currently, if I add a formula on those cells, it gets overwritten when the query refreshes.
Exactly. Once we build a template in Google Sheets, we often only need to change the campaign name.
We also use formulas in the filter column or have specific date requirements or want to control which dimensions are looked it via formulas. Please see the refer to column AA in:
docs.google.com/spreadsheets/d/1-hfKOdF1RPPFxNBirQtSpd3MjBtRkKOBzELqF7a1Kz4/edit#gid=1162887409 using the dataslayer@atomic email address
I have looked at the sheet and it is not very clear to us what exactly you mean when you say allow formulas in the backend.
Can you share a video or a more specific example?
Sorry for the inconvenience
Please find an example in this sheet under data tab: docs.google.com/spreadsheets/d/1-hfKOdF1RPPFxNBirQtSpd3MjBtRkKOBzELqF7a1Kz4/edit#gid=1162887409