HOME

PAUL ANTHONY GUPIT

Digital Marketing

EXPERTISE / SKILLS

Advertising Expert

8+ Years PPC/SEO

PRODUCTS / SERVICES

WHAT TO KNOW

ABOUT ME ?

Paul Anthony Z. Gupit has been digital marketing and web designer at age twenty eight. He has an over 8+ years of experience in Digital Marketing including the Mobile Marketing Strategist.

His experienced in advertising and marketing play a vital role in the internet and mobile industry enables business to build closer relationship with their customers. His passion with the latest technologies and media, gives opportunity to integrate and leverage the power of digital media into a highest revenues.

As he started Internet Business analyst, total online revenues exceeded $20 million in annual sales by 2016 including both physical and digital products for Apparels, Home Decorative, Sports, Beauty and Personal Care, Automotive Parts and Accessories.

SKILL SET PERCENTAGE

DIGITAL MARKETING

  • SEO

    20%

  • PPC

    40%

  • Graphics

    10%

  • Tableau

    30%

Help set and work to a performance indicators for SEO, that everyone understands and which complement overall marketing and business objectives.

Data Tracker Using If, Concatenate, Max If, and Search Index by using Row.



Data Tracker Using If.
Data Tracker and Monitoring System using Excel.

1. Create 3 Sheet Tab, name it as DataMonitoring-Y17, 2017 and Settings

2. Create and Reserve Column from A-Z

3. In Column B, put this code:
=MAX(IF(E3='2017'!$B$2:$B$11978,'2017'!$A$2:$A$11978)) then press Shift+Ctrl+Enter to have curly bracket. It should be looks like this:
{=MAX(IF(E3='2017'!$B$2:$B$11978,'2017'!$A$2:$A$11978))}

4. In Column C, put this code:
=IF(B3=0,"",IF(N3=1,B3+Settings!C$6, B3+Settings!C$7))
4.1. In Settings Tab, put this identifier.
at Column B, Row 6, put identifier label called: First Priority #1 then at Column C, Row 6, put value such as 7 - this serve as how many days to count (One Week).
at Column B, Row 7, put identifier label called: First Priority #2  then at Column C, Row 7, put value such as 14 - this serve as how many days to count (Two Weeks).

5. In Column E, put this code:
=CONCATENATE(D3," | ",A3)

6. Go to "2017" Sheet
Create and reserve Column A-G

Column A: Date


Column B: 
Campaign / AdGroup

Column C: 
Date Range

Column D: 
Spend

Column E: 
Sales

Column F: 
ACoS

Column G: 
Notes

Okay, that's Phase 1.

0 comments:

Post a Comment

COMPLETE

SERVICES

DOWNLOAD SERVICES (.pdf file)

PRESENT LOCATION

LOCALITY BRGY CAWAYAN 1 SAN FRANCISCO, QUEZON COUNTRY PHILIPPINES ZIP CODE 1453

CONTACT ME

EMAIL ask@ctsytem.info

$2000 / MONTH

$2000 + 8% of Total PPC Budget / month for 6 months

PPC CONSULTANT

$500 / BASIC

Clearly one of the best places to find information these days.

WEB DESIGNING

$800 / MONTH

As your SEO Consultant, your traffic will grow to your potential customers.

SEO CONSULTANT
Go Top