GORILLA_SBUNITSGROUPHIST() – Get Advertising Brand Units Group History

Sample Usage =GORILLA_SBUNITSGROUPHIST(“TOY STORE”, “2023”, “US”) =GORILLA_SBUNITSGROUPHIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) =GORILLA_SBUNITSGROUPHIST(“TOY STORE”, , “US”, “BOTTLESMALL”) Syntax Description Description: Get Advertising Brand Units Group History Syntax: GORILLA_SBUNITSGROUPHIST(sellerId, [period], [marketplace], [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 –…

GORILLA_SBUNITSGROUP() – Get total units of advertised Brand group between any period

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

GORILLA_SBUNITSCAMPAIGNHIST() – Get Advertising Brand Units Campaign History

Sample Usage =GORILLA_SBUNITSCAMPAIGNHIST(“TOY STORE”, “2023”, “US”) =GORILLA_SBUNITSCAMPAIGNHIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) =GORILLA_SBUNITSCAMPAIGNHIST(“TOY STORE”, , “US”, “BOTTLESMALL”) Syntax Description Description: Get Advertising Brand Units Campaign History Syntax: GORILLA_SBUNITSCAMPAIGNHIST(sellerId, [period], [marketplace], [campaign], [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_SBUNITSCAMPAIGN() – Get total units of advertised Brand campaigns between any period

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

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_SPUNITSCAMPAIGNHIST() – Advertising Units Campaign History

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

GORILLA_SPUNITSCAMPAIGN() – Get total units of advertised campaigns between any period

Sample Usage =GORILLA_SPUNITSCAMPAIGN(“TOY STORE”, “2023”) =GORILLA_SPUNITSCAMPAIGN(“TOY STORE”, “2023”, “US”) =GORILLA_SPUNITSCAMPAIGN(“TOY STORE”, “2023”, “US”, , “BOTTLESMALL”) Syntax Description Description: Get total units of advertised campaigns between any period. Syntax: GORILLA_SPUNITSCAMPAIGN(sellerId, period, [marketplace], [campaign], [datapoint], [start_date], [end_date], [header]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla account. PERIOD – REQUIREDPredefined period…

GORILLA_SPUNITSPRODHIST() – Advertising Units Product History

Sample Usage =GORILLA_SPUNITSPRODHIST(“TOY STORE”, “2023”) =GORILLA_SPUNITSPRODHIST(“TOY STORE”, “2023”, “US”, $A$1:$A$100) =GORILLA_SPUNITSPRODHIST(“TOY STORE”, “2023”, “US”, $A$1:$A$1000, “BOTTLESMALL”) Syntax Description Description: Advertising Units Product History. Syntax: GORILLA_SPUNITSPRODHIST(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_SPUNITSPROD() – Get total units of advertised products between any period

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

GORILLA_SPUNITSKEYWORDHIST() – Advertising Units Keyword History

Sample Usage =GORILLA_SPUNITSKEYWORDHIST(“TOY STORE”, “2023”) =GORILLA_SPUNITSKEYWORDHIST(“TOY STORE”, “2023”, “US”) =GORILLA_SPUNITSKEYWORDHIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) Syntax Description Description: Advertising Units Keyword History. Syntax: GORILLA_SPUNITSKEYWORDHIST(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 – OPTIONALPredefined period to…