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_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 –…