GORILLA_SDUNITSGROUP() – Get total units of Sponsored Display group between any period.

Sample Usage =GORILLA_SDUNITSGROUP(“TOY STORE”, “2023”) =GORILLA_SDUNITSGROUP(“TOY STORE”, “2023”, “US”) =GORILLA_SDUNITSGROUP(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) Syntax Description Description: Get total units of Sponsored Display group between any period. Syntax: GORILLA_SDUNITSGROUP (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_SDUNITSPROD() – Get total units of Sponsored Display products between any period

Sample Usage =GORILLA_SDUNITSPROD(“TOY STORE”, “2023”) =GORILLA_SDUNITSPROD(“TOY STORE”, “2023”, “US”, A1:$A100) =GORILLA_SDUNITSPROD(“TOY STORE”, “2023”, “US”, A1:A1000, “BOTTLESMALL”) Syntax Description Description: Get total units of Sponsored Display products between any period Syntax: GORILLA_SDUNITSPROD (sellerId, [period], [marketplace], [prod], [campaign], [adgroup], [datapoint], [output], [start_date], [end_date], [header]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your…

GORILLA_SDUNITSGROUPHIST() – Sponsored Display Units Group History

Sample Usage =GORILLA_SDUNITSGROUPHIST(“TOY STORE”, “2023”, “US”) =GORILLA_SDUNITSGROUPHIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) =GORILLA_SDUNITSGROUPHIST(“TOY STORE”, , “US”, “BOTTLESMALL”) Syntax Description Description: Sponsored Display Units Group History Syntax: GORILLA_SDUNITSGROUPHIST (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_SDUNITSCAMPAIGNHIST() – Sponsored Display Units Campaign History

Sample Usage =GORILLA_SDUNITSCAMPAIGNHIST(“TOY STORE”, “2023”) =GORILLA_SDUNITSCAMPAIGNHIST(“TOY STORE”, “2023”, “US”) =GORILLA_SDUNITSCAMPAIGNHIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) Syntax Description Description: Sponsored Display Units Campaign History Syntax: GORILLA_SDUNITSCAMPAIGNHIST (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 – OPTIONALPredefined period to…

GORILLA_SDUNITSCAMPAIGN() – Get total units of Sponsored Display campaigns between any period

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

GORILLA_SDUNITSPRODHIST() – Sponsored Display Units Product History

Sample Usage =GORILLA_SDUNITSPRODHIST(“TOY STORE”, “2023”) =GORILLA_SDUNITSPRODHIST(“TOY STORE”, “2023”, “US”, $A$1:$A$100) =GORILLA_SDUNITSPRODHIST(“TOY STORE”, “2023”, “US”, $A$1:$A$1000, “BOTTLESMALL”) Syntax Description Description: Sponsored Display Units Product History Syntax: GORILLA_SDUNITSPRODHIST (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…

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