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.
@bindukumari1990 You can add purchase related columns like:
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.
@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.