GORILLA_SBORDERSKEYWORDHIST() – Get Advertising Order Brand Keyword History

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

GORILLA_SBORDERSKEYWORD() – Get total orders of advertised Brand keyword between any period

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_SBORDERSKEYWORD(“TOY STORE”, “2023”, “US”) =GORILLA_SBORDERSKEYWORD(“TOY STORE”, “2023”, “US”, , “BOTTLESMALL”) =GORILLA_SBORDERSKEYWORD(“TOY STORE”, “2023”, “US”, , “BOTTLESMALL”, , , , “DUMP”) Syntax Description Description: Get total…

GORILLA_SBORDERSGROUPHIST() – Get Advertising Orders Brand Group History

Sample Usage =GORILLA_SBORDERSGROUPHIST(“TOY STORE”, “2023”, “US”) =GORILLA_SBORDERSGROUPHIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) =GORILLA_SBORDERSGROUPHIST(“TOY STORE”, “THIS MONTH”, “US”, “BOTTLESMALL”) Syntax Description Description: Advertising Orders Brand Group History Syntax: =GORILLA_SBORDERSGROUPHIST(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_SBORDERSGROUP() – Get total orders of advertised Brand group between any period

Sample Usage =GORILLA_SBORDERSGROUP(“TOY STORE”, “2023”, “US”) =GORILLA_SBORDERSGROUP(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) =GORILLA_SBORDERSGROUP(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”, , ,”DUMP”) Syntax Description Description: Get total orders of advertised brand group between any period Syntax: GORILLA_SBORDERSGROUP(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_SBORDERSCAMPAIGNHIST() – Get Advertising Orders Brand Campaign History

Sample Usage =GORILLA_SBORDERSCAMPAIGNHIST(“TOY STORE”, “2023”, “US”) =GORILLA_SBORDERSCAMPAIGNHIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) =GORILLA_SBORDERSCAMPAIGNHIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) Syntax Description Description: Advertising Orders Brand Campaign History Syntax: GORILLA_SBORDERSCAMPAIGNHIST(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…

GORILLA_SBORDERSCAMPAIGN() – Get total orders of advertised Brand campaigns between any period

Sample Usage =GORILLA_SBORDERSCAMPAIGN(“TOY STORE”, “2023”, “US”) =GORILLA_SBORDERSCAMPAIGN(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) =GORILLA_SBORDERSCAMPAIGN(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”, ,”DUMP”) Syntax Description Description: Get total orders of advertised brand campaigns between any period Syntax: GORILLA_SBORDERSCAMPAIGN(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_ADORDERSPRODHIST() – Advertising Orders Product History

Sample Usage =GORILLA_ADORDERSPRODHIST(“TOY STORE”, “2023”) =GORILLA_ADORDERSPRODHIST(“TOY STORE”, “2023”, “US”, $A$1:$A$100) =GORILLA_ADORDERSPRODHIST(“TOY STORE”, “2023”, “US”, $A$1:$A$1000, “BOTTLESMALL”) Syntax Description Description: Advertising Orders Product History. Syntax: GORILLA_ADORDERSPRODHIST(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. PERIOD – REQUIREDPredefined…

GORILLA_ADORDERSPROD() – Get total orders of advertised products between any period

Sample Usage =GORILLA_ADORDERSPROD(“TOY STORE”, “2023”) =GORILLA_ADORDERSPROD(“TOY STORE”, “2023”, “US”, $A$1:$A$100) =GORILLA_ADORDERSPROD(“TOY STORE”, “2023”, “US”, $A$1:$A$1000, , “BOTTLESMALL”) Syntax Description Description: Get total orders of advertised products between any period. Syntax: GORILLA_ADORDERSPROD(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….

GORILLA_ADORDERSKEYWORDHIST() – Advertising Order Keyword History

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

GORILLA_ADORDERSKEYWORD() – Get total orders of advertised keyword between any period

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