This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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...
