I am creating a solution for an e-commerce company where we can run an overnight process to push new campaigns / ads and update / pause others depending on new items that come in or go out of stock.
We want a hands-off solution where the API can be called automatically from our SQL 2008 server. I have read a couple of posts where this has been done, but there is no real documentation on this. The idea I had was to compile the API interface project to run as an EXE or Service on the sql server. The SSIS job would run in two phases: Phase 1: Renew the campaign / Ad data in our database using a dedicated stored procedure. Phase 2: Run the API EXE and loop through each campaign in the table created in (1) and batch push all ads / keywords for that campaign to Adwords account. If we encounter an item out of stock then use the API to pause that item (if that's possible through API). Phase 3: Repeat for next campaign in table I did read in the documentation that there is a Service account you can apply for. Is this service account required for such an application? We have already registered for and received the standard API token. Thanks in advance, Jason Lorenti CopierSupplyStore -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 --- You received this message because you are subscribed to the Google Groups "AdWords API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.