GORILLA_SDSPENDCAMPAIGN() – Get total advertising spend of campaign between any period

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

GORILLA_SDSALESGROUP() – Get total sales of Sponsored Display group between any period.

Sample Usage =GORILLA_SDSALESGROUP(“TOY STORE”, “2023”) =GORILLA_SDSALESGROUP(“TOY STORE”, “2023”, “US”) =GORILLA_SDSALESGROUP(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) Syntax Description Description: Get total sales of Sponsored Display group between any period. Syntax: GORILLA_SDSALESGROUP (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_SDSALESPRODHIST() – Sponsored Display Sales Product History.

Sample Usage =GORILLA_SDSALESPRODHIST(“TOY STORE”, “2023”) =GORILLA_SDSALESPRODHIST(“TOY STORE”, “2023”, “US”, $A$1:$A$100) =GORILLA_SDSALESPRODHIST(“TOY STORE”, “2023”, “US”, $A$1:$A$1000, “BOTTLESMALL”) Syntax Description Description: Sponsored Display Sales Product History. Syntax: GORILLA_SDSALESPRODHIST (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_SDSALESGROUPHIST() – Sponsored Display Sales Group History.

Sample Usage =GORILLA_SDSALESGROUPHIST(“TOY STORE”, “2023”) =GORILLA_SDSALESGROUPHIST(“TOY STORE”, “2023”, “US”) =GORILLA_SDSALESGROUPHIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) Syntax Description Description: Sponsored Display Sales Group History. Syntax: GORILLA_SDSALESGROUPHIST (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 Attributes: DATAPOINT –…

GORILLA_SDPERFORMPRODHIST() – Sponsored Display Perform Product History.

Sample Usage =GORILLA_SDPERFORMPRODHIST(“TOY STORE”, “2023”) =GORILLA_SDPERFORMPRODHIST(“TOY STORE”, “2023”, “US”, $A$1:$A$100) =GORILLA_SDPERFORMPRODHIST(“TOY STORE”, “2023”, “US”, $A$1:$A$1000, “BOTTLESMALL”) Syntax Description Description: Sponsored Display Perform Product History. Syntax: GORILLA_SDPERFORMPRODHIST (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_SDSPENDCAMPAIGNHIST() – Sponsored Display Spend Campaign History

Sample Usage =GORILLA_SDSPENDCAMPAIGNHIST(“TOY STORE”, “2023”) =GORILLA_SDSPENDCAMPAIGNHIST(“TOY STORE”, “2023”, “US”) =GORILLA_SDSPENDCAMPAIGNHIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) Syntax Description Description: Sponsored Display Spend Campaign History. Syntax: GORILLA_SDSPENDCAMPAIGNHIST (sellerId, [period], [marketplace], [campaign], [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 get…

GORILLA_SDSALESCAMPAIGNHIST() – Sponsored Display Sales Campaign History.

Sample Usage =GORILLA_SDSALESCAMPAIGNHIST(“TOY STORE”, “2023”) =GORILLA_SDSALESCAMPAIGNHIST(“TOY STORE”, “2023”, “US”) =GORILLA_SDSALESCAMPAIGNHIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) Syntax Description Description: Sponsored Display Sales Campaign History. Syntax: GORILLA_SDSALESCAMPAIGNHIST (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 Attributes: DATAPOINT – OPTIONALReturn…

GORILLA_SDPERFORMPROD() – Get total perform of Sponsored Display products between any period.

Sample Usage =GORILLA_SDPERFORMPROD(“TOY STORE”, “2023”) =GORILLA_SDPERFORMPROD(“TOY STORE”, “2023”, “US”, $A$1:$A$100) =GORILLA_SDPERFORMPROD(“TOY STORE”, “2023”, “US”, $A$1:$A$1000, “BOTTLESMALL”) Syntax Description Description: Get total perform of Sponsored Display products between any period. Syntax: GORILLA_SDPERFORMPROD (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_SDPERFORMGROUPHIST() – Sponsored Display Perform Group History.

Sample Usage =GORILLA_SDPERFORMGROUPHIST(“TOY STORE”, “2023”) =GORILLA_SDPERFORMGROUPHIST(“TOY STORE”, “2023”, “US”) =GORILLA_SDPERFORMGROUPHIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) Syntax Description Description: Sponsored Display Perform Group History. Syntax: GORILLA_SDPERFORMGROUPHIST (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 Attributes: DATAPOINT…

GORILLA_SDSALESPROD() – Get total sales of Sponsored Display products between any period

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