Weekly Split (Mon-Sunday) Header Naming and Weekly Refresh for Facebook Ads
I'm trying to create a weekly refresh for 'Amount Spent' from campaigns on Facebook, split by Mon-Sun. I've ran into a few issues and have looked at the forum, but I'm not sure if there a is a solution.
In the screenshot, this is the data I am pulling in from Facebook. The two main problems I have is renaming the WeekISO header, I'd like it to show the date rather than the week. I have tried TIME_DIMENSION_FORMAT_m/d/Y in advanced settings - doesnt seem to work?
Secondly, I'd like to refresh this table every Monday 6am for the previous week, my understanding is this should be a scheduled refresh with the setting 'combine new results with old' is this correct?