Duplicates in Results

Google Cloud Database
1

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
bigd.JPG1112×494 94.1 KB

2

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