Stats: 3,184,313 members, 7,923,375 topics. Date: Saturday, 17 August 2024 at 02:58 AM |
Nairaland Forum / Science/Technology / Programming / Python Help Needed ASAP (566 Views)
Python Help / Help Needed To Get A Scammer / Urgent Help Needed On How To Save Fingerprint To Sql Using U Are U 4500 And Java (2) (3) (4)
Python Help Needed ASAP by GreatKingg: 4:35pm On Jun 22, 2023 |
If you know you can solve this, kindly ping me... It's not free. Ping me and we can discuss compensation. You will have to explain and give a breakdown of the result. I have all the files and data needed to complete the assignment. Instructions: create a python script that pulls data from the attached five files to generate keyword bids based on the logic below Overall, the script should accomplish the following: * Extract data from the five files * Join the data as need * Calculate KW level bids * Generate a bid upload file * Note: all data was fabricated for this exercise and does not represent ARIS performance or general business economics. * Definitions of terminology used are included at bottom of this email Deliverables: * Bid upload file (a csv file per specs below) * Python script used (instead of a Notebook) to generate the bid upload file Bid upload file: * Format: CSV * Columns to include: Keyword ID Bid Files included for your use: * Inventory_Historical – contains the trailing 120 day average inventory by Mk/Mo/Yr * Inventory_Current_Onsite – contains the current number of the vehicles on our site by make, model and year (e.g., 205 2013 Honda Accords, 150 2015 Toyota Camrys, etc) * KW_Attributes – contains KW, KW ID, Ad Group, Campaign, Match Type, Quality Score, Est First Pos. Bid, Est Top of Page Bid * KW_Performance_L120D – contains historical KW performance (impressions, clicks, cost, conversions) for prior 120 days by KW ID * Make_Model_ARS – contains the historical average ARS for each make/model Bidding logic: Step 1: Calculate initial bid for each KW based on its historical performance a) If KW has >10 conversions * Calculate KW bid based on KW’s historical performance * New KW Bid = KW CVR * Mk/Mo ARS. b) If KW has <11 conversions but ad group has >10 conversions * Calculate KW bid based on its ad group’s historical performance * New KW Bid = AG CVR * Mk/Mo ARS. c) If AG has <11 conversions, but Mk/Mo/Yr has >10 conversions * Calculate KW bid based on the Mk/Mo’s historical performance * New KW bid = Mk/Mo/Yr CVR * Mk/Mo ARS. d) If Mk/Mo/Yr has <11 conversions, but Mk/Mo has >10 conversions * Calculate KW bid based on the Mk/Mo’s historical performance * New KW bid = Mk/Mo CVR * Mk/Mo ARS. e) If Mk/Mo has <11 conversions * New KW bid = Est First Pos Bid. *Hint: aggregate KW data to level needed to get AG, Mk/Mo/Yr, Mk/Mo and Mkt level data *Hint: several attributes (e.g., Mkt, Mk/Mo, etc) will need to be extracted from CMPN and AG names Step 2: Adjust calculated bid based on the following considerations: a) Adjust bid based on current onsite inventory * If current Mk/Mo/Yr inv < hist Mk/Mo/Yr inv * Reduce KW bid by % equal to half the % diff between current and historical inv * E.g., if hist avg is 20 and current inv is 15, reduce bid by 12.5% (i.e., half of 25%). b) Adjust bid based on Mkt CVR only for KWs whose bids were calculated based on Mk/Mo/Yr or Mk/Mo CVR (i.e., not based on KW or AG CVR) * Increase/decrease KW bid by the half the % above or below overall site CVR the market CVR is relative to overall site average * i.e., if overall CVR for the entire site is 1.0% and DAL overall CVR is 1.07%, increase bids for KWs in DAL by 3.5%. c) Cap bids at reasonable levels, based on their quality score * KWs with QS>7 cannot be higher than Est First Pos Bid * KWs with QS<8 and QS>5 cannot be higher than average of Est Top of Page Bid and Est First Pos Bid * KWs with QS<6 cannot be higher than (Est Top of Page Bid *0.9) + (Est First Pos Bid *0.1) * No bids can be higher than $12. d) Cap bids of broad match KWs * Ensure that no bid for a broad match KW is greater than any bid for an exact match KW within the same ad group * E.g., if bids for exact match KWs within the same ad group are $1.50, $1.75 and $1.60, then if a broad match KW with a calculated of bid of $2.00 should have its bid reduced to $1.50 . Definitions: * KW = keyword * AG = ad group * CMPN = campaign * Campaigns target geographical areas where users are located (e.g., a campaign could target all people physically located in Dallas) * CMPNs contain multiple AGs; AGs contain multiple KWs (learn more here) * QS = quality score = value google assigns to each KW based (learn more here) * Impressions = # of times a KW’s ad was seen on in google search results * Clicks = # of times the KW’s ads were clicked (i.e., # of times people clicked through to carvana.com) * Conversions = # of car sales generated from the clicks * CTR = click through rate = clicks / impressions * CVR = conversion rate = conversions / clicks * ARS = average revenue per sale = amount of money Carvana makes per car sold * This is specific to each make and model, but not by year * Est First Pos. Bid = Google’s estimate for the bid required to show up in first position (see below) * Est Top of Page Bid = Google’s estimate for the bid required to show up at the top of the page (i.e., 4th position) * Mkt = Market = the geography the campaign is targeting * ATL = Atlanta * DAL = Dallas * NYC = New York City * CHI = Chicago * SFO = San Francisco * Mk/Mo/Yr = combination of make, model and year. |
Re: Python Help Needed ASAP by Holybwoy: 4:46pm On Jun 22, 2023 |
This is data analysis with python.. very simple You go pay for my data.. I'd do it free.. brother helping brothers |
Re: Python Help Needed ASAP by OlawaleBammie: 4:55pm On Jun 22, 2023 |
Holybwoy:Lol, sofre scam people sir ![]() ![]() Firstly it's not easy, only a seasoned python developer can handle it Secondly no one waste his times for just data money, nothing goes for free ![]() 1 Like |
Re: Python Help Needed ASAP by GreatKingg: 6:22pm On Jun 22, 2023 |
of course, it's analyzing data with python... but you've got to be good at python to attempt it. Email me if you can do it, and I'd send you the data file for the task... then I can pay for your data... deal? Holybwoy: |
Re: Python Help Needed ASAP by Holybwoy: 7:41pm On Jun 22, 2023 |
GreatKingg: Here's my email dollarpor89agmail.com |
Re: Python Help Needed ASAP by GreatKingg: 8:38pm On Jun 22, 2023 |
aii... check your email. Holybwoy: |
Re: Python Help Needed ASAP by Popoola009(m): 9:56am On Jun 23, 2023 |
Send the details and any datasets I need to work with let me see how it will go I am a data scientist and with a little touch of data engineer who has some good knowledge of SQL. e-mail address: adisaazeez61@gmail.com |
Re: Python Help Needed ASAP by Acheems: 11:24am On Jun 23, 2023 |
GreatKingg: How do I contact you? Drop your number |
Re: Python Help Needed ASAP by GreatKingg: 4:05pm On Jun 23, 2023 |
hey, this is to be done with python, not SQL. I'm a data engineer myself with over 8 years SQL experience. If you can do it with python, drop me your email and I will send you the dataset. Popoola009: |
Re: Python Help Needed ASAP by GreatKingg: 4:05pm On Jun 23, 2023 |
Hey, drop me your email address so I can email you. Acheems: |
Re: Python Help Needed ASAP by Acheems: 6:13pm On Jun 23, 2023 |
GreatKingg: |
Re: Python Help Needed ASAP by Popoola009(m): 5:51pm On Jun 24, 2023 |
GreatKingg: I have been waiting to send it so that I can work on it with someone here but I did not see the data. If you have not done it send it to my email : adisaazeez61@gmail.com thanks |
(1) (Reply)
Help Me In Making The Right Choice ,HP Elite 8440E WINDOW 7 I5 Vpro,55k / Need Help In Programming, Want To Learn Or Want A Fully Dynamic Website / Guys Help Me Solve This ASAP...
(Go Up)
Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health religion celebs tv-movies music-radio literature webmasters programming techmarket Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 38 |