GORILLA_SBOVERVIEWHIST() – Get daily total Brand overview of the data for advertising

Sample Usage =GORILLA_SBOVERVIEWHIST(“TOY STORE”, “2023”, “US”) =GORILLA_SBOVERVIEWHIST(“TOY STORE”, “2023”, “US”,”BOTTLESMALL”) =GORILLA_SBOVERVIEWHIST(“TOY STORE”, , “US”,”BOTTLESMALL”) Syntax Description Description: Get daily total Brand overview of the data for advertising. Syntax: =GORILLA_SBOVERVIEWHIST(sellerId, [period], [marketplace], [campaign], [adgroup], [days], [sort], [start_date], [end_date], [transpose]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla account. MARKETPLACE –…

GORILLA_SBUNITSKEYWORD() – Get total units of advertised Brand keyword between any period

Ads/PPC data is here! Ads/PPC data is here! Ads/PPC data is here! Sample Usage 🚨 Use ranges (e.g.A2:A1000) in your formula wherever possible for quicker results and to prevent Google from blocking your account for 24 hrs due to overloading their resources.  =GORILLA_SBUNITSKEYWORD(“TOY STORE”, “2023”, “US”) =GORILLA_SBUNITSKEYWORD(“TOY STORE”, “2023”, “US”, ,”BOTTLESMALL”) =GORILLA_SBUNITSKEYWORD(“TOY STORE”, “2023”, “US”,…

GORILLA_SBNOSALESCAMPAIGN() – Shows all ads Brand campaign that has clicks, but no sales

Sample Usage =GORILLA_SBNOSALESCAMPAIGN(“TOY STORE”, “2023”, “US”) =GORILLA_SBNOSALESCAMPAIGN(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) =GORILLA_SBNOSALESCAMPAIGN(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”, ,”DUMP”) Syntax Description Description: Shows all ads Brand campaign that has clicks, but no sales Syntax: GORILLA_SBNOSALESCAMPAIGN(sellerId, [period], [marketplace], [campaign], [datapoint], [output], [start_date], [end_date], [header]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla…

GORILLA_SBGROUPLIST() – Get advertising Brand group list

Sample Usage =GORILLA_SBGROUPLIST(“TOY STORE”, “2023”) =GORILLA_SBGROUPLIST(“TOY STORE”, “2023”, “US”) =GORILLA_SBGROUPLIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) Syntax Description Description: Get advertising brand group list. Syntax: GORILLA_SBGROUPLIST(sellerId, [period], [marketplace], [campaign], [status], [hasSalesOnly], [start_date], [end_date], [header]) Seller ID – REQUIREDSeller account or Nickname to work with. CAMPAIGN – OPTIONALInclude campaign to filter data by campaign. Use SBCAMPAIGNLIST to list…

GORILLA_SBCAMPAIGNLIST() – Get advertising Brand campaign list

Sample Usage =GORILLA_SBCAMPAIGNLIST(“TOY STORE”, “2023”) =GORILLA_SBCAMPAIGNLIST(“TOY STORE”, “2023”, “US”) =GORILLA_SBCAMPAIGNLIST(“TOY STORE”, “2023”, “US”, “ENABLED”) Syntax Description Description: Get advertising brand campaign list Syntax: GORILLA_SBCAMPAIGNLIST(sellerId, [period], [marketplace], [status], [hasSalesOnly], [start_date], [end_date], [header]) Seller ID – REQUIREDSeller account or Nickname to work with. PERIOD – OPTIONALPredefined period to get ads data or use ‘custom’ to specify a…

GORILLA_SPSPENDPRODHIST() – Advertising Spend Product History

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

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

GORILLA_SPSPENDKEYWORDHIST() – Advertising Spend Keyword History

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

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

Sample Usage =GORILLA_SPSPENDGROUPHIST(“TOY STORE”, “2023”) =GORILLA_SPSPENDGROUPHIST(“TOY STORE”, “2023”, “US”) =GORILLA_SPSPENDGROUPHIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) Syntax Description Description: Advertising Spend Group History. Syntax: GORILLA_SPSPENDGROUPHIST(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…