Google Sheets Functions

  1. Home
  2. Docs
  3. Google Sheets Functions
  4. GORILLA_BIZCONVERSIONHIST() – Get daily historical conversion data from business reports

GORILLA_BIZCONVERSIONHIST() – Get daily historical conversion data from business reports

New functions for business reports have been released

Sample Usage

🚨 Use ranges (e.g.A2:A1000) in your formula wherever possible for 
quicker results and to prevent Google from blocking your account for 
24 hrs due to overloading their resources. 
=GORILLA_BIZCONVERSIONHIST("TOY STORE", "Custom", "B00YD545CC", "US", "INCLUDE", "ALL", , , "2023-12-01", "2023-12-21")
=GORILLA_BIZCONVERSIONHIST("TOY STORE", "Custom", "B00YD545CC", "US", "INCLUDE", "ALL", 21)
=GORILLA_BIZCONVERSIONHIST("TOY STORE", "This Week", A2:A10, "US", , "ALL")
=GORILLA_BIZCONVERSIONHIST("TOY STORE", "This Month", "IPHN3724", , , "UnitSessionPercentage")
=GORILLA_BIZCONVERSIONHIST("TOY STORE", "Same Day Last Month", "IPHN3724", "US")
=GORILLA_BIZCONVERSIONHIST("TOY STORE", "This Year")

Screenshot of Output

Syntax Description:

image 22 Gorilla ROI

Description:

Daily historical conversions data from business reports.

Syntax:

GORILLA_BIZCONVERSIONHIST(sellerId, period, [filter], [marketplace], [b2b], [datapoint], [days], [sort], [start_date], [end_date], [transpose])

Seller ID – REQUIRED
Enter the seller ID or nickname you entered in your Gorilla account.

PERIOD – REQUIRED
Predefined period to get data for or use custom to specify a start and end date.

FILTER – OPTIONAL
SKU or ASIN to filter the results. Can be a range of values like A1:A100 where A1 to A100 consists of values like SKU111, SKU222, SKU333 or ASIN123…

MARKETPLACE – OPTIONAL
Marketplace country filter. Country codes are US, CA, MX, BR, UK, DE, ES, IT, FR, NL, PL, TR, IN, SE, AE, AU, SG, JP, EG, SA. Use DEFAULT for your default market.

B2B– OPTIONAL
Show or hide B2B data. Valid values are:

  • Include (DEFAULT)
  • Exclude.

DATAPOINT – OPTIONAL
Return data for the specific data point.

Valid values are:

  • All (DEFAULT)
  • UnitSessionPercentage
  • UnitSessionPercentageB2B
  • OrderItemSessionPercentage
  • OrderItemSessionPercentageB2B

DAYS – OPTIONAL
Number of days to return starting from current date. This filter will override any custom start date.

SORT – OPTIONAL
Date sorting criteria. Valid values:

  • Desc (DEFAULT)
  • Asc

START_DATE – OPTIONAL
Starting date for the data when period is custom. (Date is ignored if the days filter has a non-zero value like 5.)

END_DATE – OPTIONAL
Ending date for the data when period is custom. (Date is ignored if the days filter has a non-zero value like 5.)

TRANSPOSE – OPTIONAL
If empty or no, returns datapoints as header and SKU as a column. If yes, returns SKUs as headers and datapoints as a column.

GORILLA_BIZCONVERSIONHIST Attributes

Period Attributes:

TodayThis monthLast 3 Months
YesterdayThis quarterLast 12 Months
Same day last weekThis yearLast 7 Days Week Ago
Same day last monthThis Year-to-Last-MonthLast 7 Days Year Ago
Same day last yearLast WeekLast 30 Days Month Ago
Last 7 DaysLast MonthLast 30 Days Year Ago
Last 14 DaysLast QuarterLast Week Year Ago
Last 30 DaysLast YearLast Month Year Ago
Last 90 DaysLast 60 DaysYYYY-MM (change format to text)
 This weekYYYY YYYYQ1… YYYYQ4
Custom

Datapoint Attributes:

AllUnitSessionPercentage
UnitSessionPercentageB2BOrderItemSessionPercentage
OrderItemSessionPercentageB2B

Examples:

🚨 Use ranges (e.g.A2:A1000) in your formula wherever possible for 
quicker results and to prevent Google from blocking your account for 
24 hrs due to overloading their resources. 
=GORILLA_BIZCONVERSIONHIST("TOY STORE", "Custom", "B00YD545CC", "US", "INCLUDE", "ALL", , , "2023-12-01", "2023-12-21")

Gets All BIZCONVERSIONHIST datapoints for B00YD545CC, including B2B datapoints for the US marketplace between Dec 1, 2023 and Dec 21, 2023.

=GORILLA_BIZCONVERSIONHIST("TOY STORE", "Custom", "B00YD545CC", "US", "INCLUDE", "ALL", 21)

Gets All BIZCONVERSIONHIST datapoints for B00YD545CC, including B2B datapoints for the US marketplace within the last 21 days starting from current date.

=GORILLA_BIZCONVERSIONHIST("TOY STORE", "This Week", A2:A10, "US", , "ALL")

Gets All BIZCONVERSIONHIST datapoints for SKUs/ASINs within A2:A10 range, including B2B datapoints for the US marketplace within this week. Supports 2 dimensional ranges. Bulk return an array of values by assigning the range of the SKUs or ASINs. In this example the SKUs or ASINs are listed in A2:A10 and returns all values at once. Can also work for rows and ranges like A1:Z1 or D3:G37.

=GORILLA_BIZCONVERSIONHIST("TOY STORE", "This Month", "IPHN3724", , , "UnitSessionPercentage")

Gets BIZCONVERSIONHIST ‘UnitSessionPercentage’ datapoint for ‘IPHN3724’ for all Marketplaces within this month.

=GORILLA_BIZCONVERSIONHIST("TOY STORE", "Same Day Last Month", "IPHN3724", "US")

Gets All BIZCONVERSIONHIST datapoints for ‘IPHN3724’, including B2B datapoints for the US marketplace the same day last month.

=GORILLA_BIZCONVERSIONHIST("TOY STORE", "This Year")

Gets All BIZCONVERSIONHIST datapoints for all SKUs/ASINs, including B2B datapoints for current year.

To get quarterly data use the format YYYYQ1, YYYYQ2, YYYYQ3, YYYYQ4 as the preset period.

To get monthly data, use the format YYYY-MM as the preset period.

How can we help?