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], [start_date], [end_date]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla account. PERIOD – OPTIONALPredefined period to get ads…

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], [start_date], [end_date], [header]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla account. PERIOD – REQUIREDPredefined period…

GORILLA_SPPERFORMCAMPAIGNHIST() – Advertising Perform Campaign History

Sample Usage =GORILLA_SPPERFORMCAMPAIGNHIST(“TOY STORE”, “2023”) =GORILLA_SPPERFORMCAMPAIGNHIST(“TOY STORE”, “2023”, “US”) =GORILLA_SPPERFORMCAMPAIGNHIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) Syntax Description Description: Advertising Perform Campaign History. Syntax: GORILLA_SPPERFORMCAMPAIGNHIST(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_SPPERFORMCAMPAIGN() – Get total perform of advertised campaigns between any period

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

GORILLA_SPORDERSCAMPAIGNHIST() – Advertising Orders Campaign History

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