GORILLA_SPSPENDPRODHIST() – Advertising Spend Product History

Sample Usage =GORILLA_SPSPENDPRODHIST(“TOY STORE”, “2023”) =GORILLA_SPSPENDPRODHIST(“TOY STORE”, “2023”, “US”, $A$1:$A$100) =GORILLA_SPSPENDPRODHIST(“TOY STORE”, “2023”, “US”, $A$1:$A$1000, “BOTTLESMALL”) Syntax Description Description: Advertising Spend Product History. Syntax: GORILLA_SPSPENDPRODHIST(sellerId, [period], [marketplace], [prod], [days], [sort], [start_date], [end_date], [transpose], [header]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla account. PROD – OPTIONALSKU or ASIN to…

GORILLA_SPSPENDPROD() – Get total advertising spend of product between any period

Sample Usage =GORILLA_SPSPENDPROD(“TOY STORE”, “2023”) =GORILLA_SPSPENDPROD(“TOY STORE”, “2023”, “US”, $A$1:$A$100) =GORILLA_SPSPENDPROD(“TOY STORE”, “2023”, “US”, $A$1:$A$1000, “BOTTLESMALL”) Syntax Description Description: Get total advertising spend of product between any period. Syntax: GORILLA_SPSPENDPROD(sellerId, [period], [marketplace], [prod], [campaign], [adgroup], [start_date], [end_date]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla account. PROD – OPTIONALSKU…

GORILLA_SPSALESPRODHIST() – Advertising Sales Product History

Sample Usage =GORILLA_SPSALESPRODHIST(“TOY STORE”, “2023”) =GORILLA_SPSALESPRODHIST(“TOY STORE”, “2023”, “US”, $A$1:$A$100) =GORILLA_SPSALESPRODHIST(“TOY STORE”, “2023”, “US”, $A$1:$A$1000, “BOTTLESMALL”) Syntax Description Description: Advertising Sales Product History. Syntax: GORILLA_SPSALESPRODHIST(sellerId, [period], [marketplace], [prod], [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. PROD – OPTIONALSKU…

GORILLA_SPSALESPROD() – Get total sales of advertised products between any period

Sample Usage =GORILLA_SPSALESPROD(“TOY STORE”, “2023”) =GORILLA_SPSALESPROD(“TOY STORE”, “2023”, “US”, $A$1:$A$100) =GORILLA_SPSALESPROD(“TOY STORE”, “2023”, “US”, $A$1:$A$1000, “BOTTLESMALL”) Syntax Description Description: Get total sales of advertised products between any period. Syntax: GORILLA_SPSALESPROD(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. PROD…

GORILLA_SPORDERSPRODHIST() – Advertising Orders Product History

Sample Usage =GORILLA_SPORDERSPRODHIST(“TOY STORE”, “2023”) =GORILLA_SPORDERSPRODHIST(“TOY STORE”, “2023”, “US”, $A$1:$A$100) =GORILLA_SPORDERSPRODHIST(“TOY STORE”, “2023”, “US”, $A$1:$A$1000, “BOTTLESMALL”) Syntax Description Description: Advertising Orders Product History. Syntax: GORILLA_SPORDERSPRODHIST(sellerId, [period], [marketplace], [prod], [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_SPORDERSPROD() – Get total orders of advertised products between any period

Sample Usage =GORILLA_SPORDERSPROD(“TOY STORE”, “2023”) =GORILLA_SPORDERSPROD(“TOY STORE”, “2023”, “US”, $A$1:$A$100) =GORILLA_SPORDERSPROD(“TOY STORE”, “2023”, “US”, $A$1:$A$1000, , “BOTTLESMALL”) Syntax Description Description: Get total orders of advertised products between any period. Syntax: GORILLA_SPORDERSPROD(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….

GORILLA_SPUNITSPRODHIST() – Advertising Units Product History

Sample Usage =GORILLA_SPUNITSPRODHIST(“TOY STORE”, “2023”) =GORILLA_SPUNITSPRODHIST(“TOY STORE”, “2023”, “US”, $A$1:$A$100) =GORILLA_SPUNITSPRODHIST(“TOY STORE”, “2023”, “US”, $A$1:$A$1000, “BOTTLESMALL”) Syntax Description Description: Advertising Units Product History. Syntax: GORILLA_SPUNITSPRODHIST(sellerId, [period], [marketplace], [prod], [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. PROD – OPTIONALSKU…

GORILLA_SPUNITSPROD() – Get total units of advertised products between any period

Sample Usage =GORILLA_SPUNITSPROD(“TOY STORE”, “2023”) =GORILLA_SPUNITSPROD(“TOY STORE”, “2023”, “US”, $A$1:$A$100) =GORILLA_SPUNITSPROD(“TOY STORE”, “2023”, “US”, $A$1:$A$1000, “BOTTLESMALL”) Syntax Description Description: Get total units of advertised products between any period. Syntax: GORILLA_SPUNITSPROD(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. PROD…

GORILLA_SPPERFORMPRODHIST() – Advertising Perform Product History

Sample Usage =GORILLA_SPPERFORMPRODHIST(“TOY STORE”, “2023”) =GORILLA_SPPERFORMPRODHIST(“TOY STORE”, “2023”, “US”, $A$1:$A$100) =GORILLA_SPPERFORMPRODHIST(“TOY STORE”, “2023”, “US”, $A$1:$A$1000, “BOTTLESMALL”) Syntax Description Description: Advertising Perform Product History. Syntax: GORILLA_SPPERFORMPRODHIST(sellerId, [period], [marketplace], [prod], [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. PROD- OPTIONALSKU or…

GORILLA_SPPERFORMPROD() – Get total perform of advertised products between any period

Sample Usage =GORILLA_SPPERFORMPROD(“TOY STORE”, “2023”) =GORILLA_SPPERFORMPROD(“TOY STORE”, “2023”, “US”, $A$1:$A$100) =GORILLA_SPPERFORMPROD(“TOY STORE”, “2023”, “US”, $A$1:$A$1000, “BOTTLESMALL”) Syntax Description Description: Get total perform of advertised products between any period. Syntax: GORILLA_SPPERFORMPROD(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. PROD…