AdWords
3.1K members online now
3.1K members online now
Use AdWords conversion tracking and reporting to measure your results. Have a question about Google Analytics? Post it here, on the Google Analytics Community!
Guide Me
star_border
Reply

Adwords Campaign Clicks cost Export

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi, 

 

I am exporting my adwords cost to excel as a CSV so that I can keep track of costs.  However when I export the date format is pretty funky and non standard such as Feb 21, 2017

 

Obviously this is a date format that excel cannot understand.  My question is how to I export in the correct date format or how do I change it in excel to the correct date format.  

 

Hope someone can help

1 Expert replyverified_user

Adwords Campaign Clicks cost Export

Top Contributor Alumni
# 2
Top Contributor Alumni

Good morning.

 

You cannot change how the date is formatted for an export. 

 

To change the format in the Excel spreadsheet, highlight the column, select the Format button, then Format Cells. From there, you have the option to change how the dates display.

 


Theresa
Google AdWords Top Contributor
*~*~*~*~*~*~*~*