Hey all. A while ago I was asked to make a Looker Studio report that showed the difference, absolute and percentage, of various ad campaign metrics. Quickly realized doing that within Looker Studio would be impossible, so I went with the solution of a script that generates a "looker friendly" spreadsheet with all the comparisons pre-calculated. Within Looker Studio, I just use a few calculated fields to show the difference between {metric} and {metric -1 month}, all of which are headers in my source sheet. Anyways, it seems like every month, when I run my script and update the spreadsheet "database" table, the report breaks. Currently, every single 1 month comparison table is broken with a "can't connect to the underlying dataset" error, while my "3 month aggregate" comparison tables are just fine. Any insights?
LinkedIn
Twitter
