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…

GORILLA_SBORDERSGROUPHIST() – Get Advertising Orders Brand Group History

Sample Usage =GORILLA_SBORDERSGROUPHIST(“TOY STORE”, “2023”, “US”) =GORILLA_SBORDERSGROUPHIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) =GORILLA_SBORDERSGROUPHIST(“TOY STORE”, “THIS MONTH”, “US”, “BOTTLESMALL”) Syntax Description Description: Advertising Orders Brand Group History Syntax: =GORILLA_SBORDERSGROUPHIST(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_SBORDERSGROUP() – Get total orders of advertised Brand group between any period

Sample Usage =GORILLA_SBORDERSGROUP(“TOY STORE”, “2023”, “US”) =GORILLA_SBORDERSGROUP(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) =GORILLA_SBORDERSGROUP(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”, , ,”DUMP”) Syntax Description Description: Get total orders of advertised brand group between any period Syntax: GORILLA_SBORDERSGROUP(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_SBGROUPLIST() – Get advertising Brand group list

Sample Usage =GORILLA_SBGROUPLIST(“TOY STORE”, “2023”) =GORILLA_SBGROUPLIST(“TOY STORE”, “2023”, “US”) =GORILLA_SBGROUPLIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) Syntax Description Description: Get advertising brand group list. Syntax: GORILLA_SBGROUPLIST(sellerId, [period], [marketplace], [campaign], [status], [hasSalesOnly], [start_date], [end_date], [header]) Seller ID – REQUIREDSeller account or Nickname to work with. CAMPAIGN – OPTIONALInclude campaign to filter data by campaign. Use SBCAMPAIGNLIST to list…

GORILLA_SPSPENDGROUPHIST() – Advertising Spend Group History

Sample Usage =GORILLA_SPSPENDGROUPHIST(“TOY STORE”, “2023”) =GORILLA_SPSPENDGROUPHIST(“TOY STORE”, “2023”, “US”) =GORILLA_SPSPENDGROUPHIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) Syntax Description Description: Advertising Spend Group History. Syntax: GORILLA_SPSPENDGROUPHIST(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 get ads…

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

Sample Usage =GORILLA_SPSPENDGROUP(“TOY STORE”, “2023”) =GORILLA_SPSPENDGROUP(“TOY STORE”, “2023”, “US”) =GORILLA_SPSPENDGROUP(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) Syntax Description Description: Get total advertising spend of adgroup between any period Syntax: GORILLA_SPSPENDGROUP(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 – OPTIONALPredefined period…

GORILLA_SPPERFORMGROUPHIST() – Advertising Perform Group History

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

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