Difficulty Retrieving Data for Specific Google Ads Campaign using Google Ads Scripts

189 views
Skip to first unread message

Miran Esfahani

unread,
Dec 27, 2023, 7:17:39 AM12/27/23
to Google Ads API and AdWords API Forum
I am encountering an issue with fetching data from on of my campaigns in Google Ads using Google Ads Scripts. While the script functions correctly for other campaigns, it consistently fails to retrieve data for this specific campaign.

Campaign Details:

The campaign is an active search campaign with three ad groups. Despite being active and having generated reportable data, the script does not fetch any data for this campaign.
The logs consistently show "No data found" when attempting to fetch data for that specific.

Issue Description:
The script is intended to pull data such as date, cost, conversions, and conversion value for the current month.
While it operates correctly for other campaigns and writes data to designated Google Sheets, it fails for this campaign.
Troubleshooting Attempts:

Ensured that the campaign name in the script exactly matches the one in Google Ads.
Confirmed that the script has the necessary permissions to access Google Sheets.
Modified the script for a broader date range and simplified data requests.
Created new sheets in Google Sheets to rule out potential sheet-specific issues.
Despite these troubleshooting steps, the script continues to show no data for that campaign. This issue seems to be isolated to this specific campaign.

I would appreciate your assistance in identifying why the script fails to fetch data for that campaign. 

Miran Esfahani

unread,
Dec 27, 2023, 12:45:12 PM12/27/23
to Google Ads Scripts Direct Support, adwor...@googlegroups.com
That can’t be right. Here’s a screenshot of the campaign and it’s live. It’s been live the entire time I’ve been working here. 



Sendt fra Outlook for iOS

Fra: Google Ads Scripts Direct Support <googleadsscr...@google.com>
Sendt: Wednesday, December 27, 2023 6:39:36 PM
Til: Miran Esfahani <miran.e...@felleskjopet.no>
Kopi: adwor...@googlegroups.com <adwor...@googlegroups.com>
Emne: RE: difficulty retrieving data for specific google ads campaign using google ads scripts
 
Hi, 

Thank you for getting back to us.

After reviewing your concern, I understand that you are getting No data found error messages. I would like to inform you that I have checked your script with name "DH_BRAND - Google Sheet" and I found there is no campaign exist with name "DH_BRAND" in your account from where you are trying to fetch the data. Please make sure to fetch the data from the existing campaigns.
 
This message is in relation to case "ref:!00D1U01174p.!5004Q02r3HJM:ref"

Thanks,
 
Google Logo Google Ads Scripts Team


Image.jpeg

Miran Esfahani

unread,
Dec 27, 2023, 1:30:00 PM12/27/23
to Google Ads Scripts Direct Support, adwor...@googlegroups.com
Oh my lord, I feel so stupid. Thanks for pointing that out 

Sendt fra Outlook for iOS

Fra: Google Ads Scripts Direct Support <googleadsscr...@google.com>
Sendt: Wednesday, December 27, 2023 7:23:41 PM
Emne: Re: difficulty retrieving data for specific google ads campaign using google ads scripts
 
Hi, 

Thank you for getting back to us.

I would like to inform you that I have checked your account and I would like to suggest you to use the campaign name "DH_ BRAND" instead of "DH_BRAND" in the script. 

I hope this helps. If the issue still persists, kindly get back to us.
Reply all
Reply to author
Forward
0 new messages