GORILLA_SDSTATS() – Sponsored Display Stats

Sample Usage =GORILLA_SDSTATS(“TOY STORE”, “2023”) =GORILLA_SDSTATS(“TOY STORE”, “Last Month”, “US”, “spend”) =GORILLA_SDSTATS(“TOY STORE”, “2023”, “US”, “Spend”, B4:B215,,, “TOTAL”) Syntax Description Description: Sponsored Display Stats Syntax: GORILLA_SDSTATS (sellerId, [period], [marketplace], [datapoint], [prod], [campaign], [adgroup], [output], [start_date], [end_date], [header]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla account. MARKETPLACE – OPTIONALMarketplace…

GORILLA_SBSTATSNEGATIVEKEYWORD() – Get advertising Brand stats negative keyword list

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_SBSTATSNEGATIVEKEYWORD(“TOY STORE”, “2023”, “US”) =GORILLA_SBSTATSNEGATIVEKEYWORD(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) =GORILLA_SBSTATSNEGATIVEKEYWORD(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”, ,”DUMP”) Syntax Description Description: Get advertising brand…

GORILLA_SBSTATS() – Advertising Brand Stats

Sample Usage =GORILLA_SBSTATS(“TOY STORE”, “Last Month”) =GORILLA_SBSTATS(“TOY STORE”, “Last Month”, “US”, “spend”) =GORILLA_SBTATS(“TOY STORE”, “Last Month”, “US”, “Spend”, B4:B215,, “single”) Syntax Description Description: Get Advertising Brand Stats. Syntax: GORILLA_SBSTATS(sellerId, [period], [marketplace], [datapoint], [campaign], [adgroup], [output], [start_date], [end_date], [header]) Seller ID – REQUIREDSeller account or Nickname to work with. MARKETPLACE – OPTIONALMarketplace country filter. Country codes…

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,…