MCC Report to Google Sheet

[Low Hao]

Hi, currently I'm downloading the MCC report manually everyday from Google ads Report

If there possible i can make a script let the report auto update on Google Sheet instead of me manually download and copy paste to the Google Sheet I want?

Cheers

[Google Ads Scripts Forum Advisor]

Hi Low,

Thank you for reaching out to us.

With regard to your concern, you may utilize the campaign report for your use case. You may check this sample code on generating report via Google Ads Scripts.

Regards,

Teejay Wennie Google Ads Scripts Team

ref:_00D1U1174p._5004Q2Ys3OS:ref

[Low Hao]

Hi, is that possible you can help me with the script? because currently my JS skill is very beginner.

thank you

[Google Ads Scripts Forum Advisor]

Hello,

Thanks for getting back to us.

Since you're trying to mimic that said MCC report, you can check on guide first to iterate through the account hierarchy. Once the client account has been selected, you can refer to this sample code on generating report via Google Ads Scripts (as previously mentioned by Teejay).

Let us know if you encounter any errors during the implementation so our team can further assist you.

Regards,

Mark Kevin Google Ads Scripts Team

ref:_00D1U1174p._5004Q2Ys3OS:ref