Hi Zweitze, I appreciate your helpful response. However, I've already been down the Google scripts path, and do use it for various purposes. Part of the reason for using the API is here is to do something simple with the API, because we have much more demanding applications in the works - campaign budget control etc. A number of the custom reporting and campaign control scrips we're building go beyond what can be done do scripts. So part of the reason for doing this is to get the API working, data flowing, and to familiarize more with the API.
Thanks again - Steve On Wednesday, November 6, 2019 at 1:38:27 AM UTC-8, Zweitze wrote: > > You may want to consider Google Ads Scripts, combined with Google Sheets. > I do assume that you can find some solution for FileMaker and Google Sheets? > > I am pretty sure that ready-made Ads scripts are available to generate a > Google Ads report and save the results in a sheet, which you can process > further after moving that sheet to FileMaker. > Otherwise, you may find a way to move data from FileMaker to Google > Sheets. Then you may find a script that changes the Google Ads account > accordingly. > > Hope this helps. > > > On Tuesday, November 5, 2019 at 3:16:31 PM UTC+1, Steve Bell wrote: >> >> Hello Google Ads API Group: >> >> We were approved to utilize the Google Ads API in order to create >> reports, and manage campaigns through the API. We're looking at building, >> or at least prototyping some of our internal solutions using Filemaker 18. >> My two questions related to that are: >> >> 1) I don't find much after searching google, youtube, this group, and the >> Google Ads scripting group for "google ads api filemaker". If you take >> "ads" out of my search query, there plenty of solutions are out there for >> getting Filemaker to talk to generic Google (Gmail, etc) accounts - to do >> things like get contacts and appointments. But for paid Google Ads >> accounts, using the API it is slim pickings. So would much appreciate info >> from anyone knows whether this is "a thing", perhaps off in some obscure >> Filemaker shop or app(s). >> >> I do find generic API solutions, e.g. cdata, Supermetrics etc but - those >> are more generic middleware services which connect to the API; the cost of >> using them is proportional to the quantity of data through them - hundreds >> per month and up. Surely that isn't needed, just to get data out of the >> API which isn't much more than what can be exported manually in csv format; >> wouldn't make sense. >> >> Anyway I'm not looking for paid monthly solutions that do the OAuth or >> data warehousing. Our solutions are fairly simple, at least inititally - >> automated/API versions of what can be done manually either within Google >> Ads, using simple scripts, or manual daily exports and Excel. We want to >> start by automating those manual tasks in Filemaker, to run once/day, for >> the learning curve before we try anything more complex; and to save time on >> reporting. We might need to purchase a module to do the Oauth >> authentication, or something like that - looks like it can be tricky from >> what i've read - but we don't want an expensive recurring paid service, >> just to get started. >> >> 2) I have a CS Education but haven't coded for years, and don't know the >> best way to approach learning about the API, short of the dreaded RTFM :) >> -- (the Google Ads API spec, yes i will study that) what is the best way to >> gain a better understanding of this? If you can point me at any books, >> YouTube videos, or online resources which might be particularly helpful, >> i'd appreciate it. I'm a marketer (digital advertising) technical oriented >> business person; however i do am an EE/Masters in CS, and enjoy messing >> around with scripting languages, etc - i'm technically oriented but not a >> developer. Or, as a software professional might say, "a total hack" :) >> >> Thanks in advance for info &/or suggestions -- >> >> Steve B. >> Blastoff Labs, Reno NV >> linkedin.com/in/sbell22 >> blastofflabs.com >> > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads 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 and Google Ads API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/38c83874-3f92-430b-9040-b3e03de96fbc%40googlegroups.com.
