Hi Deepesh, Please find my responses inline:
Which report type should be used to get the campaign level totals. I am trying to get the data in the format of headers -campaign_id|campaign_name|CLicks|Impressions|Cost|Conversions. Your best bet would be Campaign Performance Report <https://developers.google.com/adwords/api/docs/appendix/reports/campaign-performance-report>. For your reference, other report types are available in this <https://developers.google.com/adwords/api/docs/appendix/reports/all-reports> guide. I have tried to use "CAMPAIGN_PERFORMANCE_REPORT" but I get broken up information at a keyword level, but I am trying to pull the data at a campaign level. By 'broken up information at a keyword level', do you mean you are getting more rows than the number of campaigns you have? Please note that if you use segmentation <https://developers.google.com/adwords/api/docs/guides/reporting#segmentation>, you will have more than one row per campaign. Could you please reply back with your report definition? I also need to push the data to a database. In the API documentation, i get samples which will either print the results on my screen or it will create a file on my machine. is there a way where I can get the data in JSON to push it to the database. Unfortunately, the supported download formats <https://developers.google.com/adwords/api/docs/guides/reporting#supported_download_formats> do not contain JSON but, you may handle conversion at your end, in your code, for example, by using csv.DictReader in python. I have 7 accounts on my MCC account as of now, the number will increase in the coming days. I don't want to manually hard code the client customer ids into my code as there will be new accounts which will be created. is there a way where I can get the list of client customer ids which are on my MCC ac Sure, the get_account_hierarchy <https://github.com/googleads/googleads-python-lib/blob/master/examples/adwords/v201710/account_management/get_account_hierarchy.py> sample code will give you a list of all accounts directly under your MCC id and the parallel_report_download <https://github.com/googleads/googleads-python-lib/blob/master/examples/adwords/v201710/reporting/parallel_report_download.py> sample code will let you download reports in parallel for every account under a MCC. Just be sure to run it against the MCC clientCustomerId. Also, you may find this <https://developers.google.com/adwords/api/docs/guides/reporting> documentation on Reporting Basics handy. Please let me know if you have further questions. Regards, Dhanya, AdWords API Team -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/c90ee5e6-9d01-474a-9ef3-9f00a1f408d8%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
