GORILLA_SPUNITSGROUP() – Get total units of advertised group between any period

Sample Usage =GORILLA_SPUNITSGROUP(“TOY STORE”, “2023”) =GORILLA_SPUNITSGROUP(“TOY STORE”, “2023”, “US”) =GORILLA_SPUNITSGROUP(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) Syntax Description Description: Get total units of advertised group between any period. Syntax: GORILLA_SPUNITSGROUP(sellerId, period, [marketplace], [campaign], [adgroup], [datapoint], [output], [start_date], [end_date], [header]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla account. PERIOD – REQUIREDPredefined…

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_SPHIGHACOSCAMPAIGN() – Advertising campaign with high acos

Sample Usage =GORILLA_SPHIGHACOSCAMPAIGN(“TOY STORE”) =GORILLA_SPHIGHACOSCAMPAIGN(“TOY STORE”,”Last Month”,”US”) =GORILLA_SPHIGHACOSCAMPAIGN(“TOY STORE”,”Last Month”,”US”,”SPEND”) Syntax Description Description: Advertising campaign with high acos Syntax: GORILLA_SPHIGHACOSCAMPAIGN(sellerId, [period], [marketplace], [datapoint], [output], [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, CA, MX, BR, UK,…

GORILLA_SPHIGHACOSGROUP() – Advertising group with high acos

Sample Usage =GORILLA_SPHIGHACOSGROUP(“TOY STORE”) =GORILLA_SPHIGHACOSGROUP(“TOY STORE”,”Last Month”,”US”) =GORILLA_SPHIGHACOSGROUP(“TOY STORE”,”Last Month”,”US”,,”SPEND”) Syntax Description Description: Advertising group with high acos Syntax: GORILLA_SPHIGHACOSGROUP(sellerId, [period], [marketplace], [campaign], [datapoint], [output], [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, CA, MX, BR,…

GORILLA_SPHIGHACOSSEARCHTERM() – Advertising search term with high acos

Sample Usage =GORILLA_SPHIGHACOSSEARCHTERM(“TOY STORE”) =GORILLA_SPHIGHACOSSEARCHTERM(“TOY STORE”,”Last Month”,”US”) =GORILLA_SPHIGHACOSSEARCHTERM(“TOY STORE”,”Last Month”,”US”,B4:B215,,,”SPEND”) Syntax Description Description: Advertising campaign with high acos Syntax: GORILLA_SPHIGHACOSSEARCHTERM(sellerId, [period], [marketplace], [prod], [campaign], [adgroup], [datapoint], [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, CA, MX,…

GORILLA_SPNOSALESGROUP() – Shows all ads group that has clicks, but no sales

Sample Usage =GORILLA_SPNOSALESGROUP(“TOY STORE”) =GORILLA_SPNOSALESGROUP(“TOY STORE”,”Last Month”,”US”) =GORILLA_SPNOSALESGROUP(“TOY STORE”,”Last Month”,”US”,,,”SPEND”) Syntax Description Description: Shows all ads group that has clicks, but no sales Syntax: GORILLA_SPNOSALESGROUP(sellerId, [period], [marketplace], [campaign], [adgroup], [datapoint], [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…

GORILLA_SPNOSALESCAMPAIGN() – Shows all ads campaign that has clicks, but no sales

Sample Usage =GORILLA_SPNOSALESCAMPAIGN(“TOY STORE”) =GORILLA_SPNOSALESCAMPAIGN(“TOY STORE”,”Last Month”,”US”) =GORILLA_SPNOSALESCAMPAIGN(“TOY STORE”,”Last Month”,”US”,,”SPEND”) Syntax Description Description: Shows all ads campaign that has clicks, but no sales Syntax: GORILLA_SPNOSALESCAMPAIGN(sellerId, [period], [marketplace], [campaign], [datapoint], [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…

GORILLA_ADIDCONV() – Convert between any ad data ID to another ID in the Amazon system

Sample Usage =GORILLA_ADIDCONV(“TOY STORE”,”US”,B4:B386) =GORILLA_ADIDCONV(“TOY STORE”,”US”,B4:B639,”adgroup2adprod”) =GORILLA_ADIDCONV(“TOY STORE”,”US”,B4:B639,”adgroup2adprod”, “enabled”) Syntax Description Description: Convert between any ad data ID to another ID in the Amazon system. Syntax: GORILLA_ADIDCONV(sellerId, [marketplace], filter, [direction], [status], [header]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla account. MARKETPLACE – OPTIONALOPTIONAL-Marketplace country filter. Country codes are…

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 –…