The same email address may be registered for multiple platforms. How to retain the source of users during batch testing?

It is possible to register with the same email addressAmazon, and possibly Facebook, Instagram or other platforms. If you only remove duplicates by mailbox before batch detection, although the amount of data will be reduced, source information such as advertising channels, landing pages, event times, etc. may also be lost together.

The correct way to deal with it is not to cancel the deduplication, but to first retain the identity number for each piece of data, and then detect and merge it.

Don’t directly use your email address as your unique identity

Assume that the same email address appears three times, each fromFacebook advertising, independent site registration and offline activities. After directly deduplicating, only the first one is left. Even if it is later detected that this email address is registered with a certain platform, we still don’t know where it first entered and through which channels it reappears.

Before batch processing, you can add an internal number to each original record while retaining the email address, source channel, activity name, acquisition date and customer type. The mailbox can be repeated, but the internal number cannot be repeated.

In this way, duplication can be counted without destroying the original user source.

Detection data and source data are processed separately

The source field is mainly used to determine the customer acquisition channel, such as which advertisement, landing page or event the customer came from. Platform detection is used to determine whether the email is valuable for further contact and analysis.

Do not mix the two types of data into one result before testing. You can first extract the mailboxes that need to be detected from the original data, and then complete the corresponding platform status detection through Digital Planet. After the test is completed, use the email or internal number to match the results back to the original record.

Digital Planet is responsible for supplementing the relevant status of the platform, and the original data table is responsible for saving user sources. The two sides are processed separately, making it easier to check later, and the original channel information will not be overwritten by one deduplication.

Registering multiple platforms with one email address requires retaining multiple statuses

The same email address may be registered for multiple platforms at the same time. You cannot set up just one."Registered" field.

For example, after detection by Digital Planet, it was found that a mailbox was related toThere is a registration relationship with Amazon and a Facebook or Instagram related status. These results should be saved separately. When you later judge the customer value, you can choose a more appropriate communication portal based on the actual business.

When doing cross-border e-commerce, you can focus onStatus related to Amazon, TEMU and other platforms; when doing social media marketing, you can check platform information such as Facebook and Instagram. The value provided by Digital Planet is to help users add more discernible dimensions from a single mailbox, rather than compressing all platforms into a simple label.

Keep when deduplicating"First Source" and "All Sources"

according toAccording to Google Analytics’ data attribution idea, first contact and subsequent contact play different roles. When sorting mailboxes in batches, it is recommended to retain both source fields.

"First source" records the channel through which the user first enters, and is used to determine which entrance brings new customers; "All sources" records the activities in which the same email address appears later, and is used to observe whether the customer has been contacted multiple times.

For example, an email first comes fromFacebook ads, and later participated in email campaigns and registered an independent website. After completing the digital planet detection, you can see its corresponding platform status, but the original multiple sources are still retained. This way we can determine whether the ad brought customers for the first time, or whether subsequent activities drove registrations and conversions.

After the detection is completed, the method of merging will be decided.

If you just count the number of different mailboxes, you can remove duplicates by mailbox; if you want to analyze advertising effects, you need to keep records of each source; if you want to make follow-up contacts, you can merge duplicate contact information, but you cannot overwrite the original channel and activity information.

During actual processing, you can first use Digital Planet to batch detect the platform status corresponding to the mailbox, and then backfill the detection results into each original record. The same mailbox shares the detection status, and different sources continue to be retained independently.

Digital Planet can help supplementRelated detection information on Amazon, TEMU and social platforms, but channel attribution should still be based on the original records. The mailbox is responsible for connection detection results, the internal number is responsible for protecting each record, and the source field is responsible for restoring the user's entry path. In this way, even if the same email address is registered on multiple platforms and comes from multiple channels, key information will not be lost in the batch detection and deduplication process.

digital planet is a world-leading number screening platform that combines Global mobile phone number segment selection, number generation, deduplication, comparison and other functions . It supports customers worldwideBatch numbers for 236 countriesScreening and testing services , currently supports40+ social and apps like:

whatsapp/line, twitter, facebook, Instagram, LinkedIn, Viber, zalo, binance, signal, skype, DISCORD, Amazon, Microsoft, Truemoney, Snapchat, kakao, Wish, GoogleVoice, Botim, MoMo, TikTok, GCash, Fantuan, Airbnb, Cash, VKontakte, Band, Mint, Paytm, VNPay, Moj, DHL, Okx, MasterCard, ICICBank, Byb Wait.

The platform has several features including Open filtering, active filtering, interactive filtering, gender filtering, avatar filtering, age filtering, online filtering, precise filtering, duration filtering, power-on filtering, empty number filtering, mobile phone device filtering wait.

Platform provides Self-screening mode, generation screening mode, fine screening mode and customized mode , to meet the needs of different users.

Its advantage lies in integrating major social networking and applications around the world, providing one-stop, real-time and efficient number screening services to help you achieve global digital development.

You can find it on the official channelt.me/xingqiupro Get more information and verify the identity of business personnel through the official website. official businesstelegram:@xq966

(Kind tips:existWhen searching for Telegram’s official customer service number, be sure to look for the usernamexq966), you can also verify it through the official website personnel: https://www.xingqiu.pro/check.html , confirm whether the business contact you is a planet official