AdWords
7.1K members online now
7.1K 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
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