[Skip to main content](https://www.t-mobile.com#content-main) [](https://www.t-mobile.com/advertising-solutions) [](https://www.t-mobile.com/advertising-solutions) - [Audience Insights](https://www.t-mobile.com/advertising-solutions/audience-insights) - [Media Solutions](https://www.t-mobile.com) Media Solutions - [Mobile Media](https://www.t-mobile.com/advertising-solutions/mobile-media#INTNAV=tNAV:MediaSolutions:MobileMedia) - [App Install](https://www.t-mobile.com/advertising-solutions/app-install#INTNAV=tNAV:MediaSolutions:AppInstall) - [Rideshare Advertising](https://www.t-mobile.com/advertising-solutions/rideshare-advertising#INTNAV=tNav:MediaSolutions:RideshareAdvertising) - [Retail Media](https://www.t-mobile.com) Retail Media - [Advertisers](https://www.t-mobile.com/advertising-solutions/in-store-retail-media-advertisers) - [Retailers](https://www.t-mobile.com/advertising-solutions/in-store-retail-media-retailers) - [Platforms](https://www.t-mobile.com) Platforms - [Blis](https://blis.com/us/) - [Vistar Media](https://www.vistarmedia.com/) [Contact Us](https://www.t-mobile.com/advertising-solutions/contact-us.html?INTNAV=tNav%3AContactUs) [](https://www.t-mobile.com) ## DOCUMENTATION - [Getting Started with Magenta Advertising Platform](https://www.t-mobile.com/advertising-solutions/map/developer/documentation/getting-started-with-magenta-advertising-platform.html) - [Publisher Data Collection Compliance Requirements](https://www.t-mobile.com/advertising-solutions/map/developer/documentation/publisher-data-collection-compliance-requirements.html) ## CONSOLE - [Uploading Audiences](https://www.t-mobile.com/advertising-solutions/map/developer/console/uploading-audiences.html) ## DATA MARKETPLACE API - [Overview](https://www.t-mobile.com/advertising-solutions/map/developer/data-marketplace-api/overview.html) - [Attributes](https://www.t-mobile.com/advertising-solutions/map/developer/data-marketplace-api/attributes.htm) - [Import](https://www.t-mobile.com/advertising-solutions/map/developer/data-marketplace-api/import.html) - [Data File Format](https://www.t-mobile.com/advertising-solutions/map/developer/data-marketplace-api/data-file-format.html) - [Taxonomy File Format](https://www.t-mobile.com/advertising-solutions/map/developer/data-marketplace-api/taxonomy-file-format.html) ## DATA TRANSFER AND INTEGRATION - [](https://www.t-mobile.com)[AWS S3 Access](https://www.t-mobile.com/advertising-solutions/map/developer/data-transfer-and-integration/aws-s3-access.html) # T-Mobile Complete Data Hygiene The T-Mobile Complete Data Hygiene native app is a stored procedure you can run on your first party user data to standardize, correct, update, and add flags to postal addresses. Below is a quick overview on how to use the app. For more detailed instructions, please consult the app’s “About the App” tab. 1. Install the App 2. Complete the [Processing Acknowledgement Form](https://truencoa.com/wp-content/uploads/2017/03/NCOA_Processing_Acknowledgement_Form_PAF.pdf) (PAF) 3. Enable External Access Integration 4. Create and Grant Access to a View of Your Data 5. Run the App 6. Get Results ## Install the App 1. Navigate to the T-Mobile Complete Data Hygiene app listing. 2. Click the blue “Buy” button on the upper-right hand side of the page, and then click the second blue “Buy” button again on the pop-up page. The app will begin to install. 3. Once it is finished installing, another pop-up box will appear notifying you that your purchase was successful. Click the blue “Open” button. This will take you to the Streamlit dashboard. 4. Select your preferred data warehouse to proceed. ## Complete the Processing Acknowledgement Form (PAF) 1. Following app install, you will be prompted to visit the PAF website and complete your information. 2. Click the link to visit the PAF website and complete the required information there. 3. The PAF website sends the PAF through Adobe Sign for signatures. 4. Following signatures, the PAF ID (and API key) will be generated within four hours. You will receive the completed PAF with PAF ID via email. 5. Enter the PAF ID into the Streamlit dashboard; if you don’t have access to Streamlit, call the initialize\_app stored procedure with the PAF ID, e.g: CALL TMOBILE\_DATA\_HYGIENE.CORE.INITIALIZE\_APP('example paf id'); The app is now ready to use. ## Data Schemas #### Input data schema | | | | |---------------|-------------------|------------------------------------------------------------------------------------------------| | Field | Required Not Null | Description | | REF\_ID | Yes | Unique identifier: client can use this field to join the app output back to their source data. | | FIRST\_NAME | Yes | Must be populated if FULL\_NAME is null. | | LAST\_NAME | Yes | Must be populated if FULL\_NAME is null. | | FULL\_NAME | No | Only populate this field if FIRST\_NAME & LAST\_NAME are null. | | ADDRESS\_1 | Yes | First line of address (e.g., 321 Sesame Street). Must be populated if FULL\_ADDRESS is null. | | ADDRESS\_2 | No | Second line of address (e.g., apt. 411). | | FULL\_ADDRESS | No | Complete address: only populate this field if ADDRESS\_1 & ADDRESS\_2 are null. | | CITY | No | | | STATE | No | Can be either 2-character state code (e.g., NY) or full state name (New York). | | ZIP | Yes | 5-digit zip code or zip plus 4 in the following format: 12345-1234. | #### Output data schema | | | |-------------------------|------------------------------------------------------------------------------------------------------------------| | Name | Pricing (CPM) | | OUT\_REF\_ID | | | OUT\_FIRST\_NAME | | | OUT\_LAST\_NAME | | | OUT\_FULL\_NAME | Will be populated with cleansed first and last name even if input field was null. | | OUT\_ADDRESS\_1 | First line of address (e.g., 321 Sesame Street). | | OUT\_ADDRESS\_2 | Second line of address (e.g., apt. 411). | | OUT\_FULL\_ADDRESS | Will be populated with both cleansed address fields even if input field was null. | | OUT\_CITY | | | OUT\_STATE | | | OUT\_ZIP | 5-digit zip code. | | OUT\_ZIP4 | 4-digit delivery route associated with the address. | | OUT\_CRID | The carrier route associated with the cleansed data. | | PARSEDADDRESS | The street number associated with the cleansed data. | | PARSEDPRE | | | PARSEDSTRNAME | The name of the street associated with the cleansed data. | | PARSEDSUFX | The street “suffix” (e.g., Ave, St., Ct. etc.) associated with the cleansed data. | | PARSEDPOST | | | PARSEDSUD | | | PARSEDADDRESS2 | | | MOVEDATE | | | MOVETYPE | | | DPVFLAG | Flag (Y or N) indicating whether Delivery Point Validation has been done on the address. | | VACANTFLAG | Flag (Y or N) indicating whether address is vacant. | | DELIVERYPOINTCHECKDIGIT | The check digit (if available) for the address. | | DECEASEDFLAG | Flag (Y or N) indicating whether resident of the address is deceased. | | PRISONFLAG | Flag (Y or N) indicating whether resident of the address is in prison. | | SUPPRESSFLAG | Flag (Y or N) indicating whether resident of the address has requested their name be removed from mailing lists. |  130 Fifth Avenue, 6th Floor, New York, NY 10011 [www.t-mobile.com/advertising-solutions](http://www.t-mobile.com/advertising-solutions) Contact: [T-Ads\_Data\_Products\_Support@T-Mobile.com](http://T-Ads_Data_Products_Support@t-mobile.com/) ## Hello! Want to stay logged in? To keep your accounts safe, you'll be automatically logged out in:  Yes, stay logged in No, log me out ## Share your screen while on a call or in store __Get guided support from an Expert in real time__ - For your security, personal info, tabs, and notifications are automatically hidden. - You can stop screen sharing at any time. - Experts can only see what’s on T-Mobile.com. - Don’t use screen share while driving or in any situation where it's unsafe to focus on your screen. By clicking 'Accept and continue,' you are consenting to allow the Expert to view your screen for assisted navigation. This session may be recorded. To learn more, please visit the 
[__T-Mobile Privacy Notice__](https://www.t-mobile.com/privacy-center/privacy-notices/t-mobile-privacy-notice). Accept and continue No thanks __Next:__ Generate a code to share with your Expert ## Share this code with your Expert code Once your code has been successfully entered by your Expert, this window will close and continue to the session. ## Allow screen sharing with your Expert? Personal and sensitive data is hidden for your security and privacy. Allow Don’t allow ## End your session? Ending your session will stop sharing your screen, but will not end your call. End session Continue session ## Your session has ended Your screen is no longer being shared with your Expert. OK Share again ## You are already in an active session OK ## Your code has expired Generate a new one to share with your Expert. Generate new code T-Mobile Advertising Solutions - [English](https://www.t-mobile.com) - [Español](https://www.t-mobile.com) - ### Legal Legal - [T-Mobile Privacy Notice](https://www.t-mobile.com/privacy-center/privacy-notices/t-mobile-privacy-notice) - [Privacy Center](https://www.t-mobile.com/privacy-center) - ### Contact us Contact us - [Contact Advertising Solutions](https://www.t-mobile.com/advertising-solutions/contact-us) [](https://www.t-mobile.com/) - [About](https://www.t-mobile.com/our-story) - [Investor relations](https://investor.t-mobile.com/default.aspx?INTNAV=fNav%3AInvestorRelations) - [Press](https://www.t-mobile.com/news) - [Careers](https://careers.t-mobile.com?INTNAV=fNav%3ACareers) - [Deutsche Telekom](https://www.telekom.com/en?INTNAV=fNav%3ADeutscheTelekom) - [Puerto Rico](https://www.t-mobilepr.com/?INTNAV=fNav%3APuertoRico) - [Privacy Notice](https://www.t-mobile.com/privacy-center/privacy-notices/t-mobile-privacy-notice) - [Trust Center](https://security.t-mobile.com/?INTNAV=fNav%3ATrustCenter) - [Privacy Center](https://www.t-mobile.com/privacy-center) - [Consumer information](https://www.t-mobile.com/responsibility/consumer-info) - [Public safety/911](https://www.t-mobile.com/responsibility/consumer-info/safety/9-1-1) - [Terms & conditions](https://www.t-mobile.com/responsibility/legal/terms-and-conditions) - [Terms of use](https://www.t-mobile.com/responsibility/consumer-info/policies/terms-of-use) - [Accessibility](https://www.t-mobile.com/responsibility/consumer-info/accessibility-policy) - [Open Internet](https://www.t-mobile.com/responsibility/consumer-info/policies/internet-service) - [Do Not Sell or Share My Personal Information](https://www.t-mobile.com) - [Licenses & Patents](https://www.t-mobile.com/responsibility/legal/licenses-and-patents) - [Consumer Health Data Privacy Notice](https://www.t-mobile.com/privacy-center/privacy-notices/t-mobile-privacy-notice.html?INTNAV=fNav%3AConsumerHealthDataPrivacyNotice#health-data-privacy-notice) - T-Mobile, the T logo, Magenta and the magenta color are registered trademarks of Deutsche Telekom AG. - [Instagram](https://www.instagram.com/tmobile/) - [Facebook](https://www.facebook.com/TMobile) - [X](https://twitter.com/TMobile) - [You Tube](https://www.youtube.com/user/TMobile/custom) © 2026 T‑Mobile USA, Inc.  ## Stay up to date with notifications Get the latest from T-Mobile when you’re using the web. You can opt out any time. Allow notifications Don't allow  ## Get the latest from T-Mobile Stay up to date with notifications - including offers just for you Allow notifications Don't allow notifications  ## Stay up to date with notifications Get the latest from T-Mobile when you’re using the web. You can opt out any time. Allow notifications Don't allow  ## Get the latest from T-Mobile Stay up to date with notifications - including offers just for you Allow notifications Don't allow notifications