It's simple to create a report of your ad data in Google Sheets using Weld. First, activate the extension by clicking Add-ons in the Google Sheet's toolbar, followed by Weld, then Start.

When you run Weld the first time, we'll ask you to select a data source to import your information.

Select one of the Data providers to get started. You will have to authenticate the first time you activate a data provider in a tab. After you have completed your authentication, close the tab and return to your Google Sheet to start creating your report.

In this example, we'll create a report showing visitors to our website over the last 30 days using Google Analytics.

First, we'll select a "View" for the data. This option allows you to choose from an existing View you have setup within Google Analytics.

After choosing a View, I'll select a date range, in this case, the last 30 days.

Then, I'll move to the "Metrics" field and type "users" in order to pull in the user (visitor) counts from the last 30 days.

Then I'll move to "Dimensions" and type "date" to bring in the date user's visited our site.

Finally, I'll click run at the bottom of the panel and my data will be pulled into the sheet!

Now let's create a quick chart to show off this data. Select all the fields you'd like to display in the chart.

Then "Insert" followed by "Chart".

That's it! The chart should display next to your data. Now you can update your query and rerun it to update your chart or add new information.