I am trying to link weekly data from Google Trends over a 10 year period. As the discussion here explains, weekly data can only be downloaded in a 5year window. This then can be merged with the aid of an overlapping week (see also here ). However, this does not work if the overlapping week has 0's. The advice is to enlarge the overlapping period. However, it is possible that even if one chosses, say, 1 year overlap, that year would still have (only) 0s.
It therefore becomes impossible to know what overlapping period to choose such that it does not include only 0s. Any suggestions?