GORILLA_SPORDERSCAMPAIGN() – Get total orders of advertised campaigns between any period

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

GORILLA_SPCAMPAIGNLIST() – Get advertising campaign list

Sample Usage =GORILLA_SPCAMPAIGNLIST(“TOY STORE”, “2023”) =GORILLA_SPCAMPAIGNLIST(“TOY STORE”, “2023”, “US”) =GORILLA_SPCAMPAIGNLIST(“TOY STORE”, “2023”, “US”, “ENABLED”) Syntax Description Description: Get advertising campaign list. Syntax: GORILLA_SPCAMPAIGNLIST(sellerId, period, [marketplace], [status], [hasSalesOnly], [start_date], [end_date], [header]) Seller ID – REQUIREDSeller account or Nickname to work with. PERIOD – OPTIONALPredefined period to get ads data or use ‘custom’ to specify a start…

GORILLA_SPHIGHACOSCAMPAIGN() – Advertising campaign with high acos

Sample Usage =GORILLA_SPHIGHACOSCAMPAIGN(“TOY STORE”) =GORILLA_SPHIGHACOSCAMPAIGN(“TOY STORE”,”Last Month”,”US”) =GORILLA_SPHIGHACOSCAMPAIGN(“TOY STORE”,”Last Month”,”US”,”SPEND”) Syntax Description Description: Advertising campaign with high acos Syntax: GORILLA_SPHIGHACOSCAMPAIGN(sellerId, [period], [marketplace], [datapoint], [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, MX, BR, UK, DE,…

GORILLA_SPNOSALESCAMPAIGN() – Shows all ads campaign that has clicks, but no sales

Sample Usage =GORILLA_SPNOSALESCAMPAIGN(“TOY STORE”) =GORILLA_SPNOSALESCAMPAIGN(“TOY STORE”,”Last Month”,”US”) =GORILLA_SPNOSALESCAMPAIGN(“TOY STORE”,”Last Month”,”US”,,”SPEND”) Syntax Description Description: Shows all ads campaign that has clicks, but no sales Syntax: GORILLA_SPNOSALESCAMPAIGN(sellerId, [period], [marketplace], [campaign], [datapoint], [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…

GORILLA_SPSALESCAMPAIGNHIST() – Advertising Sales Campaign History

Sample Usage =GORILLA_SPSALESCAMPAIGNHIST(“TOY STORE”, “2023”) =GORILLA_SPSALESCAMPAIGNHIST(“TOY STORE”, “2023”, “US”) =GORILLA_SPSALESCAMPAIGNHIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) Syntax Description Description: Advertising Sales Campaign History. Syntax: GORILLA_SPSALESCAMPAIGNHIST(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. DATAPOINT – OPTIONALReturn data for specific data…

GORILLA_SPSALESCAMPAIGN() – Get total sales of advertised campaigns between any period

Sample Usage =GORILLA_SPSALESCAMPAIGN(“TOY STORE”, “2023”) =GORILLA_SPSALESCAMPAIGN(“TOY STORE”, “2023”, “US”) =GORILLA_SPSALESCAMPAIGN(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) Syntax Description Description: Get total sales of advertised campaigns between any period. Syntax: GORILLA_SPSALESCAMPAIGN(sellerId, [period], [marketplace], [campaign], [datapoint], [start_date], [end_date], [header]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla account. DATAPOINT – OPTIONALReturn data for…