Sql query month sales year jobs

I'm looking for a professional to assist with my project by making calls to business owners with the intent of offering our gas and electricity services. This particular role requires someone with strong communication skills and experience in phone-sales, specifically within the energy sector. Ideally, the professional should be: - Knowledgeable about energy products and services - Experienced in lead generation and conversion - Proficient in conducting professional and persuasive calls. The main goal is to expand our reach, and grow our clientele within the business community by effectively communicating the benefits of our diversified energy solutions.

I worked incredibly hard for over a year to bring you a top-notch learning program with Freelancer.com that was never revealed before… It's not just about teaching you everything I know and sharing my journey to the #1 amongst 70 million people; it's also about connecting you with a great community.. Once you complete the program and pass the test, you'll earn an exclusive badge that very few people get.. But.. Also, you get all of the following INCLUDED with NO HIDDEN COST in a YEARLY price of 129 USD: ➡️ Be among the elite few to earn the new IFC badge on your profile so that you can stand out! (Upon successful completion of the test) - Priceless! ➡️ Unlock hours of groundbreaking video content I’ve been working on for months that's nowhere el...

I am in need of a Python developer with expertise in hardware oriented programming to add some additional functionality to an already written script of mine. The existing functions also need to be double-checked for correctness. Key requirements include: - Modify the existi...experience with Python, specifically in writing and improving scripts with a focus towards integration with hardware - Solid knowledge and experience working with Debian operating system, especially in creating bootable Debian images for computer-on-modules (COMs) - A keen eye for detail and proficient debugging skills - Ability to work independently and deliver the completed and tested project within a month. Bid if this is something you can skillfully and confidently handle. I am looking forward to your ap...

I'm in need of a seasoned Sales Manager with a proven track record in the security and facility management industry. You'll be mainly responsible for closing deals and building robust client relationships. Your tasks will include: -Generate & Converting leads into sales - Maintaining long-lasting relationships with clients Ideal Skills & Experience: - Experience: More than 3 years in the security and facility management industry - Key Skills: Strong knowledge of customer service practices is essential. Familiarity with CRM systems will also be a great plus. Your dedication to customer service and ability to close deals will pave the way for our company's continued growth and success. Looking forward to working with a results-orientated Sales...

...(for US primary market) Ali express for the secondary market. Automatic Ability to sync products, prices, availability, etc. frequently. Ability to post product and merchant reviews. Packing slip & shipping labels. Ability to carry min. 50,000 sku's in online catalog. Discounts: Visitor, first order, seasonal, Occasional (tied to things like mother's father's day, Christmas etc. up to 25 occasions/year. Variety of Gift Cards. There may be many more items that would have to included due to client request or designer suggestions. Primary Market US, Canada (may be shipped from China or USA) Secondary market UK, All of Europe, GCC. and 50 additional countries. Secondary market to ship from China only. Incorporated in Houston, Texas or Kansas City, Kansas. S...

As a local business in the UK, I'm seeking to enhance my online presence by attracting more British residents to my website. The primary goal of this project is to increase my site's traffic, thereby boosting my brand's visibility within the local market. Key Requirements: - Skills in Search Engine Optimization (SEO): I need my website to be optimized for search engines to reach a wid...platforms to drive traffic and engage with potential customers. - Pay-Per-Click (PPC) Advertising Knowledge: Experience in setting up and managing PPC campaigns specifically targeting local British residents. Your successful execution of this project will result in a noticeable increase in the number of British residents visiting my website, leading to a potential spike in brand awareness a...

I need a top-notch designer to create a high-converting E-commerce website for my business. Key Requirements: - E-commerce Expertise: Experience designing and building E-commerce websites is essential. You should have a deep understanding of what drives conversions in an online store. - Payment Gateway: I want to integrate Razorpay as my payment gateway. Experience with this, or a simila...solution, is a plus. - User Experience: The website should be intuitive, easy to navigate, and optimized for all devices. - SEO-Friendly: A good understanding of SEO best practices and how they relate to E-commerce is preferred. Your role will be to create a visually appealing and functional E-commerce site that not only showcases my products effectively but also leads to a significant increase in ...

I'm in urgent need of a Tableau expert who can assist me with my data visualization and dashboard/reporting needs. Your responsibilities will include: - Crafting effective and visually appealing data visualizations - Developing interactive an...include: - Crafting effective and visually appealing data visualizations - Developing interactive and insightful dashboards and reports I will provide you with the specific data and objectives for these visualizations and dashboards. The ideal candidate for this position should be proficient in Tableau and have a strong background in data analysis and visualization. Experience in working with sales data would be a plus, although not mandatory. This is an urgent project, so I need someone who can start immediately and complete th...

I own a beautiful property (house + land) in a fabulous location (North West Ireland), and I'd like to raffle it on Raffall - an online platform. The raffle campaign would possibly be for a 3-4 month duration, but I have yet to start. I have loads of ideas and I've done loads of research into it. I am very confident it would be a huge success. Your role will be crucial in managing the campaign from the ground up. Tasks: - Kickstart the project from scratch, as it has yet to begin - Set the strategic direction for advertising and promotion, employing out-of-the-box methodologies to generate attention and spark engagement The ideal candidate: - BASED IN IRELAND - Proven experience in executing successful raffle campaigns, particularly focusing on the advertising a...

...conversion analysis. - Sales Forecasting: Accurate prediction of sales trends and opportunities based on the CRM data. User Base: - The CRM system will be used by 1-50 users, so it should be user-friendly, scalable, and efficient. Integration: - It's imperative that the CRM can seamlessly integrate with other systems, particularly: - Email Platforms: For streamlined communication and lead nurturing. - Social Media: To enhance customer engagement and acquisition. - Accounting Software: To automate financial data synchronization and reporting. Ideal Freelancer: - Proven experience in CRM development, with a strong portfolio of CRM systems. - Proficiency in integrating CRMs with email platforms, social media, and accounting software. - Understanding of data anal...

The main objective of this project is to significantly increase online sales, bringing exponential growth to the business. To achieve this goal, I am seeking a professional with expert skills in sales strategies, online marketing, and e-commerce. Relevant experience with a proven track record of transforming online sales is mandatory. While it remains unspecified, understanding diverse customer bases could be beneficial considering the diverse array of potential customers in the online marketplace. An understanding of challenges in boosting online sales will also be valuable in crafting effective strategies.

I'm a store owner with a focus on home and lifestyle products. I need skilled and experienced help with running effective Facebook ads to boost my sales. Key Responsibilities: - Develop effective Facebook ad strategies for my store - Drive substantial sales through these ads - Assist with refining my target market Ideal skills: - Strong experience in Facebook ads management - Understanding of home and lifestyle industry - Excellent skills in market analysis and targeting.

I worked incredibly hard for over a year to bring you a top-notch learning program with Freelancer.com that was never revealed before… It's not just about teaching you everything I know and sharing my journey to the #1 amongst 70 million people; it's also about connecting you with a great community.. Once you complete the program and pass the test, you'll earn an exclusive badge that very few people get.. But.. Also, you get all of the following INCLUDED with NO HIDDEN COST in a YEARLY price of 129 USD: ➡️ Be among the elite few to earn the new IFC badge on your profile so that you can stand out! (Upon successful completion of the test) - Priceless! ➡️ Unlock hours of groundbreaking video content I’ve been working on for months that's nowhere el...

Phoenix property Investors is looking for a Vice President of U.S. Operations with a strong background in the real estate industry. Your priority tasks will entail: -Sales and Business Development: You should have a keen eye for growth opportunities and the acumen to drive sales and expand our business. -Operations Management: You'll efficiently manage our operations to ensure everything is running smoothly and growth targets are being met. -Team Leadership and Management: You will oversee our operations team, providing guidance, leadership, and management. We've set three main objectives for this role: -Increase Property Portfolio: You'll look for opportunities to expand our property portfolio. -Maximize Rental Income: Leveraging strategi...

I'm seeking an experienced Shopify developer to help me set up a new Shopify store. Requirements: - I have not set up a...to sell products, so I need assistance in ensuring that the store is optimized for this purpose. Please bear in mind that as the store is still in the early stages of development, I may have additional features and functionalities that I would like to implement as we progress. Ideal Skills and Experience: - Proven experience in setting up Shopify stores, particularly with a focus on product sales. - Ability to advise on and implement the most suitable e-commerce features and functionalities for selling physical goods. - Strong communication skills and a collaborative approach, as I will need your guidance in making decisions about the store's desig...

As a B2B consulting firm, Veritern is seeking skilled freelancers to enhance our sales through targeted lead generation. We need experts who can identify, reach out to, and engage businesses that require consulting services. Desired Skills and Experience: Proven track record in B2B lead generation Extensive knowledge of the consulting sector Expertise in sales growth strategies Exceptional business communication skills Proficiency in digital marketing tools and techniques Familiarity with LinkedIn automation tools like Responsibilities: Develop and implement effective lead generation strategies Utilise LinkedIn, automation tools like , and cold emails for outreach Identify and engage potential clients within various industries Create and execute digital

...user register, they receive confirmation; user register, admin receive confirmation 3. user make payment, user and admin receive confirmation 4. course allocation after registration 5. user can sign-up for webinar; flat fee for webinar is $7. Link to Google Meet and Google Classroom 6. grade book function and Progress Tracking; recommend customized programme (if possible) 7. Flat price of $7 per month. 8. Take a test and get feedback ($7) 9. Registered students can Make appointment for (1 hour consultation) 11. Process in place to create new courses (with text, pictures, video and quiz) – and show new courses on Front Page 12. Personal info should be kept safe and private – user must be convinced that all info is private. LMS should be fully responsive, optimised and...

I'm seeking a skilled affiliate marketer to promote my investing business. I pay 50 percent commission of sales and help you invest for free

I'm looking for an experienced professional to create a visually appealing email template. The template will be used on my domain-based email account for an email campaign aimed at increasing product sales. Key requirements: - Creation of a visually appealing, professional and engaging email template. - Ensuring the template is compatible. - A well-designed layout that can effectively deliver our sales-focused message. - Understanding of email marketing best practices, i.e., user-friendly design, call-to-action placement, etc. Targeted Customers: Entrepreneurs, Company Owners, Founders, Investors, Rich People, Executives and Directors, Research Professors Message to be delivered: We are offering Product Design & Development Service. Now, we need to send emails to ...

I'm seeking a skilled professional to help me with incorporating affiliate marketing features into my investment website, aiming at driving sales. I teach you how to advertise I pay half the sales and help you invest for free

I'm in need of a talented web developer to create a corporate website for my business. This project has a time constraint, so I'd like the website to be completed within a month. Key Project Details: - I require a visually appealing and professional corporate website that clearly represents my business and services. - It should be user-friendly with easy navigation for potential clients. - Mobile responsiveness is vital. The website should adapt well to various screen sizes and devices. Ideal Skills and Experience: - Proven experience in developing corporate websites is a must. Please provide examples of your previous work. - Proficiency in HTML, CSS, JavaScript and other relevant web development technologies. - Understanding of SEO practices to optimize the website ...

I'm in need of experienced social media and search engine advertising specialists. My goal is to launch a comprehensive campaign that will increase brand awareness, bring in sales, drive traffic to my website, and generate leads. To achieve this, the ideal candidate will have a thorough understanding of: - Facebook advertising - Instagram advertising - Google advertising My target audience is across multiple demographics, specifically focusing on individuals aged 18-44. I'm looking for a professional who can tailor campaigns to these audiences, ensuring maximum impact and engagement.

...Implementation: - Set up a CI/CD pipeline using GitHub Actions for automated testing, building, and deployment of both frontend and backend applications. - Integrate the pipeline with our GCP infrastructure, including Compute Engine, Cloud SQL, and Cloud Storage. 2. Logging Setup: - Configure logging for all services: -- Frontend (Nginx, ): Log HTTP requests, errors, and application logs. -- Backend (Gunicorn, Django): Log application errors, access logs, and system logs. -- Celery and Beat: Log task execution and periodic tasks. -- Database (Cloud SQL): Log database queries and errors. -- Redis (Cloud Memorystore): Log Redis operations. - Collect and store logs centrally using GCP's Stackdriver Logging. - Set up log rotation and retention policies. 3. HTTPS Domain...

...visitors. - Improve search engine ranking: I need my site to rank higher on search engine results pages to increase visibility and credibility. - Boost online sales: Ultimately, the end goal of this project is to enhance my conversion rate and drive more sales through my site. Target Audience: - Local, national, and international customers: The SEO strategy you will implement should be able to attract and engage with customers from various geographical locations. Ideal Skills and Experience: - Proven track record in SEO: I'm looking for someone who can demonstrate their knowledge and experience in improving website traffic, rankings, and sales through SEO. - Multifaceted SEO expertise: Given the diverse range of search engines and target markets, I need a pr...

I require a Marketing Team dedicated to supporting lead generation targeted towards B2B marke...Marketing Team dedicated to supporting lead generation targeted towards B2B markets. Your focus should be on delivering unparalleled value through: -Sales and Marketing : Use strategies to effectively market the unique capabilities of our services to B2B audiences. -Business Developments: Assist in identifying new business opportunities and set up meetings -Lead Generation: Attracting and engaging potential business clients for our tech offerings in an optimized manner. Applicants should have sufficient experience in IT Sales, an understanding of the tech industry, and proven success in lead generation and business development. Expertise in B2B sales and marketing would...

I need specialized assistance on visualizing my completed data analysis, encompassing sales data, financial data and customer data. To make this happen, I'm seeking a seasoned Power BI dashboard designer. Expertise required: - Proficient in creating Bar charts, Pie charts, and Line charts in Power BI - Has experience working with diverse datasets especially sales, financial and customer data - Can deliver the project urgently If you can create a comprehensive and visually appealing dashboard to delineate and amplify my data's context, your experience and skills will be indispensable to this project. Let's connect ASAP and bring this to life.

I'm seeking a professional with an established social media presence to help me promote my product on your platform. Your role will be to post my video content for 2-3 days to maximize sales.

...looking for a skilled Facebook Ads expert to help me promote my anime clothing brand to a young adult audience. The primary goal of the campaign is to boost sales . since its a startup looking for someone who can generate good sales in the limited budget in the starting phase Key Tasks: - Create and manage Facebook Ads: You should be experienced with setting up and managing successful Facebook ads campaigns. - Tailor the content for young adults: You need to understand the preferences and behaviour of the young adult demographic and create content that resonates with them. - Optimize for sales: Your main focus should be on increasing our sales conversion rate. Ideal Skills and Experience: - Proven track record in running successful Facebook ads campaigns. -...

...insoles product. The main goal of this ad is to increase sales by capturing the attention of the target audience. Key Details: - The product in question is height increasing insoles. - The target audience consists of people in western countries like the USA and Europe. I'm specifically looking to target teens and adults, particularly men. - The primary message of the ad should be to showcase how the product can help increase height instantly. Ideal Skills and Experience: - Proven experience in creating successful radio ads. - Familiarity with the target audience and the product's unique selling points. - A creative mindset and ability to craft a compelling message that resonates with the audience. - Previous success in increasing sales through advertising is hi...

I'm looking to boost sales through a dedicated social media marketing strategy. Key Goals: - The primary goal of this project is to increase my sales figures. Therefore, I'm looking for an experienced professional who can design and implement an effective social media marketing strategy to achieve this. Key Requirements: - The target audience for this project is the general public. As my products are aimed at a wide audience, the strategy should be able to engage with a broad range of individuals. Ideal Skills: - Experience in social media marketing is a must. The candidate should have a successful track record in increasing sales through social media platforms. - Understanding and familiarity with general public demographics will be an advantage. Please...

I'm looking to boost sales through a dedicated social media marketing strategy. Key Goals: - The primary goal of this project is to increase my sales figures. Therefore, I'm looking for an experienced professional who can design and implement an effective social media marketing strategy to achieve this. Key Requirements: - The target audience for this project is the general public. As my products are aimed at a wide audience, the strategy should be able to engage with a broad range of individuals. Ideal Skills: - Experience in social media marketing is a must. The candidate should have a successful track record in increasing sales through social media platforms. - Understanding and familiarity with general public demographics will be an advantage. Please...

hello I am currently planning to start a startup. I am currently entering the IT field (fields such as Facebook and Instagram) and need a programmer to join me. The working hours per day will be more than 40 hours, and a small salary may be paid per month. I have very creative ideas and am ready to grow into a global company. If you join me, I will provide you with an additional salary increase and a higher position as the company grows (e.g. Data Manager/Marketing Manager, etc.) Anyone who can do any of the following is welcome. -programmer -translator -lawyer -Server maintenance -Marketing expert -Anyone else who can contribute to the growth of the company Anyone who has a lot of passion and is starting a journey with me for my company is always welcome!

I'm looking for a YouTube ads expert to help me with an ad campaign that aims to boost sales. Your primary task will be to create and manage YouTube ads that appeal to young adults aged 18-34. The goal here is not only to increase brand awareness but to directly translate that into sales for my business. It's important that you have a proven track record of running successful YouTube ad campaigns that have led to tangible sales growth. Budget-wise, I'm looking to keep it under $500. So, an efficient and cost-effective approach will be highly appreciated. Please apply if you are confident in your ability to deliver on these requirements.

use Oracle PL SQL teach me how to install free Oracle DB on my local windows 11 acceptance: I can run your code on my computer ; all code work on my computer when I run it by myself You have 2 days you provide code to simulate input data (both code versions: python and sql)-> transactions data *****you provide SQL code to calculate per day summary for each day for each product for each store for 3 years SIMULATION data for 3 years 100 products 20 stores 5 USA states random dates and prices promotion for 30 promotions per year , each promotion happen for 7 to 15 products, for example promotion at may 10, 2023 happen for product ids: 34, 65, 12, 78, 5, 23, 41. When 34 for 20%; 65 for 30%; 12 for 40%; 78 for 10%; 5 for 15%; 23 for 70%; 41 for 30% ...

I'm seeking a seasoned professional who can help me sell my productivity app on platfo...passionate buyer who can truly appreciate the value of my product. Key Requirements: - Proven track record in selling apps or digital products - Familiarity with Flippa and other similar platforms - Experience in targeting and attracting the right audience for a digital product - Knowledge of the productivity app market Your responsibilities will include but not limited to: - Developing a solid sales strategy - Crafting compelling product descriptions - Managing communications and negotiations with potential buyers - Ensuring a smooth and secure transaction The ideal candidate should be a strategic thinker, a great communicator, and a tech-savvy individual with a passion for apps and di...

I am looking for a designer skilled in creating cartoony and kid-friendly designs that would captivate the imagination of a 6 year olds. This project merges three themes: a birthday celebration, an army theme, and cartoon character illustrations of birthday boy and friends Key Deliverables: - Embracing these themes, create fun, unique, and creative invitation implying an exciting adventure. - use exisiting backdrop and create 3 army characters one based on a real person and 2 others partly imagined - Customize the design to include the birthday boy/girl's name and age and birthday party details - include one black and white colouring page based on the invitation Ideal Experience: - children Graphic design - Character illustration - Experience in designing materials for ch...

Project Description: We are seeking an experienced Google Ads expert to manage and optimize multiple Google Ads accounts targeting the niche of dog owners. The selected freelancer will be responsible for managing 10 different Google Ads accounts and optimizing a total of 15 different campaigns over the course of one month. Responsibilities: Account Management: Manage and oversee 10 Google Ads accounts effectively. Campaign Optimization: Optimize a total of 15 campaigns within the dog owners niche to improve performance and ROI. Keyword Research: Conduct thorough keyword research to identify high-performing keywords relevant to the niche. Ad Copy Optimization: Continuously optimize ad copies to improve click-through rates and conversions. Bid Management: Monitor and adjust bidding...

hello We are currently looking for someone to manage the server that will run our website and app. (Please enter “ITO” to confirm) -Work: Anywhere you want -Job description: Manage everything from server hosting to operation In particular, maintenance/repair to ensure that security is very strong. Video conference once a week Submit work deta...the server that will run our website and app. (Please enter “ITO” to confirm) -Work: Anywhere you want -Job description: Manage everything from server hosting to operation In particular, maintenance/repair to ensure that security is very strong. Video conference once a week Submit work details and inspection results as a report every three days -Salary: $100/month ((Budgets may continue to increase as the company grow...

...familiar with the details of the project before contacting me. You will be tested to see if you are serious. I'm looking for a skilled web developer to build , a multi-vendor platform connecting digital artists with the print-on-demand service Gelato. The platform aims to facilitate the sale of digital artworks as physical prints/wall art, with artists earning commissions on their sales. There will also be some unique features and an affiliate program. The major points and requirements for the project are listed in the attached project document. The design files are nearly finished, but some design work is likely needed: (ZAPTA)?type=design&node-id=5042-102&mode=design The website should be built using JavaScript

...Our primary objective is to generate leads and drive sales through captivating advertisements. Key Responsibilities: - Create compelling advertising content that effectively promotes our products/services and entices potential customers to engage with our brand. - Utilize your expertise in Meta Ads to strategically target and reach our specified audience demographics. In this instance, our target audience will consist of individuals aged between 25-34 and 35-44. - Monitor, analyze, and optimize the performance of our advertising campaign to ensure maximum lead generation and sales conversion. Ideal Candidate: - Proven track record of successfully running and managing Meta Ads campaigns, with a strong focus on lead generation and sales. - Proficiency in creating en...

I need someone who is experienced in collecting contact data and leads from Linkedin Sales Navigator for C level contacts. I will share the industry name and instructions in the chat message. I want you to quote for 3000 leads. If you collect more leads, you will paid proportionately.

As a growing company, we've fully set up our QuickBooks Online but it's in need of a thorough review and ongoing management. We're looking for a QuickBooks expert who can help in the following areas on a monthly basis: - Setting up sales and expenses - Managing stock - Budgeting Your responsibilities will involve keeping the system up-to-date, ensuring financial data consistency, and providing insights to support our decision-making process. The ideal candidate for this role would be an experienced accountant with previous QuickBooks Online experience. Knowledge of other accounting tools and financial acumen are also a plus.

I am looking for an email marketing expert to help me generate leads through a strategic email campaign. We want to send cold emails to our lead list and hopefully book appointments out of that. We plan to send at least 100K cold emails per month to business owners in the US. The applicant should have similar experience in the past and should be aware of all technicalities from scratch to the end. He or she will be managing the entire system by himself/ herself We are looking for an expert and budget is not a constraint. Please apply only if you have done this in the past. Also to make sure you have read this description, start you application with the word "Blue" to be considered. Thank you.

I have an Amazon and Ebay store specializing in Indian ethnic clothing such as sarees, kurtis, and lehengas. Currently, my inventory consists of less than 100 products, and I am looking for assistance in managing my store and listing products. The store is registered for global selling @ USA, Canada, Maxico Key Responsib... specifically in the clothing niche - Proficiency in listing products on Amazon - A keen eye for creating compelling product descriptions and attractive titles - Ability to optimize listings for search engine visibility - Excellent inventory management skills Your role will be critical in ensuring that my products are presented professionally and that the store is efficiently managed to drive sales. A track record of success in similar projects will be highly b...

hello I am currently looking for a lawyer who can provide legal help regarding IT. Salary will be provided on a monthly basis and additional details are as follows. -Duties: Creating/editing/reviewing international personal information protection laws and terms of use In addition, legitimacy checks are conducted when operating apps and websites. -Budget: $100/month (Budgets may continue to increase as the company grows in size and sales increase)

My primary objective is to capitalize on the combined reach towards men and women within the 18-34 years demographic on Facebook marketplace. The desired outcome is not tied to lead generation or brand awareness but rather a direct increase in sales. Ideal Skills & Experience: - In-depth Knowledge of Facebook ad manager - Experience in targeting optimal demographic groups - Proven record of boosting sales through Facebook ads - Ability to evaluate and adjust campaigns to maximize results Please layout your experience and successes with similar projects in your proposal.

More details: Is this project for business or personal use? For starting a new enterprise What information should successful freelancers include in their application? Detailed project proposals How soon do you need your project completed? Within a month

We are looking for 5-10 years of .Net experienced developer who can also have experienced in React and .Net based web development. Long terms multiple projects development. Using Mainly Azure SQL server database with Visual Studio .Net Core API. Graph QL and EF. Worked on Azure Key Vault, Azure Logic app, Azure function is bonus.

I am looking for a skilled individual who can help me promote the links of my website across social media platforms. Although I skipped the question on which platforms, I expect the freelancer to have experience with Facebook, Instagram and Twitter. The goal of the project is to increase website traffic, generate leads and ultimately boost sales. The target audience for my website is primarily aged between 25-34.

use Oracle PL SQL teach me how to install free Oracle DB on my local windows 11 acceptance: I can run your code on my computer ; all code work on my computer when I run it by myself You have 2 days *****you provide code to simulate input data -> transactions data *****you provide SQL code to calculate per day summary for each day for each product for each store for 3 years SIMULATION data for 3 years 100 products 20 stores 5 USA states randomly 30 to 170 transactions per day for given product for usual price randomly 200 to 600 transactions per day for given product for promotion random dates and prices promotion for 30 promotions per year , each promotion happen for 7 to 15 products, for example promotion at may 10, 2023 happen for product ids: 34, 65, ...