GORILLA_SBPERFORMGROUPHIST() – Get Advertising Brand Perform Group History

Sample Usage =GORILLA_SBPERFORMGROUPHIST(“TOY STORE”, “2023”, “US”) =GORILLA_SBPERFORMGROUPHIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) =GORILLA_SBPERFORMGROUPHIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) Syntax Description Description: Get Advertising Brand Perform Group History Syntax: GORILLA_SBPERFORMGROUPHIST(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 –…

GORILLA_SBPERFORMGROUP() – Get total perform of advertised Brand group between any period

Sample Usage =GORILLA_SBPERFORMGROUP(“TOY STORE”, “2023”, “US”) =GORILLA_SBPERFORMGROUP(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) =GORILLA_SBPERFORMGROUP(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”, , ,”DUMP”) Syntax Description Description: Get total perform of advertised Brand group between any period Syntax: =GORILLA_SBPERFORMGROUP(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_SBUNITSGROUPHIST() – Get Advertising Brand Units Group History

Sample Usage =GORILLA_SBUNITSGROUPHIST(“TOY STORE”, “2023”, “US”) =GORILLA_SBUNITSGROUPHIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) =GORILLA_SBUNITSGROUPHIST(“TOY STORE”, , “US”, “BOTTLESMALL”) Syntax Description Description: Get Advertising Brand Units Group History Syntax: GORILLA_SBUNITSGROUPHIST(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 –…

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

Sample Usage =GORILLA_SBUNITSGROUP(“TOY STORE”, “2023”, “US”) =GORILLA_SBUNITSGROUP(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) =GORILLA_SBUNITSGROUP(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”, , ,”DUMP”) Syntax Description Description: Get total units of advertised group between any period. Syntax: =GORILLA_SBUNITSGROUP(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…

GORILLA_SBSPENDGROUPHIST() – Get advertising Brand Spend Group History

Sample Usage =GORILLA_SBSPENDGROUPHIST(“TOYSTORE”,”2023″,”US”) =GORILLA_SBSPENDGROUPHIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) =GORILLA_SBSPENDGROUPHIST(“TOY STORE”, “THIS MONTH”, “US”, “BOTTLESMALL”) Syntax Description Description: Get advertising brand Spend Group History Syntax: GORILLA_SBSPENDGROUPHIST(sellerId, [period], [marketplace], [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…

GORILLA_SBSPENDGROUP() – Get total advertising Brand spend of adgroup between any period

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

GORILLA_SBSALESGROUPHIST() – Get Advertising Brand Sales Group History

Sample Usage =GORILLA_SBSALESGROUPHIST(“TOY STORE”, “2023”, “US”) =GORILLA_SBSALESGROUPHIST(“TOY STORE”, “2023”, “US”,”BOTTLESMALL”) =GORILLA_SBSALESGROUPHIST(“TOY STORE”, , “US”,”BOTTLESMALL”, ,”9″) Syntax Description Description: Get Advertising Brand Sales Group History Syntax: GORILLA_SBSALESGROUPHIST(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…

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

Sample Usage =GORILLA_SBSALESGROUP(“TOY STORE”, “2023”, “US”) =GORILLA_SBSALESGROUP(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) =GORILLA_SBSALESGROUP(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”, , ,”DUMP”) Syntax Description Description: Get total sales of advertised Brand group between any period Syntax: =GORILLA_SBSALESGROUP(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_SBHIGHACOSGROUP() – Get Advertising Brand group with high acos

Sample Usage =GORILLA_SBHIGHACOSGROUP(“TOY STORE”, “2023”, “US”) =GORILLA_SBHIGHACOSGROUP(“TOY STORE”,”Last Month”,”US”, ,”SPEND”) =GORILLA_ADHIGHACOSGROUP(“TOY STORE”,”Last Month”,”US”,,”SPEND”) Syntax Description Description: Get Advertising Brand group with high acos Syntax: GORILLA_SBHIGHACOSGROUP(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…

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

Sample Usage =GORILLA_SBNOSALESGROUP(“TOY STORE”, “2023”, “US”) =GORILLA_SBNOSALESGROUP(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) =GORILLA_SBNOSALESGROUP(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”, , ,”DUMP”) Syntax Description Description: Shows all ads Brand group that has clicks, but no sales Syntax: GORILLA_SBNOSALESGROUP(sellerId, [period], [marketplace], [campaign], [adgroup], [datapoint], [output], [start_date], [end_date], [header]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in…