Webhook + Google Ads API: Basic Web Based System To Post Conversion Events

Job ID: 37233336

Budget: $250 – $750 USD

We are looking for a full stack dev for ongoing work. Our goal is to provide this basic API project as a test to see how you do. This project will be for one aspect, google conversion tracking.

Overview:
------------------------------------------------
When a conversion event occurs, we will post the event (purchase, addtocart, etc) to our new webhook system. The system will then lookup the correct conversion even and google account to post the data to. All responses, success/partial/failure will be recorded so we can fix the issues on on going basis. This will require a basic password protected web gui to view the tables, inbound webhooks, outbound api requests, responses, etc.

Sample webhook (broken up to make easier to read) we might post to "ourdomain.com" :
---------------------------------

https://ourdomain.com/webhook.php?
glid=TESTRIsAGuzdw379KwG_CxOif2s9IAaP7T3j9JMdz5KplnE2VvJT0sr2ixF_BqRkoYaAlRiEALw_wcB
&wbraid=TESTRIsAGuzdw379KwG_CxOif2s9IAaP7T3j9JMdz5KplnE2VvJT0sr2ixF_BqRkoYaAlRiEALw_wcB
&gbraid=TESTRIsAGuzdw379KwG_CxOif2s9IAaP7T3j9JMdz5KplnE2VvJT0sr2ixF_BqRkoYaAlRiEALw_wcB
&payout=50
&timestamp=2023-09-21 17:47:21
&vertical=wifi
&transid=971789296hg464596a2ebb444c4c8c45e


Conversion Table:
---------------------------------

- id
- gclid
- gbraid
- wbraid
- payout
- timestamp
- vertical
- transid
- date entered, date last fire
- result (success, partial success, failure)

google ads fire table (attempts to post to google):
---------------------------------

- id
- gclid
- gbraid
- wbraid
- payout
- timestamp
- vertical
- transid
- date last fire
- result (success, partial success, failure):

Vertical / pixel table fields
---------------------------------

- ID
- Vertical ID (about 10)
- Vertical Name
- event type (purchase, addtocart, etc) --- matching google events
- Google Account To Use
- Pixel ID to use


Logic
---------------------------------
1) new webhook request is entered into "Conversion Table"
2) the system will lookup the vertical specified and the appropriate google account and pixel to use
3) it will use the google ads api upload conversion service: https://developers.google.com/google-ads/api/docs/conversions/upload-clicks
4) we will use WBRAID if set/valid, or GBRAID if not set/valid, finally GCLID if nothing else set/valid
5) please include your favorite ice cream in your upwork application so we know you read this
6) the api post & response, error/success is recorded in our outgoing table
7) debug failed api posts to resolve missing information

Note: failures will be alerted via email, with:

- the webhook we posted
- time / date/ ip source
- what we sent to google ads api
- api response (error message)

-----------------------
1) Hours and time zone you are available
2) Your experience with gui web based systems
3) Please tell us your experience building web based systems
4) What skills you would use (php, node.js, etc) to build this
5) Estimated time to deliver
Related categories: PHP JavaScript MySQL API