Transaction Data Implementation

There is an option to connect your backend order system with Roivenue and evaluate your marketing activities on the margin level and clean of all canceled orders and returns.

1. Why to Connect Transaction Feed With Backend Orders Data

1. Profit and Margin included in Roivenue - Google Analytics provides only the information about revenue. But the profit levels can be vastly different for each SKU. That is why it is possible to include profit in the export and analyse effectivity of campaigns on profit, which is what matters most at the end of the day.

2. Cancelations and Returned Orders - Between 5 % and 50 % of online orders is returned or canceled which creates a big gap between conversions reported in Google Analytics and final revenue from these orders. By connecting the data to Roivenue, you can see the truth and the real revenue and profit from orders which were actually paid and delivered.

3. Visibility to all conversions - not all conversions are measured by web analytics due to cookie consents, tracking blockers and similar. It can cause web analytics to report up to 50% lower results, compared to real number of conversions. While it is not possible to calculate attribution for orders which are not in web analytics, we will show you how many of these orders you have. You will be able to analyse if the quality of your measurement is getting better or worse and what proportion of your traffic is not measured.

4. Customer Lifetime Value Analysis - Roivenue combines data from your system with the data from ad platforms and web analytics. It means that you can evaluate which channels works best for acquisition and which are the retention drivers. Also some channels may bring customers with much higher CLV. This analysis is typically conducted using Roivenue data in Power BI or similar BI platform.

2. How it Works in Roivenue

This is the list of changes you will notice in Roivenue after implementing the transaction feed.

1. Transaction feed will become the source of truth - The number of conversions, delivered orders, the total revenue and profit values will be taken from the transaction feed instead of Google Analytics. This is important to remember as the total numbers will now be comparable with your CRM but will not be 1:1 comparable with your web analytics

2. Revenue and profit will be calculated only from delivered orders - There is an option to specify the status of each order during the import to Roivenue. Roivenue will take only orders marked as "delivered" and show revenue and profit from them. Until the order does not have the "delivered" status, revenue and profit will not be displayed!

3. New dimension value called "Not Tracked" will appear - These are all the orders which were missing in your web analytics. So do not worry, not tracked will always be there and it is a good guidance on how much traffic/conversions is not measured due to cookie consents and other challenges.

4. Daily updates of orders - you will be uploading the file daily and multiple weeks of data will be always included so we can update the status of orders - returns, cancellations, etc.

Always upload all transactions in the given period. Roivenue will always automatically process the newest file. All the orders data which were already in Roivenue for that period will be deleted first and the newest file is always considered a source of truth.

3. Creating The Transaction Feed

Note: There needs to be a separate XML file for each site in Roivenue. If not sure what are all the sites in Roivenue, contact your account manager who will help you clarify this.

3.1 Naming The File

Correct naming is crucial for successful integration with Roivenue. If the naming will be incorrect, it will not be possible to connect the data.

The created XML files have to be named with the following syntax:

oms-extract-orders_{code}_{start-date}-{end-date}.xml

• Values inside of {} will be replaced. The file name has to be entirely lower case letters including the XML suffix.

• code = business unit code (ask your account manager about your business unit code). For a website example.com the code will usually be "examplecom"

• start-date = This needs to be the first day for which data is included in the file and needs to be in a format yyyyMMdd.

• end-date = This needs to be the last day for which data is included in the file and needs to be in a format yyyyMMdd.

3.2 Content of The File

The goal here is to define what will be all the information shared with Roivenue.

The file should include all the orders created on a given site. You can differentiate between shipped, cancelled, or returned orders using one of the order parameters.

There are two types of parameters for each order.

• Required - these need to be sent for all orders.

• Optional - You can use these parameters if you want to work with them further in your analysis, but they are unnecessary for Roivenue to work correctly.

In case the required parameters are missing in the file, data will not be loaded to Roivenue

See the list and description of parameters below:

Required Parameters

Name	Description and examples
Site	The web domain where the order was generated. This is typically the site for which the feed is created. Example value: example.cz
WebId	The unique ID of the online order captured by the web tracking software, for instance when Google Analytics is used, this is the transaction ID. ID must be unique. Example value: 15108766
OrderId	Internal unique order number. Can be the same as WebId. During all editing in the system this ID has to stay the same. Example Value: 12001508xxx
UserId	User ID connected to the order. Must be hashed.If it is not possible to assign an ID to a user (e.g. the system does not create users for orders without a login) their hashed e-mail address is used. UserId will then be the same as userEmailAddress. Example Value: e99f33420f577ee8
Status	This identifies the status of the order, following statuses are allowed: • Created - The status when the order is initialized (put in the cart) • Ordered - Accepted/created order • Canceled - Cancellation (test or duplicate order) • Shipped - Forwarded to dispatch • Delivered - Delivered / Paid-in order • Returned - Returned order • Undelivered - order was not delivered or picked up
Delivered	Status whether money was received. Only revenue from orders with delivered = 1 will be shown in Roivenue! 1 = YES, 0 = NO. Example Value: 1|0
OrderedAt	The date when the order was completed. The date when the order was accepted into the ERP system. This should be the time when WebID was send to Google Analytics. Example Value: 2015-04-25T09:00:00
CurrencyCode	ISO 4217 currency name, the whole order must be converted into a single currency. Example Value: CZK|EUR|PLN
Profit	This should be the gross profit made on the order. It is typically calculated as revenue - cogs (cost of goods sold) Example Value: 235
Revenue	Total revenue for sold goods. Value excludes VAT and other delivery, payment or shipping costs. Example Value: 928.05

Optional Parameters

Name	Description and examples
UserBirthAt	Date of birth "YYYY-MM-DD". Example Value: 1988-12-11
UserCountryCode	Country code identifying the user's country. Example Value: CZ|SK
UserCity	The city where the order was delivered. Example Value: Prague 2
UserPostalCode	ZIP code. Example Value: 12200
UserLatitude	Latitude of the User or Delivery address. Example Value: 12.458033
UserLongitude	Longitude of the User or delivery address. Example Value: 31.113281
UserCreatedAt	The date the user account was created. For an unregistered user the order date will be applied. Example Value: 2015-02-25T12:17:00
SourceSystem	Identifier of the system where the order was sourced from, ERP name. Example Value: SAP ERP6.142
SalesChannel	Optional. If not filled in, the order behaves as "online". Example Value: online|offline
PaymentType	Determines the payment method, e.g. cash, card, cupon delivery, ... Example Values: • Payment in database on client side - Value (in export) • Cash or card at delivery - CashOnDelivery • In advance by card(Gopay, PayU) - Card.PayU • Bank account transfer - Bank.KB • On hire purchase - Installment
DeliveryType	Determines the delivery method, e.g. post, local pickup, ... Example Values: • DPD - Delivery.DPD • PPL - Delivery.PPL • Geis - Delivery.Geis • Czech Post - Delivery To Hand - Delivery.CP • Czech Post - Delivery To Post Office - Pickup.CP • Ulozenka - Pickup.Ulozenka
ProcessingType	This is the how the order was processed, e.g. quick checkout, login checkout, call, store, ... Example Value: login | no-login
CreatedAt	Date and time when the product was first added to the cart. If CreatedAt is unknown, the value from OrderedAt is used. Example Value: 2015-04-25T09:00:00
ModifiedAt	Date when the order was modified. Example Value: 2015-04-25T11:11:00
UserEmailHash	Hash of the email address. For example MD5(LOWERCASE(email_address)). When the UserEmailHash is not populated then a UserId must be provided, bad data shall be encoded with "-". Example Value: e99f33420f577ee8
ShippedAt	Datetime when the order was completed and dispatched to the customer (or prepared for pick up by the customer). Example Value: 2015-04-26T13:00:00
DeliveredAt	Date the order was handed over to the customer (date of receipt of the shipment). Example Value: 2015-04-27T10:00:00
ReturnedAt	Datetime when the order was returned by the customer. Example Value: 2015-05-02T10:00:00
UserPhoneHash	Hash of the phone number, preferable in a standardised international format. For example MD5([phone]), bad data shall be encoded with "-". Example Value: s11f12420f897cc8
DeliveryCost	Cost of delivered / undelivered shipment. Usually it has fixed values according to the type of transport. It is not the fee that your customer pays for delivery. Example Value: 80
PaymentCost	Payment costs (e.g: for payment gate maintenance, costs for each type of payment) - fixed value. Example Value: 15
ProcessingCost	Other costs for order processing. For example, packing. Example Value: 0
UserGender	gender of the customer. Values: "m" or "f". Example Value: m | f
UserSegment	Indicates the kind of the customer private - customer who is not a company private.partner.{xxx} - customer who is not a company with a special contract, {xxx} defines the contract type, for instance the discount level etc business – customer who is a company, and his price is the same as for private customers business.partner.{xxx} – companies, with a specific status, either they do have a special contract or a special price, {xxx} defines the contract type, for instance the discount level etc. Example Value: customer.c15
ProductCost	Cost of purchasing goods excluding VAT. Example Value: 235
Discount	Discount value including VAT. These include, for example, a discount obtained through a discount coupon, a discount on a product or an entire order. The discount value can be any positive number; it cannot be zero. Example Value: 30
Delivery	Delivery costs, including VAT, that are charged to the client. Example Value: 0
Surcharge	Extra charges to the customer, for instance payment fee, etc, including VAT. Example Value: 0
ProductsQuantity	Number of products sold in the order. Example Value: 1
ProductsDelivered	Number of products delivered, ProductsQuantity less ProductsReturned, or removed from the order when amended. Example Value: 0
Tax	Tax of the products VAT and any other tax paid if applicable, tax is calculated only from the total less delivery and surcharge. Example Value: 194.95
Total	Invoiced amount including all charges (postage, shipping, discounts and VAT) as seen by the customer. (ProductsRevenue + Delivery + Surcharge + Tax). Example Value: 1123

3.3 Important Things To Decide or Check

1. When to consider order as "delivered" - Until you mark order as delivered, the revenue from this order will not be visible in Roivenue. It is important to decide when do you want to recognize the revenue.

   1. It might be good for marketers to mark orders as delivered immediately to see the ROI of campaigns as soon as possible. These orders, when cancelled can be changed, and revenue will disappear from Roivenue

   2. From a financial point of view, it makes sense to mark the order as delivered once it is paid.

   3. Ultimately, it is important to discuss this with all the stakeholders and choose an approach that aligns with your business decision-making process.

2. What to do with partial returns - Sometimes, customers order multiple products, choose the ones they want and then return the others. You can include this information in the transaction feed in two ways.

   1. The simpler option is to keep the order status as "delivered" and adjust only the revenue and profit for this order. This option is easy to implement, but a disadvantage is that it is impossible to recognize which orders have been partially returned.

   2. The more advanced option is to send a new " PartialReturn" status for these orders, keep the element "Delivered" = 1 and adjust the revenue and profit accordingly. This will allow us to analyse how many orders are being partially returned.

3. Sending date and time information in the correct time zone—The feed data is connected with data from web analytics, so the time zone needs to be set the same in both destinations. If you are not sure which time zone to use, contact your account manager for help.

4. How to include orders from other sales channels—It is possible to include not only online orders but also orders from brick-and-mortar stores, orders through phone, and similar. Typically, the optional parameter "SalesChannel" is used to include these, but we recommend discussing this custom implementation with us in advance. We will help you choose the right way to share the data.

3.4 XML File Structure

This is an example how the XML structure should look like. On the first page, there is just the example but you can also switch to the second tab where there is a description for each of the parameters. The example shows a feed with exactly one order

XML File Structure

<?xml version="1.0" encoding="utf-8"?>
<Orders>
    <Order>
        <Site>example.cz</Site>
        <OrderId>12001508xxx</OrderId>
        <UserId>e99f33420f577ee8</UserId> 
        <Status>Ordered</Status>
        <Delivered>1|0</Delivered>
        <OrderedAt>2015-04-25T09:00:00</OrderedAt> 
        <CurrencyCode>CZK|EUR|PLN</CurrencyCode> 
        <Profit>235</Profit>
        <Revenue>928.05</Revenue> 
        <DeliveryCost>80</DeliveryCost> 
        <PaymentCost>15</PaymentCost> 
        <ProcessingCost>0</ProcessingCost> 
        <ProductsCost>235</ProductsCost> 
        <Total>1123</Total> 
        <Tax>194.95</Tax>
        <Discount>30</Discount> 
        <Delivery>0</Delivery> 
        <Surcharge>0</Surcharge> 
        <ProductsRevenue>980</ProductsRevenue> 
        <SalesChannel>online|offline</SalesChannel> 
        <PaymentType>CashOnDelivery</PaymentType> 
        <DeliveryType>PPL</DeliveryType>
        <ProcessingType>no-login | login</ProcessingType> 
        <ProductsQuantity>1</ProductsQuantity> 
        <ProductsDelivered>0</ProductsDelivered> 
        <CreatedAt>2015-04-25T09:00:00</CreatedAt>
        <ModifiedAt>2015-04-25T11:11:00</ModifiedAt>
        <ShippedAt>2015-04-26T13:00:00</ShippedAt> 
        <DeliveredAt>2015-04-27T10:00:00</DeliveredAt> 
        <ReturnedAt>2015-05-02T10:00:00</ReturnedAt>
        <SourceSystem>SAP ERP6.142</SourceSystem> 
        <UserEmailHash>e99f33420f577ee8</UserEmailHash>
        <UserPhoneHash>s11f12420f897cc8</UserPhoneHash>
        <UserSegment>customer.c15</UserSegment>
        <UserGender>m | f</UserGender> 
        <UserBirthAt>1988-12-11</UserBirthAt>
        <UserCountryCode>CZ|SK</UserCountryCode>
        <UserCity>Praha 2</UserCity>
        <UserPostalCode>12200</UserPostalCode>
        <UserCreatedAt>2015-02-25T12:17:00<UserCreatedAt> 
    </Order>
</Orders>

XML File Structure with detailed description

<?xml version="1.0" encoding="utf-8"?>

<Orders version="5.2" propertyCode="examplecz" startDate="2017-02-28" endDate="2017-03-28">

Note: propertyCode - the same as Business unit code

startDate - beginning of the period for which the export is generated

endDate - end of the period for which the export is generated

each order is represented by one Order element

<Order>

Required fields

<Site>example.cz</Site>

Note: The web domain where the order was generated. If the order isn't placed online the value will be "-".

<WebId>A1234582</WebId>

Note: The unique ID of the online order captured by the web tracking software, for instance when Google Analytics is used, this is the transaction ID. ID must be unique. For offline orders it will be a dash -.

<OrderId>12001508xxx</OrderId>

Note: Internal unique order number. Can be the same as WebId. During all editing in the system this ID has to stay the same.

<UserId>e99f33420f577ee8</UserId>

Note: User ID connected to the order. Must be hashed.If it is not possible to assign an ID to a user (e.g. the system does not create users for orders without a login) their hashed e-mail address is used. UserId will then be the same as userEmailAddress. UserId for offline orders can be null.

<Status>Ordered</Status>

Note: This identifies the status of the order, it can be a numerical type or a textual description of the order status. Examples statuses are new/paid/returned. Unknown status shall be encoded with "-".

<<Delivered>1|0</Delivered>

Note: Status whether money was received.1 = YES, 0 = NO.

<OrderedAt>2015-04-25T09:00:00</OrderedAt>

Note: The date when the order was completed. The date when the order was accepted into the ERP system. This should be the time when WebID was send to Google Analytics.

<Curr<CurrencyCode>CZK|EUR|PLN</CurrencyCode>

Note: ISO 4217 currency name, the whole order must be converted into a single currency.

<Profit>235</Profit>

Note: Trade margin / surcharge. Difference in sales and purchase prices. This is the gross profit on the order. If not filled in, counts as (Revenue - ProductsCost).

<Revenue>928.05</Revenue>

Note: Total revenue for sold goods. Value excludes VAT and other delivery, payment or shipping costs. From a business perspective, not a customer. (Total - (Tax + DeliveryCost + PaymentCost + ProcessingCost)). We can simplify this calculation by subtracting only tax and inputting the other costs as zero.

The following items are optional - these are the real costs of processing the order. Ideally however, we recommend that you implement them to verify that all values are correct

<DeliveryCost>80</DeliveryCost>

Note: Cost of delivered / undelivered shipment. Usually it has fixed values according to the type of transport. It is not the fee that your customer pays for delivery.

<PaymentCost>15</PaymentCost>

Note: Payment costs (e.g: for payment gate maintenance, costs for each type of payment) - fixed value.

<ProcessingCost>0</ProcessingCost>

Note: Other costs for order processing. For example, packing.

<ProductsCost>235</ProductsCost>

Note: Cost of purchasing goods excluding VAT.

The following items are optional - financial information from the customer's perspective

<Total>1123</Total>

Note: Invoiced amount including all charges (postage, shipping, discounts and VAT) as seen by the customer. (ProductsRevenue + Delivery + Surcharge + Tax).

<Tax>194.95</Tax>

Note: Tax of the products VAT and any other tax paid if applicable, tax is calculated only from the total less delivery and surcharge.

<Discount>30</Discount>

Note: Discount value including VAT. These include, for example, a discount obtained through a discount coupon, a discount on a product or an entire order. The discount value can be any positive number; it cannot be zero., a discount obtained through a discount coupon, a discount on a product or an entire order. The discount value can be any positive number; it cannot be zero.

<Delivery>0</Delivery>

Note: Delivery costs, including VAT, that are charged to the client.

<Surcharge>0</Surcharge>

Note: Extra charges to the customer, for instance payment fee, etc, including VAT.

<ProductsRevenue>980</ProductsRevenue>

Note: This is the income on sold goods without any bonuses or discounts. In cases when there are no discounts and other costs then this is identical to the revenue.excluding VAT.

Optional items - further information about the order

<SalesChannel>online|offline</SalesChannel>

Note: Optional. If not filled in, the order behaves as "online".

<PaymentType>CashOnDelivery</PaymentType>

Note: Determines the payment method, e.g. cash, card, cupon delivery, ...

<DeliveryType>PPL</DeliveryType>

Note: Determines the delivery method, e.g. post, local pickup, ...

<ProcessingType>no-login | no-login</ProcessingType>

Note: Order processing method. E.g. order without registration -> order.nologin; order after login -> order.login etc.

<ProductsQuantity>1</ProductsQuantity>

Note: Number of products sold in the order.

<ProductsDelivered>0</ProductsDelivered>

Note: Number of products delivered, ProductsQuantity less ProductsReturned, or removed from the order when amended.

Optional items - times of order status change

<CreatedAt>2015-04-25T09:00:00</CreatedAt>

Note: Date and time when the product was first added to the cart. If CreatedAt is unknown, the value from OrderedAt is used.

<ModifiedAt>2015-04-25T11:11:00</ModifiedAt>

Note: Date when the order was modified.

<ShippedAt>2015-04-26T13:00:00</ShippedAt>

Note: Datetime when the order was completed and dispatched to the customer (or prepared for pick up by the customer).

<DeliveredAt>2015-04-27T10:00:00</DeliveredAt>

Note: Date the order was handed over to the customer (date of receipt of the shipment).

<ReturnedAt>2015-05-02T10:00:00</ReturnedAt>

Note: Datetime when the order was returned by the customer.

Optional items - customer information

<SourceSystem>SAP ERP6.142</SourceSystem>

Note: Identifier of the system where the order was sourced from, ERP name.

<UserEmailHash>e99f33420f577ee8</UserEmailHash>

Note: Hash of the email address. For example MD5(LOWERCASE(email_address)). When the UserEmailHash is not populated then a UserId must be provided, bad data shall be encoded with "-".

<UserPhoneHash>s11f12420f897cc8</UserPhoneHash>

Note: Hash of the phone number, preferable in a standardised international format. For example MD5([phone]), bad data shall be encoded with "-".

<UserSegment>customer.c15</UserSegment>

Note: Indicates the kind of the customer private - customer who is not a company private.partner.{xxx} - customer who is not a company with a special contract, {xxx} defines the contract type, for instance the discount level etc business – customer who is a company, and his price is the same as for private customers business.partner.{xxx} – companies, with a specific status, either they do have a special contract or a special price, {xxx} defines the contract type, for instance the discount level etc.

<UserGender>m | f</UserGender>

Note: gender of the customer. Values: "m" or "f".

<UserBirthAt>1988-12-11</UserBirthAt>

Note: Date of birth "YYYY-MM-DD".

<UserCountryCode>CZ|SK</UserCountryCode>

Note: Country code identifying the user's country.

<UserCity>Praha 2</UserCity>

Note: The city where the order was delivered.

<UserPostalCode>12200</UserPostalCode>

Note: Zip code.

<UserCreatedAt>2015-02-25T12:17:00<UserCreatedAt>

Note: The date the user account was created. For an unregistered user the order date will be applied.

</Order>

</Orders>

4. Validation of the Data in The Transaction Feed

To make the feed preparation easier, we have a Feed Validator available here.

It is a simple website that will guide you through validation of the following aspects of the feed:

1. Check if the naming is correct

2. Validate the structure of the file

3. Check if the data in the feed actually makes sense

4. You can also validate if you are uploading the file correctly to Azure storage (as described in step 5) but you can upload the file directly to Feed Validator from your computer.

If you run into any error during the validation process, you will be given information what went wrong. If you are struggling with the solution, let us know and we will help you find the solution.

Please do not go to the next step until you complete the validation through Feed Validator.

5. Upload of The File to Our Azure Storage

5.1 First Upload of the Data

Once you successfully go through all the steps in the Feed Validator, it is the right time to do the first upload of historical data.

• The first upload should be for the entire period which you have agreed with your account manager to be uploaded. Typically, it will be from the date from which you have the rest of your data in Roivenue.

• You can upload all of that data in one big file, but if you prefer, you can split it into multiple files; just make sure there will be no gaps in the dates.

5.2 Daily Uploads

Once the initial load of historical data is complete, you need to set up an automatic daily export, which will ensure that the data is always up to date in Roivenue.

• The data should be sent to Roivenue after midnight, no later than 2 AM.

• The data range should always end with the previous day.

• The default number of weeks to upload every day is 13 weeks. This is to account for returns in that period, but if you need to make this window shorter or longer, contact your account manager, and it can be adjusted.

• Example: on 1.1. the file should be sent before 2 am with data containing a date range from 2.10. to 31.12. and the name will be oms-extract-orders_examplecom_20231002-20231231.xml

5.3 How to do The API Call

To upload an XML file to the Azure Blob file storage, please follow the following steps:

1. Make an HTTP POST on this URL:

   1. "https://api2.roivenue.com/api/blob-storage/upload?key=somekeyfromaccountmanager&fileName=oms-extract-orders_examplecz_20210101-20210131.xml&storageAccountName=roiimportexample&path=export"

2. The XML file has to be uploaded in the body of the POST.

3. The fileName parameter in the URL contains dates. Eg. fileName=oms-extract-orders_examplecz_20210101-20210131.xml&storageAccountName=roiimportexample&path=export

   1. These dates are a record of all orders created during this period. In this example, it would be an XML file with all orders created from 1.1.2021 till 31.1.2021.

   2. According to the range of orders exported from your backend system, these dates must always change with every file uploaded to the storage.

4. In the case that you will get a response = 200 (Success) but the file is not uploaded, then most likely:

   1. the file was not put into the request correctly

   2. the header did not contain 'content-type': 'application/octet-stream'

5. You should expect one of the following responses:

   <Response [201]> {"content":"","contentType":"text/plain"}

   <Response [200]> Success

6. Lastly, you can find here a request example in Python you can use to guide yourself with:

import requests
from datetime import date, timedelta

key = "Storage key, ask your CSM to provide you with correct one"
storage = "roiimportexample"
fileName = "oms-extract-orders_examplecz_"+str(date.today()-timedelta(days=91))+"-"+str(date.today()-timedelta(days=1))+".xml"
url = "https://api2.roivenue.com/api/blob-storage/upload?key={}&fileName={}&storageAccountName={}&path=export".format(key,fileName,storage)

headers = {
    'accept': '*/*',
    'content-type': 'application/octet-stream',
}
with open('XMLFEED.xml', 'rb') as f:
    response = requests.post(url=url,headers=headers,data=f)
print(response)
print(response.text)

Some of the information from the HTTP Post needs to be provided by an account manager. If you do not have them yet, let us know. You need the following:

Account Key - e.g. "P3N2PTIwMjAtMDQtMDgmc3Q9MjAzgubhnijmkiZzcj1jJnNwPWFjd2wmc2lnPVlIMzNQRElQNTYlMkJGMTgxTUhkJTJGQjRMaGhscjNSY0RZZnJUNzBWdGQ5T2xRJTNE"

Account Name - e.g. "roiimportexample"

6. Validation of the Connection to Roivenue

Congratulations, if you finished all the previous steps, you should now have your backend orders data connected to Roivenue.

1. Check the total value of conversions, revenue and profit in Roivenue with your order management system to validate that everything was successful. In ideal case, the two systems should be matching

2. Check the "not tracked" if it looks reasonable. Not tracked orders are all the orders from the transaction feed which are not available in web analytics so they cannot be connected with a customer journey.

   1. Check the not tracked by going to dimension breakdown -> platform name -> Conversions

   2. Check what is the share of not tracked, anything below 15% is good and even values around 30 % can be seen for clients which have higher proportion of unconsented users on their website.

3. Check if "not tracked" can be reduced - sometimes, some issue can occur and even conversions which are in GA will fall into not tracked category. It can happen for example in cases when time zone is not set up correctly and part of orders from a day 1 are included in the feed for day 2. How to check this:

   1. Go to Process Explorer

   2. In the Filter Panel, select

If you want to go forward with this and implement the transaction feed, please reach out to the Customer Success team and they will create your Azure Blob Storage account in order to start processing your files from the internal management system.