GORILLA_SBSALESCAMPAIGNHIST() – Get Advertising Brand Sales Campaign History

Sample Usage =GORILLA_SBSALESCAMPAIGNHIST(“TOY STORE”, “2023”, “US”) =GORILLA_SBSALESCAMPAIGNHIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) =GORILLA_SBSALESCAMPAIGNHIST(“TOY STORE”, , “US”, “BOTTLESMALL”) Syntax Description Description: Get Advertising Brand Sales Campaign History Syntax: GORILLA_SBSALESCAMPAIGNHIST(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. DATAPOINT – OPTIONALReturn…

GORILLA_SBSALESCAMPAIGN() – Get total sales of advertised Brand campaigns between any period

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

GORILLA_SPSALESPRODHIST() – Advertising Sales Product History

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

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

Sample Usage =GORILLA_SPSALESKEYWORDHIST(“TOY STORE”, “2023”) =GORILLA_SPSALESKEYWORDHIST(“TOY STORE”, “2023”, “US”) =GORILLA_SPSALESKEYWORDHIST(“TOY STORE”, “2023”, “US”, , , “BOTTLESMALL”) Syntax Description Description: Advertising Sales Keyword History. Syntax: GORILLA_SPSALESKEYWORDHIST(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_SPSALESKEYWORD() – Get total sales of advertised keyword between any period

Sample Usage =GORILLA_SPSALESKEYWORD(“TOY STORE”, “2023”) =GORILLA_SPSALESKEYWORD(“TOY STORE”, “2023”, “US”) =GORILLA_SPSALESKEYWORD(“TOY STORE”, “2023”, “US”, , , “BOTTLESMALL”) Syntax Description Description: Get total sales of advertised keyword between any period. Syntax: GORILLA_SPSALESKEYWORD(sellerId, period, [marketplace], [keyword], [datapoint], [campaign], [adgroup], [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_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…

GORILLA_SPSALESCAMPAIGNHIST() – Advertising Sales Campaign History

Sample Usage =GORILLA_SPSALESCAMPAIGNHIST(“TOY STORE”, “2023”) =GORILLA_SPSALESCAMPAIGNHIST(“TOY STORE”, “2023”, “US”) =GORILLA_SPSALESCAMPAIGNHIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) Syntax Description Description: Advertising Sales Campaign History. Syntax: GORILLA_SPSALESCAMPAIGNHIST(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. DATAPOINT – OPTIONALReturn data for specific data…

GORILLA_SPSALESCAMPAIGN() – Get total sales of advertised campaigns between any period

Sample Usage =GORILLA_SPSALESCAMPAIGN(“TOY STORE”, “2023”) =GORILLA_SPSALESCAMPAIGN(“TOY STORE”, “2023”, “US”) =GORILLA_SPSALESCAMPAIGN(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) Syntax Description Description: Get total sales of advertised campaigns between any period. Syntax: GORILLA_SPSALESCAMPAIGN(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. DATAPOINT – OPTIONALReturn data…