GORILLA_SDPRODLIST() – Get Sponsored Display product list

Sample Usage =GORILLA_SDPRODLIST(“TOY STORE”, “2023”) =GORILLA_SDPRODLIST(“TOY STORE”, “2023”, “US”) =GORILLA_SDPRODLIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) Syntax Description Description: Get Sponsored Display product list. Syntax: GORILLA_SDPRODLIST(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. Period Attributes: MARKETPLACE – OPTIONALMarketplace country filter….

GORILLA_SDGROUPLIST() – Get Sponsored Display group list

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

GORILLA_SDCAMPAIGNLIST() – Get Sponsored Display campaign list

Sample Usage =GORILLA_SDCAMPAIGNLIST(“TOY STORE”, “2023”) =GORILLA_SDCAMPAIGNLIST(“TOY STORE”, “2023”, “US”) =GORILLA_SDCAMPAIGNLIST(“TOY STORE”, “2023”, “US”, “ENABLED”) Syntax Description Description: Get Sponsored Display campaign list Syntax: GORILLA_SDCAMPAIGNLIST(sellerId, [period], [marketplace], [status], [hasSalesOnly], [start_date], [end_date], [header]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla account. PERIOD – OPTIONALPredefined period to get ads data or…

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. CAMPAIGN – OPTIONALInclude campaign to filter data by campaign. Use SBCAMPAIGNLIST to list…

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_SPCAMPAIGNLIST() – Get advertising campaign list

Sample Usage =GORILLA_SPCAMPAIGNLIST(“TOY STORE”, “2023”) =GORILLA_SPCAMPAIGNLIST(“TOY STORE”, “2023”, “US”) =GORILLA_SPCAMPAIGNLIST(“TOY STORE”, “2023”, “US”, “ENABLED”) Syntax Description Description: Get advertising campaign list. Syntax: GORILLA_SPCAMPAIGNLIST(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 start…

GORILLA_SPGROUPLIST() – Get advertising group list

Sample Usage =GORILLA_SPGROUPLIST(“TOY STORE”, “2023”) =GORILLA_SPGROUPLIST(“TOY STORE”, “2023”, “US”) =GORILLA_SPGROUPLIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) Syntax Description Description: Get advertising group list. Syntax: GORILLA_SPGROUPLIST(sellerId, [period], [marketplace], [campaign], [status], [hasSalesOnly], [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,…

GORILLA_SPKEYWORDLIST() – Get advertising keyword list

Sample Usage =GORILLA_SPKEYWORDLIST(“TOY STORE”, “2023”, “US”) =GORILLA_SPKEYWORDLIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) =GORILLA_SPKEYWORDLIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”, “TOYSMALL-Manual Low Bid Exact”) Syntax Description Description: Get advertising keyword list. Syntax: GORILLA_SPKEYWORDLIST(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 –…