Amazon Connector for Google Sheets
Amazon data automatically plugged into your Google Sheet
- Save Time
- Greater Accuracy
- More Money
Manual reporting is a time-consuming and wasteful hassle.
Wastes Time
How much time do you or your employees spend creating reports? Copy-and-paste reporting?
Inaccurate Reports
How often do you make decisions based upon a report made by tedious manual entry?
Unoptimized Ad Campaigns
Why are you spending that much on that ad? Why aren’t you spending more?
These are questions you can’t answer if you don’t have a good grip on your ad and campaign data
Poor Decisions
Are you making your business decisions based upon stale data? Last week’s data is usually too old.
Losing Money
If you aren’t looking at the right data and from the right source, you are saying no to growth and money in your pocket.
Why should I use the Seller Labs Sheets Extension?
Save Time
Automatic Reports
How much time do you or your employees spend creating reports? Copy-and-paste reporting? Greater Accuracy
Seller Central Data
Throw away old, inaccurate, copy-and-paste reporting and pull in your data straight from Amazon Seller Central Account. See the latest and the greatest on the daily. More Money
Data Insights
Make insightful, data-driven decisions to propel your business past the competition. Sell more, better optimize, advertise like a pro, and watch your revenue steadily climb.How It Works
The fastest, most accurate way to see and analyze your data
1
Integrate
Getting started takes 2 minutes. Connect Data Warehouse and your marketplace data2
Get Add-On
Install the easy-to-use google sheets extension3
Use Formulas
Use Google Sheet formulas to instantly access data4
SQL Queries
For advanced users allow for increased customization of data views and analysis5
Data-Driven Decisions
Make data-driven decisions to propel your business forwardLike any other formula in Sheets…
Super helpful dropdown documentation.
sl_keywords()
Sample Usage:
‘=sl_keywords(“default”, “”, “”, “keyword, bid, serving_status”)”
‘=sl_keywords(“default”, “71844445819”, “278778753738”, “keyword, bid, serving_status”)”
‘=sl_keywords(“default”, “71844445819”, “278778753738”, “keyword, bid, serving_status”)”
Syntax Description:
sl_keywords ( venue_selector , list_of_campaign_ids, list_of_adgroup_ids, attributes)
EXAMPLE
sl_keywords(“default”, “11758309922985”, “276078802792547”, “venue_id, bid, state”)
ABOUT
Return information on keywords in your campaigns.
Description:
Return information on keywords in your campaigns.
Syntax:
PARAMETER
TYPE
DESCRIPTION
venue_selector
REQUIRED
Venue/Marketplace filter. Can use a number, such as 1 or 2 for the first or second marketplaceetc. in your Seller Labs account. Use “default” or 0 to select the default marketplace. Countrycodes (us, uk, mx, ca, etc) can also be used.
list_of_campaign_ids
OPTIONAL
A comma-separated list or a data range of campaign_ids
list_of_adgroup_ids
OPTIONAL
A comma-separated list or a data range of adgroup_ids
attributes
REQUIRED
A comma-separated list of attributes associated with a keyword including: keyword, venue_id,keyword_id, campaign_id, campaign_name, campaign_type, adgroup_id, adgroup_name, bid,created_ts, modified_ts, serving_status, and match_typs.
Who should choose the Seller Labs Sheets Extension?
Amazon Sellers who Understand Data
Account managers who waste time creating manual reports
You click multiple times to download reports
You want to see advertising Data
You’re Tired of Getting Things the Long Way
Employees who want to look professional to their bosses
You Have a Basic Understanding of Sheets
You Wish You Could See Data Your Own Way
Sellers who want to Grow their Brands
Agencies who want to look like a pro to their clients
At a minimum, you save 5 minutes per table you don’t have to download from Amazon. Over the course of a week you save 9 hours.
