⚠️ 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.
PPC-Attributed Data Only
All advertising-related data is based on advertising-attributed sales, not organic sales.
When viewing metrics such as sales7d or conversions7d, these represent Sponsored Products (SP) sales or SP conversions, not total sales over the past seven days.
All values including spend, units sold, and performance metrics are derived solely from PPC-attributed data.
Regular advertising functions (non-HIST functions) aggregate data over the specified period. For example, SPPRODSALES() displays the total PPC sales for the selected timeframe, such as "last month."
HIST functions, like SPSALESPRODHIST(), provide daily PPC sales values.
All reported figures strictly reflect PPC-attributed data.
Syntax Screenshot
Description
It converts Sponsored Products IDs (like Campaign Names to Adgroup Names) in Google Sheets for Amazon PPC analysis.
Syntax
GORILLA_ADIDCONV(sellerId, [marketplace], filter, [direction], [status], [header])
Parameter Descriptions
Seller ID – (REQUIRED)
Seller ID or Nickname found within the Gorilla App to work with.
Marketplace – (OPTIONAL)
Marketplace country filter.
If left blank, the Main Marketplace in the Gorilla App will be used.
Valid inputs:
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)
Filter – (REQUIRED)
The range of values you want to convert. This can be a range such as,
A1:A100, where each cell contains values like CAM111, ADG222, SKU333, or ASIN123.
Direction – (OPTIONAL)
Defines the conversion direction (Left Input → Right Output).
If left blank, the default input will be used.
Valid inputs:
Valid inputs:
adcampaign2adgroup (DEFAULT)
adcampaign2adprod
adcampaign2adkeyword
adgroup2adcampaign
adgroup2adprod
adgroup2adkeyword
adprod2adcampaign
adprod2adgroup
adkeyword2adcampaign
adkeyword2adgroup
Status – (OPTIONAL)
Filter by status.
If left blank, the default input will be used.
Valid inputs:
Valid inputs:
enabled (DEFAULT)
paused
archived
all but archived
all
Header – (OPTIONAL)
Include the header line in the results.
If left blank, the default input will be used.
Valid inputs:
Valid inputs:
true (DEFAULT)
false
Usage & Examples
=GORILLA_ADIDCONV("TOY STORE", "CA", A3:A1000)This function pulls data for "TOY STORE" in the CA marketplace. It converts data based on the IDs listed in the range A3:A1000, which are campaigns and converts them into adgroups, only including ads that are enabled.
=GORILLA_ADIDCONV("TOY STORE", "US", B2:B100, "adgroup2adprod")This function pulls data for "TOY STORE" in the US marketplace. It converts data based on the IDs listed in the range B2:B100, which are adgroups and converts them into adproducts, only including ads that are enabled.
=GORILLA_ADIDCONV("TOY STORE", "US", B4:B639, "adgroup2adprod", "all")This function pulls data for "TOY STORE" in the US marketplace. It converts data based on the IDs listed in the range B4:B639, which are adgroups, and converts them into adproducts, including all ads.
Output Screenshot
