I have received a huge set of customer reviews as a csv file from our data team that I would like to use in Iterable. Our business model is representing hundreds of other brands to help consumers make educated buying decisions. So our Data team pulled the 10 most helpful reviews for each brand and supplied me with a giant csv of 182,000+ rows. I know, that's a lot. Probably 172,000 more than we need. But, with that in mind, my goal is to intersperse reviews into brand related emails.
For instance, a consumer may inquire on a brand, let's just say Iterable. In the email, I would want to pull in several random Iterable reviews to feature in the body. I had intended to upload this as a catalog but immediately ran into a lot of problems, most notably that the max is 1,000 rows and this is 182x too big. Secondly, it needs a unique key, and I don't know what I would key off of. The brand's ID in our system would work except there are 10 reviews per brand and the csv has them all on separate lines, with a number of columns that include extra data like review date, name, star rating, url, etc. So it feels like trying to pack 10 reviews all on one row with a unique key of brand_id is not the best path forward. How else would I match up a brand with its reviews?
The reason we want 10 reviews per brand is because these reviews would appear within a variety of emails in a customer journey as they try to make a decision and we don't want to repeat the same reviews over and over.
So, I'm a little stumped on how to proceed. Catalog feels like the only option, but I can't figure out how to send the data to Iterable, how to store the data, and how to pull it in.
Page 1 / 1
Hi Ryan! Thank you for posting! For a more complex request like this, we would recommend discussing your use case with your CSM. They may be able to strategize alternatives or workarounds for a catalog upload of this size.
Reply
Create a new Iterable Plaza community account
Already have an account? Login
Login to the Iterable Plaza Community
Not a customer? Create an account
Log in to Iterable (SSO)
Iterable customers and employees login/create an accountor
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.