Show # of Duplicates on the Upload Email Confirmation

RyanUWMadison Posts: 10 Green Ribbon

We've had a few scenarios where users uploaded a sheet with duplicates and were concerned why the # of rows didn't match the # after merge. As a work around I told them to check for duplicates before doing the upload.

4 votes

Active · Last Updated


  • Cheli
    Cheli Austin, TexasPosts: 24 Gold Medal
    edited Jan 27, 2023 6:58PM


    If this is still true of how Eloqua works (it's been a while since I "tested" this!), if there is a duplicate row of data, the update rules Eloqua uses for uploads may be pulling from both rows--it pulls alphabetically so if you have

    [email protected] Bob Jones Manager

    [email protected] Robert Jones Assistant Manager

    Eloqua combines the two but keeps the ABC-first value - so you get combined data

    [email protected] Bob Jones Assistant Manager

    This is just an example. With other data fields, this behavior may be more impactful so it's ALWAYS a good idea to dedupe your lists before uploading, to preserve data integrity as much as you can. (Also would help to address the root of the duped data --ie, the database you pulled it from--but we don't always have control over that. :) )