Hi, I'm trying to find out if it's possible to let Supermetrics run the data query automatically once a month? And if so is it possible to alter the row in which the data will be imported?
it is possible to set a monthly trigger to your file. Please read more from here.
It is not possible to alter the row, but if you use "combine new results with old" under options in your query, it will keep the last results as long as you have a date related Split By value in your query to reference.
I'd like to add to this question. For example, if I want stats everyday refreshed at the end of the day, if I have "Combine New Results with Old", the output would be something like this?
2017-08-29 | <Stats For 8/29>
2017-08-30 | <Stats For 8/30>
2017-08-31 | <Stats For 8/31>
Meaning a new row is inserted when the query refreshes?