new_0222_0545|ADV|0|total_current_assets|cash_on_hand|inventories_net|net_ppe|goodwill_and_intangible|liabilities|total_current_liabilities|total_long_term_liab|total_deposits|book_value_of_equity|retained_earnings|treasury_stock|ev_revenues|ev_earnings|ev_free_cash_flow|ev_assets|ps_ratio|pe_ratio|price_to_book_value|peg_ratio|debt_equity_ratio|dividend_yield|shareholder_yield_ttm|percent_of_shares_outstanding|receivables|payables|capital_stock|return_on_invested_capital|quality_ratio_fractile|momentum_fractile|market_beta_12_month|sustainable_growth_rate|institutional_investor_ownership_percentage|average_shares_outs_diluted|total_employee_number|eps|sga_expense|shares_outstanding|repurchase_of_capital_stock|ordinary_shares_number|payout_ratio|quick_ratio|normalized_eps|stock_buyback|effective_tax_rate|return_on_equity|net_income_ttm|revenues_ttm|dividend_per_share|revenues|gross_profit|pre_tax_income|net_income|interest_income|price|total_return_price|enterprise_value|average_volume_30|one_year_return|short_interest|forward_pe_ratio|forward_pe_ratio_1y|forward_ps_ratio|forward_ps_ratio_1y|quarterly_eps_estimates|quarterly_sales_estimates|quarterly_eps_surprise|quarterly_sales_surprise|quarterly_eps_actual|quarterly_sales_actual|sales_est_0y|sales_est_1y|price_target|consensus_recommendation|price_target_num_est|eps_est_0y|eps_est_1y|r_and_d_expense|reconciled_depreciation|interest_expense_non_operating|land_and_improvements|buildings_and_improvements|other_properties|machinery_furniture_equipment|price_next_month|price_second_month
new_0222_0545|ADV|1|Advantage Solutions Inc Total Current Assets (Quarterly) (USD)|Advantage Solutions Inc Cash and Short Term Investments (Quarterly) (USD)|Advantage Solutions Inc Inventories (Quarterly) (USD)|Advantage Solutions Inc Net PP&E (Quarterly) (USD)|Advantage Solutions Inc Goodwill and Intangibles (Quarterly) (USD)|Advantage Solutions Inc Total Liabilities (Quarterly) (USD)|Advantage Solutions Inc Total Current Liabilities (Quarterly) (USD)|Advantage Solutions Inc Total Long Term Liabilities (Quarterly) (USD)|Advantage Solutions Inc Total Deposits (Quarterly) (USD)|Advantage Solutions Inc Book Value (Quarterly) (USD)|Advantage Solutions Inc Retained Earnings (Quarterly) (USD)|Advantage Solutions Inc Treasury Stock (Quarterly) (USD)|Advantage Solutions Inc EV to Revenues|Advantage Solutions Inc EV to Earnings|Advantage Solutions Inc EV to Free Cash Flow|Advantage Solutions Inc EV to Assets (Quarterly)|Advantage Solutions Inc PS Ratio|Advantage Solutions Inc PE Ratio|Advantage Solutions Inc Price to Book Value|Advantage Solutions Inc PEG Ratio|Advantage Solutions Inc Debt to Equity Ratio|Advantage Solutions Inc Dividend Yield|Advantage Solutions Inc Shareholder Yield (TTM)|Advantage Solutions Inc Percent of Shares Outstanding Short|Advantage Solutions Inc Total Receivables (Quarterly) (USD)|Advantage Solutions Inc Total Payables (Quarterly) (USD)|Advantage Solutions Inc Total Capital Stock (Quarterly) (USD)|Advantage Solutions Inc Return on Invested Capital|Advantage Solutions Inc Quality Ratio Score|Advantage Solutions Inc Momentum Score|Advantage Solutions Inc Beta (1Y)|Advantage Solutions Inc Sustainable Growth Rate (TTM)|Advantage Solutions Inc Institutional Investor Ownership Percentage|Advantage Solutions Inc Average Diluted Shares Outstanding (Quarterly)|Advantage Solutions Inc Total Employees (Annual)|Advantage Solutions Inc EPS Diluted (Quarterly) (USD)|Advantage Solutions Inc SG&A Expense (Quarterly) (USD)|Advantage Solutions Inc Shares Outstanding|Advantage Solutions Inc Repurchase of Capital Stock (Quarterly) (USD)|Advantage Solutions Inc Ordinary Shares Number (Quarterly)|Advantage Solutions Inc Payout Ratio|Advantage Solutions Inc Quick Ratio (Quarterly)|Advantage Solutions Inc Normalized Diluted EPS (Quarterly) (USD)|Advantage Solutions Inc Stock Buybacks (Quarterly) (USD)|Advantage Solutions Inc Effective Tax Rate (TTM)|Advantage Solutions Inc Return on Equity|Advantage Solutions Inc Net Income (TTM) (USD)|Advantage Solutions Inc Revenue (TTM) (USD)|Advantage Solutions Inc Dividend Per Share (Quarterly) (USD)|Advantage Solutions Inc Revenue (Quarterly) (USD)|Advantage Solutions Inc Gross Profit (Quarterly) (USD)|Advantage Solutions Inc Pre-Tax Income (Quarterly) (USD)|Advantage Solutions Inc Net Income (Quarterly) (USD)|Advantage Solutions Inc Net Interest Income (Quarterly) (USD)|Advantage Solutions Inc Price (USD)|Advantage Solutions Inc Total Return Price (USD)|Advantage Solutions Inc Enterprise Value (USD)|Advantage Solutions Inc 30-Day Average Daily Volume|Advantage Solutions Inc 1 Year Price Returns (Daily)|Advantage Solutions Inc Short Interest|Advantage Solutions Inc PE Ratio (Forward)|Advantage Solutions Inc PE Ratio (Forward 1y)|Advantage Solutions Inc PS Ratio (Forward)|Advantage Solutions Inc PS Ratio (Forward 1y)|Advantage Solutions Inc Quarterly EPS Estimates (USD)|Advantage Solutions Inc Quarterly Revenue Estimates (USD)|Advantage Solutions Inc Quarterly EPS Surprise|Advantage Solutions Inc Quarterly Revenue Surprise|Advantage Solutions Inc Quarterly Actual EPS (USD)|Advantage Solutions Inc Quarterly Actual Revenue (USD)|Advantage Solutions Inc Revenue Estimates for Current Fiscal Year (USD)|Advantage Solutions Inc Revenue Estimates for Next Fiscal Year (USD)|Advantage Solutions Inc Price Target (USD)|Advantage Solutions Inc Consensus Recommendation|Advantage Solutions Inc Price Target Num Estimates|Advantage Solutions Inc EPS Estimates for Current Fiscal Year (USD)|Advantage Solutions Inc EPS Estimates for Next Fiscal Year (USD)|Advantage Solutions Inc Research and Development Expense (Quarterly) (USD)|Advantage Solutions Inc Reconciled Depreciation (Quarterly) (USD)|Advantage Solutions Inc Non-Operating Interest Expense (Quarterly) (USD)|Advantage Solutions Inc Land and Improvements (Quarterly) (USD)|Advantage Solutions Inc Buildings and Improvements (Quarterly) (USD)|Advantage Solutions Inc Other Properties (Quarterly) (USD)|Advantage Solutions Inc Machine, Furniture & Equipment (Quarterly) (USD)||
new_0222_0545|ADV|2|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|figure_USD_metric|figure_USD_metric|figure_USD_metric|figure_USD_metric|figure_USD_metric|figure_USD_metric|figure_USD_metric|figure_USD_metric|figure_USD_metric|percent_USD_metric|percent_USD_metric|percent_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|percent_USD_metric|figure_USD_metric|figure_USD_metric|figure_USD_beta|percent_USD_metric|percent_USD_metric|mil_figure_USD_metric|figure_whole_USD_metric|figure_money_USD_per_share_metric|mil_figure_money_USD_metric|mil_figure_USD_metric|mil_figure_money_USD_metric|mil_figure_USD_metric|percent_USD_metric|figure_USD_metric|figure_money_USD_per_share_metric|mil_figure_money_USD_metric|percent_USD_metric|percent_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|figure_money_USD_per_share_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|figure_money_USD_price|figure_money_USD_price|mil_figure_money_USD_metric|figure_USD_metric|percent_USD_metric|figure_USD_metric|figure_USD_metric|figure_USD_metric|figure_USD_metric|figure_USD_metric|figure_money_USD_per_share_metric|mil_figure_money_USD_metric|percent_USD_per_share_metric|percent_USD_metric|figure_money_USD_per_share_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|figure_money_USD_price|figure_USD_metric|figure_whole_USD_price|figure_money_USD_per_share_metric|figure_money_USD_per_share_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric|mil_figure_money_USD_metric||
new_0222_0545|ADV|4|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|daily|quarterly|daily|quarterly|daily|quarterly|daily|daily|quarterly|daily|quarterly|monthly|quarterly|quarterly|quarterly|quarterly|quarterly|monthly|monthly|quarterly|monthly|quarterly|quarterly|quarterly|quarterly|monthly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|daily|daily|daily|daily|daily|monthly|daily|daily|daily|daily|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|monthly|monthly|monthly|monthly|monthly|monthly|monthly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly||
new_0222_0545|ADV|5|411|411||411|411|411|411|411||411|411||1.44984802432|91|1.44984802432|91|1.44444444444||1.44984802432|1.43827160494|234.857142857|1.44498381877|91|15.2666666667|411|411|411|92|92|32.6428571429|30.5|91.5|30.5|251.125||251.125|251.125|22.0588235294||411|91.4|234.857142857|251.125|91.25|91.4|91.5|91.4|91.4||251.125|251.125|251.125|251.125|251.125|1.44498381877|1.44498381877|1.44984802432|1.44991511036|1.44383561644|15.2666666667|1.44755244755|1.44755244755|1.44755244755|1.44755244755|91.25|91.1428571429|91|91|91.25|91.25|32.1538461538|34.8333333333|26.125|22|26.125|23.2222222222|32.1538461538||251.125|91.3333333333||||||
new_0222_0545|ADV|6|4|4||4|4|4|4|4||4|4||329|3|329|3|414||329|162|7|618|3|30|4|4|4|1|1|14|16|2|14|8||8|8|17||4|5|7|8|4|5|2|5|5||8|8|8|8|8|618|618|329|589|365|30|286|286|286|286|8|7|3|3|4|4|13|12|16|19|16|18|13||8|6||||||
new_0222_0545|ADV|7|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|daily|quarterly|daily|quarterly|daily|daily|daily|daily|quarterly|daily|quarterly|daily|quarterly|quarterly|quarterly|quarterly|quarterly|monthly|monthly|quarterly|monthly|quarterly|yearly|quarterly|quarterly|daily|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|market_daily|market_daily|daily|market_daily|market_daily|daily|daily|daily|daily|daily|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|daily|daily|daily|daily|daily|daily|daily|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly|quarterly||
new_0222_0545|ADV|201603||||||||||||||||||||||||||||||||||203.75||-0.0636|23.025||||||-0.0636|||||||458.276|87.908|-21.822|-12.964|44.066|||||||||||||||||||||||||42.639|||||||
new_0222_0545|ADV|201703|528.565|67.233||69.972|5273.746|4234.505|356.436|3878.069||1694.118|37.454||||||||||1.6202||||415.832|73.051||||||||203.75||-0.0459|26.668|||313.4252||1.3553|-0.0459|||||||508.468|95.315|-15.609|-9.35|41.362|||||||||||||||||||||||||42.894|||||||
new_0222_0545|ADV|201909|||||||||||||||||||||||||||||||||||||||||||||||||||||||9.95|9.95||61226.7333|||||||||||||||||||||||||||10.38|10.47
new_0222_0545|ADV|201912|||||||||||||||||||||||||||||||||||||||||||||||||||||||10.4|10.4||13540|||||||||||||||||||||||||||10.8|11.18
new_0222_0545|ADV|202003||||||||||||||||||||||||||||||||||203.75||-0.11|41.056||||||-0.11|||||||879.396|132.703|-20.356|-21.708|-51.794|9.9|9.9||39333.2|||||||||||||||||||||60.209|51.794|||||10.65|10.78
new_0222_0545|ADV|202006|||||||||||||||||0.905|||||||||||||||||203.75||-0.18|80.569||||||-0.2077||25.2175||-81.426|2487.683||641.543|131.62|-51.518|-37.404|-51.521|11.05|11.05||107465.2333|||||||||||||||||||||58.748|51.521|||||11|10.6
new_0222_0545|ADV|202009|||||||||||||1.9661||21.4567||0.7357||1.6632|||||0.0276||||||6|0.4152||5.0261|203.75||0.18|11.855|313.4252|||||0.18||32.0645||-32.513|2813.752||784.345|158.982|40.328|35.949|-48.243|10.16|10.16|5532.2455|479530.9|2.1106|86409|||||||||0.2093|784.345|3124.197|3303.6025|12.5|1.5|2|0.657|0.7292||58.556|48.243|||||8.99|10.51
new_0222_0545|ADV|202012|899.751|204.301|44.185|129.789|4616.135|3258.703|574.989|2683.714||2421.835|-921.101||1.9386|-34.7974|19.4342|1.0589|0.9316||1.7044||0.8659||-10.1609|2.022|584.267|202.054|0.032|||5|0.7625||32.7354|281.6613|62000|-0.68|172.802|313.4252||313.4252||1.3714|-0.6454|-925.216|2.9551||-175.806|3155.671||850.387|180.881|-148.855|-152.643|-82.486|13.17|13.17|6117.5839|1206058.0667|26.6346|6337407|19.9545|16.4625|1.1619|1.0276|0.19|818.905|110.9842|3.8444|0.4009|850.387|||13.5|1.5|2||||61.085|82.486|||49.773|192.414|9.78|9.05
new_0222_0545|ADV|202103|887.191|156.351||73.876|4586.06|3205.226|522.139|2683.087||2425.13|-921.217||1.8719|-37.2324|19.3382|1.0027|0.9691||1.5508||0.8418||3.7411|1.2853|576.282|189.846|0.032|||2|1.5458|-7.0729|32.736|317.6013||-0.0004|40.481|318.45||318.45||1.4031|0.0123||3.1193|-7.0729|-154.214|3067.296||791.021|137.682|1.197|-0.116|-30.865|11.81|11.81|5741.7515|579658.9333|19.2929|4093157|17.8939|14.7625|1.0586|0.9363|0.1068|694.398|36.4462|13.9146|0.1457|791.021|3294.2295|3931.6987|14.25|1.5|2|0.746|0.8798||59.613|30.865|||||12.81|12.6
new_0222_0545|ADV|202106|928.667|159.782||63.13|4546.471|3186.797|521.863|2664.934||2438.748|-915.096||1.6525|-48.9038|39.014|0.9461|0.9275||1.4092|-1.0931|0.8367||-38.7972|2.346|641.136|206.436|0.032|-2.4145|3|3|2.1101|-4.9306|37.1333|323.2943||0.0189|46.607|318.4964||318.4964||1.5347|0.003||-16.1157|-4.9306|-110.689|3275.707||849.954|151.728|12.317|6.121|-37.189|10.79|10.79|5413.1102|903159.2667|-2.3529|7471894|16.3485|13.4875|0.9673|0.8555|0.1435|799.0383|-10.8263|6.3721|0.128|849.954|3520.324|4039.179|13|2|3|0.6628|0.8148||62.674|37.189|||||9.78|8.71
new_0222_0545|ADV|202109|1056.107|168.028||65.083|4541.641|3295.604|628.098|2667.506||2462.713|-891.785||1.3805|-38.2853|37.8262|0.8067|0.7857||1.119|-0.0523|0.8281||-48.4054|1.3708|704.119|244.586|0.032|-2.6883|3|2|2.3128|-5.389|34.0482|320.1206||0.07|37.742|318.5736||318.5736||1.3886|0.0619|-0.794|-19.4329|-5.389|-123.327|3420.122||928.76|162.507|32.603|23.311|-36.49|8.65|8.65|4721.6136|392482.9667|-14.8622|4367031|13.1061|10.8125|0.7757|0.686|0.195|943.802|-5.3333|-1.5938|0.1846|928.76|3520.324|4039.179|12.6667|2|3|0.6628|0.8148||59.163|36.49|||||8.54|7.23
new_0222_0545|ADV|202112|||||||||||||1.3219||36.2183||0.7285||1.0375|-0.0485||||1.0537||||||2|2.0394||34.8762||||||||||||||||||||||8.02|8.02|4520.9123|474901.1333|-39.104|3356793|10.025|9.1136|0.6361|0.6244|0.225|952.991|||||3552.6036|4091.9034|10.5|2.5|2|0.66|0.88||||||||7.28|7.83
new_0222_0545|ADV|202203|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||0.125|887.681||||||||||||||||||||
new_0222_0545|ADV|202206|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||0.195|968.18||||||||||||||||||||
new_0222_0545|ADV|202209|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||0.225|1049.405||||||||||||||||||||
new_0222_0545|ADV|202212|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||0.26|||||||||||||||||||||