Cyndx's Analytics Explorer allows you to customize your dashboard to quickly identify and track what's happening in the spaces most relevant to you. As you structure Explorer queries, these tips can help you get the most out of your results.
Get started by selecting Run a query to begin creating one of your own.
These parameters help query your data.
Metrics are quantitative, meaning they can be measured and recorded with numbers. Metrics are like calculations, including sums, totals, similar to the way users can add calculations to a cell in excel. Metrics contain numeric, quantitative values that can be measured or aggregated. Examples of metrics are things like total number of funding rounds that occurred within a given time frame, average acquisition transaction amount, or a count of a total number of companies.
On the other hand, dimensions are the fields for your data. In Explorer’s case, dimensions are the fields that the database will be searched for. Dimensions are qualitative, meaning they can't be measured but are instead described using qualitative values such as company or contact names, dates, or location. You can use dimensions to categorize, segment, and reveal the details in your data.
In the results, the dimensions and metrics will determine the columns. As you type into the Measures or Dimensions bar, Explorer searches data fields, functions, and string values and displays results in a drop-down list for selection.
A custom metric can be added to an Explorer query to return results within a range of dates that can then be sorted or filtered, or grouped by granularity to compare differences over time.
To remove null values, ensure that there is a filter with the dimension name and “is not null”. For example, to ensure only companies where the CEO’s email is populated appear in the results use a “People Email is not null” filter. Where “Search field...” is populated with “People Email” and “is equal to” field is populated with “is not null”.
If you want to generate a count (e.g. count of companies on the platform), add a 'Count companies' metric. A custom metric count is available for all dimensions.
When applying filters, the field you are filtering by must also be added as a dimension. You cannot apply a filter to a dimension that is not in the query
A search operator - sometimes referred to as a search parameter - is a character or string of characters used in a search engine query to narrow the focus of the search. In Explorer, operators represent a filtering action to be performed. Below is a list with definitions of the operators found in Explorer.
To adjust order of columns you can either add them in the order you’d like them to appear in your query results. Additionally, you can hover over the column title, click to drag and reorder your columns as you see fit.
Column results can be sorted in ascending or descending order, or filtered by value.
Run a Finder Search - selecting up to 10 companies or concepts to search for.
Here you can type an address to perform a distance-based search. Our Geo Search will filter companies to a bounding box, meaning we calculate the miles North, South, East and West from the address. It's default value is a max distance of 25 miles (or kilometers), which can be changed, automatically updating the latitude and longitude coordinates.
Think of the structure of your Explorer search in terms of key words. For example, instead of “I want to see all fundraise transactions that have happened over the last 30 days”, try beginning your query with “funding round” by “funding round announcement date.”
As you type into the Measures, Dimensions or Time bar, Explorer searches data fields, functions, and string values and displays results in a drop-down list for selection.