Introduction

DataHawk allows you to access your Amazon and Walmart eCommerce data right within the same Google Sheets file, all fully synced automatically, so you can say goodbye to manual data exports.

DataHawk provides a set of pre-built ready-to-use Google Sheets dashboards.

This article presents the different pre-built dashboards you can access.

Requirements

First, you will have to set up Google Sheets as a Destination on DataHawk. To access as many data points as possible, make sure you add as many sources as needed, such as Products, Keywords, Amazon Advertising, and Amazon Seller Central integrations.

Pre-Built Dashboards

Google Sheets Dashboard

Description

Requirements

Search Dashboard

A dashboard that analyzes organic ranks of tracked products given keywords that are tracked.

At least one project containing tracked Products and their relevant Keywords.

Best Seller Rank Dashboard

A dashboard that analyzes the best seller ranks of tracked products across multiple categories.

At least one project containing tracked Products.

Content Dashboard

A dashboard that analyzes the product detail pages and the listing quality of tracked products.

At least one project containing tracked Products.

Advertising Dashboard

A dashboard that analyzes advertising performance including on a campaign level.

At least one connected Amazon Advertising account.

Profit & Loss Dashboard

A dashboard that analyzes sales, expenses, and profitability metrics. Sales metrics are also analyzed on a product level.

At least one connected Amazon Seller Central and Advertising account. Importing your COGS is recommended.

Limitations

If you have large volumes of data, your data may get truncated, meaning that the Dashboards would contain only partial data as we run through limitations related to Google Sheet's capacity to process a limited number of cells.

If that is the case, we would recommend either

  • Using a database-based Destination, such as Power BI, Snowflake, or others

  • Syncing data from Snowflake to Google Sheets using a reverse ETL tool

Customization

Say you would like to customize our pre-built dashboards or build your own custom ones.

  • If you want to customize the file, create new tabs in it or duplicate the pre-existing tabs.

  • If you edit the pre-existing tabs, your edits will be reverted at the next synchronization.

  • We advise not to rename the pre-existing tabs as it will stop their synchronization, in which case, a new tab will be created during the next synchronization.

Did this answer your question?