GORILLA_SDUNITSPROD() – Get total units of Sponsored Display products between any period

Sample Usage =GORILLA_SDUNITSPROD(“TOY STORE”, “2023”) =GORILLA_SDUNITSPROD(“TOY STORE”, “2023”, “US”, A1:$A100) =GORILLA_SDUNITSPROD(“TOY STORE”, “2023”, “US”, A1:A1000, “BOTTLESMALL”) Syntax Description Description: Get total units of Sponsored Display products between any period Syntax: GORILLA_SDUNITSPROD (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_SDSPENDPRODHIST() – Sponsored Display Spend Product History.

Sample Usage =GORILLA_SDSPENDPRODHIST(“TOY STORE”, “2023”) =GORILLA_SDSPENDPRODHIST(“TOY STORE”, “2023”, “US”, $A$1:$A$100) =GORILLA_SDSPENDPRODHIST(“TOY STORE”, “2023”, “US”, $A$1:$A$1000, “BOTTLESMALL”) Syntax Description Description: Sponsored Display Spend Product History Syntax: GORILLA_SDSPENDPRODHIST (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. Period Attributes: PROD –…

GORILLA_SDSPENDPROD() – Get total Sponsored Display spend of product between any period.

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

GORILLA_SDSALESPRODHIST() – Sponsored Display Sales Product History.

Sample Usage =GORILLA_SDSALESPRODHIST(“TOY STORE”, “2023”) =GORILLA_SDSALESPRODHIST(“TOY STORE”, “2023”, “US”, $A$1:$A$100) =GORILLA_SDSALESPRODHIST(“TOY STORE”, “2023”, “US”, $A$1:$A$1000, “BOTTLESMALL”) Syntax Description Description: Sponsored Display Sales Product History. Syntax: GORILLA_SDSALESPRODHIST (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…

GORILLA_SDPERFORMPRODHIST() – Sponsored Display Perform Product History.

Sample Usage =GORILLA_SDPERFORMPRODHIST(“TOY STORE”, “2023”) =GORILLA_SDPERFORMPRODHIST(“TOY STORE”, “2023”, “US”, $A$1:$A$100) =GORILLA_SDPERFORMPRODHIST(“TOY STORE”, “2023”, “US”, $A$1:$A$1000, “BOTTLESMALL”) Syntax Description Description: Sponsored Display Perform Product History. Syntax: GORILLA_SDPERFORMPRODHIST (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…

GORILLA_SDPERFORMPROD() – Get total perform of Sponsored Display products between any period.

Sample Usage =GORILLA_SDPERFORMPROD(“TOY STORE”, “2023”) =GORILLA_SDPERFORMPROD(“TOY STORE”, “2023”, “US”, $A$1:$A$100) =GORILLA_SDPERFORMPROD(“TOY STORE”, “2023”, “US”, $A$1:$A$1000, “BOTTLESMALL”) Syntax Description Description: Get total perform of Sponsored Display products between any period. Syntax: GORILLA_SDPERFORMPROD (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_SDSALESPROD() – Get total sales of Sponsored Display products between any period

Sample Usage =GORILLA_SDSALESPROD(“TOY STORE”, “2023”) =GORILLA_SDSALESPROD(“TOY STORE”, “2023”, “US”, $A$1:$A$100) =GORILLA_SDSALESPROD(“TOY STORE”, “2023”, “US”, $A$1:$A$1000, “BOTTLESMALL”) Syntax Description Description: Get total sales of Sponsored Display products between any period. Syntax: GORILLA_SDSALESPROD (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_SDORDERSPRODHIST() – Sponsored Display Orders Product History.

Sample Usage =GORILLA_SDORDERSPRODHIST(“TOY STORE”, “2023”) =GORILLA_SDORDERSPRODHIST(“TOY STORE”, “2023”, “US”) =GORILLA_SDORDERSGROUPHIST(“TOY STORE”, “THIS MONTH”, “US”, “BOTTLESMALL”) Syntax Description Description: Sponsored Display Orders Product History. Syntax: GORILLA_SDORDERSPRODHIST(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 – OPTIONALPredefined…

GORILLA_SDORDERSPROD() – Get total orders of Sponsored Display products between any period.

Sample Usage =GORILLA_SDORDERSPROD(“TOY STORE”, “2023”, “US”) =GORILLA_SDORDERSPROD(“TOY STORE”, “2023”, “US”, , “BOTTLESMALL”) =GORILLA_SDORDERSPROD(“TOY STORE”, “2023”, “US”, ,”BOTTLESMALL”, , ,”DUMP”) Syntax Description Description: Get total orders of Sponsored Display products between any period. Syntax: GORILLA_SDORDERSPROD (sellerId, [period], [marketplace], [prod], [campaign], [adgroup], [datapoint], [output], [start_date], [end_date], [header]) Seller ID – REQUIREDEnter the seller ID or nickname you…

GORILLA_SDPRODLIST() – Get Sponsored Display product list

Sample Usage =GORILLA_SDPRODLIST(“TOY STORE”, “2023”) =GORILLA_SDPRODLIST(“TOY STORE”, “2023”, “US”) =GORILLA_SDPRODLIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) Syntax Description Description: Get Sponsored Display product list. Syntax: GORILLA_SDPRODLIST(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. Period Attributes: MARKETPLACE – OPTIONALMarketplace country filter….