Google Sheets Functions

  1. Home
  2. Docs
  3. Google Sheets Functions
  4. GORILLA_SNSFORECAST() – Get Subscribe and Save forecast reports

GORILLA_SNSFORECAST() – Get Subscribe and Save forecast reports

Sample Usage

=GORILLA_SNSFORECAST()
=GORILLA_SNSFORECAST(“SKU111, SKU222, SKU333”)
=GORILLA_SNSFORECAST(A3:A12, “US”, “fullwithheader”)
=GORILLA_SNSFORECAST(A3:A12, “US”, “singledatapoint”, “activeSubscriptions”)

Syntax Description

GORILLA_SNSFORECAST() – Get Subscribe and Save forecast reports 1

Description:

Return the subscribe and save forecast report for the skus that are activated in your account.

Syntax:

GORILLA_SNSFORECAST([filter], [marketplace], [returnStyle], [datapoint])

For Gorilla ROI Agency, the syntax is

GORILLA_SNSFORECAST([filter], [marketplace], [returnStyle], [datapoint])

filter – OPTIONAL

SKU or ASIN to filter the results. Can be a range of values like A1:A100 or “SKU111, SKU222, SKU333” or ASIN123.

marketplace – OPTIONAL

Marketplace country filter. Country codes are US, CA, MX, BR, UK, DE, ES, IT, FR, NL, SE, TR, IN, SE, AU, SG, JP. Use ALL to combine values from a single account, EU for all Europe markets EXCEPT UK, EURO to combine countries using EURO currency. Amazon Marketplace ID like ATVPDKIKX0DER can be used too.

returnStyle – OPTIONAL

Return style (defaults to fullWithHeader).

Possible values

  • full
  • fullWithHeader
  • singleDataPoint. SKU filter and datapoint are mandatory when using singleDataPoint.

datapoint – OPTIONAL

Return data for specific data point. Default is empty value which shows “full” returnStyle. Can be a range of values like A1:S1.

  • avgDiscount8weeks
  • activeSubscriptions
  • week1startDate
  • scheduledUnitsWeek1
  • scheduledUnitsWeek2
  • scheduledUnitsWeek8
  • offerState

Examples:

=GORILLA_SNSFORECAST()

If no attributes are entered, it will list all your current active SNS products and display a full table of results with all support data points offered. The forecast data will load based on the closet starting date according to the current date.

=GORILLA_SNSFORECAST(“SKU111, SKU222, SKU333”)

This will the subscribe and save forecast report for the range of SKUs entered.

=GORILLA_SNSFORECAST(A3:A12, “US”, “fullwithheader”)

This will auto generate a table of the SNS forecast report for the SKUs or ASINs listed in A3:A12 for the US market. The table will generate a header. The header can be removed by using “full” instead of “fullwithheader”.

=GORILLA_SNSFORECAST(A3:A12, “US”, “singledatapoint”, “activeSubscriptions”)

To get one data point only, select the return style as “singledatapoint” and then reference the data point you wish to get. In this example, it will get the “activesubscriptions” for each of the SKUs listed in A3:A12.

For Gorilla AGENCY, the formulas will start with the seller ID:

=GORILLA_SNSFORECAST(sellerID)
=GORILLA_SNSFORECAST(sellerID, “SKU111, SKU222, SKU333”)
=GORILLA_SNSFORECAST(sellerID, A3:A12, “US”, “fullwithheader”)
=GORILLA_SNSFORECAST(sellerID, A3:A12, “US”, “singledatapoint”, “activeSubscriptions”)

What is Gorilla ROI?

Gorilla ROI automatically pulls Amazon data into Google sheets for you to make sense of the data without the inconvenience of manually downloading, sorting and updating spreadsheets.

Learn how you can centralize your data and use it to increase your ROI.

How can we help?