GORILLA_SDORDERSPRODHIST() – Sponsored Display Orders Product History.

Sample Usage =GORILLA_SDORDERSPRODHIST(“TOY STORE”, “2023”) =GORILLA_SDORDERSPRODHIST(“TOY STORE”, “2023”, “US”) =GORILLA_SDORDERSGROUPHIST(“TOY STORE”, “THIS MONTH”, “US”, “BOTTLESMALL”) Syntax Description Description: Sponsored Display Orders Product History. Syntax: GORILLA_SDORDERSPRODHIST(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 – OPTIONALPredefined…

GORILLA_SDORDERSPROD() – Get total orders of Sponsored Display products between any period.

Sample Usage =GORILLA_SDORDERSPROD(“TOY STORE”, “2023”, “US”) =GORILLA_SDORDERSPROD(“TOY STORE”, “2023”, “US”, , “BOTTLESMALL”) =GORILLA_SDORDERSPROD(“TOY STORE”, “2023”, “US”, ,”BOTTLESMALL”, , ,”DUMP”) Syntax Description Description: Get total orders of Sponsored Display products between any period. Syntax: GORILLA_SDORDERSPROD (sellerId, [period], [marketplace], [prod], [campaign], [adgroup], [datapoint], [output], [start_date], [end_date], [header]) Seller ID – REQUIREDEnter the seller ID or nickname you…

GORILLA_SDORDERSGROUPHIST() – Sponsored Orders Display Group History.

Sample Usage =GORILLA_SDORDERSGROUPHIST(“TOY STORE”, “2023”) =GORILLA_SDORDERSGROUPHIST(“TOY STORE”, “2023”, “US”) =GORILLA_SDORDERSGROUPHIST(“TOY STORE”, “THIS MONTH”, “US”, “BOTTLESMALL”) Syntax Description Description: Sponsored Orders Display Group History. Syntax: GORILLA_SDORDERSGROUPHIST (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 – OPTIONALPredefined…

GORILLA_SDORDERSGROUP() – Get total orders of Sponsored Display group between any period.

Sample Usage =GORILLA_SDORDERSGROUP(“TOY STORE”, “2023”) =GORILLA_SDORDERSGROUP(“TOY STORE”, “2023”, “US”) =GORILLA_SDORDERSGROUP(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) Syntax Description Description: Get total orders of Sponsored Display group between any period. Syntax: GORILLA_SDORDERSGROUP (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 account. PERIOD…

GORILLA_SDORDERSCAMPAIGN() – Get total orders of Sponsored Display campaigns between any period.

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

GORILLA_SDORDERSCAMPAIGNHIST() – Sponsored Orders display Campaign History

Sample Usage =GORILLA_SDORDERSCAMPAIGNHIST(“TOY STORE”, “Last Month”, “US”) =GORILLA_SDORDERSCAMPAIGNHIST(“TOY STORE”, “Last Month”, “US”, “BOTTLESMALL”) =GORILLA_SDORDERSCAMPAIGNHIST(“TOY STORE”, “Last Month”, “US”, “BOTTLESMALL”) Syntax Description Description: Sponsored Orders display Campaign History. Syntax: GORILLA_SDORDERSCAMPAIGNHIST(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…

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…