GORILLA_SPNOSALESKEYWORD() – Shows all ads keywords that has clicks, but no sales

Sample Usage =GORILLA_SPNOSALESKEYWORD(“TOY STORE”,”Last Month”,”US”) =GORILLA_SPNOSALESKEYWORD(“TOY STORE”,”Last Month”,”US”,B4:B215) =GORILLA_SPNOSALESKEYWORD(“TOY STORE”,”Last Month”,”US”,B4:B215,,,”SPEND”) Syntax Description Description: Shows all ads keywords that has clicks, but no sales Syntax: GORILLA_SPNOSALESKEYWORD(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. MARKETPLACE – OPTIONALMarketplace country filter….

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…

GORILLA_SPPRODLIST() – Get advertising product list

Sample Usage =GORILLA_SPPRODLIST(“TOY STORE”, “2023”) =GORILLA_SPPRODLIST(“TOY STORE”, “2023”, “US”) =GORILLA_SPPRODLIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) Syntax Description Description: Get advertising product list. Syntax: GORILLA_SPPRODLIST(sellerId, [period], [marketplace], [campaign], [adgroup], [status], [hasSalesOnly], [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…

GORILLA_SPPERFORMPRODHIST() – Advertising Perform Product History

Sample Usage =GORILLA_SPPERFORMPRODHIST(“TOY STORE”, “2023”) =GORILLA_SPPERFORMPRODHIST(“TOY STORE”, “2023”, “US”, $A$1:$A$100) =GORILLA_SPPERFORMPRODHIST(“TOY STORE”, “2023”, “US”, $A$1:$A$1000, “BOTTLESMALL”) Syntax Description Description: Advertising Perform Product History. Syntax: GORILLA_SPPERFORMPRODHIST(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 or…

GORILLA_SPPERFORMPROD() – Get total perform of advertised products between any period

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

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

GORILLA_SPPERFORMKEYWORD() – Get total perform of advertised keyword between any period

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

GORILLA_SBUNITSKEYWORDHIST() – Get Advertising Brand Units Keyword History

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