Upload and download via API

[John]

I have requirements to delete keywords from AdWords accounts based on
an excel spreadsheet which contains a list of
account,adgroup,campaign, keywords. What would be best way to do this?
Does AdWords API accept an upload file like this for deleting
keywords?

Second question, when using ReportService, is xml is only format for a
download report? Is it possible to get an excel report like from the
Google AdWords user web interface?

Thanks,
John

[AdWords API Advisor]

Hi John,

Unfortunately there isn't the ability to upload a list of changes in a
spreadsheet directly via the API, you would need to write a program
that will parse the spreadsheet and make API calls to modify the
keywords. There are a number of client libraries available that make
it simpler to call API methods, which are listed here:
http://code.google.com/apis/adwords/docs/clients.html.

You may also want to investigate using the AdWords Editor, a free
program provided by Google that allows you to work with your AdWords
account. It supports the upload of CSV files, and this may be a
simpler way to achieve your goals. You can download it here:
http://www.google.com/intl/en/adwordseditor/.

At this time the report data can only be returned in XML format, but
thanks for letting us know about your interest in other formats.

Best,
- Eric Koleda, AdWords API Team

[michell...@schooloutfitters.com]

I have a similar question. I want to upload an excel spreadsheet with ad group and keyword bid changes. Does the API support this today? If so, what format does the spreadsheet require?

Thanks,

Michelle

[Josh Radcliff (AdWords API Team)]

Hi Michelle,

The API does not directly support importing from Excel. A better fit for that use case is the AdWords Editor or AdWords Scripts.

Cheers,

Josh, AdWords API Team

[Alessandro Improta]

I see Adwords Scripts allows you to upload .csv files directly from your google drive. Is it still the case that this kind of thing cannot be done through the API? If not, is there any kind of similar solution?

[Josh Radcliff (AdWords API Team)]

Hi,

The AdWords API doesn't specifically include uploads from CSV or Google Drive. However, you could certainly read a file in your application and use that data to construct your AdWords API requests. If your files are in Google Drive, then you can use the Google Drive API for the first step.

Thanks,

Josh, AdWords API Team