def test_find_last_thirty_days(): with freeze_time("2019-05-01"): start_date, end_date = find_last_thirty_days() assert end_date == datetime.date(2019, 4, 30) assert start_date == datetime.date(2019, 4, 1) with freeze_time("2020-03-19"): start_date, end_date = find_last_thirty_days() assert end_date == datetime.date(2020, 3, 18) assert start_date == datetime.date(2020, 2, 18)
def get_transactions_for_tools_request(tool): start_date, end_date = find_last_thirty_days() filters = [{ 'dimensionName': 'ga:eventCategory', 'operator': 'REGEXP', 'expressions': [tool['event_category_filter']] }, { 'dimensionName': 'ga:pagePath', 'operator': 'REGEXP', 'expressions': [tool['page_path_filter']] }] if 'event_action_filter' in tool: filters.append({ 'dimensionName': 'ga:eventAction', 'operator': 'REGEXP', 'expressions': [tool['event_action_filter']] }) return { 'viewId': VADOTGOV_VIEW_ID, 'dateRanges': [{ 'startDate': start_date.isoformat(), 'endDate': end_date.isoformat() }], 'metrics': [{ 'expression': 'ga:totalEvents' }], 'dimensionFilterClauses': [{ 'operator': 'AND', 'filters': filters }] }
def get_last_month_users_request(page_path): start_date, end_date = find_last_thirty_days() return { "viewId": VADOTGOV_VIEW_ID, "dateRanges": [ { "startDate": start_date.isoformat(), "endDate": end_date.isoformat() }, { "startDate": one_year_before(start_date).isoformat(), "endDate": one_year_before(end_date).isoformat() } ], "metrics": [ { "expression": "ga:users" } ], "dimensionFilterClauses": [ { "filters": [ { "dimensionName": "ga:pagePath", "operator": "REGEXP", "expressions": [ page_path ] } ] } ] }
def get_foresee_items_for_services(): start_date, end_date = find_last_thirty_days() recent_items = get_measure_data(authenticate(), start_date, end_date) recent_df = pd.DataFrame(make_table_from_foresee_response(recent_items)) last_year_items = get_measure_data(authenticate(), one_year_before(start_date), one_year_before(end_date)) last_year_df = pd.DataFrame(make_table_from_foresee_response(last_year_items)) return recent_df, last_year_df