Pinned Repositories
communication-developer-services-reference-architectures
AWS Amazon Pinpoint and Amazon Simple Email Service (SES) Digital User Engagement Reference Architectures with CloudFormation templates.
excel-to-sql
Convert an Excel column to ("cellA1","cellA2","cellA3",etc.) so you can use it in a SQL "where in" function. (Check read me)
google-search-scrape
This script is using Selenium & Chrome driver to scrape Google's paid search results based on keywords. The users are inputting their keywords under a column in an Excel Spreadsheet and the script is emulating both mobile and desktop while scraping the results for each. Each Google result contains position, a look-up for the company, landing page URL and the copy of the ad as well as if it is Mobile or Desktop. The code is cleaning cookies and operating in Icognito mode. The final data output is pushed into a MySQL DB and in my project I visualise it in Power BI. This script runs well for 5 minutes intervals and with 10 keywords. More that that I would suggest investigating running multiple instances of the Chrome driver.
pinpoint-friendly-sender-name
Choose the email friendly sender name to match your Pinpoint journey use case.
pinpoint-gtm-connector
Integrate Amazon Pinpoint & GTM using API GateWay endpoint as a custom pixel.
pinpoint-incremental-analytics
Pinpoint Incremental Analytics - allows business users to enter business rules based on user events' and updated respective user attributes.
pinpoint-journey-events-attribution
Attributing client side user events to Pinpoint Journeys
pinpoint-journeys-adminevent-trigger
Triggering a Pinpoint Journey based on a company wide event e.g. new feature release and reaching out to multiple customers
pinpoint-renewal-reminder
A mechanism to send renewal reminders to your customers using Pinpoint
slackbot-sql-query
A slack bot which collects your data query through a dialogue and returns a CSV. The data bot is obtaining the data from your SQL server.
Pioank's Repositories
Pioank/pinpoint-renewal-reminder
A mechanism to send renewal reminders to your customers using Pinpoint
Pioank/excel-to-sql
Convert an Excel column to ("cellA1","cellA2","cellA3",etc.) so you can use it in a SQL "where in" function. (Check read me)
Pioank/pinpoint-gtm-connector
Integrate Amazon Pinpoint & GTM using API GateWay endpoint as a custom pixel.
Pioank/pinpoint-journey-events-attribution
Attributing client side user events to Pinpoint Journeys
Pioank/slackbot-sql-query
A slack bot which collects your data query through a dialogue and returns a CSV. The data bot is obtaining the data from your SQL server.
Pioank/communication-developer-services-reference-architectures
AWS Amazon Pinpoint and Amazon Simple Email Service (SES) Digital User Engagement Reference Architectures with CloudFormation templates.
Pioank/google-search-scrape
This script is using Selenium & Chrome driver to scrape Google's paid search results based on keywords. The users are inputting their keywords under a column in an Excel Spreadsheet and the script is emulating both mobile and desktop while scraping the results for each. Each Google result contains position, a look-up for the company, landing page URL and the copy of the ad as well as if it is Mobile or Desktop. The code is cleaning cookies and operating in Icognito mode. The final data output is pushed into a MySQL DB and in my project I visualise it in Power BI. This script runs well for 5 minutes intervals and with 10 keywords. More that that I would suggest investigating running multiple instances of the Chrome driver.
Pioank/pinpoint-friendly-sender-name
Choose the email friendly sender name to match your Pinpoint journey use case.
Pioank/pinpoint-incremental-analytics
Pinpoint Incremental Analytics - allows business users to enter business rules based on user events' and updated respective user attributes.
Pioank/pinpoint-journeys-adminevent-trigger
Triggering a Pinpoint Journey based on a company wide event e.g. new feature release and reaching out to multiple customers
Pioank/python-games
This repository contains 3 Python games that one can play in their CMD. The games are hangman, guess the number and perform the correct calculations to pass levels
Pioank/web-scraping-and-data-aggregation
Scrape similar data points from different sites, homogenise them and aggregate your data for analysis and visualisation in one place
Pioank/web-scraping-image-management
This project is using Python web-scraping to scrape both data and screenshot elements from the target page that are later stored to an SQL DB and an Image management system ( Cloudinary )