GORILLA_SPORDERSGROUPHIST() – Advertising Orders Group History

Sample Usage =GORILLA_SPORDERSGROUPHIST(“TOY STORE”, “2023”) =GORILLA_SPORDERSGROUPHIST(“TOY STORE”, “2023”, “US”) =GORILLA_SPORDERSGROUPHIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) Syntax Description Description: Advertising Orders Group History. Syntax: GORILLA_SPORDERSGROUPHIST(sellerId, [period], [marketplace], [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 to get…

GORILLA_SPORDERSGROUP() – Get total orders of advertised group between any period

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

GORILLA_SPSALESGROUPHIST() – Advertising Sales Group History

Sample Usage =GORILLA_SPSALESGROUPHIST(“TOY STORE”, “2023”) =GORILLA_SPSALESGROUPHIST(“TOY STORE”, “2023”, “US”) =GORILLA_SPSALESGROUPHIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) Syntax Description Description: Advertising Sales Group History. Syntax: GORILLA_SPSALESGROUPHIST(sellerId, [period], [marketplace], [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 – OPTIONALReturn data for specific…

GORILLA_SPUNITSGROUPHIST() – Advertising Units Group History

Sample Usage =GORILLA_SPUNITSGROUPHIST(“TOY STORE”, “2023”) =GORILLA_SPUNITSGROUPHIST(“TOY STORE”, “2023”, “US”) =GORILLA_SPUNITSGROUPHIST(“TOY STORE”, “2023”, “US”, ,”BOTTLESMALL”) Syntax Description Description: Advertising Units Group History. Syntax: GORILLA_SPUNITSGROUPHIST(sellerId, [period], [marketplace], [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 to get…

GORILLA_SPUNITSGROUP() – Get total units of advertised group between any period

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

GORILLA_SPGROUPLIST() – Get advertising group list

Sample Usage =GORILLA_SPGROUPLIST(“TOY STORE”, “2023”) =GORILLA_SPGROUPLIST(“TOY STORE”, “2023”, “US”) =GORILLA_SPGROUPLIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) Syntax Description Description: Get advertising group list. Syntax: GORILLA_SPGROUPLIST(sellerId, [period], [marketplace], [campaign], [status], [hasSalesOnly], [start_date], [end_date], [header]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla account. STATUS – OPTIONALFilter by status. Status are: enabled, paused,…

GORILLA_SPHIGHACOSGROUP() – Advertising group with high acos

Sample Usage =GORILLA_SPHIGHACOSGROUP(“TOY STORE”) =GORILLA_SPHIGHACOSGROUP(“TOY STORE”,”Last Month”,”US”) =GORILLA_SPHIGHACOSGROUP(“TOY STORE”,”Last Month”,”US”,,”SPEND”) Syntax Description Description: Advertising group with high acos Syntax: GORILLA_SPHIGHACOSGROUP(sellerId, [period], [marketplace], [campaign], [datapoint], [output], [start_date], [end_date], [header]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla account. MARKETPLACE – OPTIONALMarketplace country filter. Country codes are US, CA, MX, BR,…

GORILLA_SPNOSALESGROUP() – Shows all ads group that has clicks, but no sales

Sample Usage =GORILLA_SPNOSALESGROUP(“TOY STORE”) =GORILLA_SPNOSALESGROUP(“TOY STORE”,”Last Month”,”US”) =GORILLA_SPNOSALESGROUP(“TOY STORE”,”Last Month”,”US”,,,”SPEND”) Syntax Description Description: Shows all ads group that has clicks, but no sales Syntax: GORILLA_SPNOSALESGROUP(sellerId, [period], [marketplace], [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. Country codes…

GORILLA_SPSALESGROUP() – Get total sales of advertised group between any period

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