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

Sample Usage =GORILLA_SDNOSALESCAMPAIGN(“TOY STORE”, “2023”, “US”) =GORILLA_SDNOSALESCAMPAIGN(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) =GORILLA_SDNOSALESCAMPAIGN(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”, ,”DUMP”) Syntax Description Description: Shows all Sponsored Display campaign that has clicks, but no sales Syntax: GORILLA_SDNOSALESCAMPAIGN (sellerId, [period], [marketplace], [campaign], [datapoint], [output], [start_date], [end_date], [header]) Seller ID – REQUIREDSeller account or Nickname to work with. Period Attributes: MARKETPLACE…