Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
mvk843
New Member

Connect Yandex Metrika and Yandex Direct

Hello! I have two tables:

YaM_stat:

StringIdINTEGERNULLABLE
 
 
CounterIDINTEGERNULLABLE
 
 
TimeVisitDATENULLABLE
 
 
DepthINTEGERNULLABLE
 
 
GoalsSTRINGNULLABLE
 
 
AdINTEGERNULLABLE
 
 
UTMCampaignSTRINGNULLABLE
 
 
UTMContentSTRINGNULLABLE
 
 
UTMMediumSTRINGNULLABLE
 
 
UTMSourceSTRINGNULLABLE
 
 
UTMTermSTRINGNULLABLE
 
 
DurationINTEGERNULLABLE
 
 
OtkaznostINTEGERNULLABLE
 
 
ClientIdSTRINGNULLABLE


YaD_stat:

AdIdSTRINGNULLABLE
 
 
CampaignIdSTRINGNULLABLE
 
 
ClicksINTEGERNULLABLE
 
 
CostSTRINGNULLABLE
 
 
DateDATENULLABLE
 
 
ImpressionsINTEGERNULLABLE
 
 
AvgCpcSTRINGNULLABLE
 
 
Status_adsSTRINGNULLABLE
 
 
TypeSTRINGNULLABLE
 
 
DisplayUrlPathSTRINGNULLABLE
 
 
HrefSTRINGNULLABLE
 
 
Id_adsetSTRINGNULLABLE
 
 
Name_adsetSTRINGNULLABLE
 
 
Status_adsetSTRINGNULLABLE
 
 
EndCampaignSTRINGNULLABLE
 
 
Name_campaignSTRINGNULLABLE
 
 
StartCampaignSTRINGNULLABLE
 
 
StateSTRINGNULLABLE
 
 
SourceIdSTRINGNULLABLE
 
 
AccountNameSTRINGNULLABLE
 
 
ClientInfoSTRINGNULLABLE
 
 
ClientIdSTRINGNULLABLE
 
 
LoginSTRINGNULLABLE


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?

2 REPLIES 2
V-lianl-msft
Community Support
Community Support

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
New Member

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.