advertising

GORILLA_SBNOSALESSEARCHTERM() – Shows all ads Brand search term that has clicks, but no sales

Sample Usage =GORILLA_SBNOSALESSEARCHTERM(“TOY STORE”, “2023”, “US”) =GORILLA_SBNOSALESSEARCHTERM(“TOY STORE”,”Last Month”,”US”,B4:B215) =GORILLA_SBNOSALESSEARCHTERM(“TOY STORE”,”Last Month”,”US”,B4:B215, , , ,”DUMP”) Syntax Description Description: Shows all ads Brand search term that has clicks, but no sales Syntax: GORILLA_SBNOSALESSEARCHTERM(sellerId, [period], [marketplace], [prod], [campaign], [adgroup], [datapoint], [output], [start_date], [end_date], [header]) Seller ID – REQUIREDSeller account or Nickname to work with. MARKETPLACE – OPTIONALMarketplace…

GORILLA_SBHIGHACOSSEARCHTERM() – Get Advertising Brand search term with high acos

Sample Usage =GORILLA_SBHIGHACOSSEARCHTERM(“TOY STORE”, “2023”, “US”) =GORILLA_SBHIGHACOSSEARCHTERM(“TOY STORE”, “Last Month”, “US”, B4:B215) =GORILLA_SBHIGHACOSSEARCHTERM(“TOY STORE”, “Last Month”, “US”, B4:B215 , , , , “DUMP”) Syntax Description Description: Get Advertising Brand search term with high acos Syntax: =GORILLA_SBHIGHACOSSEARCHTERM(sellerId, [period], [marketplace], [prod], [campaign], [adgroup], [datapoint], [output], [start_date], [end_date], [header]) Seller ID – REQUIREDSeller account or Nickname to work…

GORILLA_SBOVERVIEW() – Get total brand overview of the data for advertising

Sample Usage =GORILLA_SBOVERVIEW(“TOY STORE”) =GORILLA_SBOVERVIEW(“TOY STORE”, “Last Month”, “US”) =GORILLA_SBOVERVIEW(“TOY STORE”, “Last Month”, “US”, B4:B215,, “SINGLE”) Syntax Description Description: Get total brand overview of the data for advertising Syntax: GORILLA_SBOVERVIEW(sellerId, [period], [marketplace], [campaign], [adgroup], [output], [start_date], [end_date]) Seller ID – REQUIREDSeller account or Nickname to work with. MARKETPLACE – OPTIONALMarketplace country filter. Country codes are…

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], [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_SBPERFORMKEYWORD() – Get total perform of advertised Brand keyword between any period

Sample Usage =GORILLA_SBPERFORMKEYWORD(“TOY STORE”, “2023”, “US”) =GORILLA_SBPERFORMKEYWORD(“TOY STORE”, “2023”, “US”,”BOTTLESMALL”) =GORILLA_SBPERFORMKEYWORD(“TOY STORE”, “2023”, “US”,”BOTTLESMALL”, , , ,”DUMP”) Syntax Description Description: Get total perform of advertised Brand keyword between any period Syntax: =GORILLA_SBPERFORMKEYWORD(sellerId, [period], [marketplace], [keyword], [campaign], [adgroup], [datapoint], [output], [start_date], [end_date], [header]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your…

GORILLA_SBHIGHACOSKEYWORD() – Get Advertising Brand keyword with high acos

Sample Usage =GORILLA_SBHIGHACOSKEYWORD(“TOY STORE”, “2023”, “US”) =GORILLA_SBHIGHACOSKEYWORD(“TOY STORE”,”Last Month”,”US”, , , ,”SPEND”) =GORILLA_SBHIGHACOSKEYWORD(“TOY STORE”,”Last Month”,”US”, , , ,”SPEND”,”DUMP”) Syntax Description Description: Get Advertising Brand keyword with high acos Syntax: GORILLA_SBHIGHACOSKEYWORD(sellerId, [period], [marketplace], [prod], [campaign], [adgroup], [datapoint], [output], [start_date], [end_date], [header]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla account….

GORILLA_SBHIGHACOSGROUP() – Get Advertising Brand group with high acos

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

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_SBOVERVIEWHIST() – Get daily total Brand overview of the data for advertising

Sample Usage =GORILLA_SBOVERVIEWHIST(“TOY STORE”, “2023”, “US”) =GORILLA_SBOVERVIEWHIST(“TOY STORE”, “2023”, “US”,”BOTTLESMALL”) =GORILLA_SBOVERVIEWHIST(“TOY STORE”, , “US”,”BOTTLESMALL”) Syntax Description Description: Get daily total Brand overview of the data for advertising. Syntax: =GORILLA_SBOVERVIEWHIST(sellerId, [period], [marketplace], [campaign], [adgroup], [days], [sort], [start_date], [end_date], [transpose]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla account. MARKETPLACE –…

GORILLA_SBNOSALESKEYWORD() – Shows all ads Brand keywords that has clicks, but no sales

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