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_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…

GORILLA_SBPERFORMCAMPAIGNHIST() – Get Advertising Brand Perform Campaign History

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

GORILLA_SBPERFORMCAMPAIGN() – Get total perform of advertised Brand campaigns between any period

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

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

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

Sample Usage =GORILLA_SBUNITSCAMPAIGN(“TOY STORE”, “2023”, “US”) =GORILLA_SBUNITSCAMPAIGN(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) =GORILLA_SBUNITSCAMPAIGN(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”, ,”DUMP”) Syntax Description Description: Get total units of advertised brand campaigns between any period Syntax: =GORILLA_SBUNITSCAMPAIGN(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_SBSPENDCAMPAIGNHIST() – Get advertising Brand Spend Campaign History

Sample Usage =GORILLA_SBSPENDCAMPAIGNHIST(“TOYSTORE”,”2023″,”US”) =GORILLA_SBSPENDCAMPAIGNHIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) =GORILLA_SBSPENDCAMPAIGNHIST(“TOY STORE”, “THIS MONTH”, “US”, “BOTTLESMALL”) Syntax Description Description: Get advertising brand Spend Campaign History Syntax: =GORILLA_SBSPENDCAMPAIGNHIST(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…

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

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

GORILLA_SBSALESCAMPAIGNHIST() – Get Advertising Brand Sales Campaign History

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