SDITools / adobeanalyticsr

R Client for Adobe Analytics API v2.0
Other
18 stars 9 forks source link

Data mismatch between frontend and API return #21

Closed surananeha closed 3 years ago

surananeha commented 3 years ago

Code: df <- aa_freeform_report(company_id = company_id, rsid = rsid_usp, date_range = Total_period, dimensions = c('prop2', 'daterangeday', 'prop1', 'lasttouchchannel'), metrics = 'visitors', segmentId = 's300008117_5dceed9bc945642acd98d070', top = top_values) [segment is 'group| --- side of brand' in the front end]

This is a hit level segment and so should be pulling only that particular side of brand data in which is what is happening when I create a freeform table in the front end with that segment applied. However the data pull has prop2=unspecified also included.

Sample output: Prop2 daterangeday prop1 lasttouchchannel visitors 1 Unspecified Oct 5, 2020 Unspecified None 13 2 Unspecified Oct 6, 2020 Unspecified None 49 3 Unspecified Oct 7, 2020 Unspecified None 50 4 Unspecified Oct 8, 2020 Unspecified None 32 5 Unspecified Oct 9, 2020 Unspecified None 32 7 --- (right) Oct 5, 2020 not brand aligned None 11 8 --- (right) Oct 6, 2020 not brand aligned None 47

benrwoodard commented 3 years ago

Add 'include_unspecified = FALSE' to the function attributes when calling the data. Need to determine if default should be false or true.