Overview:

πŸ“Š Outcome: Visualized Google Ads Spend

πŸ•‘ Estimated Time: ~20min

πŸ—’ Structure:

  1. Rename Columns

  2. Change Field Types

  3. Normalize Data

  4. Visualize Data

🏷 Model:

Bildschirmfoto_2021-09-15_um_11.57.07.png

Rename Columns

πŸŽ₯ Video Explanation:

 

 

πŸ‘ž Step by Step:

 

  1. Open Modeling
  2. Insert Input Node and select Google Ads: AD_PERFORMANCE_REPORT
  3. Use Fields Node to drop and Rename Columns; We would recommend renaming:
    1. cost -> spend
    2. Day -> date

 

Change Field Types

πŸŽ₯ Video Explanation:

 

 

πŸ‘ž Step by Step:

 

 

  1. Identify the type of your date column
    If the type = date, you can continue with Normalize Data.
  2. Add Date Parser node to convert the type of the date column from text to dateBildschirmfoto_2021-08-15_um_18.15.27__1_.png

 

 

 

πŸ“š Additional Ressources:

 

Normalize Data 

πŸŽ₯ Video Explanation:

 

 

πŸ‘ž Step by Step:

 

  1. Use Functions Node to normalize spend
    ℹ️ Google Ads is saving revenue in one-millionth USD, therefore we have to divide it by 1,000,000 to normalize it to one USD. In Y42 we can do this with the Functions Node.
  2. Add an Output Node and select the Columns that you want to see in the Output.
  3. Commit the Model to make it available for e.g. Visualize and as Input for another model

 

 

 

πŸ“š Additional Ressources:

 

Visualize Data 

πŸŽ₯ Video Explanation:

 

 

πŸ‘ž Step by Step:

 

  1. Go to the Modeling Section and create a new dashboard 
  2. Add a widget and select the "Daily Ad spend" table as an input
  3. Drag and drop the columns into the fields:
    - Breakdown by: Date of date
    - Summarize by: Sum of Spend

 

➑️ Next Step:

Clean Facebook Data & Calculate Daily Ad Spend

 

Was this article helpful?
1 out of 1 found this helpful

Comments

0 comments

Please sign in to leave a comment.