This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.
Log in to ask a question

Duplicates in Results

Posted on 04-03-2022 11:07 PM
yrstruly
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

Please assist? I am getting duplicates and empty columns. What am i doing wrong?

 

SELECT Feed_2_Unique_ID, Date, jevn.DV360_Line_Item_ID, Value, Metric, jevn.Journey, jevn.Slide, Counter, Friendly_Name, Event_LabelFROM `pod-315417.Testing.Journey_Event_Value_New` jevn
Left Join `pod-315417.Testing.Journey_Meta_Data_New` jmdn
On jevn.DV360_Line_Item_ID = jmdn.DV360_Line_Item_ID and jevn.Journey = jmdn.Journey and jevn.Slide = jmdn.SlideLeft Join `pod-315417.Testing.Event_label_New` eln
On jevn.DV360_Line_Item_ID = eln.DV360_Line_Item_ID and jevn.Metric= eln.Event and jevn.Counter = eln.Event_Type
Order by Date, Feed_2_Unique_ID, Journey, Slide

 

bigd.JPG

0 1 194
Topic Labels
0 Likes
1 REPLY 1

Posted on --/--/---- --:-- AM
sarder
Staff
Reply posted on --/--/---- --:-- AM

Hello, 

I understand that the Quality of results from your Query in BigData is not as you expected. Apparently, this Query result seems to be a function of the Data in the BigQuery Storage. From the information provided, I guess this data was exported to BigQuery from Google Analytics? Please correct me if my understanding is wrong. Or maybe you can shed more light on where the Data is pulled from. 

If my understanding is right, then I think the Google Analytics team will be able to assist you better on the missing data or duplicate data. Hence, I recommend that you contact the Google Analytics Support team by following the steps on their Support Center listed below [0] and/or to consult their documentation.

 

[0]https://support.google.com/analytics/answer/4553001?hl=en

0 Likes