cancel
Showing results for 
Search instead for 
Did you mean: 
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
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power BI Dev Camp Session 27

Ted's Dev Camp

This session walks through creating a new Azure AD B2C tenant and configuring it with user flows and custom policies.