GORILLA_SBSALESGROUPHIST() – Get Advertising Brand Sales Group History

Sample Usage =GORILLA_SBSALESGROUPHIST(“TOY STORE”, “2023”, “US”) =GORILLA_SBSALESGROUPHIST(“TOY STORE”, “2023”, “US”,”BOTTLESMALL”) =GORILLA_SBSALESGROUPHIST(“TOY STORE”, , “US”,”BOTTLESMALL”, ,”9″) Syntax Description Description: Get Advertising Brand Sales Group History Syntax: GORILLA_SBSALESGROUPHIST(sellerId, [period], [marketplace], [campaign], [adgroup], [datapoint], [days], [sort], [start_date], [end_date], [transpose], [header]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla account. DATAPOINT – OPTIONALReturn…

GORILLA_SBSALESGROUP() – Get total sales of advertised Brand group between any period

Sample Usage =GORILLA_SBSALESGROUP(“TOY STORE”, “2023”, “US”) =GORILLA_SBSALESGROUP(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) =GORILLA_SBSALESGROUP(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”, , ,”DUMP”) Syntax Description Description: Get total sales of advertised Brand group between any period Syntax: =GORILLA_SBSALESGROUP(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_SBSALESCAMPAIGNHIST() – Get Advertising Brand Sales Campaign History

Sample Usage =GORILLA_SBSALESCAMPAIGNHIST(“TOY STORE”, “2023”, “US”) =GORILLA_SBSALESCAMPAIGNHIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) =GORILLA_SBSALESCAMPAIGNHIST(“TOY STORE”, , “US”, “BOTTLESMALL”) Syntax Description Description: Get Advertising Brand Sales Campaign History Syntax: GORILLA_SBSALESCAMPAIGNHIST(sellerId, [period], [marketplace], [campaign], [datapoint], [days], [sort], [start_date], [end_date], [transpose], [header]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla account. DATAPOINT – OPTIONALReturn…

GORILLA_SBSALESCAMPAIGN() – Get total sales of advertised Brand campaigns between any period

Sample Usage =GORILLA_SBSALESCAMPAIGN(“TOY STORE”, “2023”, “US”) =GORILLA_SBSALESCAMPAIGN(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) =GORILLA_SBSALESCAMPAIGN(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”, ,”DUMP”) Syntax Description Description: Get total sales of advertised Brand campaigns between any period Syntax: GORILLA_SBSALESCAMPAIGN(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….

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_SBHIGHACOSKEYWORD() – Get Advertising Brand keyword with high acos

Sample Usage =GORILLA_SBHIGHACOSKEYWORD(“TOY STORE”, “2023”, “US”) =GORILLA_SBHIGHACOSKEYWORD(“TOY STORE”,”Last Month”,”US”, , , ,”SPEND”) =GORILLA_SBHIGHACOSKEYWORD(“TOY STORE”,”Last Month”,”US”, , , ,”SPEND”,”DUMP”) Syntax Description Description: Get Advertising Brand keyword with high acos Syntax: GORILLA_SBHIGHACOSKEYWORD(sellerId, [period], [marketplace], [prod], [campaign], [adgroup], [datapoint], [output], [start_date], [end_date], [header]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla account….

GORILLA_SBHIGHACOSGROUP() – Get Advertising Brand group with high acos

Sample Usage =GORILLA_SBHIGHACOSGROUP(“TOY STORE”, “2023”, “US”) =GORILLA_SBHIGHACOSGROUP(“TOY STORE”,”Last Month”,”US”, ,”SPEND”) =GORILLA_ADHIGHACOSGROUP(“TOY STORE”,”Last Month”,”US”,,”SPEND”) Syntax Description Description: Get Advertising Brand group with high acos Syntax: GORILLA_SBHIGHACOSGROUP(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…

GORILLA_SBHIGHACOSCAMPAIGN() – Get Advertising Brand campaign with high acos

Sample Usage =GORILLA_SBHIGHACOSCAMPAIGN(“TOY STORE”, “2023”, “US”) =GORILLA_SBHIGHACOSCAMPAIGN(“TOY STORE”,”Last Month”,”US”,”SPEND”) =GORILLA_SBHIGHACOSCAMPAIGN(“TOY STORE”,”Last Month”,”US”,”SPEND”,”DUMP”) Syntax Description Description: Get Advertising Brand campaign with high acos Syntax: =GORILLA_SBHIGHACOSCAMPAIGN(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,…

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

Sample Usage =GORILLA_SBNOSALESGROUP(“TOY STORE”, “2023”, “US”) =GORILLA_SBNOSALESGROUP(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) =GORILLA_SBNOSALESGROUP(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”, , ,”DUMP”) Syntax Description Description: Shows all ads Brand group that has clicks, but no sales Syntax: GORILLA_SBNOSALESGROUP(sellerId, [period], [marketplace], [campaign], [adgroup], [datapoint], [output], [start_date], [end_date], [header]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in…