Create Post Marketing Request

Actors

• User

Steps in Scenario

Users create a marketing request with specific goals for their social media posts. Main Page Demo:

1. User selects a platform for marketing (e.g. Instagram). They are presented with marketing options and services for that platform.
2. User selects a posts marketing service (e.g. likes, views..). They are presented with several "packages", services and their prices offered by GrowBridge's Service Providers.

3. User clicks on the "package" or service that they chose, and they are asked to select a post from one of their linked social media profile's by providing it's URL. The user is redirected to the transaction page.
4. User selects their payment method, and inputs their payment details.
5. System creates a new record in the post marketing requests table.

INSERT INTO PostMarketingRequest (target_likes , target_comments , timeline , postid , date_created , status , userid , providerid) 
VALUES (500, 50, '2025-02-05 00:00:00', 2, '2025-01-12 14:00:00', 'pending', 2, 2);