AWS Pinpoint Uploading User/Customer Data and Purchase data

0

I am trying to create segments by uploading user data and purchase data into AWS Pinpoint, there by understanding user's purchase pattern/preferences and run campaigns accordingly. I am able to upload user data using create segment through CSV but not able to upload purchase data. I am getting below error, Import job 1: Import failed for file PinPointPurchaseData.csv with segment name Purchase Data. Bad request: The data we received didn't match the format we expected for the createImportJob operation.

User Data File Header: ChannelType,Address,Location.Country,User.UserId,Attributes.SubscriberNumber

Purchase Data File Header: Attributes.User_ID,Attributes.RegDate,Attributes.ArticleID,Attributes.Purchasetype,Attributes.SusbcriptionStartDate,Attributes.SusbcriptionEndDate,Attributes.ArticlePurchaseDate

Jeevan
asked 10 months ago239 views
1 Answer
0

You might want to assert the values held by the attributes in PinPointPurchaseData.csv segment file must be 100 or fewer characters.

As per the official documentation here, Your endpoint definitions can include only certain attributes. In addition, an attribute name has to be 50 or fewer characters. An attribute value has to be 100 or fewer characters.

profile picture
navule
answered 10 months ago
  • Thanks for your reply, I have checked and can confirm that none of attribute values is greater than 100 characters or attribute name is greater than 50 characters.

  • @Jeevan Also please be noted that your segment files always needs the mandatory columns Address and ChannelType.

    Please keep in mind the following points when you are importing segment files: When you import a segment, remember the following:

    • Amazon Pinpoint can't import compressed files.
    • The files that you import must use UTF-8 character encoding.
    • If you're importing new endpoints, the Address and ChannelType attributes are required.
    • If you're updating existing endpoints, the Id attribute is required for each endpoint that you want to update.
    • Your endpoint definitions can include only certain attributes. For a list, see Supported attributes. In addition, an attribute name has to be 50 or fewer characters. An attribute value has to be 100 or fewer characters.

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions