LookerStudio - Pivot Table of Google Search Console data
Hello!
I need to set up a draft dashboard with test data. Then I will copy it and connect real data that I simply cannot provide. I will receive and give you feedback, and there will be further more specific paid adjustments to this board.
Context: There are two test sites. They have the same categories/pages (can be matched) but different brands (conditionally JewelleryName1.com, JewelleryName2.net). There is access to data from GoogleSearchConsole (Looker can automatically pull their fields)
1) It is necessary to combine the data from the two sites into a single table (Blended Data? I don't know how to do that).
2) The table should display data by sites, broken down by categories of pages (url, conditionally separately /kolca/ and /sergi/).
3.1) Additionally, display the % of traffic to the category of pages from the total traffic.
3.2) Additionally, display Δ from the previous period.
3.3) Additionally, set up simple traffic forecasting for the current month based on data from previous days.
3.4) Help come up with how to format "with" and "without" data for the Query field = Name1, Name2.
The dashboard will be refined and redone. Feedback on usage will need to be obtained and further formulated needs.
Estimated more detailed task description: https://docs.google.com/document/d/1We9LX9zMtiEhwniEyhPKUYTuDoqdksHR7ZYJqqkCFVk/edit?usp=sharing
Current freelance projects in the category Data Parsing
Database of websites on WooCommerceIt is necessary to compile a database of Ukrainian online store websites on WooCommerce with the contact information provided on the sites. Only active websites (indicator: updated catalog/content, working domain) Table format - website address, phone number, e-mail. Data Parsing ∙ 1 day 20 hours back ∙ 20 proposals |
Create a dashboard in https://airtable.com/ for the performance of advertising creatives from Facebook ads.Full specification https://docs.google.com/document/d/1_n_oYRNZWYxalUA---DM5AD1b5ZSrtePw5J4G42svGw/edit?usp=sharing Databases & SQL, Data Parsing ∙ 3 days 10 hours back ∙ 17 proposals |
Creation of an Excel file for uploading products to the websites of other partners.I am interested in creating an Excel table with all parameters. Here is the website - https://heiztechnik.com.ua/ And the positions I am interested in to be transferred: Manual boilers: 1) TIS UNI 15-95 kW (10) pcs 2)TIS HARD 150-500 kW (7) pcs Pellet boilers: 1)TIS PELLET… Data Parsing ∙ 3 days 14 hours back ∙ 35 proposals |
A developer is required for parsing the catalog and automating data import.Detailed technical specifications in the attached document Please indicate the estimated cost and timeline in your response Do you have experience working with parsing large catalogs What possible difficulties or limitations do you see in this task Databases & SQL, Data Parsing ∙ 3 days 17 hours back ∙ 40 proposals |
Find a product feed (Google Merchant XML) for a website on OpenCart
16 USD
It is necessary to find a direct link to the active product feed (XML) of a competitor for Google Merchant Center Platform (CMS): OpenCart / ocStore Find the original feedRequirements for the result: Working link to the XML file Python, Data Parsing ∙ 3 days 22 hours back ∙ 25 proposals |