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…

GORILLA_SDHIGHACOSGROUP() – Sponsored Display group with high acos

Sample Usage =GORILLA_SPHIGHACOSGROUP(“TOY STORE”) =GORILLA_SPHIGHACOSGROUP(“TOY STORE”,”Last Month”,”US”) =GORILLA_SPHIGHACOSGROUP(“TOY STORE”,”Last Month”,”US”,,”SPEND”) Syntax Description Description: Sponsored Display group with high acos Syntax: GORILLA_SDHIGHACOSGROUP (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. MARKETPLACE – OPTIONALMarketplace country filter. Country codes are US, CA,…

GORILLA_SDHIGHACOSCAMPAIGN() – Sponsored Display campaign with high acos

Sample Usage =GORILLA_SDHIGHACOSCAMPAIGN(“TOY STORE”) =GORILLA_SDHIGHACOSCAMPAIGN(“TOY STORE”, “2023”, “US”) =GORILLA_SDHIGHACOSCAMPAIGN(“TOY STORE”,”Last Month”,”US”,”CLICKS”) Syntax Description Description: Sponsored Display campaign with high acos Syntax: GORILLA_SDHIGHACOSCAMPAIGN (sellerId, [period], [marketplace], [datapoint], [output], [start_date], [end_date], [header]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla account. MARKETPLACE – OPTIONALMarketplace country filter. Country codes are US, CA,…

GORILLA_SDPRODLIST() – Get Sponsored Display product list

Sample Usage =GORILLA_SDPRODLIST(“TOY STORE”, “2023”) =GORILLA_SDPRODLIST(“TOY STORE”, “2023”, “US”) =GORILLA_SDPRODLIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) Syntax Description Description: Get Sponsored Display product list. Syntax: GORILLA_SDPRODLIST(sellerId, [period], [marketplace], [campaign], [adgroup], [status], [hasSalesOnly], [start_date], [end_date], [header]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla account. Period Attributes: MARKETPLACE – OPTIONALMarketplace country filter….

GORILLA_SDGROUPLIST() – Get Sponsored Display group list

Sample Usage =GORILLA_SDGROUPLIST(“TOY STORE”, “2023”) =GORILLA_SDGROUPLIST(“TOY STORE”, “2023”, “US”) =GORILLA_SDGROUPLIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) Syntax Description Description: Get Sponsored Display group list. Syntax: GORILLA_SDGROUPLIST(sellerId, [period], [marketplace], [campaign], [status], [hasSalesOnly], [start_date], [end_date], [header]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla account. Period Attributes: STATUS – OPTIONALFilter by status. Status…

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_SDPERFORMCAMPAIGNHIST() – Sponsored Display Perform Campaign History.

Sample Usage =GORILLA_SDPERFORMCAMPAIGNHIST(“TOY STORE”, “2023”) =GORILLA_SDPERFORMCAMPAIGNHIST(“TOY STORE”, “2023”, “US”) =GORILLA_SDPERFORMCAMPAIGNHIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) Syntax Description Description: Sponsored Display Perform Campaign History. Syntax: GORILLA_SDPERFORMCAMPAIGNHIST (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_SDCAMPAIGNLIST() – Get Sponsored Display campaign list

Sample Usage =GORILLA_SDCAMPAIGNLIST(“TOY STORE”, “2023”) =GORILLA_SDCAMPAIGNLIST(“TOY STORE”, “2023”, “US”) =GORILLA_SDCAMPAIGNLIST(“TOY STORE”, “2023”, “US”, “ENABLED”) Syntax Description Description: Get Sponsored Display campaign list Syntax: GORILLA_SDCAMPAIGNLIST(sellerId, [period], [marketplace], [status], [hasSalesOnly], [start_date], [end_date], [header]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla account. PERIOD – OPTIONALPredefined period to get ads data or…