Hello, thanks for you response. See below for the samples.
Index 1, Clicks:
_id
id number_index
company_click_out_score
0_type
_docclick_box_title
specific categoryclick_out_id
click id numberclick_price
1.00clickbox_category_id
366company_id
1111company_location_city
Utrechtcompany_location_city_keyword
Company A Utrechtcompany_location_country
ENGcompany_location_geo_point
14.422657, 17.94846company_location_id
85 642company_location_name
Franchise Acompany_location_postcode
43253company_name
Company Acreated_at
Timefield when the doc is addedday_of_week_keyword
monday
hour_of_day
1is_free_click_int
0
is_paid_click_int
1missed_revenue
0,00monetization_rate
100%month_keyword
januarynumber_of_clicks
1occurrences_times
original_price
1.00paid_clicks_percentage
100%parent_category_title
Parent categorytype
bookingupdated_at
Jan 1, 2020, @ 00:00:00visit_id
id of the sessionvisitor_ip_address
ip address of the uservisitor_ip_address_string
ip address of the user in string typevisitor_user_agent
device information of the userweek_number
1
-- Above is index a, Clicks, below this line starts index b, conversions.
Index 2, conversion:
_id
123_index
company_conversion_score
0_type
_docclickbox_category_id
123clickbox_category_name
Categoryconversion_id
123created_at
Jun 4, 2021 @ 14:00:00.000experiments
{
String with some experimental data
}offer_date_from
Start date of the offeroffer_date_until
End date of the offerpermanent_visitor_id
27346278_a424brental_item_id
1435rental_item_name
specific item namerental_service_provider_id
23452rental_service_provider_location_id
23552rental_service_provider_location_name
Company A Utrechtrental_service_provider_name
Franchise A - Company A Utrechttype
bookingupdated_at
Jun 4, 2021 @ 14:00:00.000visit_id
id of the session
The bold text is the field with some sample data which I would like in the combined doc. These are from the 2 indices, clicks and conversions, both have the field 'visit_id', which might add some possibilities when it comes to combining docs.
Hope this information is an answer to your request and you can help us out!