GORILLA_SDSALESCAMPAIGN() – Get total sales of Sponsored Display campaigns between any period.

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

GORILLA_SDPERFORMGROUP() – Get total perform of Sponsored Display group between any period.

Sample Usage =GORILLA_SDPERFORMGROUP(“TOY STORE”, “2023”) =GORILLA_SDPERFORMGROUP(“TOY STORE”, “2023”, “US”) =GORILLA_SDPERFORMGROUP(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) Syntax Description Description: Get total perform of Sponsored Display group between any period. Syntax: GORILLA_SDPERFORMGROUP (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_SDOVERVIEWHIST() – Get daily total overview of the data for Sponsored Display

Sample Usage =GORILLA_SDOVERVIEWHIST(“TOY STORE”) =GORILLA_SDOVERVIEWHIST(“TOY STORE”,”Last Month”,”US”) =GORILLA_SDOVERVIEWHIST(“TOY STORE”,”Last Month”,”US”,B4:B215) Syntax Description Description: Get daily total overview of the data for Sponsored Display Syntax: ORILLA_SDOVERVIEWHIST (sellerId, [period], [marketplace], [prod], [campaign], [adgroup], [days], [sort], [start_date], [end_date], [transpose]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla account. Period Attributes: MARKETPLACE –…

GORILLA_SDPERFORMCAMPAIGN() – Get total perform of Sponsored Display campaigns between any period.

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

GORILLA_SDOVERVIEW() – Get total overview of the data for Sponsored Display

Sample Usage =GORILLA_SDOVERVIEW(“TOY STORE”) =GORILLA_SDOVERVIEW(“TOY STORE”,”Last Month”,”US”) =GORILLA_SDOVERVIEW(“TOY STORE”,”Last Month”,”US”,B4:B215) Syntax Description Description: Get total overview of the data for Sponsored Display Syntax: GORILLA_SDOVERVIEW (sellerId, [period], [marketplace], [prod], [campaign], [adgroup], [output], [start_date], [end_date]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla account. MARKETPLACE – OPTIONALMarketplace country filter. Country codes…

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_SDNOSALESGROUP() – Shows all Sponsored Display group that has clicks, but no sales

Sample Usage =GORILLA_SDNOSALESGROUP(“TOY STORE”, “Last Month”, “US”) =GORILLA_SDNOSALESGROUP(“TOY STORE”, “Last Month”, “US”, “BOTTLESMALL”) =GORILLA_SDNOSALESGROUP(“TOY STORE”, “Last Month”, “US”, “BOTTLESMALL”, , ,”DUMP”) Syntax Description Description: Shows all Sponsored Display group that has clicks, but no sales Syntax: GORILLA_SDNOSALESGROUP (sellerId, [period], [marketplace], [campaign], [adgroup], [datapoint], [output], [start_date], [end_date], [header]) Seller ID – REQUIREDSeller account or Nickname to…