Download data from Google Analytics to PostgreSQL
Database of Postgresql
Python through anaconda
I have to set the data output from Google Analytics to the PostgreSQL database.
I applied the request code, to upload the data, found it on the internet
I need to restore it to my task.
The task is to upload these data:
The Dimensions:
by: date
Tagged: Campaign
by:sourcemedium
The Metrics:
Tagged: adclicks
by: adcost
Set up 2 files.
one for data upload from 01.01.2020, it is one
The second file to upload data yesterday - so that I can run the script automatically, and it then starts on its own...
in the second file the script needs to be improved, add error processing, for example, if a error occurs when the data is uploaded to the BD, then you need to do so that the script initiated a new download so that we do not lose the data due to the error.
Information taken from the source: http://toolmark.ru/python-postgre/
Applications 1
Client's review of cooperation with freelancer
Download data from Google Analytics to PostgreSQLDmitry great beauty, he knows his business well, did everything quickly and quality, not just did, but suggested and gave the right advice.
Freelancer's review of cooperation with Taras Melnichuk
Download data from Google Analytics to PostgreSQLA great customer and a good person. Clear TZ, frequently online. It was very pleasant to work!
![]()
-
скрипт не проверял...
БД находиться локально на моем сервере, но также есть доступ через IP
-
Current freelance projects in the category Databases & SQL
Development of Backend core (Python), Telegram FSM engine, and Stripe integrationWe are looking for an experienced Backend Developer (Middle/Senior) to create an independent Headless core for an EdTech product. The system operates on a strict monthly subscription model. The core logic must be completely isolated from the content. All development is conducted… Python, Databases & SQL ∙ 1 hour 1 minute back ∙ 5 proposals |
Restoring Instagram after a banOn March 3, 2026, my Instagram was blocked due to a violation of rules. I believe there has been some mistake, as the page was personal with photos and videos of my personal trips. I did not post any comments anywhere. I have sent several appeals. I cannot download my files… Databases & SQL, Web Programming ∙ 5 hours 58 minutes back ∙ 4 proposals |
It is necessary to upload products into the corresponding categories and subcategories from SQL files.The site is created on WP. It has a product catalog. Products were uploaded from a PDF file, resulting in a bit of a mess. There are three files with a clear distribution of categories, subcategories, and products in them. In the file PA.sql, categories are numbered, for… Databases & SQL, Web Programming ∙ 9 hours 29 minutes back ∙ 28 proposals |
CRM system for Railway LogisticsCreation of a CRM system for a logistics company mainly focused on rail and road transport, 1) Financial reporting 2) Processing applications 3) Contractors 4) Automatic issuance of invoices and acts upon closure, it is possible to create a simplified system based on 1C below… Databases & SQL, Client Management & CRM ∙ 18 hours 4 minutes back ∙ 34 proposals |
Eliminate the issue of incomplete data import from Excel files of Nova Poshta specifications into 1C:
45 USD
Goal: There is a processing in 1C for uploading the specifications of Nova Poshta. For unclear reasons, it has stopped loading some tabular data. We need to find the reason and eliminate the problem of incomplete data import from Excel files of Nova Poshta specifications into… System & Network Administration, Databases & SQL ∙ 3 days 12 hours back ∙ 16 proposals |