Activity Reporting - Get Conversion and Impression Data by Date | Community
Skip to main content
zach_shearer
zach_shearer
Level 4
September 16, 2020
Investigating

Activity Reporting - Get Conversion and Impression Data by Date

  • September 16, 2020
  • 2 replies
  • 1349 views

Currently it is not possible to add a date or timeframe dimension to a report in Adobe Target when one doesn't have access to Analytics for Target. See the following forum thread for reference: 

 

https://experienceleaguecommunities.adobe.com/t5/adobe-target-questions/activity-reporting-get-conversion-and-impression-data-by-date/qaq-p/378938/comment-id/4400#M4399

 

I'd like to request that it be possible to segment activity reporting by hour, day, week, month, quarter, year, and date. I'm probably missing a level of granularity there. 

 

2 replies

Amelia_Waliany
Adobe Employee
Amelia_WalianyAdobe Employee
Adobe Employee
October 2, 2020

Thank you for sharing this feedback, @zach_shearer! This is something that the Adobe Target Product Management team will consider for the future of Target reporting. Please feel free to share more details on this thread. Thanks!

 

Warmly,

Amelia

zach_shearer
zach_shearerAuthor
Level 4
October 7, 2020

Thanks @amelia_waliany . Your developers can see the the process that I followed with my incredibly messy Python script. If it is helpful, I can provide the contents of the supporting functions. In short, a report segmented by day should be available in the user interface. 

 

def main(): # Get array of date ranges to query the API with. dateRange = create_date_range_array(startDate, endDate) # Testing # print(dateRange) # Create list to store reports from the API reportsArray = [] # Loop through date range array and query the API for reports. for date in dateRange: # Print currently working report print('Getting current report for date: %s' % date) # Make the API request reportResponse = get_Adobe_abTestResult(adobeTarget_activityId, date, headers) # Loop through the experiences in the response and add a date column with the appropriate date for experience in reportResponse: experience['date'] = date # Append the report to a list of reports. reportsArray.append(reportResponse) # Sleep to avoid hitting API limits. sleep(1) # Create dataframe array to store dataframes reportDataFrameArray = [] # Loop through the reports array and json_normalize them for report in reportsArray: tempDataFrame = pd.json_normalize(report) reportDataFrameArray.append(tempDataFrame) # Concat all of the dataframes in the dataframe array. allReportsDataFrame = pd.concat(reportDataFrameArray) ### Testing # print(reportsArray) # Convert the dataframe to a csv. allReportsDataFrame.to_csv( 'Adobe Target - A-B Test Report - Activity ID({0}) - Date(Start-{1}|End-{2}).csv'.format(adobeTarget_activityId, startDate, endDate), index=False)

 

Terms & ConditionsAccessibility statement

Loading footer...