Start a new topic

DoubleClick Search - Wrong Year&Month Number on January 1st 2017

Hi, DS seems to return the wrong Year&Month number at the end of 2016 and specificly on January 1st 2017. This day is still the week 2016|52, but it actually is the month 2017|01. Supermetrics however returns this data as Year&Month 2016|01 (the wrong year).

Month Week (Mon-Sun) Impressions
2016|01 2016|52 245
2016|12 2016|48 2114
2016|12 2016|49 2531
2016|12 2016|50 2901
2016|12 2016|51 1896
2016|12 2016|52 1612
2017|01 2017|01 2511
2017|01 2017|02 2312

Can this be fixed? Query id = DztqJnMHSj9sM2HboMJI2fw7dlAKaV

Hi Team,

Lot of my friends also face the same issue as above. Any answers?

Hi Twan and JK,

we have asked Twan to share the sheet with us for investigation. Well get back to you on this asap.


-Supermetrics team

Hi Jouni,

I have already shared the sheet as soon as Mikael contacted me about it, which was 3 days ago. Below the url once again:

This seems to be just cached field definitions causing it, wait ten minutes or so and try again. If it doesn't work, delete the query and create it again and you should be good to go.


-Supermetrics Team


Hi Team,

Do you have any update on this? If am not mistaken, there is no solution here. 

do i need to share any documents privately to you? If yes can you send a small hello email to please? 


There was small bug causing that issue. It has been fixed a couple of weeks ago and it should behave normal, try to refresh all your DoubleClick Search queries, and if it doesn't do recreate the queries.


-Supermetrics Team

Login or Signup to post a comment