GORILLA_SBUNITSKEYWORD() – Get total units of advertised Brand keyword between any period

Ads/PPC data is here! Ads/PPC data is here! Ads/PPC data is here! 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_SBUNITSKEYWORD(“TOY STORE”, “2023”, “US”) =GORILLA_SBUNITSKEYWORD(“TOY STORE”, “2023”, “US”, ,”BOTTLESMALL”) =GORILLA_SBUNITSKEYWORD(“TOY STORE”, “2023”, “US”,…

GORILLA_SPSPENDKEYWORDHIST() – Advertising Spend Keyword History

Sample Usage =GORILLA_SPSPENDKEYWORDHIST(“TOY STORE”, “2023”) =GORILLA_SPSPENDKEYWORDHIST(“TOY STORE”, “2023”, “US”) =GORILLA_SPSPENDKEYWORDHIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) Syntax Description Description: Advertising Spend Keyword History Syntax: GORILLA_SPSPENDKEYWORDHIST(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 get…

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

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

GORILLA_SPSALESKEYWORDHIST() – Advertising Sales Keyword History.

Sample Usage =GORILLA_SPSALESKEYWORDHIST(“TOY STORE”, “2023”) =GORILLA_SPSALESKEYWORDHIST(“TOY STORE”, “2023”, “US”) =GORILLA_SPSALESKEYWORDHIST(“TOY STORE”, “2023”, “US”, , , “BOTTLESMALL”) Syntax Description Description: Advertising Sales Keyword History. Syntax: GORILLA_SPSALESKEYWORDHIST(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_SPSALESKEYWORD() – Get total sales of advertised keyword between any period

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

GORILLA_SPORDERSKEYWORDHIST() – Advertising Order Keyword History

Sample Usage =GORILLA_SPORDERSKEYWORDHIST(“TOY STORE”, “2023”) =GORILLA_SPORDERSKEYWORDHIST(“TOY STORE”, “2023”, “US”) =GORILLA_SPORDERSKEYWORDHIST(“TOY STORE”, “2023”, “US”, , “BOTTLESMALL”) Syntax Description Description: Advertising Order Keyword History. Syntax: GORILLA_SPORDERSKEYWORDHIST(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 period…

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

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

GORILLA_SPUNITSKEYWORDHIST() – Advertising Units Keyword History

Sample Usage =GORILLA_SPUNITSKEYWORDHIST(“TOY STORE”, “2023”) =GORILLA_SPUNITSKEYWORDHIST(“TOY STORE”, “2023”, “US”) =GORILLA_SPUNITSKEYWORDHIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) Syntax Description Description: Advertising Units Keyword History. Syntax: GORILLA_SPUNITSKEYWORDHIST(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 – OPTIONALPredefined period to…

GORILLA_SPUNITSKEYWORD() – Get total units of advertised keyword between any period

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

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

Sample Usage =GORILLA_SPNOSALESKEYWORD(“TOY STORE”,”Last Month”,”US”) =GORILLA_SPNOSALESKEYWORD(“TOY STORE”,”Last Month”,”US”,B4:B215) =GORILLA_SPNOSALESKEYWORD(“TOY STORE”,”Last Month”,”US”,B4:B215,,,”SPEND”) Syntax Description Description: Shows all ads keywords that has clicks, but no sales Syntax: GORILLA_SPNOSALESKEYWORD(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….