Re: Need advice on the right way to delete Campaigns.

2010-05-05 Thread AdWords API Advisor
Hi Bruce,

You can delete a campaign by setting its status to DELETED, but you
are correct that there is no way to completely remove a campaign from
your account.  As for how to handle name conflicts, we generally
recommend solution #1.  You don't need to add a timestamp to the
campaigns as they are being created, only as they are being deleted.
Having many deleted campaigns in your account will not impact the
performance of the AdWords API, and if you use the campaignStatuses
field of the CampaignSelector then you can can ensure that deleted
campaigns are not returned in your requests.

Best,
- Eric Koleda, AdWords API Team

On May 2, 5:31 pm, bruce bruce.job...@gmail.com wrote:
 After reading through the forum, I found there is no way to delete a
 campaign.  It can only be set to DELETED status, but it's a real
 deletion.  It doesn't allow us to create new campaigns with same name
 as deleted campaigns.  To accommodate, there are two choices to
 workaround:

 1. append a timestamp at end of each campaign name.  But the problem
 is we will end up putting millions of deleted campaigns in the system
 after a month of usage of API.  This would finally drag down the
 system performance.

 2. Never delete campaigns.  However, there is big performance
 penalty.  Before adding each new campaign, we have to query the API,
 to find out if that name is already used or not.  i.e. to add 10 new
 campaigns, we have to read all 5000 campaigns from API, make a
 comparison, then decide to add 3 campaigns as new, revive the other 7
 campaigns from DELETED pile.

 You may argue that we should keep a good record of which campaign
 names are used.  Yes, I can do that.  But that will create duplicate
 information about campaigns, and make the system much less reliable.
 Whenever those duplicate information becomes inconsistent (I believe
 experienced software people all found this happening frequently), it
 will create a mess / unnecessary bugs.

 Also, It seems Campaigns do not support cascade delete (to propagate
 the deletion to all elements within.)  Can this be added soon?  It
 would help a lot to maintain system consistency, and make programming
 easier.

 --
 =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
 Also find us on our blog and discussion 
 group:http://adwordsapi.blogspot.comhttp://groups.google.com/group/adwords-api
 =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

 You received this message because you are subscribed to the Google
 Groups AdWords API Forum group.
 To post to this group, send email to adwords-api@googlegroups.com
 To unsubscribe from this group, send email to
 adwords-api+unsubscr...@googlegroups.com
 For more options, visit this group 
 athttp://groups.google.com/group/adwords-api?hl=en

-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
http://adwordsapi.blogspot.com
http://groups.google.com/group/adwords-api
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups AdWords API Forum group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en


Need advice on the right way to delete Campaigns.

2010-05-03 Thread bruce
After reading through the forum, I found there is no way to delete a
campaign.  It can only be set to DELETED status, but it's a real
deletion.  It doesn't allow us to create new campaigns with same name
as deleted campaigns.  To accommodate, there are two choices to
workaround:

1. append a timestamp at end of each campaign name.  But the problem
is we will end up putting millions of deleted campaigns in the system
after a month of usage of API.  This would finally drag down the
system performance.

2. Never delete campaigns.  However, there is big performance
penalty.  Before adding each new campaign, we have to query the API,
to find out if that name is already used or not.  i.e. to add 10 new
campaigns, we have to read all 5000 campaigns from API, make a
comparison, then decide to add 3 campaigns as new, revive the other 7
campaigns from DELETED pile.

You may argue that we should keep a good record of which campaign
names are used.  Yes, I can do that.  But that will create duplicate
information about campaigns, and make the system much less reliable.
Whenever those duplicate information becomes inconsistent (I believe
experienced software people all found this happening frequently), it
will create a mess / unnecessary bugs.

Also, It seems Campaigns do not support cascade delete (to propagate
the deletion to all elements within.)  Can this be added soon?  It
would help a lot to maintain system consistency, and make programming
easier.

-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
http://adwordsapi.blogspot.com
http://groups.google.com/group/adwords-api
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups AdWords API Forum group.
To post to this group, send email to adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en