Experiments - Error

[Selina Poms]

Hi guys, 

I need your help. 

Here is my script. It should be set on MCC level and should show me all Experiments and their metrics. 

https://docs.google.com/spreadsheets/d/1-EoHpksNlxMShFgUJOG3N09kwAfoO__Cv3NG2dZ7mLQ/edit?usp=sharing

These are the errors: 

24.1.2025 14:38:28
Ga: Mapping for TrialService.Status not available. at processClientAccount (Code:72:9)
24.1.2025 14:38:29
Ga: Mapping for TrialService.Status not available. at processClientAccount (Code:72:9)
24.1.2025 14:38:30
Ga: Mapping for TrialService.Status not available. at processClientAccount (Code:72:9)
24.1.2025 14:38:31
Ga: Mapping for TrialService.Status not available. at processClientAccount (Code:72:9)
24.1.2025 14:38:33
Ga: Mapping for TrialService.Status not available. at processClientAccount (Code:72:9)
24.1.2025 14:38:33
Ga: Mapping for TrialService.Status not available. at processClientAccount (Code:72:9)
24.1.2025 14:38:35
Ga: Mapping for TrialService.Status not available. at processClientAccount (Code:72:9)
24.1.2025 14:38:36
Ga: Mapping for TrialService.Status not available. at processClientAccount (Code:72:9)
24.1.2025 14:38:36
Ga: Mapping for TrialService.Status not available. at processClientAccount (Code:72:9)
24.1.2025 14:38:37
Ga: Mapping for TrialService.Status not available. at processClientAccount (Code:72:9)
24.1.2025 14:38:39
Ga: Mapping for TrialService.Status not available. at processClientAccount (Code:72:9)
24.1.2025 14:38:40
Ga: Mapping for TrialService.Status not available. at processClientAccount (Code:72:9)
24.1.2025 14:38:40
Ga: Mapping for TrialService.Status not available. at processClientAccount (Code:72:9)
24.1.2025 14:38:42
Ga: Mapping for TrialService.Status not available. at processClientAccount (Code:72:9)
24.1.2025 14:38:42
Ga: Mapping for TrialService.Status not available. at processClientAccount (Code:72:9)
24.1.2025 14:38:20
Filtering accounts by 'Impressions' is no longer supported. The 'Impressions > 100' filter was not applied. To filter by 'Impressions', you must use account.getStatsFor(DATERANGE).getImpressions() or issue a separate AdsApp.search/report call.
24.1.2025 14:38:20
Restricting account stats to a date range is no longer supported, and the "forDateRange" call was not applied. To apply a date range, you must invoke the account.getStatsFor(DATERANGE) on each account, or issue a separate AdsApp.search/report call.
24.1.2025 14:38:20
Ordering accounts by 'Clicks' is no longer supported. The 'Clicks DESC' order by was not applied. To order by 'Clicks', you must use account.getStatsFor(DATERANGE).getClicks() or issue a separate AdsApp.search/report call.
24.1.2025 14:38:44
Ga: Mapping for TrialService.Status not available. at processClientAccount (Code:72:9)
24.1.2025 14:38:44
Ga: Mapping for TrialService.Status not available. at processClientAccount (Code:72:9)
24.1.2025 14:38:59
SyntaxError: Unexpected end of JSON input at JSON.parse (<anonymous>) at afterProcessAllClientAccounts (Code:36:21) at Object.<anonymous> (adsapp_compiled:20557:54)  

[Google Ads Scripts Forum Advisor]

Hi,

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

Upon reviewing the error "Mapping for TrialService.Status not available at processClientAccount (Code:72:9)", I would like to inform you to change the code at line 72 with the below snippet regarding the status. Regarding the other error messages on filtering and ordering, I recommend you to refer to the stats documentation for more information while retrieving the accounts from AdsManagerApp.accounts() instead of current conditions that are used.

.withCondition("Status = 'ACTIVE'")

Feel free to get back in case of any further issues.

 

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

Thanks,
 

Google Ads Scripts Team

Feedback
How was our support today?