GORILLA_SDSALESGROUP() – Get total sales of Sponsored Display group between any period.

Sample Usage =GORILLA_SDSALESGROUP(“TOY STORE”, “2023”) =GORILLA_SDSALESGROUP(“TOY STORE”, “2023”, “US”) =GORILLA_SDSALESGROUP(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) Syntax Description Description: Get total sales of Sponsored Display group between any period. Syntax: GORILLA_SDSALESGROUP (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_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_SDSALESGROUPHIST() – Sponsored Display Sales Group History.

Sample Usage =GORILLA_SDSALESGROUPHIST(“TOY STORE”, “2023”) =GORILLA_SDSALESGROUPHIST(“TOY STORE”, “2023”, “US”) =GORILLA_SDSALESGROUPHIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) Syntax Description Description: Sponsored Display Sales Group History. Syntax: GORILLA_SDSALESGROUPHIST (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 Attributes: DATAPOINT –…

GORILLA_SDSALESCAMPAIGNHIST() – Sponsored Display Sales Campaign History.

Sample Usage =GORILLA_SDSALESCAMPAIGNHIST(“TOY STORE”, “2023”) =GORILLA_SDSALESCAMPAIGNHIST(“TOY STORE”, “2023”, “US”) =GORILLA_SDSALESCAMPAIGNHIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) Syntax Description Description: Sponsored Display Sales Campaign History. Syntax: GORILLA_SDSALESCAMPAIGNHIST (sellerId, [period], [marketplace], [campaign], [datapoint], [days], [sort], [start_date], [end_date], [transpose], [header]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla account. Period Attributes: DATAPOINT – OPTIONALReturn…

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_SDSALESCAMPAIGN() – Get total sales of Sponsored Display campaigns between any period.

Sample Usage =GORILLA_SDSALESCAMPAIGN(“TOY STORE”, “2023”) =GORILLA_SDSALESCAMPAIGN(“TOY STORE”, “2023”, “US”) =GORILLA_SDSALESCAMPAIGN(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) Syntax Description Description: Get total sales of Sponsored Display campaigns between any period. Syntax: GORILLA_SDSALESCAMPAIGN (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. Period Attributes:…

GORILLA_SBSALESKEYWORDHIST() – Get Advertising Brand Sales Keyword History

Sample Usage =GORILLA_SBSALESKEYWORDHIST(“TOY STORE”, “2023”, “US”) =GORILLA_SBSALESKEYWORDHIST(“TOY STORE”, “2023”, “US”,”BOTTLESMALL”) =GORILLA_SBSALESKEYWORDHIST(“TOY STORE”, , “US”,”BOTTLESMALL”) Syntax Description Description: Get Advertising Brand Sales Keyword History Syntax: GORILLA_SBSALESKEYWORDHIST(sellerId, [period], [marketplace], [keyword], [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_SBSALESKEYWORD() – Get total sales of advertised Brand keyword between any period

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

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…