Anyone know how to change timezone in cake marketing? Most network using cake right now, but I don't find to change the timezone on cake marketing.. It help me to analyze data because I can set the timezone same with the traffic sources.. In has offers we can do that easily..
Thanks..
THere is a timezone adjust for reporting on the admin side. But I don't think think anything available yet on the affiliate side.
Yeah as far as I know its only on admin side, to cope with that personally I just count my stats per day in the cake day, and them subtract it from traffic source spends on that day, even if the gap is 4-6 hours difference etc i just wait those hours then optimise my campaigns accordingly. This way it makes it simple because you don't double count stats as well
If you really want to you could just export the data from the click report in Cake and then timeshift to account for your difference in timezones. How you want to work with the data is up to you but I'm sure if you were doing things repeatedly you could automate a lot of it and make things easier.
To time shift for instance you can format the date column, set to category:custom -> d/mm/yyyy h:mm. The dates wont change but they are now represented in number for days since Jan 1990 or something like that (so will be numbers like ~40,000). To timeshift just make another column and set it to equal the original date column plus ±hours/24, so to shift forward by three hours for instance you would do =A2+0.125. Then, format that column to the same category as the original one. Presto 3 hour time shift. Now you could delete all data outside of whatever date and do whatever with it.
Or use MobAff Tracker that has timezone support 