Database Insights > Data > Data Sources
The Data Sources page in the platform provides reporting and insights about data coming from any source system integrations. Use this page to compare relative counts or as a sanity check for active integrations to verify expected data flow.
Data Sources & Recent Data Loads
The Data Sources visual displays the top 3 sources for the current month based on the number of people loaded from the source system. If you have more than 3 sources active, only the top 3 will be displayed.
The Recent Data Loads visual displays the counts of People, Transactions, and Records for your top sources over the last 8 weeks (Monday to Sunday). Click on the legend to show or hide the data for a specific source. Hover over the data to see specific counts.
Data Sources History
The Data Sources History table displays historical data for each source in the CDP. By default, this table displays data from the last 12 months. Use the date selector in the upper right to select different date ranges, or choose a custom date range. If no records were pulled for a source during the selected date range, the source will not show in the resulting table. Click any column header to sort.
First and Last Source Pie Charts
People by First Source
People by First Source shows the distribution of individuals in your CDP by their First Source value. An individual's First Source is set upon the first interaction with a source system and cannot change. First Source is a helpful metric to determine the primary ways new individuals are entering your database.
People by Last Source
People by Last Source shows the distribution of individuals in your CDP by their Last Source value. An individual's Last Source is set each time an updated record flows in and can change. Last Source is a helpful metric to determine the effectiveness of your omni-channel marketing efforts.
Lifetime Spend by First Source
Lifetime Spend by First Source shows the total revenue attributed in your CDP by the first source of the people purchasing.
Lifetime Spend by Last Source
Lifetime Spend by Last Source shows the total revenue attributed in your CDP by the last source of the people purchasing.
Source Specific Charts
At the bottom of the page, select a source from the dropdown to display more information about that source.
People in {This Source} Only
This is the percentage of people in the CDP who have only interacted with this source
People Purchasing from {This Source} only
This is the percentage of people whose purchases are only from this source. This is helpful if you are trying to identify what percentage of your database has only ever lodged but never transacted, or vice versa. If the source is not transactional, this visual will always show 0%.
People Added to the CDP in Last 12 Months due to {This Source}
This displays the number of people added to the CDP in the last 12 months with this source as their First Source value. These people may have also interacted with other sources, but this source was where they first entered the CDP.
Revenue Growth in the Last 12 Months due to {This Source}
This displays the amount of revenue in the last 12 months that came from people whose first source was the source selected. For contests and one-time loads, this can tell you whether running the contest was worth it to grow your database and revenue.
People from This Source Venn Diagram
This displays the overlap between this source and other sources flowing into the CDP. The "Other Sources" circle represents people who are in all of the other sources that are flowing in to the CDP. The {This Source} circle (labeled "Contest" in the diagram above) represents people who are in this source. The overlap between the two circles displays the number of people who are in this source and other sources.
