New Project
Create a new project by selecting 'Select Project' and '+ New Project'.
Give your project a title and description, then click 'Create Project'.
Data Packages
Once in your project, select 'Data Packages' (1), on the left-hand column, to access the data available to your account. Here you can search for specific data packages (2) and create queries from each data package (3).
In this tutorial, the Live Domains data package will be used as an example of how to query.
To begin the analytics on this data, we will add a filter.
In this example, we will add a filter to find all prefix's which start with 'tutorial'. You can do this by selecting 'Prefix' - 'Like' - 'tutorial*', in the relevant boxes.
Now that all prefix's are showing tutorial* you can add a formula to determine the length of each prefix. This will allow you to find the longest domain starting with 'tutorial'.
Here you can write your own formula to create a new column within your data. All available function are accessible below the expression box. You can also find additional documentation on writing formula's HERE.
Once the formula is created you can sort the column in descending order by clicking the arrow next to the column title. This will allow you to see the longest domains first.
Extended Query
Now save the query and give it a name. - this will now be visible in the 'Stored Queries' section of the DAP. Here you can extent the query to perform further analysis. Begin this process by clicking the three dots on the right-hand side and selecting "Create Extended Query".
In this example we will extend the query and join it to two separate data packages to create one data set.
Search for which data package you would like to join with and click 'Select'.
Then select which parameters the data should be mapped to. This will help the DAP to find which column of data to use when joining the packages. In this example, we have joined our query with 'Domain Name Website' and 'Domain Registrar Data'.
Now that the data packages have joined, there may be data which you are not interested in. In order to minimise the noise within the data, you can edit which columns to include.
Now save the changes to create a new stored query.
Dashboards
Once you have created you queries from the data packages, you can create fully customisable, visual dashboards to make the data more accessible to the user.
Give your dashboard a title and begin configuring by dragging and dropping which function you would like to include.
In this example, we are including a Table, Doughnut Chart and Bar Chart. Select which data you would like to create the table using. Then complete a title and head back to the dashboard where you will be able to see the table.
In order to include a chart of any kind, you need to repeat the process above - as well as a few other steps.
Additionally, you need to summarise the data. In this example we will summarise the Tld type by the total number of domain names.
You also need to determine which labels and values are used within the chart. Configure this by selecting the chart header in the bottom window. Here you are also able to select a colour gradient for your chart.
In order to include a bar chart, follow a similar process as above; selecting the different data you want displayed.
Once you have completed your dashboard, save it.
You can view all your project dashboards within your account at any time and they will update to give you the most up to date data within the DAP.LIVE system.
