Orders Data Mis-match Website vs Adobe

[bindukumari1990]

Hi Team, 

We are seeing mis-match in orders count because order confirmation page is not loading due payment gateway issue so we have decided to use offline data upload, in which we  will send data feed to s3 and after that website team will do the reconciliation and find the missing orders. They will provide me the file which I will upload in data source.

But, as I am new to data source thing, so which column  should I add in data feeds. Because of mis-match I found issue in units, orders and revenue.

[yuhuisg]

Take a look at Transaction ID data sources | Adobe Analytics. If you're going to use this, make sure you read Transaction and customer integration | Adobe Analytics too.

[Ishan_Sinha_ · Accepted solution]

@bindukumari1990 You can add purchase related columns like:

currency
curr_factor
curr_rate
duplicate_purchase
event_list

post_event_list
post_product_list
product_list
purchaseid

In addition to the above columns, you can add:

date_time, exclude_hit, hit_source, page_url, post_page_url, post_visid_high, post_visid_low, post_visid_type, mcvisid_high, mcvisid_low

I believe these columns in Data Feeds should be sufficient to find the missing orders.

[bindukumari1990]

@Ishan_Sinha_ for faster solution, we decided to use flat file approach using data source, can you guide me how should I proceed futher like which type of data source should I create, what metrics and dimeson should I create to go further.