AdWords
2K members online now
2K members online now
Get started with AdWords - learn the basics to get set up for success
Guide Me
star_border
Reply

excel not recognising adwords report format

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

hi there, 

 

I've downloaded my first search terms report and noticed that in two columns I have data which I cannot Sort. The Date cannot be formatted or sorted as well as the Cost and average CPC.

DAte is currently in this format and cost is shown with another character infront of it.

thanks 

Rod

Sep 6, 2016

and cost is in this format 

€0.66

1 Expert replyverified_user

Re: excel not recognising adwords report format

Rising Star
# 2
Rising Star

Hey Tony,

 

This isn't a lot of information but I will do my best to help based on what I know.

 

Date: If I input "Sep 6, 2016" as text into cell A1 then I can turn it into a standard (and sortable date) by using this formula in an adjacent cell =TEXT(A1,"mm/dd/yy")

 

Cost: There are a couple potential solutions for this:

  1. Delete the currency from all numbers by doing a find and replace (ctrl+h). Find "€" and replace with "".
  2. In an adjacent cell, try dividing the value of the cost by 1. This sometimes works by forcing excel to treat the value like a number.
Jim Vaillancourt, AdWords Rising Star, LinkedIn
Was my response helpful? If yes, please mark it as the ‘Best Answer.’ Learn how here.