Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Custom Calc returning different R/F than inventory search

Description

The following requests generate different R/F metrics between the /search endpoint and the /measures/summary endpoint.

search request:

{ "target_segment": "2035", "period_days": 84, "target_geography_list": [ "local_cbsa" ], "measures_release": "2021r1", "id_type": "frame_id", "id_list": [ 30453085 ] }

/measures/summary request:

{ "target_segment": "2035", "period_days": 84, "target_geography_list": [ "local_cbsa" ], "measures_release": "2021r1", "id_type": "frame_id", "id_list": [ 30453085 ] }

I’ve attached the screenshots of the results provided by the user.

Additionally, when pulling the raw data from the custom calc function in snowflake, there is a difference between the VEH 12 Week Unreach value when compared to the raw data from the measures table. I’ve attached the csv outputs from snowflake.

Environment

None

Attachments

5
  • 27 Aug 2021, 08:53 PM
  • 26 Aug 2021, 08:14 PM
  • 26 Aug 2021, 08:14 PM
  • 26 Aug 2021, 08:12 PM
  • 26 Aug 2021, 08:12 PM

Activity

Show:

Michael RiccioAugust 30, 2021 at 2:59 PM

Thanks, see this working as expected in production

Janna GuAugust 27, 2021 at 8:55 PM

The issue was the the max period of days for RF model at month level was set at 84 days, where it is supposed to be 365 (no longer than a year)

Janna GuAugust 27, 2021 at 8:53 PM

A fix in the RF model is deployed. Ready for test!

Here is my test results:

Janna GuAugust 27, 2021 at 6:40 PM

custom calc scripts

SELECT
batch_id,
spot_id,
gp_frame_id,
demo_id,
gp_market_id,
market_id,
demographic_population,
ped_circulation,
veh_circulation,
total_impressions,
total_in_market_impressions,
veh_spot_tot_imp,
veh_spot_in_mkt_imp,
veh_unreach_prob1eff,
veh_unreach_probneff,
ped_spot_tot_imp,
ped_spot_in_mkt_imp,
ped_unreach_prob1eff,
ped_unreach_probneff,
time_calculated,
period_of_days,
start_date,
end_date
FROM
table(
gp_insights_prod_beta.gp_library_2021_r1.gp_measures_calc_a (
'{"base_segment":"2032","target_segment":["2035"],"target_geography_list":["CBSA27260"],"min_freq":1,"batch_list":[{"batch_id":"1","id_list":[30453085],"period":{"start_date":"2021-01-01T00:00:00.000Z","end_date":"2021-03-25T23:59:59.999Z"}}]}'
)
) where gp_market_id = 'CBSA27260' and demo_id = '3fa766d0-467f-47cf-aaec-00ae7bd60933' and batch_id = 0
ORDER BY
batch_id,
spot_id;

Janna GuAugust 27, 2021 at 6:38 PM
Edited

It turns out that RF model need to updated to support custom calc to handle reporting period longer than 12 weeks well. I will update once a resolution is in place

Done
Pinned fields
Click on the next to a field label to start pinning.

Details

Assignee

Reporter

Sprint

Priority

Parent

Created August 26, 2021 at 8:08 PM
Updated March 10, 2022 at 3:52 PM
Resolved August 30, 2021 at 2:59 PM

Flag notifications