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_SPORDERSPRODHIST() – Advertising Orders Product History

Sample Usage =GORILLA_SPORDERSPRODHIST(“TOY STORE”, “2023”) =GORILLA_SPORDERSPRODHIST(“TOY STORE”, “2023”, “US”, $A$1:$A$100) =GORILLA_SPORDERSPRODHIST(“TOY STORE”, “2023”, “US”, $A$1:$A$1000, “BOTTLESMALL”) Syntax Description Description: Advertising Orders Product History. Syntax: GORILLA_SPORDERSPRODHIST(sellerId, [period], [marketplace], [prod], [campaign], [adgroup], [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_SPORDERSPROD() – Get total orders of advertised products between any period

Sample Usage =GORILLA_SPORDERSPROD(“TOY STORE”, “2023”) =GORILLA_SPORDERSPROD(“TOY STORE”, “2023”, “US”, $A$1:$A$100) =GORILLA_SPORDERSPROD(“TOY STORE”, “2023”, “US”, $A$1:$A$1000, , “BOTTLESMALL”) Syntax Description Description: Get total orders of advertised products between any period. Syntax: GORILLA_SPORDERSPROD(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…

GORILLA_SPORDERSKEYWORDHIST() – Advertising Order Keyword History

Sample Usage =GORILLA_SPORDERSKEYWORDHIST(“TOY STORE”, “2023”) =GORILLA_SPORDERSKEYWORDHIST(“TOY STORE”, “2023”, “US”) =GORILLA_SPORDERSKEYWORDHIST(“TOY STORE”, “2023”, “US”, , “BOTTLESMALL”) Syntax Description Description: Advertising Order Keyword History. Syntax: GORILLA_SPORDERSKEYWORDHIST(sellerId, [period], [marketplace], [keyword], [campaign], [adgroup], [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_SPORDERSKEYWORD() – Get total orders of advertised keyword between any period

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

GORILLA_SPORDERSGROUPHIST() – Advertising Orders Group History

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

GORILLA_SPORDERSGROUP() – Get total orders of advertised group between any period

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

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…

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

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