Hey guys,I spent the day trying to get my head around a moving average function. In my case I want to calculate the 7 day average of my Google Ads CPL (cost per lead) metric. I have daily data from Google Ads in my base along with all important metri...
Update:I created a field for "7-D Ad Spend" and one for "7-D Leads" in my main "Google Ads" base.Next I created a script that runs twice for each of those fields (4 in total):On entry creationOn entry updateThis is the script: let config = input.conf...
Thanks for this! I think I am getting closer now. First question I have is: Is this setup scaleable? Can I connect unlimited amounts of data entries (Google Ads days) to the reporter?I automated the import from Google Ads data via Make.com using a AP...
@AlliAlosa @TheTimeSavingCo Ok, I think I understand what you are trying to say. I am just thinking it is a lot to link isn't it? I mean this would mean creating a 30 day moving average requires me to link each record to the previous 29 days. Is that...
