Connect Yandex Metrika and Yandex Direct

[mvk843]

Hello! I have two tables:

YaM_stat:

StringId	INTEGER	NULLABLE
CounterID	INTEGER	NULLABLE
TimeVisit	DATE	NULLABLE
Depth	INTEGER	NULLABLE
Goals	STRING	NULLABLE
Ad	INTEGER	NULLABLE
UTMCampaign	STRING	NULLABLE
UTMContent	STRING	NULLABLE
UTMMedium	STRING	NULLABLE
UTMSource	STRING	NULLABLE
UTMTerm	STRING	NULLABLE
Duration	INTEGER	NULLABLE
Otkaznost	INTEGER	NULLABLE
ClientId	STRING	NULLABLE

YaD_stat:

AdId	STRING	NULLABLE
CampaignId	STRING	NULLABLE
Clicks	INTEGER	NULLABLE
Cost	STRING	NULLABLE
Date	DATE	NULLABLE
Impressions	INTEGER	NULLABLE
AvgCpc	STRING	NULLABLE
Status_ads	STRING	NULLABLE
Type	STRING	NULLABLE
DisplayUrlPath	STRING	NULLABLE
Href	STRING	NULLABLE
Id_adset	STRING	NULLABLE
Name_adset	STRING	NULLABLE
Status_adset	STRING	NULLABLE
EndCampaign	STRING	NULLABLE
Name_campaign	STRING	NULLABLE
StartCampaign	STRING	NULLABLE
State	STRING	NULLABLE
SourceId	STRING	NULLABLE
AccountName	STRING	NULLABLE
ClientInfo	STRING	NULLABLE
ClientId	STRING	NULLABLE
Login	STRING	NULLABLE

I need to connect them by some field, but there is no direct match or fields with similar values. May be someone already did this?

[V-lianl-msft]

If there is a relationship in the fields of the two tables, you can try to create a bridge table to connect the two tables.

[mvk843]

I tried to connect UTMCampaign and Name_campaign, but they have different values. So I have no more ideas.