GORILLA_SDSPENDPRODHIST() – Sponsored Display Spend Product History.

Sample Usage =GORILLA_SDSPENDPRODHIST(“TOY STORE”, “2023”) =GORILLA_SDSPENDPRODHIST(“TOY STORE”, “2023”, “US”, $A$1:$A$100) =GORILLA_SDSPENDPRODHIST(“TOY STORE”, “2023”, “US”, $A$1:$A$1000, “BOTTLESMALL”) Syntax Description Description: Sponsored Display Spend Product History Syntax: GORILLA_SDSPENDPRODHIST (sellerId, [period], [marketplace], [prod], [days], [sort], [start_date], [end_date], [transpose], [header]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla account. Period Attributes: PROD –…

GORILLA_SDSPENDGROUPHIST() – Sponsored Display Spend Group History

Sample Usage =GORILLA_SDSPENDGROUPHIST(“TOY STORE”, “2023”) =GORILLA_SDSPENDGROUPHIST(“TOY STORE”, “2023”, “US”) =GORILLA_SDSPENDGROUPHIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) Syntax Description Description: Sponsored Display Spend Group History. Syntax: GORILLA_SDSPENDGROUPHIST (sellerId, [period], [marketplace], [campaign], [adgroup], [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…

GORILLA_SDSPENDPROD() – Get total Sponsored Display spend of product between any period.

Sample Usage =GORILLA_SDSPENDPROD(“TOY STORE”, “2023”) =GORILLA_SDSPENDPROD(“TOY STORE”, “2023”, “US”, $A$1:$A$100) =GORILLA_SDSPENDPROD(“TOY STORE”, “2023”, “US”, $A$1:$A$1000, “BOTTLESMALL”) Syntax Description Description: Get total Sponsored Display spend of product between any period Syntax: GORILLA_SDSPENDPROD (sellerId, [period], [marketplace], [prod], [campaign], [adgroup], [output], [start_date], [end_date], [header]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla…

GORILLA_SDSPENDGROUP() – Get total Sponsored Display spend of adgroup between any period

Sample Usage =GORILLA_SDSPENDGROUP(“TOY STORE”, “2023”) =GORILLA_SDSPENDGROUP(“TOY STORE”, “2023”, “US”) =GORILLA_SDSPENDGROUP(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) Syntax Description Description: Get total Sponsored Display spend of adgroup between any period. Syntax: GORILLA_SDSPENDGROUP (sellerId, [period], [marketplace], [campaign], [adgroup], [output], [start_date], [end_date], [header]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla account. PERIOD –…

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

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

GORILLA_SDSPENDCAMPAIGNHIST() – Sponsored Display Spend Campaign History

Sample Usage =GORILLA_SDSPENDCAMPAIGNHIST(“TOY STORE”, “2023”) =GORILLA_SDSPENDCAMPAIGNHIST(“TOY STORE”, “2023”, “US”) =GORILLA_SDSPENDCAMPAIGNHIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) Syntax Description Description: Sponsored Display Spend Campaign History. Syntax: GORILLA_SDSPENDCAMPAIGNHIST (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_SBSPENDKEYWORDHIST() – Get Advertising Brand Spend Keyword History

Sample Usage =GORILLA_ADSPENDKEYWORDHIST(“TOY STORE”, “2023”) =GORILLA_ADSPENDKEYWORDHIST(“TOY STORE”, “2023”, “US”) ‘=GORILLA_SBSPENDKEYWORDHIST(“TOY STORE”, , “US”, “BOTTLESMALL”) Syntax Description Description: Advertising brand Spend Keyword History Syntax: GORILLA_SBSPENDKEYWORDHIST(sellerId, [period], [marketplace], [keyword], [campaign], [adgroup], [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…

GORILLA_SBSPENDKEYWORD() – Get total advertising Brand spend of keywords between any period

Sample Usage =GORILLA_SBSPENDKEYWORD(“TOYSTORE”,”2023″,”US”) =GORILLA_SBSPENDKEYWORD(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) =GORILLA_SBSPENDKEYWORD(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”, , ,”DUMP”) Syntax Description Description: Get total advertising brand spend of keywords between any period Syntax: GORILLA_SBSPENDKEYWORD(sellerId, [period], [marketplace], [keyword], [campaign], [adgroup], [output], [start_date], [end_date], [header]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla account. PERIOD…

GORILLA_SBSPENDGROUPHIST() – Get advertising Brand Spend Group History

Sample Usage =GORILLA_SBSPENDGROUPHIST(“TOYSTORE”,”2023″,”US”) =GORILLA_SBSPENDGROUPHIST(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) =GORILLA_SBSPENDGROUPHIST(“TOY STORE”, “THIS MONTH”, “US”, “BOTTLESMALL”) Syntax Description Description: Get advertising brand Spend Group History Syntax: GORILLA_SBSPENDGROUPHIST(sellerId, [period], [marketplace], [campaign], [adgroup], [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…

GORILLA_SBSPENDGROUP() – Get total advertising Brand spend of adgroup between any period

Sample Usage =GORILLA_SBSPENDGROUP(“TOY STORE”, “2023”, “US”) =GORILLA_SBSPENDGROUP(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”) =GORILLA_SBSPENDGROUP(“TOY STORE”, “2023”, “US”, “BOTTLESMALL”, ,”DUMP”) Syntax Description Description: Get total advertising brand spend of adgroup between any period. Syntax: GORILLA_SBSPENDGROUP(sellerId, [period], [marketplace], [campaign],[adgroup], [output], [start_date], [end_date], [header]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla account. PERIOD…