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

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

GORILLA_SBHIGHACOSCAMPAIGN() – Get Advertising Brand campaign with high acos

Sample Usage =GORILLA_SBHIGHACOSCAMPAIGN(“TOY STORE”, “2023”, “US”) =GORILLA_SBHIGHACOSCAMPAIGN(“TOY STORE”,”Last Month”,”US”,”SPEND”) =GORILLA_SBHIGHACOSCAMPAIGN(“TOY STORE”,”Last Month”,”US”,”SPEND”,”DUMP”) Syntax Description Description: Get Advertising Brand campaign with high acos Syntax: =GORILLA_SBHIGHACOSCAMPAIGN(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,…

GORILLA_SBORDERSCAMPAIGNHIST() – Get Advertising Orders Brand Campaign History

Sample Usage =GORILLA_SBORDERSCAMPAIGNHIST(“TOY STORE”, “2023”, “US”) =GORILLA_SBORDERSCAMPAIGNHIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) =GORILLA_SBORDERSCAMPAIGNHIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) Syntax Description Description: Advertising Orders Brand Campaign History Syntax: GORILLA_SBORDERSCAMPAIGNHIST(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 – REQUIREDPredefined period…

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

Sample Usage =GORILLA_SBORDERSCAMPAIGN(“TOY STORE”, “2023”, “US”) =GORILLA_SBORDERSCAMPAIGN(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) =GORILLA_SBORDERSCAMPAIGN(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”, ,”DUMP”) Syntax Description Description: Get total orders of advertised brand campaigns between any period Syntax: GORILLA_SBORDERSCAMPAIGN(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….

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

Sample Usage =GORILLA_SBNOSALESCAMPAIGN(“TOY STORE”, “2023”, “US”) =GORILLA_SBNOSALESCAMPAIGN(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) =GORILLA_SBNOSALESCAMPAIGN(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”, ,”DUMP”) Syntax Description Description: Shows all ads Brand campaign that has clicks, but no sales Syntax: GORILLA_SBNOSALESCAMPAIGN(sellerId, [period], [marketplace], [campaign], [datapoint], [output], [start_date], [end_date], [header]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla…

GORILLA_SBCAMPAIGNLIST() – Get advertising Brand campaign list

Sample Usage =GORILLA_SBCAMPAIGNLIST(“TOY STORE”, “2023”) =GORILLA_SBCAMPAIGNLIST(“TOY STORE”, “2023”, “US”) =GORILLA_SBCAMPAIGNLIST(“TOY STORE”, “2023”, “US”, “ENABLED”) Syntax Description Description: Get advertising brand campaign list Syntax: GORILLA_SBCAMPAIGNLIST(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…

GORILLA_SPSPENDCAMPAIGNHIST() – Advertising Spend Campaign History

Sample Usage =GORILLA_SPSPENDCAMPAIGNHIST(“TOY STORE”, “2023”) =GORILLA_SPSPENDCAMPAIGNHIST(“TOY STORE”, “2023”, “US”) =GORILLA_SPSPENDCAMPAIGNHIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) Syntax Description Description: Advertising Spend Campaign History. Syntax: GORILLA_SPSPENDCAMPAIGNHIST(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 ads data…

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

Sample Usage =GORILLA_SPSPENDCAMPAIGN(“TOY STORE”, “2023”) =GORILLA_SPSPENDCAMPAIGN(“TOY STORE”, “2023”, “US”) =GORILLA_SPSPENDCAMPAIGN(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) Syntax Description Description: Get total advertising spend of campaign between any period. Syntax: GORILLA_SPSPENDCAMPAIGN(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 to…

GORILLA_SPUNITSCAMPAIGNHIST() – Advertising Units Campaign History

Sample Usage =GORILLA_SPUNITSCAMPAIGNHIST(“TOY STORE”, “2023”) =GORILLA_SPUNITSCAMPAIGNHIST(“TOY STORE”, “2023”, “US”) =GORILLA_SPUNITSCAMPAIGNHIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) Syntax Description Description: Advertising Units Campaign History. Syntax: GORILLA_SPUNITSCAMPAIGNHIST(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 – REQUIREDPredefined period to get ads…

GORILLA_SPUNITSCAMPAIGN() – Get total units of advertised campaigns between any period

Sample Usage =GORILLA_SPUNITSCAMPAIGN(“TOY STORE”, “2023”) =GORILLA_SPUNITSCAMPAIGN(“TOY STORE”, “2023”, “US”) =GORILLA_SPUNITSCAMPAIGN(“TOY STORE”, “2023”, “US”, , “BOTTLESMALL”) Syntax Description Description: Get total units of advertised campaigns between any period. Syntax: GORILLA_SPUNITSCAMPAIGN(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 – REQUIREDPredefined…