AdWords
2K members online now
2K 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 exel report data forma issue

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Dear community,

I have downloaded Adwords report in Exel file and in a column Average Position and Cost where should be the general number, I got a date (jan.1 instead of 1.1).

 

How to convert date format in to a general number? The option formatting doesn't work as I got some number like this 42370... Please help. Thank you.

 

Best regards,

Damjan

2 Expert replyverified_user
1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by pankaj1782 (Top Contributor)
June 2016

Re: Adwords exel report data forma issue

Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭

Hi,

 

I have finally found the solution. I have downloaded file in XLSX format, and tha data are showen in text format as well.

 

Thank you.

 

Best regards,

Damjan

View solution in original post

Re: Adwords exel report data forma issue

Top Contributor
# 2
Top Contributor
Hello,

Can you share a screenshot for better understanding removing any personal info from there?

Pankaj

Re: Adwords exel report data forma issue

[ Edited ]
Visitor ✭ ✭ ✭
# 3
Visitor ✭ ✭ ✭

This is the situation:

Cost Avg. position
okt.25 1.feb
14.27 1.mar
13.sep 1.feb
dec.79 1.feb
15.50 1.feb
dec.27 1.feb
okt.59 1.jan
16.65 1.jan
dec.35 1.feb
okt.95 1.mar
nov.27 1.jan
dec.19 1.feb
jun.48 1.jan
jun.60 1.jan
14.35 1.mar
15.55 1.jan
13.00 1.jan
dec.38 1.apr
jun.83 1.jan
14.avg 1.feb
dec.68 1.jan
14.73 1.mar
nov.42 1.jan
jun.60 1.jan
jul.46 1.jan
okt.85 1.jan
305.18 1.feb
305.18 1.feb

Re: Adwords exel report data forma issue

Top Contributor
# 4
Top Contributor
Hi Damjan,

Not sure if this gonna work as I need to see file to find the solution. Tried changing it to Text format by selecting column and then right click > Format cells > Text?

For me files I am downloading are working fine.

Thanks
NEha
Neha Gupta, AdWordsTop Contributor Follow Me: My Blog | Twitter | Google+ | LinkedIn
Did you find any helpful responses or answers to your query ? If yes, please mark it as the ‘Best Answer’
Marked as Best Answer.
Solution
Accepted by pankaj1782 (Top Contributor)
June 2016

Re: Adwords exel report data forma issue

Visitor ✭ ✭ ✭
# 5
Visitor ✭ ✭ ✭

Hi,

 

I have finally found the solution. I have downloaded file in XLSX format, and tha data are showen in text format as well.

 

Thank you.

 

Best regards,

Damjan

Re: Adwords exel report data forma issue

Top Contributor
# 6
Top Contributor
sounds good.
Neha Gupta, AdWordsTop Contributor Follow Me: My Blog | Twitter | Google+ | LinkedIn
Did you find any helpful responses or answers to your query ? If yes, please mark it as the ‘Best Answer’