Skip to main content

GORILLA_BIZSESSIONS() – Sessions data from business reports

Updated over 2 months ago

Video Tutorial

⚠️ IMPORTANT NOTICE

Optimize Your Formula Usage

Use ranges (e.g., A2:A1000) in your formula whenever possible to ensure faster results and to prevent Google from blocking your account for 24 hours due to excessive resource usage.

Syntax Screenshot


Description

Get sessions-related data from business reports

Syntax

GORILLA_BIZSESSIONS(sellerId, period, [filter], [marketplace], [b2b], [datapoint], [days], [start_date], [end_date], [transpose], [header], [aggregate])

Parameter Descriptions

Seller ID – (REQUIRED)

Seller ID or Nickname found within the Gorilla App to work with.

Period – (REQUIRED)
Predefined period to get sessions information or use ‘custom’ to specify a start and end date.

Valid inputs:

  • Today

  • Yesterday

  • This Week

  • This Month

  • This Quarter

  • This Year

  • This Year-to-Last-Month

  • Last 7 Days

  • Last 14 Days

  • Last 30 Days

  • Last 60 Days

  • Last 90 Days

  • Last Week

  • Last Month

  • Last Quarter

  • Last Year

  • Last 3 Months

  • Last 12 Months

  • Same Day Last Week

  • Same Day Last Month

  • Same Day Last Year

  • Last 7 Days Week Ago

  • Last 7 Days Year Ago

  • Last 30 Days Month Ago

  • Last 30 Days Year Ago

  • Last Week Year Ago

  • Last Month Year Ago

  • YYYY-MM (change format to text)

  • YYYY

  • YYYYQ1

  • YYYYQ2

  • YYYYQ3

  • YYYYQ4

  • Custom

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.

If left blank, the Main Marketplace in the Gorilla App will be used.

Valid inputs:

  • ALL (All Marketplaces)

  • US (USA)

  • CA (Canada)

  • MX (Mexico)

  • BR (Brazil)

  • BE (Belgium)

  • UK (United Kingdom)

  • DE (Germany)

  • FR (France)

  • ES (Spain)

  • IT (Italy)

  • ZA (South Africa)

  • NL (Netherlands)

  • SE (Sweden)

  • PL (Poland)

  • TR (Turkey)

  • SA (Saudi Arabia)

  • EG (Egypt)

  • AE (United Arab Emirates)

  • JP (Japan)

  • AU (Australia)

  • SG (Singapore)

  • IN (India)

  • IE (Ireland)

  • EU (includes all European markets except the UK)

  • EURO (combines countries using the Euro currency)

B2B – (OPTIONAL)
Show or hide B2B datapoints when datapoints filter is ‘ALL’ or not specified.

Valid inputs:

  • include (DEFAULT)

  • exclude

Datapoint – (OPTIONAL)
Return data for specific data points. Can be a range of values like A1:E1 where A1 to E1 consists of different datapoint values. Default is empty value for all data points.

Valid inputs:

  • all

  • mobileapppageviews

  • mobileapppageviewsB2B

  • browserpageviews

  • browserpageviewsB2B

  • totalpageviews

  • totalpageviewsB2B

  • mobileappsessions

  • mobileappsessionsB2B

  • browsersessions

  • browsersessionsB2B

  • totalsessions

  • totalsessionB2B

Days – (OPTIONAL)
Number of days to return starting from the current date. This filter will override any custom start date.

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)

Layout of the data.
If "NO" or empty, returns Datapoints as Headers (left to right) and SKUs/ASINs as a Column (top to bottom). If "YES", returns SKUs/ASINs as Headers (left to right) and Datapoints as a Column (top to bottom).

Valid inputs:

  • no (DEFAULT)

  • yes

Header – (OPTIONAL)
Include the header line in the results.

Valid inputs:

  • true (DEFAULT)

  • false

Usage & Examples

=GORILLA_BIZSESSIONS("TOY STORE", "Custom", "B00YD545CC", "US", "INCLUDE", "ALL", , "2023-12-01", "2023-12-21")

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

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

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

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

Gets All BIZSESSIONS datapoints for TOY STORE 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_BIZSESSIONS("TOY STORE", "This Month", "IPHN3724", , , "TotalPageViews")

Gets BIZSESSIONS ‘TotalPageViews’ datapoint for TOY STORE ‘IPHN3724’ for all Marketplaces within this month.

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

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

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

Gets All BIZSESSIONS datapoints for all TOY STORE SKUs/ASINs, including B2B datapoints for sessions related data this 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.

Output Screenshot


​

Related Articles
GORILLA_BIZCONVERSIONHIST() – Get the daily conversions data from Business Reports.
GORILLA_BIZSALES() – Get sales data from business reports
GORILLA_BIZSALESHIST() – Daily historical values of the sales data from business reports
GORILLA_BIZSESSIONSHIST() – Displays daily historical sessions data from business reports
GORILLA_BIZPERFORMANCEHIST() – Daily historical data of seller performance from business reports
Did this answer your question?