1. Stop being a LURKER - join our dealer community and get involved. Sign up and start a conversation.
    Dismiss Notice

Reporting Template for Adwords, Facebook, Twitter & Bing Data

Discussion in 'Online Marketing & Best Practices' started by nminh.hoang1023, Apr 24, 2017.

This forum sponsored by...
  1. nminh.hoang1023

    nminh.hoang1023
    Expand Collapse
    Noob

    First Name:
    Minh
    Joined:
    Apr 18, 2017
    Messages:
    9
    Likes Received:
    0
    Hi everyone,

    Continuing my previous post about Google Data Studio template for Facebook Ads, we've just developed another template for mixed paid channels, including AdWords, Facebook, Twitter and Bing data.

    The template and instructions can be found on our blog: https://supermetrics.com/blog/paid-channel-mix/

    [​IMG]

    Hope to hear what you think about it :)
     
    • Useful Useful x 1
  2. This forum sponsored by...
  3. Karen Ann

    Karen Ann
    Expand Collapse
    Refresher

    First Name:
    Karen
    Dealer or Company Name:
    Steve Marshall Ford Lincoln
    Twitter Handle:
    FordandLincoln
    Joined:
    Apr 21, 2009
    Messages:
    117
    Likes Received:
    11
    Location:
    British Columbia
    Thank Minh, popped our data in and the report worked splendidly. Was nice to see everything visually and not just an excel spreadsheet! Thanks for sharing.
    Karen Ann

    Now to work on making a Data Studio doc for my monthly spreadsheet :)
     
    • Like Like x 1
  4. Jeff Kershner

    Jeff Kershner
    Expand Collapse
    Founder

    First Name:
    Jeff
    Dealer or Company Name:
    DealerRefresh & Mercedes-Benz of Hagerstown
    Joined:
    May 1, 2005
    Messages:
    3,119
    Likes Received:
    759
    Location:
    Maryland
    Karen, so glad to see you jump on this. Curious if you're tracking and reporting on lead and sales attribution to any degree? If so, what does your visual look like?
     
  5. nminh.hoang1023

    nminh.hoang1023
    Expand Collapse
    Noob

    First Name:
    Minh
    Joined:
    Apr 18, 2017
    Messages:
    9
    Likes Received:
    0
    Thanks for the feedback Karen. It'd be great to know what are other templates you are looking for as well, since we are developing a template gallery.
     
  6. Karen Ann

    Karen Ann
    Expand Collapse
    Refresher

    First Name:
    Karen
    Dealer or Company Name:
    Steve Marshall Ford Lincoln
    Twitter Handle:
    FordandLincoln
    Joined:
    Apr 21, 2009
    Messages:
    117
    Likes Received:
    11
    Location:
    British Columbia
    I have a monthly compilation that I pull tracking each online source separately. Most include SRP to VDP CTR, Cost per VDP view - lead - sale, Solds per source, inventory counts - photos missing - descriptions missing and more....but it's very dry and separated monthly in Excel.

    I'd love to have it visually beautiful and especially with the option to easily see the previous period (month or quarter) comparison.

    I also love popping exported data into a Google Sheet and the information I want is compiled in the Data Studio report, instead of manually entering anything. I am hoping that investing time into Data Studio will help me get better!
     
  7. Alexander Lau

    Alexander Lau
    Expand Collapse
    Sr. Refresher

    First Name:
    Alex
    Joined:
    Feb 11, 2015
    Messages:
    716
    Likes Received:
    123
    Location:
    Pittsburgh, PA
  8. Karen Ann

    Karen Ann
    Expand Collapse
    Refresher

    First Name:
    Karen
    Dealer or Company Name:
    Steve Marshall Ford Lincoln
    Twitter Handle:
    FordandLincoln
    Joined:
    Apr 21, 2009
    Messages:
    117
    Likes Received:
    11
    Location:
    British Columbia
    I'm having trouble getting source in the splits in various pie charts to be the same colour (dimension a= blue, dimension b= green). Colours change depending on metric, even when I filter to sort by dimension. Did yours just magically line up perfectly with metrics?
     
  9. nminh.hoang1023

    nminh.hoang1023
    Expand Collapse
    Noob

    First Name:
    Minh
    Joined:
    Apr 18, 2017
    Messages:
    9
    Likes Received:
    0
    @Karen: Sorry for the late reply. Do you still have the problem? If so, can you please submit your question here so we can get back to you asap!
     

Share This Page

This forum sponsored by...