Ads Script for auto Ads data report scheduling on email body

115 views

Skip to first unread message

ajay rawat

unread,

Mar 9, 2023, 4:53:39 AM3/9/23

to Google Ads Scripts Forum

Hi Folks,

need your help in creating and scheduling some of the daily reports on email from Google Ads.

need 2 reports - 1 with daily cost tracking and 2nd Auction insights - impression share%, this would be required for multiple child account for Desktop and mob both.

Sample: (OPEN IMAGE IN NEW TAB TO VIEW CLEAR)

Thank you so much in advance!

Regards,

Ajay Singh rawat

Google Ads Scripts Forum Advisor

unread,

Mar 10, 2023, 2:31:21 AM3/10/23

to adwords...@googlegroups.com

Hello Ajay,

Thanks for reaching out.

You can be able to schedule scripts in general by setting it in the Frequency tab. You may check this Ads help center article in order for you to do so, just kindly navigate to the topic Scheduling a script within the article.

That being said, I'd recommend checking our guide on Reporting so you're able to have information on how to create a report in Google Ads Scripts. It appears that you are aiming to create a report at the campaign level, which you may do so by using the campaign report type. Kindly see my insights on the metrics you're looking for:

In order to get the cost, you'd need to include the metric metrics.cost_micros; please take note that this is in micros and would need to be divided by 1000000.
For the auction insights impression share, you could use metrics.auction_insight_search_impression_share, however, if this is metric is not relevant to you, you could check the documentation on the campaign report type to check which metric from the Auction Insight report you're looking for.

Lastly, I would recommend to check the following as they are helpful links when creating the report:

campaign Query Builder - Helpful for building your query. You can make use of this in order to properly structure your filter for the campaigns you're looking for, as I have observed you're only looking to pull specific campaigns.
Query Validator - If you're building your query from scratch, this tool would help you validate if your query is properly structured.
exportToSheet(sheet) - If you'd like to export the results to an external sheet, kindly check this guide.

Let us know if you have any questions or clarifications.

Best regards,

Google Ads Scripts Team