Orders Data Mis-match Website vs Adobe | Community
Skip to main content
Level 4
August 2, 2021
Solved

Orders Data Mis-match Website vs Adobe

  • August 2, 2021
  • 2 replies
  • 1405 views

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.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by isinha

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

2 replies

yuhuisg
Community Advisor
Community Advisor
August 2, 2021

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.

isinhaAdobe EmployeeAccepted solution
Adobe Employee
August 2, 2021

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

Level 4
August 9, 2021

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