How to set embeded data in bulk?

Question

I have set up a drill down question as below to have the respondents select the provinces and cities they currently live in. Then I need to set embedded data for each city to record the city tier. The problem is that I have hundreds of cities on the list, and manually typing them in could lead to errors and is also quite troublesome. Is there anyway to simplfy this process? Thanks!

ak.piraiai · Accepted Answer

​@Elaine.Li​@Chee Heng_SZ,This is exactly what our bulk embedded data generator was built for! 🎯Setting up embedded data for city tiers manually would be incredibly tedious with all those province/city combinations.Here's how you can solve this quickly:Create a CSV with your city mappings:City,CityTierToronto,Tier1Vancouver,Tier1Calgary,Tier2... etcUse our Chrome extension to bulk generate the embedded data setup: https://chromewebstore.google.com/detail/qualtrics-embedded-data-g/fkkmlmjhiehciaaodjghecnjojendgfoIt'll create all the embedded data fields and logic automatically instead of setting up each city tier manually.The extension handles:Bulk embedded data creationValidation of your mapping dataProper formatting for Qualtrics importVisit Other Free Tools Command Center:https://piraiai.com/qualtrics-toolkit1) Converting QSF files back to Excel workbook for analysis2) Validate Supplemental Data Sources for Qualtrics. Compare CSV files with up to 100K rows, find duplicates, and ensure perfect data matching.3) Generating embedded data setups fasterShould save you hours compared to manual setup. Let me know if you need any help with the CSV format or setup process!

Chee Heng_SZ · Answer

Perhaps you canconsider using Supplemental Data Source.In your supplemental data, you can have 2 columnsfor city and city tier.Use city for referencing, then get the embedded data through city tier.

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded