Bing ads hourly data for one metric, clicks, not showing correctly in sheet. It is supposed to show hours across the column headers and dates down the rows with the clicks by hour shown. Instead, after the hours, you see dates along the column headers in addition to the dates appearing where they should at the beginning of each row and the data goes on a diagonal across the table. Screenshots of the query and result are attached. Looking forward to your help!
Hi - I'm also seeing something similar.
It looks like where I would expect an integer between 0 and 23 to be returned it's actually returning a date and an integer - shifting all columns over by 1.
It seems to occur when date and hour are used in the same data set