GORILLA_SBNEGATIVEKEYWORDLIST() – Get advertising Brand negative keyword list

Sample Usage 🚨 Use ranges (e.g.A2:A1000) in your formula wherever possible for quicker results and to prevent Google from blocking your account for 24 hrs due to overloading their resources.  =GORILLA_SBNEGATIVEKEYWORDLIST(“TOY STORE”, “2023”, “US”) =GORILLA_SBNEGATIVEKEYWORDLIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) =GORILLA_SBNEGATIVEKEYWORDLIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”, “TOYSMALL-Manual Low Bid Exact”) Syntax Description Description: Get advertising Brand negative…

GORILLA_SBKEYWORDLIST() – Get advertising brand keyword list

Sample Usage =GORILLA_SBKEYWORDLIST(“TOY STORE”, “2023”, “US”) =GORILLA_SBKEYWORDLIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) =GORILLA_SBKEYWORDLIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”, “TOYSMALL-Manual Low Bid Exact”) Syntax Description Description: Get advertising brand keyword list Syntax: GORILLA_SBKEYWORDLIST(sellerId, [period], [marketplace], [campaign], [adgroup], [status], [hasSalesOnly], [start_date], [end_date], [header]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla account. MARKETPLACE…

GORILLA_SBGROUPLIST() – Get advertising Brand group list

Sample Usage =GORILLA_SBGROUPLIST(“TOY STORE”, “2023”) =GORILLA_SBGROUPLIST(“TOY STORE”, “2023”, “US”) =GORILLA_SBGROUPLIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) Syntax Description Description: Get advertising brand group list. Syntax: GORILLA_SBGROUPLIST(sellerId, [period], [marketplace], [campaign], [status], [hasSalesOnly], [start_date], [end_date], [header]) Seller ID – REQUIREDSeller account or Nickname to work with. STATUS – OPTIONALFilter by status. Status are: enabled, paused, archived, all but archived…

GORILLA_SBCAMPAIGNLIST() – Get advertising Brand campaign list

Sample Usage =GORILLA_SBCAMPAIGNLIST(“TOY STORE”, “2023”) =GORILLA_SBCAMPAIGNLIST(“TOY STORE”, “2023”, “US”) =GORILLA_SBCAMPAIGNLIST(“TOY STORE”, “2023”, “US”, “ENABLED”) Syntax Description Description: Get advertising brand campaign list Syntax: GORILLA_SBCAMPAIGNLIST(sellerId, [period], [marketplace], [status], [hasSalesOnly], [start_date], [end_date], [header]) Seller ID – REQUIREDSeller account or Nickname to work with. PERIOD – OPTIONALPredefined period to get ads data or use ‘custom’ to specify a…

GORILLA_ADCAMPAIGNLIST() – Get advertising campaign list

Sample Usage =GORILLA_ADCAMPAIGNLIST(“TOY STORE”, “2023”) =GORILLA_ADCAMPAIGNLIST(“TOY STORE”, “2023”, “US”) =GORILLA_ADCAMPAIGNLIST(“TOY STORE”, “2023”, “US”, “ENABLED”) Syntax Description Description: Get advertising campaign list. Syntax: GORILLA_ADCAMPAIGNLIST(sellerId, period, [marketplace], [status], [start_date], [end_date], [header]) Seller ID – REQUIREDSeller account or Nickname to work with. PERIOD – OPTIONALPredefined period to get ads data or use ‘custom’ to specify a start and…

GORILLA_ADGROUPLIST() – Get advertising group list

Sample Usage =GORILLA_ADGROUPLIST(“TOY STORE”, “2023”) =GORILLA_ADGROUPLIST(“TOY STORE”, “2023”, “US”) =GORILLA_ADGROUPLIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) Syntax Description Description: Get advertising group list. Syntax: GORILLA_ADGROUPLIST(sellerId, [period], [marketplace], [campaign], [status], [start_date], [end_date], [header]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla account. STATUS – OPTIONALFilter by status. Status are: enabled, paused, archived,…

GORILLA_ADKEYWORDLIST() – Get advertising keyword list

Sample Usage =GORILLA_ADKEYWORDLIST(“TOY STORE”, “2023”, “US”) =GORILLA_ADKEYWORDLIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) =GORILLA_ADKEYWORDLIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”, “TOYSMALL-Manual Low Bid Exact”) Syntax Description Description: Get advertising keyword list. Syntax: GORILLA_ADKEYWORDLIST(sellerId, [period], [marketplace], [campaign], [adgroup], [status], [start_date], [end_date], [header]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla account. MARKETPLACE – OPTIONALMarketplace…

GORILLA_ADPRODLIST() – Get advertising product list

Sample Usage =GORILLA_ADPRODLIST(“TOY STORE”, “2023”) =GORILLA_ADPRODLIST(“TOY STORE”, “2023”, “US”) =GORILLA_ADPRODLIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) Syntax Description Description: Get advertising product list. Syntax: GORILLA_ADPRODLIST(sellerId, [period], [marketplace], [status], [campaign], [adgroup], [start_date], [end_date], [header]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla account. MARKETPLACE – OPTIONALMarketplace country filter. Country codes are US,…