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_SBSPENDKEYWORDHIST() – Get Advertising Brand Spend Keyword History

Sample Usage =GORILLA_ADSPENDKEYWORDHIST(“TOY STORE”, “2023”) =GORILLA_ADSPENDKEYWORDHIST(“TOY STORE”, “2023”, “US”) ‘=GORILLA_SBSPENDKEYWORDHIST(“TOY STORE”, , “US”, “BOTTLESMALL”) Syntax Description Description: Advertising brand Spend Keyword History Syntax: GORILLA_SBSPENDKEYWORDHIST(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…

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

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

GORILLA_SBSPENDGROUPHIST() – Get advertising Brand Spend Group History

Sample Usage =GORILLA_SBSPENDGROUPHIST(“TOYSTORE”,”2023″,”US”) =GORILLA_SBSPENDGROUPHIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) =GORILLA_SBSPENDGROUPHIST(“TOY STORE”, “THIS MONTH”, “US”, “BOTTLESMALL”) Syntax Description Description: Get advertising brand Spend Group History Syntax: GORILLA_SBSPENDGROUPHIST(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…

GORILLA_SBSPENDGROUP() – Get total advertising Brand spend of adgroup between any period

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

GORILLA_SBSPENDCAMPAIGNHIST() – Get advertising Brand Spend Campaign History

Sample Usage =GORILLA_SBSPENDCAMPAIGNHIST(“TOYSTORE”,”2023″,”US”) =GORILLA_SBSPENDCAMPAIGNHIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) =GORILLA_SBSPENDCAMPAIGNHIST(“TOY STORE”, “THIS MONTH”, “US”, “BOTTLESMALL”) Syntax Description Description: Get advertising brand Spend Campaign History Syntax: =GORILLA_SBSPENDCAMPAIGNHIST(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…

GORILLA_SBSPENDCAMPAIGN() – Get total advertising Brand spend of campaign between any period

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

GORILLA_SBSALESKEYWORDHIST() – Get Advertising Brand Sales Keyword History

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

GORILLA_SBSALESKEYWORD() – Get total sales of advertised Brand keyword between any period

Sample Usage =GORILLA_SBSALESKEYWORD(“TOY STORE”, “2023”, “US”) =GORILLA_SBSALESKEYWORD(“TOY STORE”, “2023”, “US”,”BOTTLESMALL”) =GORILLA_SBSALESKEYWORD(“TOY STORE”, “2023”, “US”,”BOTTLESMALL”, , , ,”DUMP”) Syntax Description Description: Get total sales of advertised Brand keyword between any period Syntax: =GORILLA_SBSALESKEYWORD(sellerId, [period], [marketplace], [keyword], [campaign], [adgroup], [datapoint], [output], [start_date], [end_date], [header]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your…