You cannot get all fields within a single AdWords API report - some combinations of fields are not allowed. For instance, see the docs of ConversionTypeName <https://developers.google.com/adwords/api/docs/appendix/reports/campaign-performance-report#conversiontypename>, and clicks on "Not compatible with the following fields".
To get information into SQL Server, you may like to look in SSIS packages working with AdWords API. Do remember that the AdWords API version changes regularly, so check how often the package is updated. However, if you - Hate working with SSIS, or - Need informative error messages when something goes wrong, or - Need special processing for certain fields, like importing field "date" into a datetime column (the API sends a string), or strip percentage signs from certain fields (so you can import that into a numeric field), etc.etc. then you are probably better off writing a dedicated C# program. You could also look into AwReporting, an open source initiative by Google, but I don't think it connects with SQL Server, and I'm not sure whether fields can have preprocessing. But, in your case I recommend that you first determine which fields you really need. "All fields" is probably way too much, and if you don't need fields requiring special processing it could be easy. On Wednesday, December 6, 2017 at 10:34:29 AM UTC+1, Adword API User wrote: > > Hello All, > > I want to sync adwords campaigns_performance_report in sql server on > daily bases, i have developer token and ClientCustomerId. > > Is their any way to get all fields (120+) of campaigns_performance_report > using Adword API. > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog and Google+: https://googleadsdeveloper.blogspot.com/ https://plus.google.com/+GoogleAdsDevelopers/posts =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API Forum" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] 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 [email protected]. Visit this group at https://groups.google.com/group/adwords-api. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/fd3aa2d0-64ef-45e1-966d-2d9e56a77e2f%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
