DataHawk’s CEO Explains the New Report Center
Discover the DataHawk Report Center – unlocks unlimited scheduling capabilities for excel reports to be sent on an automated basis to you and the people you work with based on the frequency you set.
In this webinar we’ll discuss how to access Keyword and Product historical data to Top 100 Best Selling Products to Sales Reports and Ads Reports.
You can schedule them all on the same page. Here’s a recap of the plethora of reports you are able to schedule with DataHawk.
Othmane Sghir: So there we go, sharing my screen. All right. So good morning, everyone. Thank
you all for joining this DataHawk webinar. So today it’s gonna be actually quite
brief . We launched a new feature called the reports center a couple of days ago
that we want to show you. It’s super neat, super helpful, quite powerful for you
to make it easier for you to set up reports and export your data to spreadsheets.
The cool thing about it is that not only can you do this on an OnDemand basis
like, basically right now you need a data export, boom, you click, and then you
export it on various data points. But on top of that, you can also elect to
schedule some data to be exported at your desired frequency. So say every
week, every month to yourself or to people in your team, right to specific
recipients. So it’s really super helpful.
On top of that, we added a couple of data export capabilities that we didn’t have
previously. And that I think is really, really, really helpful. They cover two things:
they cover search results data at scale, and they cover best seller data at scale as
well. So what I mean by that is that one of these reports, you give it a bunch of
keywords and it gives you a history in a file of products, all products that have
ever made it that have ever ranked in the first five pages of search results for
each of these keywords over your selected timeframe. So really cool, because
what it means is that you don’t need to track products individually anymore, as
you are on this kind of export on DataHawk. So it’s super helpful with
competitive analysis. And the other cool one is basically there are reports for
which you pick a specific browser node or category on Amazon. So say the T
category for instance and it would send you again on a daily basis or at your
desired frequency an export of all the top 100 products for that category as
reflected by their bestseller rank.
And again, you can, as you do this in a historical way, you can imagine how this
can be helpful. Alright, so let’s dive right into it, and I’ll start showing you how,
how you can go about doing that. So first of all, I’m gonna start by showing you
the old way you used to run exports on data. So to do that, I’m gonna start by
using our neat and newly launched search feature that you see here, and I’m
doing it on purpose because I’m pretty sure a bunch of you guys have never
used this feature, right? So I’m gonna search for a keyword that I have in my
account. So say for instance, or a specific product, sorry say for instance Lipton,
right? So I have this Lipton tea bags product in one of my projects and then
boom, magic. I’ve been super fast in accessing it. Instead of, you know, going
through my I projects, and picking the products. I’m going to close a bunch of
tabs here. And wait for it to load.
I’m picking a full year of data. I shouldn’t. This is gonna take some time if I’m
picking a full year of data. So yeah, the reason this took some time is that I was
looking at an account with another DataHawk customer, and I picked a full year
of data. And the problem is that obviously when you pick a full year of data, it
may take some time for it to load. And given the fact that DataHawk saves the
parameters that you pick. Well, every time I relaunch something, it picks a full
year of data, which is annoying. And of course these kinds of things always
happen. There you go. Last 12 months always happen when you’re doing a life
thing, which is cool, but no stress. All right. So switching to the past 30 days.
Okay, there we go. We like this better daily view, for instance. All right. We save
the day. So here, I’m looking at this Lipton product on DataHawk, right?
And so one of the cool things around data exports that you’re able to do on
DataHawk, is that you can elect to export a product data, right? And the way you
go about doing that typically is that you can click on product actions. So I’m
zooming in. So you’re able to see it and then export product data, right? So this
is one of the first ways that you were able to do this on DataHawk. It continues
to be the case. Recently, as we added the search bar on the top, you also have a
quick action menu from here. Where again, similarly, I can click here on the
workspace menu, you, and then decide to export my account data, for instance,
here.
Export last seven days, account data, instead of exporting this specific
product’s data. And then I also have the ability to export data pertaining to all
the products that I have in this specific project, which I called Unilever Lipton
here.
So I can click on project actions, export project data, and as I do so I would get
an Excel file, a spreadsheet on my email with historical data, for all the products
that are in this specific project. Now, the thing is that on top of these two kinds
of exports, there are a bunch of other data points on DataHawk that you’re able
to export, right?
And sometimes, it used to be hard to access before this new
update that we launched, because you needed to go to a specific area in order
for you to run the export. For instance, were you interested in running export for
sales, for a specific product or your entire account, then you needed to go to
that specific section. Were you interested in exporting data for ads? It used to be
the same, however, things have changed. And now what you can do instead is go
to the core section here. So from the left navigation menu, you have a section
called core. You can click on it. And as you do so on top of being able to access
other teams and so forth, you go to the report center.
And this is the place where you’re gonna be able to see all the kinds of available
exports that you’re able to run on DataHawk. And you can decide to either
schedule them to be sent as a specific frequency, or to run the exports right
away.
So this is going to be the main discussion we’re gonna be having today,
and to start with it, let me show you, let’s go over the kind of exports that you’re
able to do here. So the first one, tracked products list, what this export does is
that it exports to a spreadsheet, the list of products that you’re tracking in your
entire account or in a given project, right? And it has some insights around their
latest price, rating, stars rating, top level department, best seller rank, estimated
monthly sales, competitive score and stuff like that. So, as an example it would
typically be the list that you see here. When you go to a project and you enter a
product section, a products list, this data that you see here, which you are able
to export from here. Well, this is the same, we’re just making it easier.
Plus added the ability for you to elect scheduling it to be set to the desired
frequency.
Then there’s this second one. Now this one is quite popular. The
single product data export. What this export does is that it gives you data
pertaining to a single product. So if we look at this product, for instance,
everything that you’d be able to access on DataHawk. So changes like in the
number of ratings, stars rating, box price, keyword rankings, BSR data, product
detail page. So title description, bullet points and so on and so forth, listing,
quality score, etcetera, etcetera, all of this, you’re able to export it to a single
Excel file.
And you could do that from here. So the way it functions is that you
can either run it right away. And as you do so you can pick a project for instance,
and then search for a specific product in that project, right? Like this one, and
then boom, I can run the export and it will generate it for me or I could elect to
schedule it at a specific frequency.
All right. So let’s move onto the keyword section, track keywords list. It’s similar
to what I’ve shown you here, except that it would run an export of this list that
you see here. What’s cool about it is that you have some insights around the
medium price of products ranking in the first five pages of search results, their
meeting rating, stars rating, estimated search volume and CPC data as fetched
from Google, which can be a good proxy when applied to Amazon. Competition
score for each keyword and so on and so forth. So that would be the track
keywords list export.
Then moving onto a new addition that we have, or maybe
right before that single keyword search results. Now what this one does is that it
gives you the most recent search results data related to a single keyword. What I
mean by that is if we pick here the example of bubble tea, for instance, or green
tea, as I click on it on DataHawk, one of the first things that I see is this.
A list of the 240 products that are ranking in the first five pages of search results
for it, right. And this list you’re able to export it, right, but it’s kind of hidden. You
had to have a really good view in order for you to see this export list. And what
you’re able to know through this single keyword search results export is to
export that data or schedule it to be sent to you or to specific recipients again at
your desired frequency. All right. So this one tracked product keyword ranks.
This one isn’t new, it’s a schedule, it used to be only a scheduled report, but can
run it right away as well, on top of scheduling it. What it does is that it gives you
keyword ranking performance, but only for products that you are tracking in a
given project. So say for instance, that I run it on this project that I have here.
Well, it would give me keyword ranking data for the 36 products that I’m ranking
on this project, nothing else but these ones. So it helps when you’re focused on
assessing the performance of a specific subset of products.
However, this other one, keyword search result is a new and super powerful
addition that we’ve just added. So what this export does is that it gives you
historical search results, data related to a given group of keywords for a selected
time period. Now, let me show you how it functions. And we’ll, we’re gonna
simulate running it on a scheduled basis. So I’m gonna click here on schedule.
What it asks me is a list of keywords that I want to export. So I’m gonna pick
things such as, for instance, an air mattress and queen mattress or whatever.
Mattress queen, for instance, there you go. And so on and so forth. And so I can
pick as many keywords that I want that, of course, I’m tracking in my DataHawk
account, and then I can run the export. Or in this instance, I decided to schedule
it so I can pick for instance, every day or every week, every week on Monday or
every week on we and so forth. And hit run reports. Alternatively, if I want to
send it to specific people, I can click on show advanced report options, and elect
to send it to you, for instance, Pooja, right?
And then write, hey, this is the keyword results export, enjoy. And then click on
run reports. And then what it would do is that at the timeframe that I’ve
selected here, boom, it would send it. Now you may be curious as to what the
report looks like.
So let me show you that right away. There we go. So this is the
example of what that report looks like. It’s a file that has two tabs: organic ranks
and sponsored ranks. So this is again a new and super powerful addition on top
of tracking organic rankings. You’re able as well to get sponsored ranking data.
So on the organic ranks tab, what you’ll notice is that, let me apply a little filter
here, so we can browse through this data and then fix the few. So what you’ll
see is that in this file, I have multiple keywords and I have search results for
every single product that has ranked for them in every single day. So here you
can see that for the 12th of August, for detox tea I’m looking at the products
that have been shown in page one, boom, this one was ranked first, this one,
second, this one third and so on and so forth. So this is gonna stretch all the way
to the fifth page, right?
Usually the 214th position, there you go. And then boom, it would go to the next
keyword that I’ve selected Tea bags and it would do the same, and so on and so
forth. So this is super powerful if you care, not just about your own keywords,
but about having a competitive view, showing you how you’re doing against your
competitors.
And you can imagine yourself using this data to run a bunch of
interesting analysis around maybe running a share of voice, looking at
competitive insights as reflected by you know, price ratings and stars, rating
dynamics, and so forth, etcetera. And then the same with sponsored rankings,
which is extremely helpful, right? Because you wanna know what are your
computers that are really aggressive in terms of sponsored ads on a given set of
keywords, right? If I’m setting tea products, well, I care about a detox product.
Well, I care about what my competitors are that are really aggressive on their
bids or even if I’m beating on that keyword.
Well, I’m interested to know if my bid is high enough, allowing me to appear on
page one as a sponsored product or not, because I don’t wanna be on page
three as a sponsor of a product. If that’s the case, then in all likelihood, my bid
wasn’t high enough, right? And so with this kind of insights, boom, you can drive
your advertising strategy in a much better way. So as you can see here every day
for each product, you have all the products for each keyword, sorry, you have all
the products that we detected to have been bidding on that specific keyword. So
this was one of the most important new reports that we added and we’ve just
looked at it. And by the way, as you set up a report to be sent at desired
frequency, it would appear on the scheduled report section here. So here you
can see that I’ve set up three in my account.
You can see the report type. You
can see what it contains. You can see the time at which and frequency at which
you elected to receive it and the specific recipients. And this is the same from
which I would be able to either edit it if I want to make some modifications,
right?
Or disable or enable it. In my case here, I disabled it, but here, boom, I can
enable it again. If I want it right away, I can click send to recipients. And if it has
been set up to be sent to people in my account, then it would send it to people
in my account or workspace, or I can send it to custom people.
Right. So again,
Pooja, I’m gonna spam you today. Boom, Pooja. I click on it. Okay. And so I’m
kind enough. I’m not gonna click on okay. And it would send it to the person that
you said there. All right. So let’s go back to our report center and see what other
reports we have here. So moving onto the bestseller rank area. So there are a lot
of other interesting insights that we can share on the BSR. One of which is a list
of the products that have made it to the top 100 spots in a given category on
DataHawk.
So let me show you what I refer to. You know, when you look at a
given product on DataHawk, one of the things that you care about the most is
probably tracking your BSR in given categories.
And so here, looking at the example of this Lipton product, you can see that
they’re currently ranking fourth, during the past week on average, on black tea
category.
And so I may be curious as to what are the other products they
compete with that have made it to the top 100 list in this category. And so to do
so I can either click here, which would redirect me to a list in our best rank
browser tool that can be accessed from the market tab here. A list containing
the best selling products in the category that I selected. So here I have a list of
the top 100 selling products in the black tea category, which I think is likely to be
a level five category in terms of depth or four on Amazon. So there you go. You
can see that Lipton is here forth, [inaudible] a lot of other nice brands it
competes with. And basically you are able to export again, this to Excel, as you
can see from here. And so what we added on the report center is, again, a quick
shortcut, allowing you to run these kinds of exports.
And on top of that, you can also schedule it to be sent on a daily basis. So
instead of logging to your DataHawk account and running this export every day,
you can schedule it to be sent at your desired frequency. Looking at the
following one that you see here, the top one hundred selling products in history,
this is gonna launch pretty soon. Right now it’s in a better mode. I can see it only
on my account, but as you run it, it would give you the same as this, but with a
historical view in the sense that you’d be able to see how things have been
evolving over time, right?
Because it can be interesting to see how the product
that’s currently ranked third in terms of BSR used to rank at some point, right?
And as you can see, in my chart in here, things can get pretty messy, right?
When you drop out of the top 10 ranks, it’s super tough to maintain a good BSR
and usually products that are in the top five or 10, they maintain relatively great
performance.
And this kind of insight, sorry you can get them again on that historical export.
And just as a quick reminder, the BSR, there are a lot of different ways that you
can use it.
One of which is definitely to understand the impact that your sales
velocity has on your best seller rank, which ultimately is gonna be affecting your
organic reach and which ultimately is gonna be affecting your sales, right? And
there’s this huge flywheel. And as you can see here, your ultimate goal is to
make it to top five or top 10 and work on maintaining that. So you definitely
wanna track your BSR and make sure that you’re always, and ideally make it to
the top 10 of your particular market segment. All right. So moving onto the next
type of reports that we provide. Finance, this contained product exports that
include product sales reports. So this one gives you historical sales data related
to a single product. Now you can do the same, but on an entire seller account by
picking the second reports that you see here.
So again, the content of these two reports is gonna be things such as your sales
in terms of currency volume and in terms of units volume and how we changed
over time, on a daily basis. Alternatively, you also have this third type of reports.
That’s gonna give you your orders in detail. So that’s, again, much more detailed
than granular. You can do the same on the advertising side by running a
sponsored product ads report. So again, these two types of reports when it
pertains to finance and ads, naturally, they’re required that you connect your
Amazon account to DataHawk before being able to run. But as you do so after a
couple of hours, as the data is processed, you’ll be able to run them. Moving
onto the next type of reports we have projects, data reports. So this project, the
project export, what it does is that it contains data, as I mentioned earlier,
around all the products and to keywords that you have in a given project. So the
way it functions is that you would pick a project and then run the reports. And
what it would look like is like this.
It would be a file containing multiple tabs. One of which contains daily data
around price, stars rating, number of ratings, including reviews, number of
answered questions, estimated monthly sales, the buy box status, the buy box
price, who was winning the buy box, the nearest delivery date of the products,
its title, title led, media assets description, bullet points with the length of each
one. Number of images, videos, if it has had a plus content or not, who’s the
brand, the weight, dimensions and so on and so forth. You would have another
tab containing detailed keywords, ranking data. So as you can see here for each
[inaudible], for each keyword, I see on a daily basis, how it’s been ranking
organically. And then I have a separate tab showing me the same for sponsored
ranking there. Then I have a fourth tab showing me the listing quality score,
which is a feature you may have seen on DataHawk that assesses the extent to
which we deem a product to be compliant with Amazon’s content guidelines,
things such as you know, for the title.
Well, Amazon recommends that you capitalize the first letters. So you can see
that this product here wasn’t quite applying this rule right? And so on and so
forth, BSR ranking data as well, which is super helpful. And you can get it across
multiple categories. So for each [inaudible], you can see that we’re able to fetch
it in sometimes up to eight browse nodes or categories. And yeah, that’s pretty
much it for this report.
So again, it’s super, super exhaustive. And then finally, on
the workspace side this is quite a key to the project export, except that it would
contain data across your entire account. So in case you have multiple projects,
this one can also be helpful, but it’ll be limited to seven days of data. It won’t
necessarily have all the KPIs that you see in the project data export. So that’s
pretty much it when it comes to this newly launched feature. So again, this is the
report center on DataHawk. Don’t forget to use it to automate some of the data
export work that you need to do, especially when you like to crunch data at scale
and do that on spreadsheets
And on Excel, this can be helpful to do and helpful to manage as well. And you
can, again, as a reminder, access it from the core section here, by going to the
report center. For users that are on our free tier or free plan you have the ability
to export some of this data. And a subset of this data is gonna be locked simply
due to the fact that you would need to upgrade to a paid plan in order for you to
be able to run it.
And in any case, the first scheduled report is included for free,
additional ones can be picked by amending your subscription parameters. As
you go to your account section here, and you click on upgrade. You can pick your
plan, and then as you do so you can select your quotas. And typically the
scheduled report is where you’re able to select an additional number of reports.
If you want to schedule multiple ones.
Otherwise, if you want to just run them
on an OnDemand basis without necessarily automating the fact that they are
sent to your email at your desired frequency, then you can just click run and you
don’t need to pick anything else in your quotas. So that’s pretty much it for
today. Thank you everyone for joining us. And if you have any questions, don’t
hesitate to follow up with us via email or via our live chat. Thank you all