Search Ads 360

Retrieve account's list of agency and advertiser IDs

 /** 
  
 * 
  
 Retrieves 
  
 a 
  
 list 
  
 of 
  
 all 
  
 the 
  
 agency 
  
 and 
  
 advertiser 
  
 IDs 
  
 that 
  
 the 
  
 Google 
  
 Account 
  
 * 
  
 has 
  
 permission 
  
 to 
  
 view 
 . 
  
 * 
  
 See 
 : 
  
 https 
 : 
 // 
 developers 
 . 
 google 
 . 
 com 
 / 
 google 
 - 
 ads 
 / 
 scripts 
 / 
 docs 
 / 
 features 
 / 
 third 
 - 
 party 
 - 
 apis 
 #refresh_token_grant 
  
 * 
  
 for 
  
 details 
  
 on 
  
 configuring 
  
 this 
  
 script 
 . 
  
 * 
  
 * 
  
 NOTE 
 : 
  
 This 
  
 script 
  
 also 
  
 requires 
  
 the 
  
 OAuth2 
  
 library 
  
 to 
  
 be 
  
 pasted 
  
 at 
  
 the 
  
 end 
 , 
  
 * 
  
 as 
  
 obtained 
  
 from 
  
 https 
 : 
 // 
 developers 
 . 
 google 
 . 
 com 
 / 
 google 
 - 
 ads 
 / 
 scripts 
 / 
 docs 
 / 
 examples 
 / 
 oauth20 
 - 
 library 
  
 */ 
 const 
  
 CLIENT_ID 
  
 = 
  
 'INSERT_CLIENT_ID' 
 ; 
 const 
  
 CLIENT_SECRET 
  
 = 
  
 'INSERT_CLIENT_SECRET' 
 ; 
 const 
  
 REFRESH_TOKEN 
  
 = 
  
 'INSERT_REFRESH_TOKEN' 
 ; 
 let 
  
 authUrlFetch 
 ; 
 // 
  
 Call 
  
 this 
  
 function 
  
 just 
  
 once 
 , 
  
 to 
  
 initialize 
  
 the 
  
 OAuth 
  
 client 
 . 
 function 
  
 initializeOAuthClient 
 () 
  
 { 
  
 if 
  
 ( 
 typeof 
  
 OAuth2 
  
 === 
  
 'undefined' 
 ) 
  
 { 
  
 const 
  
 libUrl 
  
 = 
  
 'https://developers.google.com/google-ads/scripts/docs/examples/oauth20-library' 
 ; 
  
 throw 
  
 Error 
 ( 
 'OAuth2 library not found. Please take a copy of the OAuth2 ' 
  
 + 
  
 'library from ' 
  
 + 
  
 libUrl 
  
 + 
  
 ' and append to the bottom of this script.' 
 ); 
  
 } 
  
 const 
  
 tokenUrl 
  
 = 
  
 'https://accounts.google.com/o/oauth2/token' 
 ; 
  
 const 
  
 scope 
  
 = 
  
 'https://www.googleapis.com/auth/doubleclicksearch' 
 ; 
  
 authUrlFetch 
  
 = 
  
 OAuth2 
 . 
 withRefreshToken 
 ( 
  
 tokenUrl 
 , 
  
 CLIENT_ID 
 , 
  
 CLIENT_SECRET 
 , 
  
 REFRESH_TOKEN 
 , 
  
 scope 
 ); 
 } 
 // 
  
 An 
  
 example 
  
 DS 
  
 request 
  
 - 
  
 taken 
  
 from 
 // 
  
 https 
 : 
 // 
 developers 
 . 
 google 
 . 
 com 
 / 
 search 
 - 
 ads 
 / 
 v2 
 / 
 how 
 - 
 tos 
 / 
 reporting 
 / 
 faq 
 const 
  
 body 
  
 = 
  
 { 
  
 reportType 
 : 
  
 'advertiser' 
 , 
  
 columns 
 : 
  
 [ 
  
 { 
 columnName 
 : 
  
 'agency' 
 }, 
  
 { 
 columnName 
 : 
  
 'agencyId' 
 }, 
  
 { 
 columnName 
 : 
  
 'advertiser' 
 }, 
  
 { 
 columnName 
 : 
  
 'advertiserId' 
 } 
  
 ], 
  
 statisticsCurrency 
 : 
  
 'usd' 
 }; 
 // 
  
 Request 
  
 an 
  
 Advertiser 
  
 report 
  
 and 
  
 return 
  
 the 
  
 resulting 
  
 report 
  
 object 
 . 
 function 
  
 generateSearchAds360AdvertiserReport 
 () 
  
 { 
  
 const 
  
 url 
  
 = 
  
 'https://www.googleapis.com/doubleclicksearch/v2/reports/generate' 
 ; 
  
 const 
  
 options 
  
 = 
  
 { 
  
 method 
 : 
  
 'POST' 
 , 
  
 contentType 
 : 
  
 'application/json' 
 , 
  
 payload 
 : 
  
 JSON 
 . 
 stringify 
 ( 
 body 
 ) 
  
 }; 
  
 const 
  
 response 
  
 = 
  
 authUrlFetch 
 . 
 fetch 
 ( 
 url 
 , 
  
 options 
 ); 
  
 // 
  
 For 
  
 now 
 , 
  
 just 
  
 log 
  
 the 
  
 generated 
  
 report 
  
 response 
 . 
  
 return 
  
 JSON 
 . 
 parse 
 ( 
 response 
 . 
 getContentText 
 ()); 
 } 
 // 
  
 Paste 
  
 in 
  
 OAuth2 
  
 library 
  
 here 
 , 
  
 from 
 : 
 // 
  
 https 
 : 
 // 
 developers 
 . 
 google 
 . 
 com 
 / 
 google 
 - 
 ads 
 / 
 scripts 
 / 
 docs 
 / 
 examples 
 / 
 oauth20 
 - 
 library 
Create a Mobile Website
View Site in Mobile | Classic
Share by: