GORILLA_SBHIGHACOSSEARCHTERM() – Get Advertising Brand search term with high acos

Sample Usage =GORILLA_SBHIGHACOSSEARCHTERM(“TOY STORE”, “2023”, “US”) =GORILLA_SBHIGHACOSSEARCHTERM(“TOY STORE”, “Last Month”, “US”, B4:B215) =GORILLA_SBHIGHACOSSEARCHTERM(“TOY STORE”, “Last Month”, “US”, B4:B215 , , , , “DUMP”) Syntax Description Description: Get Advertising Brand search term with high acos Syntax: =GORILLA_SBHIGHACOSSEARCHTERM(sellerId, [period], [marketplace], [prod], [campaign], [adgroup], [datapoint], [output], [start_date], [end_date], [header]) Seller ID – REQUIREDSeller account or Nickname to work…

GORILLA_ADSPENDPRODHIST() – Advertising Spend Product History

Sample Usage =GORILLA_ADSPENDPRODHIST(“TOY STORE”, “2023”) =GORILLA_ADSPENDPRODHIST(“TOY STORE”, “2023”, “US”, $A$1:$A$100) =GORILLA_ADSPENDPRODHIST(“TOY STORE”, “2023”, “US”, $A$1:$A$1000, “BOTTLESMALL”) Syntax Description Description: Advertising Spend Product History. Syntax: GORILLA_ADSPENDPRODHIST(sellerId, [period], [marketplace], [prod], [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 ASIN to…

GORILLA_ADSPENDPROD() – Get total advertising spend of product between any period

Sample Usage =GORILLA_ADSPENDPROD(“TOY STORE”, “2023”) =GORILLA_ADSPENDPROD(“TOY STORE”, “2023”, “US”, $A$1:$A$100) =GORILLA_ADSPENDPROD(“TOY STORE”, “2023”, “US”, $A$1:$A$1000, “BOTTLESMALL”) Syntax Description Description: Get total advertising spend of product between any period. Syntax: GORILLA_ADSPENDPROD(sellerId, [period], [marketplace], [prod], [campaign], [adgroup], [start_date], [end_date]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla account. PROD – OPTIONALSKU…

GORILLA_ADSPENDKEYWORDHIST() – Advertising Spend Keyword History

Sample Usage =GORILLA_ADSPENDKEYWORDHIST(“TOY STORE”, “2023”) =GORILLA_ADSPENDKEYWORDHIST(“TOY STORE”, “2023”, “US”) =GORILLA_ADSPENDKEYWORDHIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) Syntax Description Description: Advertising Spend Keyword History Syntax: GORILLA_ADSPENDKEYWORDHIST(sellerId, [period], [marketplace], [keyword], [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…

GORILLA_ADSPENDKEYWORD() – Get total advertising spend of keywords between any period

Sample Usage =GORILLA_ADSPENDKEYWORD(“TOY STORE”, “2023”) =GORILLA_ADSPENDKEYWORD(“TOY STORE”, “2023”, “US”) =GORILLA_ADSPENDKEYWORD(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) Syntax Description Description: Get total advertising spend of keywords between any period. Syntax: GORILLA_ADSPENDKEYWORD(sellerId, [period], [marketplace], [campaign], [adgroup], [keyword], [start_date], [end_date], [header]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla account. PERIOD – OPTIONALPredefined period…

GORILLA_ADSPENDGROUPHIST() – Advertising Spend Group History

Sample Usage =GORILLA_ADSPENDGROUPHIST(“TOY STORE”, “2023”) =GORILLA_ADSPENDGROUPHIST(“TOY STORE”, “2023”, “US”) =GORILLA_ADSPENDGROUPHIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) Syntax Description Description: Advertising Spend Group History. Syntax: GORILLA_ADSPENDGROUPHIST(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_ADSPENDGROUP() – Get total advertising spend of adgroup between any period

Sample Usage =GORILLA_ADSPENDGROUP(“TOY STORE”, “2023”) =GORILLA_ADSPENDGROUP(“TOY STORE”, “2023”, “US”) =GORILLA_ADSPENDGROUP(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) Syntax Description Description: Get total advertising spend of adgroup between any period Syntax: GORILLA_ADSPENDGROUP(sellerId, [period], [marketplace], [campaign], [adgroup], [start_date], [end_date], [header]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla account. PERIOD – OPTIONALPredefined period to…

GORILLA_ADSPENDCAMPAIGNHIST() – Advertising Spend Campaign History

Sample Usage =GORILLA_ADSPENDCAMPAIGNHIST(“TOY STORE”, “2023”) =GORILLA_ADSPENDCAMPAIGNHIST(“TOY STORE”, “2023”, “US”) =GORILLA_ADSPENDCAMPAIGNHIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) Syntax Description Description: Advertising Spend Campaign History. Syntax: GORILLA_ADSPENDCAMPAIGNHIST(sellerId, [period], [marketplace], [campaign], [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 data…

GORILLA_ADSALESPRODHIST() – Advertising Sales Product History

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

Sample Usage =GORILLA_ADSPENDCAMPAIGN(“TOY STORE”, “2023”) =GORILLA_ADSPENDCAMPAIGN(“TOY STORE”, “2023”, “US”) =GORILLA_ADSPENDCAMPAIGN(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) Syntax Description Description: Get total advertising spend of campaign between any period. Syntax: GORILLA_ADSPENDCAMPAIGN(sellerId, [period], [marketplace], [campaign], [start_date], [end_date]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla account. PERIOD – OPTIONALPredefined period to get ads…