Expand my Community achievements bar.

SOLVED

Orders Data Mis-match Website vs Adobe

Avatar

Level 4

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.

1 Accepted Solution

Avatar

Correct answer by
Employee Advisor

@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.

View solution in original post

3 Replies

Avatar

Correct answer by
Employee Advisor

@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.

Avatar

Level 4

@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.