If you are not very knowledgeable when it comes to working with SQL and creating complex queries then it is sometimes difficult to know how to join tables in your database to build reports. Popdock removes the need to know SQL by adding a feature to create custom lists. Here are the available types for a custom list and some brief information about each one:
This list will compare similarities or differences of data between lists. It can be used to compare the data from lists within the same connector or you can compare data from lists from two different connectors.
This is a list that joins the data from multiple lists based on the field you choose to join them on. It can be used like a SQL query that joins two tables. For example, you have a customer list which contains a customer ID and you have an address list that also contains a customer ID, you can join these lists based on the customer ID field to have a joined list that has customers and their addresses.
This custom list allows you to build on to an existing list more of the same data from another list or connector. For example, if you wanted to combine your contacts from multiple connectors and as long as you are wanting the exact same data and the same data is available in each of the lists you want to join, then this will merge that data together for you.
This adds the ability to customize an existing list and have it summarize data.
- Number of sales, total sales amount, and average sale price for each item that you sell.
- Number of tickets assigned and average response times for each of your help desk agents.
- The first and last dates that you sold to each of your customers