Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Orders Data Mis-match Website vs Adobe

bindukumari1990
Level 4
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.

3 Replies
ishans52004352
Employee
Employee

@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
Level 4
Level 4

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