GORILLA_ADSPENDPRODHIST() – Advertising Spend Product History

Sample Usage =GORILLA_ADSPENDPRODHIST(“TOY STORE”, “2023”) =GORILLA_ADSPENDPRODHIST(“TOY STORE”, “2023”, “US”, $A$1:$A$100) =GORILLA_ADSPENDPRODHIST(“TOY STORE”, “2023”, “US”, $A$1:$A$1000, “BOTTLESMALL”) Syntax Description Description: Advertising Spend Product History. Syntax: GORILLA_ADSPENDPRODHIST(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_ADSPENDPROD() – Get total advertising spend of product between any period

Sample Usage =GORILLA_ADSPENDPROD(“TOY STORE”, “2023”) =GORILLA_ADSPENDPROD(“TOY STORE”, “2023”, “US”, $A$1:$A$100) =GORILLA_ADSPENDPROD(“TOY STORE”, “2023”, “US”, $A$1:$A$1000, “BOTTLESMALL”) Syntax Description Description: Get total advertising spend of product between any period. Syntax: GORILLA_ADSPENDPROD(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_ADSALESPRODHIST() – Advertising Sales Product History

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

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

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

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

Sample Usage =GORILLA_ADUNITSPRODHIST(“TOY STORE”, “2023”) =GORILLA_ADUNITSPRODHIST(“TOY STORE”, “2023”, “US”, $A$1:$A$100) =GORILLA_ADUNITSPRODHIST(“TOY STORE”, “2023”, “US”, $A$1:$A$1000, “BOTTLESMALL”) Syntax Description Description: Advertising Units Product History. Syntax: GORILLA_ADUNITSPRODHIST(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_ADUNITSPROD() – Get total units of advertised products between any period

Sample Usage =GORILLA_ADUNITSPROD(“TOY STORE”, “2023”) =GORILLA_ADUNITSPROD(“TOY STORE”, “2023”, “US”, $A$1:$A$100) =GORILLA_ADUNITSPROD(“TOY STORE”, “2023”, “US”, $A$1:$A$1000, “BOTTLESMALL”) Syntax Description Description: Get total units of advertised products between any period. Syntax: GORILLA_ADUNITSPROD(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_ADPERFORMPRODHIST() – Advertising Perform Product History

Sample Usage =GORILLA_ADPERFORMPRODHIST(“TOY STORE”, “2023”) =GORILLA_ADPERFORMPRODHIST(“TOY STORE”, “2023”, “US”, $A$1:$A$100) =GORILLA_ADPERFORMPRODHIST(“TOY STORE”, “2023”, “US”, $A$1:$A$1000, “BOTTLESMALL”) Syntax Description Description: Advertising Perform Product History. Syntax: GORILLA_ADPERFORMPRODHIST(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_ADPERFORMPROD() – Get total perform of advertised products between any period

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