1. Build your Exports
Haven't created an export on AppTweak yet? Here are some articles on how to get started:
2. Export your Keyword List(s)
On the Keyword Tab, under the Analysis section, click on the 'Export' button to select the appropriate date range.
This export consists of looking at the Keyword List 1 (319) for Netflix with the competitors: Disney+, Hulu: Stream movies & TV shows, Amazon Prime Video, and Roku: Official Remote Control – United States, English for October 1st - 31st 2020.
Depending on how many keywords are in your list, the Exports may take a few seconds/minutes to be ready. You will be notified on the bottom left-hand corner once your exports are ready!
Click on your name on the top right-hand corner > Exports > and find all of the Exports you have created.
3. Create a Pivot Table in Excel
Once your CSV file is ready, let's create the Pivot Table.
As you can see, there are a lot of rows of keywords from Netflix and all of its added competitors. By creating a Pivot Table, it will be easier to digest all of this information.
If you need a refresher on how to create a Pivot Table, the following clip goes over how to exactly do so.
4. Now, let's customize our Pivot Table!
You can customize your Pivot Table however you'd like. The following Pivot Table example will show you how many installs per keyword are brought to your app based on the keyword list(s) and date range you exported.
First, drag and drop 'App Name' to the 'Filters' section. Then, drag and drop 'Keywords' to the 'Rows' section. Last but not least, drag and drop the 'Volume' and 'App Daily Installs'.
Instead of 'All', select your own App name.
Instead of seeing the 'Sum of Volume' – which shows the sum of the daily volume of the keyword list we exported, right-click the column > click on 'Value Field Settings' > click on 'Average'.
Now, you can see the Average Volume of each keyword for the list we exported.
Last but not least, the 'Sum of App Daily Installs' column can be used to see all of the installs each keyword brought to your app based on this specific export.