Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Google Analytics: wrong cost after filtering

Kindly ask you to help me with my issue.

 

I am loading data from GA:

= Cube.Transform(#"182827499",
{
{Cube.AddAndExpandDimensionColumn, "ga:date", {"ga:date"}, {"Date"}},
{Cube.AddAndExpandDimensionColumn, "ga:campaign", {"ga:campaign"}, {"Campaign"}},
{Cube.AddMeasureColumn, "Cost", "ga:adCost"}
})

 

 

 

I filter table by date 11/1/2020 and get following data: (attention to the first line - cost 7.20) - this is proper cost, which I also see in google analytics page

11/1/2020GDN_Brand_Underdog_Audience(keyword)_00220217.20
11/1/2020GDN_CEO_Audience(keyword)_00130127.18
11/1/2020GDN_Finance_2_0_Audience(keyword)_00720317.16
11/1/2020GDN_Finplan_Retargeting_UA_00620320.15
11/1/2020GDN_Marketing_core_Retargeting_UA_00420210.25
11/1/2020GSP_Keys_ALL_00080054.23
11/1/2020Retargeting_ALL_00080053.08
11/1/2020Search_Brand_UA_00080050.08
11/1/2020Search_Brand_Underdog_UA_00220210.01
11/1/2020Search_Competitors_UA_00080050.09
11/1/2020Social_All_Proudcts_0008005_SUPERLUDI_FriendsFollowers_Website142.43
11/1/2020Social_All_Proudcts_0008005_SUPERLUDI_Retargeting_Website183.20
11/1/2020Social_CEO_0013012_Interests_Website_CPA148.85
11/1/2020Social_Marketing-Core_0042021_Website_CPA99.00
11/1/2020Social_Prodigy-Finance_0072031_Interests_Website65.51
11/1/2020Social_digital_marketing_0052021_Interests_Website_CPA_v2225.44

 


Then I paste any step before filtering. For example, duplicate one of the existing column. And after filtering by the same date 11/1/2020 you can see I get following data: (attention to the first line - cost 8.40) - this cost is wrong, it is bigger than the right one.

11/1/2020GDN_Brand_Underdog_Audience(keyword)_00220218.40GDN_Brand_Underdog_Audience(keyword)_0022021
11/1/2020GDN_CEO_Audience(keyword)_00130128.38GDN_CEO_Audience(keyword)_0013012
11/1/2020GDN_Finance_2_0_Audience(keyword)_00720318.35GDN_Finance_2_0_Audience(keyword)_0072031
11/1/2020GDN_Finplan_Retargeting_UA_00620320.17GDN_Finplan_Retargeting_UA_0062032
11/1/2020GDN_Marketing_core_Retargeting_UA_00420210.29GDN_Marketing_core_Retargeting_UA_0042021
11/1/2020GSP_Keys_ALL_00080054.93GSP_Keys_ALL_0008005
11/1/2020Retargeting_ALL_00080053.60Retargeting_ALL_0008005
11/1/2020Search_Brand_UA_00080050.10Search_Brand_UA_0008005
11/1/2020Search_Brand_Underdog_UA_00220210.02Search_Brand_Underdog_UA_0022021
11/1/2020Search_Competitors_UA_00080050.10Search_Competitors_UA_0008005
11/1/2020Social_All_Proudcts_0008005_SUPERLUDI_FriendsFollowers_Website142.43Social_All_Proudcts_0008005_SUPERLUDI_FriendsFollowers_Website
11/1/2020Social_All_Proudcts_0008005_SUPERLUDI_Retargeting_Website183.20Social_All_Proudcts_0008005_SUPERLUDI_Retargeting_Website
11/1/2020Social_CEO_0013012_Interests_Website_CPA148.85Social_CEO_0013012_Interests_Website_CPA
11/1/2020Social_Marketing-Core_0042021_Website_CPA99.00Social_Marketing-Core_0042021_Website_CPA
11/1/2020Social_Prodigy-Finance_0072031_Interests_Website65.51Social_Prodigy-Finance_0072031_Interests_Website
11/1/2020Social_digital_marketing_0052021_Interests_Website_CPA_v2225.44Social_digital_marketing_0052021_Interests_Website_CPA_v2

 

 

I realy can`t get what is the problem. Maybe the reason is that cost is MeasuredColumn, but how can I fix it?

Need Help