Google ads script Kratu report

107 views
Skip to first unread message

Jeremi Boivin

unread,
Mar 14, 2023, 3:59:58 AM3/14/23
to Google Ads Scripts Forum
hi,

I've been trying to get this script to work for me: https://developers.google.com/google-ads/scripts-legacy/docs/solutions/adsmanagerapp-kratu

However, when I tweak the script as intended it will run without errors but it won't update any of the data. It can also only be run once it seems.

If someone can help me out, it'd be greatly appreciated!

Google Ads Scripts Forum Advisor

unread,
Mar 14, 2023, 9:37:26 AM3/14/23
to adwords...@googlegroups.com

Hi Jeremi,

 

Thanks for reaching out.

 

Would you be so kind as to provide the following information so we're able to further investigate your concern and assist you?:

  • Google Ads account ID
  • Name of the script in the account
  • Screenshot showing the issue
  • Shareable link of the spreadsheet the script is using (You may follow this guide under Share a file publicly)

 

You may send these privately via the Reply to author option. Note that you may need to join the Google Group for you to use this option. If this option is not available on your end still, you may send it through our email (googleadsscr...@google.com) instead.

 

Best regards,

 

Google Logo Google Ads Scripts Team


ref:_00D1U1174p._5004Q2jZNSb:ref

Google Ads Scripts Forum Advisor

unread,
Mar 15, 2023, 8:18:03 AM3/15/23
to adwords...@googlegroups.com

Hi Jeremi,

 

Thanks for providing the requested information. Kindly see my insights below.

 

  • API version, last 30 days setting, frequency of script

If you're aiming to use the latest API reporting version, you could instead comment out the line of code which has specified an API version. That said, if you're also aiming to set the report period to last 30 days, you can navigate to the spreadsheet's Settings tab and set the ReportPeriod on row 2 to LAST_30_DAYS. Row 3 is for how often the script will create new reports (in days -> 1=daily, 7=weekly, 30=monthly). With this, it's intended that the script will only create a report once if it's set daily. Once it has detected it has created a report, it will then wait for the next day to create a new report.

 

  • Clearing the sheet each run

It's stated in the source code of the script that it makes use of 2 spreadsheets: a main spreadsheet containing processing information, settings and a template for the reports, and another which is a report spreadsheet for each run (one loop over all accounts). This means that the main spreadsheet, which you've supplied in the script, will not get cleared as this is includes the configurations. This will simply log the history of each report run as well as the accounts that it has processed, but will never be cleared and will instead create a new report sheet which contains the report which is it's intended function to create a history of data. Each time a new report is generated, the script creates a report spreadsheet based on the template. All of the report files will be contained within the main spreadsheet's History tab along with the timestamps of it's execution which you may navigate to.

 

On that note, however, I will be raising this to our internal team for further investigation of the script's behaviour not logging any results. We'll get back the soonest we do receive a response with relevant feedback.

Message has been deleted
Message has been deleted
Message has been deleted

Google Ads Scripts Forum Advisor

unread,
Mar 21, 2023, 9:43:21 AM3/21/23
to adwords...@googlegroups.com

Hi Jeremi,

 

I'm afraid we don't have updates to share yet. I'll follow up and we'll get back the soonest we do receive a response with relevant information.

 

As an aside, I would like to inform you that I had to remove your message as it had contained private information. Kindly refrain from posting messages containing private information as this forum is public, moving forward. We are hoping for your kind understanding on this.

Message has been deleted

Google Ads Scripts Forum

unread,
Mar 30, 2023, 7:06:36 AM3/30/23
to Google Ads Scripts Forum
Reposting the last inquiry (https://groups.google.com/g/adwords-scripts/c/B9FL5i0-9yY) from the forum as it wasn't routed to our support queue.

Regards,
Google Ads Scripts Team

On Monday, March 27, 2023 at 9:38:28 PM UTC+8 jer...@aldrin.be wrote:
Hi,

I'm writing to check-in on the current progress. 
Regarding the message that had to be removed from the discussion, sorry for that, I was unaware of this.

Op di 21 mrt 2023 om 14:43 schreef Google Ads Scripts Forum on behalf of adsscripts <adwords...@googlegroups.com>:
--
-- You received this message because you are subscribed to the Google Groups AdWords Scripts Forum group. Please do not reply to this email. To post to this group or unsubscribe please visit https://developers.google.com/adwords/scripts/community.
---
You received this message because you are subscribed to a topic in the Google Groups "Google Ads Scripts Forum" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/adwords-scripts/B9FL5i0-9yY/unsubscribe.
To unsubscribe from this group and all its topics, send an email to adwords-scrip...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-scripts/M4O9q000000000000000000000000000000000000000000000RRVI3Z00cM3X47unQJuzwKTW5TW3zQ%40sfdc.net.

Google Ads Scripts Forum Advisor

unread,
Mar 30, 2023, 9:39:32 AM3/30/23
to adwords...@googlegroups.com

Hi Jeremi,

Unfortunately, your concern is still under investigation. Rest assured we'll update you as soon as we have information to share.

In addition, kindly refrain from sharing private information publicly on the forum. With that said, I have removed your previous message. We appreciate your understanding on this.

Regards,

Message has been deleted

Google Ads Scripts Forum Advisor

unread,
May 29, 2023, 3:20:41 AM5/29/23
to adwords...@googlegroups.com

Hi Jeremi,

 

I'm afraid we don't have any updates to share yet, however, rest assured that this issue is being investigated and monitored. I'll follow up and we'll get back once we receive a response with relevant information from our internal team.

 

Again, I would like to inform you that I had to remove your message as it had contained private information. Kindly refrain from posting messages containing private information as this forum is public, moving forward.

 

Best regards,

 

 

This message is in relation to case "ref:_00D1U1174p._5004Q2jZNSb:ref"

Thanks,

 
Google Logo Google Ads Scripts Team


Jeremi Boivin

unread,
Jun 21, 2023, 5:06:05 AM6/21/23
to Google Ads Scripts Forum
hello,

i'm following up, is this being worked on? the thread was opened in march.

Op maandag 29 mei 2023 om 09:20:41 UTC+2 schreef Google Ads Scripts Forum Advisor:

Google Ads Scripts Forum Advisor

unread,
Jun 22, 2023, 6:57:47 AM6/22/23
to adwords...@googlegroups.com
Hi Jeremi,

The issue is still under investigation. Rest assured we'll update this thread as soon as we have information to share.
Reply all
Reply to author
Forward
0 new messages