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_SPUNITSCAMPAIGNHIST() – Advertising Units Campaign History

Sample Usage =GORILLA_SPUNITSCAMPAIGNHIST(“TOY STORE”, “2023”) =GORILLA_SPUNITSCAMPAIGNHIST(“TOY STORE”, “2023”, “US”) =GORILLA_SPUNITSCAMPAIGNHIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) Syntax Description Description: Advertising Units Campaign History. Syntax: GORILLA_SPUNITSCAMPAIGNHIST(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 – REQUIREDPredefined period to get ads…

GORILLA_SPUNITSCAMPAIGN() – Get total units of advertised campaigns between any period

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

GORILLA_SPSTATS() – Get Advertising Stats

Sample Usage =GORILLA_SPSTATS(“TOY STORE”,”Last Month”) =GORILLA_SPSTATS(“TOY STORE”,”Last Month”,”US”,,”spend”) =GORILLA_SPSTATS(“TOY STORE”,”Last Month”,”US”,”Single”,”Spend”,B4:B215) Syntax Description Description: Get Advertising Stats. Syntax: GORILLA_SPSTATS(sellerId, [period], [marketplace], [output], [datapoint], [prod], [campaign], [adgroup], [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,…

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], [datapoint], [campaign], [adgroup], [start_date], [end_date], [header]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla account. DATAPOINT – OPTIONALReturn data…

GORILLA_SPPERFORMCAMPAIGNHIST() – Advertising Perform Campaign History

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

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