AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

Ads
4.5K members online now
4.5K members online now
Dive into advanced features like Remarketing, Flexible Bid Strategies, AdWords Editor, and AdWords Scripts
Guide Me
star_border
Reply

[Dynamic display ads] what is wrong with my feed?

[ Edited ]
Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi, 

As you can see in the link, https://docs.google.com/spreadsheets/d/1_AMsEShkIxDk6NqhDhuOR_frAA-f6Q0mx0KckTWNbAs/pubhtml

  1. In the first row, I have column names, one name for each column.
  2. In the following rows have proper values for the column name.
  3. When I'm done, go to File/Save as/Comma separated values, and save the file with a .csv extension.

But still Adwords is throwing out errors: 

  • One or more of your columns doesn't work with your data set or feed
  • One or more required columns is missing: Deal ID.
  • You'll need to specify at least one attribute column in order to upload a new data set or fee

Is it because I have left some columns ex) price, left blank? I simply do not want to put any value on them.

I've been struggling with this .csv format (even though I have posted the same kind question yesterday..)

Any advice would be highly appreciated!

 

1 Expert replyverified_user
1 ACCEPTED SOLUTION

Accepted Solutions
Marked as Best Answer.
Solution
Accepted by topic author April P
March 2017

Re: [Dynamic display ads] what is wrong with my feed?

[ Edited ]
Top Contributor
# 2
Top Contributor

(1) remove/delete all the lines beginning with a hash-tag (#), those are comments.

(2) the first line should be the header, only -- 13-columns across;

e.g.

Deal ID,Deal name,Final URL,Image URL,Subtitle,Description,Price,Sale price,Category,Contextual keywords,Address,Tracking template,Custom parameter


(3) each subsequent line is data, each line 13-columns across;

e.g.

tag-local-id-1,50% off at LocalGrocer,http://www.example.com/localgrocer?,http://www.example.com/localgrocer.jpg,Grocery deals,Save on your weekly bill,10 USD,5 USD,grocer;deals;savings,"1600 Amphitheatre Parkway,Mountain View,CA 94043",Food,http://redirect.com?url={lpurl}&vendor={_vendor}&city={_city}&src=google&device={device},{_vendor}=LocalGrocer;{_city}=nationwide


the data must be exactly as google defines in
their specification, under local-deals, here --
https://support.google.com/adwords/answer/6053288

 

any data that google does not define as required, may

be left missing from the data-lines -- simply be certain

that that data-cell is entirely empty (entirely blank);

the header should contain all 13-columns, used or not.

see also
https://support.google.com/adwords/topic/3122874

https://docs.google.com/spreadsheets/d/1IWOv-9bb0aV7C0GnUoiUOJhVSqdz0RXLPR7gKbvkDjA/edit?usp=sharing

 

 

View solution in original post

Marked as Best Answer.
Solution
Accepted by topic author April P
March 2017

Re: [Dynamic display ads] what is wrong with my feed?

[ Edited ]
Top Contributor
# 2
Top Contributor

(1) remove/delete all the lines beginning with a hash-tag (#), those are comments.

(2) the first line should be the header, only -- 13-columns across;

e.g.

Deal ID,Deal name,Final URL,Image URL,Subtitle,Description,Price,Sale price,Category,Contextual keywords,Address,Tracking template,Custom parameter


(3) each subsequent line is data, each line 13-columns across;

e.g.

tag-local-id-1,50% off at LocalGrocer,http://www.example.com/localgrocer?,http://www.example.com/localgrocer.jpg,Grocery deals,Save on your weekly bill,10 USD,5 USD,grocer;deals;savings,"1600 Amphitheatre Parkway,Mountain View,CA 94043",Food,http://redirect.com?url={lpurl}&vendor={_vendor}&city={_city}&src=google&device={device},{_vendor}=LocalGrocer;{_city}=nationwide


the data must be exactly as google defines in
their specification, under local-deals, here --
https://support.google.com/adwords/answer/6053288

 

any data that google does not define as required, may

be left missing from the data-lines -- simply be certain

that that data-cell is entirely empty (entirely blank);

the header should contain all 13-columns, used or not.

see also
https://support.google.com/adwords/topic/3122874

https://docs.google.com/spreadsheets/d/1IWOv-9bb0aV7C0GnUoiUOJhVSqdz0RXLPR7gKbvkDjA/edit?usp=sharing