Importing Custom Data and dashboard

[clavenk152237]

Hi, I having a requirement to allow update crm data into adobe analytic for create a dashboard view. 

e.g

importing FTP via data source into system.

sample field like. 

transaction id, application type, status, created date, created by, etc

The end goal for this is basically using the import data to drag and drop to output say rejected rate in graph for dashboard. Something that can be achieve by splunk.

Can anyone guide me where i can find these information?

[Løjmann]

Hi,

Did you look at the guide from Adobe on this: https://marketing.adobe.com/resources/help/en_US/sc/datasources/adobe_analytics_data_sources.pdf ?

/Løjmann

[clavenk152237]

HI i already did, but after upload with custom header name. It throw error. 

                  

Summary

Description Status: ERROR The Data Source could not be processed Data Source Filename: trx_appl_20170516.txt Upload Date: Tue. 16 May 2017

Details

Report Suite Site Title:   Site URL:   Username: apdapdapactemplate

Notes : The file could not be processed due to the following conditions: : Column header: "trx_application_id" is not a valid column header : Column header: "name" is not a valid column header : Column header: "id_type" is not a valid column header : Column header: "id_num" is not a valid column header : Column header: "mob_tel" is not a valid column header : Column header: "email" is not a valid column header : Column header: "education_level" is not a valid column header : Column header: "interview_date" is not a valid column header : Column header: "fist_date" is not a valid column header : Column header: "status" is not a valid column header : Column header: "created_by" is not a valid column header : Column header: "updated_date" is not a valid column header : Column header: "updated_by" is not a valid column header : At least one enabled metric is required : At least one enabled dimension is required

after that i did try to change all the column name to eVar1...eVar13. Now the status is in queue

please refer to attachement on the current upload file status

[Hyder_Ziaee]

Looks like your third file failed as well. Make sure that the 'V' is capital in 'eVar' 

Do you also have an event in the file? There must be at least one eVar and one event in the file along with the date column. Also make sure the 13 variables you are using are enabled in the report suite settings.

-Hyder

[Hyder_Ziaee · Accepted solution]

---Correction---

The evarN should be as 'Evar X', where X = {1, 250}

similarly event should be 'Event Y', where Y = {1, 1000}

Make sure the the first letter is capitalized and there is a space in between the word and the number.

-Hyder