Keep record of past query on each refresh
I'm trying to keep a record of the past 45 days average for a metric, and add to the record daily.
To be specific, For Google Ads I want to keep track of some keyword's 45 day average avg. position and record how they change over time by day. Column 1 would be a list of keywords, column 2 the past 45days avg pos. up to today, column 3 the past 45 days avg. pos up to tomorrow, etc.
Is it possible to do this through supermetrics without manual intervention?