GORILLA_SBPERFORMKEYWORDHIST() – Get Advertising Brand Perform Keyword History

Sample Usage =GORILLA_SBPERFORMKEYWORDHIST(“TOY STORE”, “2023”, “US”) =GORILLA_SBPERFORMKEYWORDHIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) =GORILLA_SBPERFORMKEYWORDHIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) Syntax Description Description: Get Advertising Brand Perform Keyword History Syntax: GORILLA_SBPERFORMKEYWORDHIST(sellerId, [period], [marketplace], [keyword], [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…

GORILLA_SBPERFORMKEYWORD() – Get total perform of advertised Brand keyword between any period

Sample Usage =GORILLA_SBPERFORMKEYWORD(“TOY STORE”, “2023”, “US”) =GORILLA_SBPERFORMKEYWORD(“TOY STORE”, “2023”, “US”,”BOTTLESMALL”) =GORILLA_SBPERFORMKEYWORD(“TOY STORE”, “2023”, “US”,”BOTTLESMALL”, , , ,”DUMP”) Syntax Description Description: Get total perform of advertised Brand keyword between any period Syntax: =GORILLA_SBPERFORMKEYWORD(sellerId, [period], [marketplace], [keyword], [campaign], [adgroup], [datapoint], [output], [start_date], [end_date], [header]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your…

GORILLA_SBSPENDKEYWORDHIST() – Get Advertising Brand Spend Keyword History

Sample Usage =GORILLA_ADSPENDKEYWORDHIST(“TOY STORE”, “2023”) =GORILLA_ADSPENDKEYWORDHIST(“TOY STORE”, “2023”, “US”) ‘=GORILLA_SBSPENDKEYWORDHIST(“TOY STORE”, , “US”, “BOTTLESMALL”) Syntax Description Description: Advertising brand Spend Keyword History Syntax: GORILLA_SBSPENDKEYWORDHIST(sellerId, [period], [marketplace], [keyword], [campaign], [adgroup], [days], [sort], [start_date], [end_date], [transpose], [header]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla account. PERIOD – OPTIONALPredefined period to…

GORILLA_SBSPENDKEYWORD() – Get total advertising Brand spend of keywords between any period

Sample Usage =GORILLA_SBSPENDKEYWORD(“TOYSTORE”,”2023″,”US”) =GORILLA_SBSPENDKEYWORD(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) =GORILLA_SBSPENDKEYWORD(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”, , ,”DUMP”) Syntax Description Description: Get total advertising brand spend of keywords between any period Syntax: GORILLA_SBSPENDKEYWORD(sellerId, [period], [marketplace], [keyword], [campaign], [adgroup], [output], [start_date], [end_date], [header]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla account. PERIOD…

GORILLA_SBSALESKEYWORDHIST() – Get Advertising Brand Sales Keyword History

Sample Usage =GORILLA_SBSALESKEYWORDHIST(“TOY STORE”, “2023”, “US”) =GORILLA_SBSALESKEYWORDHIST(“TOY STORE”, “2023”, “US”,”BOTTLESMALL”) =GORILLA_SBSALESKEYWORDHIST(“TOY STORE”, , “US”,”BOTTLESMALL”) Syntax Description Description: Get Advertising Brand Sales Keyword History Syntax: GORILLA_SBSALESKEYWORDHIST(sellerId, [period], [marketplace], [keyword], [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. PERIOD – REQUIREDPredefined…

GORILLA_SBSALESKEYWORD() – Get total sales of advertised Brand keyword between any period

Sample Usage =GORILLA_SBSALESKEYWORD(“TOY STORE”, “2023”, “US”) =GORILLA_SBSALESKEYWORD(“TOY STORE”, “2023”, “US”,”BOTTLESMALL”) =GORILLA_SBSALESKEYWORD(“TOY STORE”, “2023”, “US”,”BOTTLESMALL”, , , ,”DUMP”) Syntax Description Description: Get total sales of advertised Brand keyword between any period Syntax: =GORILLA_SBSALESKEYWORD(sellerId, [period], [marketplace], [keyword], [campaign], [adgroup], [datapoint], [output], [start_date], [end_date], [header]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your…

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_SBORDERSKEYWORDHIST() – Get Advertising Order Brand Keyword History

Sample Usage =GORILLA_SBORDERSKEYWORDHIST(“TOY STORE”, “2023”, “US”) =GORILLA_SBORDERSKEYWORDHIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) =GORILLA_SBORDERSKEYWORDHIST(“TOY STORE”, , “US”, “BOTTLESMALL”) Syntax Description Description: Get Advertising Order Brand Keyword History Syntax: GORILLA_SBORDERSKEYWORDHIST(sellerId, [period], [marketplace], [keyword], [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. PERIOD…

GORILLA_SBORDERSKEYWORD() – Get total orders of advertised Brand keyword between any period

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_SBORDERSKEYWORD(“TOY STORE”, “2023”, “US”) =GORILLA_SBORDERSKEYWORD(“TOY STORE”, “2023”, “US”, , “BOTTLESMALL”) =GORILLA_SBORDERSKEYWORD(“TOY STORE”, “2023”, “US”, , “BOTTLESMALL”, , , , “DUMP”) Syntax Description Description: Get total…

GORILLA_SBNOSALESKEYWORD() – Shows all ads Brand keywords that has clicks, but no sales

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