Sync Amazon Seller data into Google Sheets or BigQuery, then connect Looker Studio for dashboards. SyncRange keeps source data fresh so your reports stay accurate.
Connect, choose columns, schedule refreshes
Looker Studio dashboards read from connectors such as Google Sheets and BigQuery. SyncRange focuses on keeping Amazon Seller accurate inside those destinations. Think of us as the sync layer, not a charting substitute.
After data lands on a schedule, you build Looker Studio charts and blended data sources the same way you would for any other business data. Looker Studio stays fast because the heavy lifting happens in Sheets or BigQuery.
Looker Studio connects natively to BigQuery and Google Sheets. SyncRange does not paint charts inside Looker Studio. We keep Amazon Seller synchronized into those destinations so your blended reports and filters stay fast and auditable.
What we can export, and how it lands
Each row is a field you can include or omit in the app before export. Column headers match the labels below; SyncRange writes them as the first row in your destination (worksheets in Google Sheets or Excel, or BigQuery columns) when you choose Looker Studio.
Order-level detail for the selected date range. Large presets may take extended time due to Amazon rate limits. Buyer and shipping address fields are coming soon.
| Columns |
|---|
| Amazon Order ID |
| Purchase Date |
| Last Updated Date |
| Order Status |
| Fulfillment Channel |
| Sales Channel |
| Ship Service Level |
| Currency |
| Order Total |
| Items Shipped |
| Items Unshipped |
| Payment Method |
| Marketplace ID |
| Is Premium Order |
| Is Business Order |
| Is Prime |
| Order Type |
| Earliest Ship Date |
| Latest Ship Date |
| Earliest Delivery Date |
| Latest Delivery Date |
| Date Exported |
Uses the selected date range.
| Columns |
|---|
| Amazon Order ID |
| Order Item ID |
| ASIN |
| Seller SKU |
| Title |
| Quantity Ordered |
| Currency |
| Item Price |
| Item Tax |
| Shipping Price |
| Shipping Tax |
| Shipping Discount |
| Promotion Discount |
| Promotion ID |
| Condition |
| Date Exported |
Current FBA inventory snapshot. The selected date range does not apply.
| Columns |
|---|
| Seller SKU |
| FNSKU |
| ASIN |
| Product Name |
| Condition |
| Fulfillable Quantity |
| Inbound Working |
| Inbound Shipped |
| Inbound Receiving |
| Reserved Quantity |
| Total Quantity |
| Unsellable Quantity |
| Per Unit Volume |
| Researching Quantity |
| Date Exported |
Current listings snapshot. The selected date range does not apply.
| Columns |
|---|
| Seller SKU |
| ASIN |
| Item Name |
| Item Description |
| Listing ID |
| Price |
| Currency |
| Quantity |
| Open Date |
| Product ID Type |
| Item Condition |
| Status |
| Fulfillment Channel |
| Business Price |
| Date Exported |
Uses Amazon-generated settlement reports only. Older history is limited by Amazon report retention (~90 days).
| Columns |
|---|
| Settlement ID |
| Settlement Start Date |
| Settlement End Date |
| Deposit Date |
| Total Amount |
| Currency |
| Transaction Type |
| Order ID |
| Merchant Order ID |
| SKU |
| Quantity Purchased |
| Marketplace |
| Amount Type |
| Amount Description |
| Amount |
| Fulfillment ID |
| Posted Date |
| Date Exported |
Finances event lines (charges, fees, refunds, adjustments) filtered by posted date. Separate from Settlement Reports. How far back Amazon returns data varies; use append mode on scheduled exports to build history in your destination.
| Columns |
|---|
| Event Type |
| Financial Event Group ID |
| Settlement ID |
| Settlement Start Date |
| Settlement End Date |
| Deposit Date |
| Total Amount |
| Currency |
| Transaction Type |
| Order ID |
| Merchant Order ID |
| SKU |
| Quantity Purchased |
| Marketplace |
| Amount Type |
| Amount Description |
| Amount |
| Fulfillment ID |
| Posted Date |
| Date Exported |
Uses the selected date range. FBA-only.
| Columns |
|---|
| Return Date |
| Order ID |
| Seller SKU |
| ASIN |
| FNSKU |
| Product Name |
| Quantity |
| Fulfillment Center ID |
| Detailed Disposition |
| Return Reason |
| Status |
| License Plate Number |
| Customer Comments |
| Date Exported |
Monthly/current FBA storage fee report. The selected date range does not backfill full history.
| Columns |
|---|
| ASIN |
| FNSKU |
| Product Name |
| Fulfillment Center |
| Country Code |
| Longest Side |
| Median Side |
| Shortest Side |
| Measurement Units |
| Weight |
| Weight Units |
| Item Volume |
| Volume Units |
| Product Size Tier |
| Average Quantity On Hand |
| Average Quantity Pending Removal |
| Estimated Total Item Volume |
| Month Of Charge |
| Storage Rate |
| Currency |
| Estimated Monthly Storage Fee |
| Dangerous Goods Storage Type |
| Eligible For Inventory Discount |
| Qualifies For Inventory Discount |
| Total Incentive Fee Amount |
| Breakdown Incentive Fee Amount |
| Average Quantity Customer Orders |
| Date Exported |
Uses the selected date range.
| Columns |
|---|
| Snapshot Date |
| SKU |
| FNSKU |
| ASIN |
| Product Name |
| Condition |
| Per Unit Volume |
| Currency |
| Volume Unit |
| Country |
| Quantity Charged |
| Amount Charged |
| Surcharge Age Tier |
| Rate Surcharge |
| Date Exported |
Current estimated fees for active FBA offers. Not historical; Amazon limits this report to about once per day.
| Columns |
|---|
| SKU |
| FNSKU |
| ASIN |
| Product Name |
| Product Group |
| Brand |
| Fulfilled By |
| Has Local Inventory |
| Your Price |
| Sales Price |
| Longest Side |
| Median Side |
| Shortest Side |
| Length And Girth |
| Unit Of Dimension |
| Item Package Weight |
| Unit Of Weight |
| Product Size Weight Band |
| Currency |
| Estimated Fee Total |
| Estimated Referral Fee Per Unit |
| Estimated Variable Closing Fee |
| Expected Domestic Fulfilment Fee Per Unit |
| Expected EFN Fulfilment Fee Per Unit UK |
| Expected EFN Fulfilment Fee Per Unit DE |
| Expected EFN Fulfilment Fee Per Unit FR |
| Expected EFN Fulfilment Fee Per Unit IT |
| Expected EFN Fulfilment Fee Per Unit ES |
| Expected EFN Fulfilment Fee Per Unit SE |
| Date Exported |
Uses the selected date range. FBA-only.
| Columns |
|---|
| Approval Date |
| Reimbursement ID |
| Case ID |
| Amazon Order ID |
| Reason |
| SKU |
| FNSKU |
| ASIN |
| Product Name |
| Condition |
| Currency |
| Amount Per Unit |
| Amount Total |
| Quantity Reimbursed Cash |
| Quantity Reimbursed Inventory |
| Quantity Reimbursed Total |
| Original Reimbursement ID |
| Original Reimbursement Type |
| Date Exported |
Lightning Deal and Best Deal performance for promotions that start in the selected date range.
| Columns |
|---|
| Promotion ID |
| Promotion Name |
| Marketplace ID |
| Merchant ID |
| Promotion Type |
| Status |
| Creation Channel |
| Glance Views |
| Units Sold |
| Revenue |
| Revenue Currency |
| Amount Spent |
| Amount Spent Currency |
| Start Date |
| End Date |
| Created Date |
| Last Updated Date |
| Funding Agreement ID |
| Vendor Code |
| ASIN |
| Product Name |
| Product Glance Views |
| Product Units Sold |
| Product Revenue |
| Product Revenue Currency |
| Product Amount Spent |
| Product Amount Spent Currency |
| Date Exported |
Coupon campaign stats for campaigns whose start date falls in the selected range (Brand Analytics role; may be empty if ineligible).
| Columns |
|---|
| Coupon ID |
| Merchant ID |
| Marketplace ID |
| Currency |
| Coupon Name |
| Website Message |
| Start Date |
| End Date |
| Customer Segment |
| Discount Type |
| Discount Amount |
| Clips |
| Redemptions |
| Budget |
| Total Discount |
| Budget Spent |
| Budget Remaining |
| Budget Percentage Used |
| Sales |
| ASINs |
| Date Exported |
Social proof
See how teams export clean ecommerce and marketing data to Google Sheets, Microsoft Excel, or BigQuery without manual work.
Shopify Store and Food delivery
Super easy to use and has been extremely useful in getting the real time data we need from our Shopify store. Ryan was super helpful in getting started, and responded to questions within minutes. Highly recommend.
Multi-brand Shopify Plus Operator
We run multiple Shopify stores and needed brand-level exports into BigQuery without custom pipeline maintenance. SyncRange gave us reliable scheduled exports and removed hours of manual QA.
Shopify Store Founder
We were manually updating Google Sheets every morning with Shopify and ad data. It was slow and error-prone. Now everything updates automatically, and our daily profitability tracker is always accurate.
Large Shopify Store
SyncRange was very helpful setting up Report Automation for my store. Highly recommend, Ryan made it as simple as possible and was very easy to work with. I recommend.
Connect your account, then follow the configuration guide for your first export.
Other data sources you can sync to Looker Studio
