View File Stats
File stats provide information on each file you’ve uploaded to LiveRamp, such as number of rows, unique records, and columns in the file. These stats are displayed on the Files page and typically take 1-3 days to populate after file uploading. File stats are calculated during processing based directly on the data in the file.
To navigate to the Files page, click Files in the Connect navigation menu and then select the desired audience:
The stats displayed in both the table and in the details panel varies depending on whether the audience is an Onboarding workflow audience or a File-Based Recognition workflow audience. See the sections below for more information.
For additional information on the data displayed on the Files page, see "Check the Status of an Uploaded File".
View Onboarding File Stats
Onboarding file stats provide information on each Onboarding-workflow file you’ve uploaded to LiveRamp, such as number of rows, unique records, and columns in the file.
You can use these stats to evaluate file metadata and can also be used for direct file comparisons. These stats can also help you avoid going over our recommended file limits for Onboarding workflow files.
Note
If you're seeing unexpectedly low or high match rates, either in Connect or at the destination platform, first be sure to check the information in these articles:
If you still have questions about a match rate that seems unexpectedly low or high at the destination platform, first check with the platform to see if it's an issue on their end. If nothing is found, or if the issue is solely with stats within Connect, use either the Onboarding: High/Low Match Rate Investigation quick case or the Measurement: High/Low Match Rate Investigation quick case to create a support case to investigate the issue.
The Onboarding file stats displayed include:
Total Rows: The total number of rows in the file.
Unique Records: The number of unique records in that file, after deduplication. For example, John Doe, the cat lover and pasta eater, is a single record. However, John Doe also appears a few rows down in your file. If we determine that both instances of John Doe are the same person, we’ll merge those two records into one and count that as one unique record.
Note
"unavailable" indicates that your stats are being calculated.
Columns: The number of columns (or fields) in that file, including identifier fields and segment data fields.
Caution
To minimize delays and ensure maximum performance, keep our recommended file limits for Onboarding workflow files in mind:
Total rows: Minimum of 25 and maximum of 500,000,000 per file (maximum of 100,000,000 for UK data files and 30,000,000 for French data files)
Columns (segment data fields): Maximum 500 per file
View Measurement File Stats
Measurement file stats provide information on each File-Based Recognition (FBR) workflow file you’ve uploaded to LiveRamp, such as number of rows, the recognition rate, the number of invalid rows, and more.
You can use these stats to evaluate the quality of your data, see how much of your data matches to unique individuals, and to see how much of your data LiveRamp can recognize.
Note
If you still have questions about a recognition rate that seems unexpectedly low or high, use the Measurement: High/Low Match Rate Investigation quick case to create a support case to investigate the issue.
Stats Displayed in the Table
The Measurement file stats displayed in the table include:
Total Rows: The total number of rows in the file.
Recognition Rate: The percentage of valid rows in the file that were matched to a maintained RampID.
Caution
To minimize delays and ensure maximum performance, keep our recommended file limits for File-Based Recognition workflow files in mind:
Total rows: Minimum of 25 and maximum of 500,000,000 per file (maximum of 100,000,000 for UK data files and 30,000,000 for French data files)
Columns (segment data fields): Maximum 400 per file
Stats Displayed in the Details Panel
To view additional stats for a file, click on that file's row to open the details panel and display the following stats in the Import Statistics area:
Note
Stats on the recognition rate for File-Based Recognition workflow audiences are also displayed on the Files page, in the details panel. See “Check the Status of an Uploaded File” for more information.
Column count: The number of columns in the file.
Row count: The number of rows in the file.
Invalid row count: The number of rows that contain unmatchable identifier data. For PII files, we check the validity of the identifiers by looking for blanks, bad format, or known invalid email domains, for instance. For files containing devices, we check that the device is not a ‘0’, blank, or a permutation of N/A, nil and null.
Recognition rate: The percentage of valid rows in the file that were matched to a maintained RampID,
Total RampID count: The total number of RampIDs that the rows in the file matched to.
Unique RampID count: The number of unique RampIDs that the rows in the file matched to.
Maintained RampID count: The total number of maintained RampIDs that the rows in the file matched to (displayed when Show Advanced Statistics is toggled on).
Unique maintained RampID count: The number of unique maintained RampIDs that the rows in the file matched to (displayed when Show Advanced Statistics is toggled on).
Derived RampID count: The total number of derived RampIDs that the rows in the file matched to (displayed when Show Advanced Statistics is toggled on).
Unique derived RampID count: The number of unique derived RampIDs that the rows in the file matched to (displayed when Show Advanced Statistics is toggled on).
Measurement File Stats FAQs
Why can’t I see the recognition rate column for all of my audiences?
This feature is only available for File-Based Recognition workflow audiences at this time.
What is a RampID?
A RampID is an anonymous representation of an aggregation of touchpoints, representing a person.
How do you determine what is invalid data?
Invalid data are data that we deem unmatchable. For PII files, we check the validity of the identifiers by looking for blanks, bad format, or known invalid email domains, for instance. For files containing devices, we check that the device is not a ‘0’, blank, or a permutation of N/A, nil and null.
Can you point me to which line of data is invalid?
We do not retain this information in the system and we shuffle rows for each file to comply with privacy requirements. It is therefore not possible to point out specific rows that were considered invalid.
How can I prevent my data from being invalid?
For first-party data, make sure that all of the fields are filled, that the identifiers look correct (for instance, you can use an email regex to ensure basic email correctness), and that there are no obvious invalid data points, such as noname@nodomain.com. For third-party data, you can work with your DSP and/or agency to ensure that they do not include blank or ‘0’ devices in their exposure files.
Is anything changing in my file output?
No, this feature is entirely separated from any matching or formatting processes. It is solely a statistics feature and we have not changed the way we process and match files.
What is the difference between recognition rate and match rate?
Almost none. The name "recognition rate" better captures our matching process and our ability to recognize touchpoints by excluding invalid data.