Multiple metrics reorts

[Gaurav Sildhankar]

How can i add multiple metrics report in account summary report  and also campaign wise

[Google Ads Scripts Forum Advisor]

Hi,

Thank you for reaching out to the Google Ads Scripts support team.

I would suggest that you refer to the Extending the report (optional) document to add additional metrics to your account summary report. Also, make sure to add the additional columns in the switch case present inside the “function format(column, value)” function. You can add select which campaign reports you want to export to the sheet by changing the below code

const query = `SELECT ${fields} FROM customer WHERE segments.date BETWEEN ${during}`;

with

const query = `SELECT ${fields} FROM campaign WHERE segments.date BETWEEN ${during} AND campaign.name = 'nameOfTheCampaign'`;

The above mentioned changes are based on the Source code of the Account Summary Report.

I hope this helps! Kindly get back to us if you still have any queries. 

This message is in relation to case "ref:!00D1U01174p.!5004Q02vDSgO:ref" (ADR-00246676)

Thanks,
 

Google Ads Scripts Team